Analytical server including metrics engine
AssigneeHyperion Solutions Corporation
InventorsArun Shah, Robert F. Novy
Life of this patent
Estimating the term…
Abstract
Disclosed is a method for determining database queries to be sent by an analytical server to a Relational Database Monitoring System (RDBMS) by using hierarchical level metadata to describe the various structures within the database.
Claims16
A method of executing a metric query for a relational database, the relational database having fact tables, dimension tables, and metadata describing the relationships between the fact and dimension tables, wherein the fact tables include measures which can be additive or non-additive, and wherein the metadata includes a designation specifying by dimension which measures are additive and which measures are non-additive, the method comprising:
- receiving the metric query from a client;
- determining which hierarchical levels of the fact and dimension tables are available in the relational database for responding to the metric query;
- determining at least one database query according to the available hierarchical levels of the fact and dimension tables;
- retrieving data corresponding to the at least one database query from the relational database;
- and
- responding to the metric query based on the data retrieved, whereby the response is tailored to the most efficient hierarchical level necessary depending on whether the measures of the requested metric are additive.
A method of executing a metric query for a relational database, the relational database having fact tables, dimension tables, and metadata describing the relationships between the fact and dimension tables, the method comprising:
- receiving the metric query from a client;
- determining which hierarchical levels of the fact and dimension tables are available in the relational database for responding to the metric query, wherein at least one measure within the fact and dimension tables are insufficiently fine in a requested dimension in order to respond to the metric query;
- determining at least one metric by which the at least one measure which was unavailable at the requested fineness can be approximated by the using the measure along the requested dimension at a higher hierarchical level than the one needed to directly respond to the metric query;
- and
- sending a database query to the relational database based on the determining of available hierarchical levels of the fact and data tables and upon at least one higher hierarchical level for the needed measure along the dimension which was unavailable at the needed hierarchical level.
Dependencies are inferred from the claim text.