Database Calculation Engine Integrating Hierarchy Views
First Claim
Patent Images
1. A method comprising:
- receiving, by a database server from a remote application server, a query associated with a calculation scenario that defines a data flow model that includes a plurality of calculation nodes, each calculation node defining one or more operations to execute on the database server, at least one of the nodes being a semantic node specifying an operation requiring special handling, at least one of the nodes being a leaf node having two or more parent nodes;
modifying, by the database server, the query using the semantic node to handle hierarchy views within the calculation scenario;
modifying, by the database server, the calculation scenario based on the modified query;
instantiating, by the database server, the modified calculation scenario;
executing, by the database server, the operations defined by the calculation nodes of the modified calculation scenario to result in at least one result set; and
providing, by the database server to the application server, the at least one result set.
1 Assignment
0 Petitions
Accused Products
Abstract
A calculation engine is described that executes calculation scenarios comprising a plurality of calculation nodes that specify operations to be performed to execute the query. One of the nodes can be a semantic node that is used to modify the query for operations requiring special handling including handling of hierarchy views. Related apparatus, systems, methods, and articles are also described.
-
Citations
20 Claims
-
1. A method comprising:
-
receiving, by a database server from a remote application server, a query associated with a calculation scenario that defines a data flow model that includes a plurality of calculation nodes, each calculation node defining one or more operations to execute on the database server, at least one of the nodes being a semantic node specifying an operation requiring special handling, at least one of the nodes being a leaf node having two or more parent nodes; modifying, by the database server, the query using the semantic node to handle hierarchy views within the calculation scenario; modifying, by the database server, the calculation scenario based on the modified query; instantiating, by the database server, the modified calculation scenario; executing, by the database server, the operations defined by the calculation nodes of the modified calculation scenario to result in at least one result set; and providing, by the database server to the application server, the at least one result set. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. A non-transitory computer program product storing instructions, which when executed by at least one data processor, result in operations comprising:
-
receiving a query associated with a calculation scenario that defines a data flow model that includes a plurality of calculation nodes, each calculation node defining one or more operations to execute on the database server, at least one of the nodes being a semantic node specifying an operation requiring special handling, at least one of the nodes being a leaf node having two or more parent nodes; modifying the query using the semantic node to handle hierarchy views within the calculation scenario; modifying the calculation scenario based on the modified query; instantiating the modified calculation scenario; executing the operations defined by the calculation nodes of the modified calculation scenario to result in at least one result set; and providing the at least one result set.
-
-
20. A system comprising:
-
a database server; and an application server remote from the database server; wherein the database server; receives a query associated with a calculation scenario that defines a data flow model that includes a plurality of calculation nodes, each calculation node defining one or more operations to execute on the database server, at least one of the nodes being a semantic node specifying an operation requiring special handling, at least one of the nodes being a leaf node having two or more parent nodes; modifies the query using the semantic node to handle hierarchy views within the calculation scenario; modifies the calculation scenario based on the modified query; instantiates the modified calculation scenario; executes the operations defined by the calculation nodes of the modified calculation scenario to result in at least one result set; and provides the at least one result set.
-
Specification