System and method for accessing dimensional databases

摘要

In one embodiment, a method includes defining a slice of a dimensional database. The slice includes at least one dimension and at least one measurement and is expressable as a table. The method further includes building, in a structured query language (SQL) dialect, a single query that queries the slice and one or more non-dimensional databases. The SQL dialect represents the at least one dimension, the at least one measurement, and data attributes of the one or more non-dimensional databases. In addition, the method includes parsing the single query. The parsing includes generating a dimensional query for the dimensional database and a non-dimensional query for each of the one or more non-dimensional databases. Furthermore, the method includes executing the dimensional query on the dimensional database. Moreover, the method includes, for each non-dimensional database of the one or more non-dimensional databases, executing the non-dimensional query on the non-dimensional database.

主权项

1. A method comprising:
on a computer system comprising at least one server computer, defining, responsive to user input, a slice of a dimensional database, the slice comprising at least one dimension and at least one measurement of the dimensional database, wherein the slice is expressable as a table; the computer system building, in a structured query language (SQL) dialect, a single query that queries the slice and one or more non-dimensional databases; wherein the SQL dialect represents, using SQL constructs, the at least one dimension, the at least one measurement, and data attributes of the one or more non-dimensional databases; the computer system parsing the single query, the parsing comprising generating a dimensional query for the dimensional database and a non-dimensional query for each of the one or more non-dimensional databases; the computer system executing the dimensional query on the dimensional database; and for each non-dimensional database of the one or more non-dimensional databases, the computer system executing the non-dimensional query on the non-dimensional database.