System and Method for Optimized Query Execution in Computerized Data Modeling and Analysis
AssigneeOpera Solutions U.S.A., LLC
InventorsAmir Bar-Or, Yuansong Liao, Laks Srinivasan, Ding Huang, Hong Wang
Life of this patent
Estimating the term…
Loading patent…
AssigneeOpera Solutions U.S.A., LLC
InventorsAmir Bar-Or, Yuansong Liao, Laks Srinivasan, Ding Huang, Hong Wang
Estimating the term…
A sequence of queries is divided into stages, where each stage involves one pass over the data, such that the sequence of queries can be executed using the minimum number of passes over the data. The sequence of queries may be processed into a functional dependency graph that represents the relationships between query parameters (signals) and query operations, and the functional dependency graph then may be processed to divide the queries into a number of successive stages such that each stage includes queries that can be executed based on data that exists prior to execution of that stage. A sequence of queries may, and often does, require that one or more intermediate values or datasets be generated using an aggregate function.
A computer-implemented method for converting scalar expressions to relational database queries applied to a dataset, the method comprising:
A system for converting scalar expressions to relational database queries for application to a dataset, the system comprising:
A computer program product comprising a tangible, non-transitory computer readable medium having stored thereon a computer program for converting scalar expressions to relational database queries for application to a dataset, which, when run on a computer system, causes the computer system to execute interactive database query reporting computer processes comprising:
Dependencies are inferred from the claim text.