A computer-implemented system and method for handling a database statement from a first database system. The database statement is formatted according to a language format used by the first database system. Database language difference data is accessed so that a database specific statement may be generated which is operational within a different type of database system.
System, Method, And Data Structure For Automatically Generating Database Queries Which Are Data Model Independent And Cardinality Independent
Thomas P. Weber - Apex NC, US Frederick J. Levine - Hillsborough NC, US James P. Kelley - Cary NC, US
International Classification:
G06F 17/30
US Classification:
707714, 707E17017
Abstract:
Systems and methods are provided for performing a database query. After receiving an identification of data item components and associations between the data item components, wherein the data item components include a measure and a category, a query generation system creates and executes a database query that comprises one or more Uqueries, wherein each Uquery comprises a Mx segment subquery and a U0 segment subquery. The Mx segment subquery is associated with a table that contains the measure, a table that contains columns for a calculated measure, or a correlated table, and the U0 segment subquery is associated with a table that contains the category, a table that contains columns for a calculated category, a dependent measure table, or a dependent filter table. The query generation system can generate a virtual results table by aggregating Uquery results from one Uquery with Uquery results from another Uquery.
System, Method, And Data Structure For Automatically Generating Database Queries Which Are Data Model Independent And Cardinality Independent
- Cary NC, US Frederick J. Levine - Hillsborough NC, US James P. Kelley - Cary NC, US
International Classification:
G06F 17/30
US Classification:
707722
Abstract:
Systems and methods are provided for performing a query in a distributed system. In one example, a query generation system receives an identification of data item components and associations between the data item components, wherein the data item components include a measure and a category, and wherein the identified association indicates that the measure is independent of another data item component, indicates that the measure is dependent on another data item component, or indicates that two or more data item components are correlated. The query generation system creates and executes a database query for retrieving data item components, wherein the database query includes a first Uquery, wherein the first Uquery includes a Mx segment subquery and a U0 segment subquery, wherein the Mx segment subquery is associated with a table that contains the measure, a table that contains columns for a calculated measure, or a correlated table, and wherein the U0 segment subquery is associated with a table that contains the category, a table that contains columns for a calculated category, a dependent measure table, or a dependent filter table. In another example, the query generation system generates a virtual results table by aggregating the Uquery results from one Uquery with Uquery results from another Uquery and reports the virtual results table.