Query language based on business object model
First Claim
Patent Images
1. A non-transitory computer-readable storage medium containing instructions to configure a processor to perform operations comprising:
- receiving a first query;
generating, based on a model including metadata representing a data structure, a second query specific to the data structure stored in a database, the second query being a single direct query to the database and defining all nodes and associations, including a root node, nodes dependent on the root node, and associations between all nodes, needed to traverse at least one business object and nodes stored in the database to generate a result set without buffering of intermediate results; and
sending the second query to the database; and
executing the second query page by page basis at runtime based on a page being displayed on a user interface used for executing the second query and using data transported from the database and associated only with the page being displayed on the user interface, the data associated with the displayed page is searched in and obtained from data stored in the database, and by searching an unrestricted amount of data at the database at constant seek time as a prerequisite of paging.
3 Assignments
0 Petitions
Accused Products
Abstract
Methods and apparatus, including computer program products, are provided for providing a query language based on a model. In one aspect, there is provided a computer-implemented method. The method may include receiving a first query; generating, based on a model including metadata representing a data structure, a second query specific to the data structure stored in a database; and sending the second query to the database. Related apparatus, systems, methods, and articles are also described.
-
Citations
15 Claims
-
1. A non-transitory computer-readable storage medium containing instructions to configure a processor to perform operations comprising:
-
receiving a first query; generating, based on a model including metadata representing a data structure, a second query specific to the data structure stored in a database, the second query being a single direct query to the database and defining all nodes and associations, including a root node, nodes dependent on the root node, and associations between all nodes, needed to traverse at least one business object and nodes stored in the database to generate a result set without buffering of intermediate results; and sending the second query to the database; and executing the second query page by page basis at runtime based on a page being displayed on a user interface used for executing the second query and using data transported from the database and associated only with the page being displayed on the user interface, the data associated with the displayed page is searched in and obtained from data stored in the database, and by searching an unrestricted amount of data at the database at constant seek time as a prerequisite of paging. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A method comprising:
-
receiving, at a query generator, a first query; generating, at the query generator, a second query specific to the data structure stored in a database, wherein the second query is generated based on a model including metadata representing a data structure, the second query being a single direct query to the database and defining all nodes and associations, including a root node, nodes dependent on the root node, and associations between all nodes, needed to traverse at least one business object and nodes stored in the database to generate a result set without buffering of intermediate results; sending, from the query generator, the second query to the database; and executing the second query page by page basis at runtime based on a page being displayed on a user interface used for executing the second query and using data transported from the database and associated only with the page being displayed on the user interface, the data associated with the displayed page is searched in and obtained from data stored in the database, and by searching an unrestricted amount of data at the database at constant seek time as a prerequisite of paging. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A system comprising:
-
at least one processor; and at least one memory, wherein the at least one processor and the at least one memory are configured to provide operations comprising; receiving a first query; generating a second query specific to the data structure stored in a database, wherein the second query is generated based on a model including metadata representing a data structure, the second query being a single direct query to the database and defining all nodes and associations, including a root node, nodes dependent on the root node, and associations between all nodes, needed to traverse at least one business object and nodes stored in the database to generate a result set without buffering of intermediate results; sending the second query to the database; and executing the second query page by page basis at runtime based on a page being displayed on a user interface used for executing the second query and using data transported from the database and associated only with the page being displayed on the user interface, the data associated with the displayed page is searched in and obtained from data stored in the database, and by searching an unrestricted amount of data at the database at constant seek time as a prerequisite of paging.
-
Specification