Patent ID: 7657516
Filing Date: 2010-02-02
Classification: G06F,Y10S

Abstract:
1. A method for processing a relational database query, comprising: generating, using a processor coupled to a multidimensional data source, a relational model of the multidimensional data source using one or more of a schema for the multidimensional data source and metadata for the multidimensional data source, forming the relational database query from the relational database application against the relational model of the multidimensional data source using a graphical user interface displayed on a display coupled to the processor, wherein the graphical user interface: receiving the relational database query, the received relational database query being drawn against the relational model of the multidimensional data source, wherein using the relational-to-multidimensional mapping together with relational/multidimensional equivalency logic to construct a multidimensional database query based on the received relational database query, wherein the relational/multidimensional equivalency logic comprises a general mapping between relational queries and structures and multidimensional queries and structures, wherein submitting the constructed multidimensional database query for execution against the modeled multidimensional data source, wherein the multidimensional data source comprises three or more dimensions; and displaying, on the display, a result of the constructed multidimensional database query against the modeled multidimensional data source.