INTERPRETING RELATIONAL DATABASE STATEMENTS USING A VIRTUAL MULTIDIMENSIONAL DATA MODEL

摘要

The present disclosure provides improved systems, methods, and computer program products suited to address the issues with legacy approaches. Specifically, the present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for interpreting relational database statements using a virtual multidimensional data model. Certain embodiments are directed to technological solutions for receiving a relational database statement comprising relational metadata mapped to a virtual multidimensional representation of a subject database, and generating a subject database statement based at least in part on the relational database statement and the virtual multidimensional representation, and configurable to operate on the subject database to produce a visualization result set, which embodiments advance the technical fields for addressing the problem of projecting a multidimensional data view of a subject database on to a relational data analysis environment to enable real time data analyses, as well as advancing peripheral technical fields.

主权项

1. A method comprising:
identifying a storage facility having a first area to store a subject database and having a second area to store a set of multidimensional metadata, wherein the multidimensional metadata describes one or more measures and one or more dimensions; identifying a query engine, interconnected to the storage facility and configurable to interpret database statements on the subject database; accessing at least one virtual multidimensional representation of the subject database, wherein the virtual multidimensional representation is based at least in part on the one or more measures and the one or more dimensions; associating at least one of, the one or more measures and the one or more dimensions to at least one set of relational metadata, wherein the relational metadata describes a relational database structure; receiving a relational database statement to operate on the relational database structure; and generating a subject database statement, wherein the subject database statement is based at least in part on the relational database statement and the virtual multidimensional representation, and wherein the subject database statement is configurable to operate on the subject database to produce a result set.