Interpreting relational database statements using a virtual multidimensional data model

A computer program product, embodied in a non-transitory computer readable medium, the non-transitory computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a process, the process comprising:

• selecting at least one of:
• one or more measures, one or more dimensions, or one or more relationships, based at least in part on a schema that characterizes a subject database;
• generating at least one virtual multidimensional representation of the subject database based at least in part on at least one of:
• the one or more measures, the one or more dimensions, or the one or more relationships;
• generating, from the virtual multidimensional representation, relational metadata describing a relational database structure, wherein the relational metadata is based at least in part on the at least one of:
• the one or more measures the one or more dimensions, or the one or more relationships, comprising the at least one virtual multidimensional representation;
• receiving at least one relational database statement conforming to the relational metadata generated at least in part from the at least one virtual multidimensional representation;
• formulating at least one logical plan from at least one of:
• the at least one relational database statement, or the at least one virtual multidimensional representation;
• and
• generating at least one subject database statement to issue to a query engine to interpret on the subject database, the at least one subject database statement based at least in part on the at least one logical plan.

A system comprising:

• a network access port to communicate over a bus to a query engine, wherein the query engine is interconnected to a storage facility having a first area to store a subject database and having a second area to store a schema, and wherein the query engine is interprets subject database statements on the subject database;
• a data analytics engine comprising a processor to receive communications over the network access port, and to perform operations of,
• selecting at least one of:
• one or more measures, one or more dimensions, or one or more relationships, based at least in part on the schema that characterizes the subject database;
• generating at least one virtual multidimensional representation of the subject database based at least in part on at least one of:
• the one or more measures, the one or more dimensions, or the one or more relationships;
• and
• generating, from the virtual multidimensional representation, relational metadata describing a relational database structure, wherein the relational metadata is based at least in part on the at least one of:
• the one or more measures, the one or more dimensions, or the one or more relationships comprising the at least one virtual multidimensional representation;
• receiving at least one relational database statement conforming to the relational metadata generated at least in part from the at least one virtual multidimensional representation;
• formulating at least one logical plan from at least one of:
• the at least one relational database statement, or the at least one virtual multidimensional representation;
• and
• generating at least one subject database statement to issue to the query engine, the at least one subject database statement based at least in part on the at least one logical plan.