Query of multiple unjoined views
AssigneeBusiness Objects Software Ltd.
InventorDidier Mazoue
Life of this patent
Estimating the term…
Abstract
A system includes identification of two or more information models of a database schema, where each of the two or more information models includes a plurality of dimensions and a respective measure, and is not joined to any other of the two or more information models, generation, for each of the two or more information models, of an auto join on a dimension included in the information model, reception of an object-based query including one or more objects of the two or more information models, generation of one structured language query for each of the two or more information models, obtaining of a result set for each of the two or more structured language queries, and aggregation of the result sets into an aggregated result set.
Claims18
A system comprising:
- a memory storing processor-executable program code;
- and
- a processor to execute the processor-executable program code in order to cause the computing device to:
- identify two or more information models of a database schema, where each of the two or more information models includes a plurality of dimensions and a respective measure, and is not joined to any other of the two or more information models;
- for each of the two or more information models, generate an auto join on a dimension included in the information model;
- receive an object-based query including one or more objects of the two or more information models;
- generate one structured language query for each of the two or more information models;
- obtain a result set for each of the two or more structured language queries;
- and
- aggregate the result sets into an aggregated result set.
A non-transitory computer-readable medium storing program code, the program code executable by a processor of a computing system to cause the computing system to:
- identify two or more information models of a database schema, where each of the two or more information models includes a plurality of dimensions and a respective measure, and is not joined to any other of the two or more information models;
- for each of the two or more information models, generate an auto join on a dimension included in the information model;
- receive an object-based query including one or more objects of the two or more information models;
- generate one structured language query for each of the two or more information models;
- obtain a result set for each of the two or more structured language queries;
- and
- aggregate the result sets into an aggregated result set.
A computer-implemented method comprising:
- identifying two or more information models of a database schema, where each of the two or more information models includes a plurality of dimensions and a respective measure, and is not joined to any other of the two or more information models;
- for each of the two or more information models, generating an auto join on a dimension included in the information model;
- receiving an object-based query including one or more objects of the two or more information models;
- generating one structured language query for each of the two or more information models;
- obtaining a result set for each of the two or more structured language queries;
- and
- aggregating the result sets into an aggregated result set.
Dependencies are inferred from the claim text.