System and method for accessing dimensional databases

Patent metadata

Field	Value
Publication number	US-9495437-B1
Application number	US-201514869072-A
Country	US
Kind code	B1
Filing date	Sep 29, 2015
Priority date	Nov 6, 2013
Publication date	Nov 15, 2016
Grant date	Nov 15, 2016

Abstract

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.

First claim

What is claimed is:

1. A method comprising, by a computer system:
receiving a selection of a plurality of data sources from a user, the plurality of data sources comprising a slice of a dimensional database and one or more non-dimensional databases, the slice comprising at least one dimension and at least one measurement of the dimensional database, wherein the slice is expressable as a table;
providing, to the user, data attributes of each of the plurality of data sources;
permitting the user to graphically build a single query that queries the slice and the one or more non-dimensional databases;
receiving selected data attributes from the user responsive to the permitting; and
constructing the single query in a SQL dialect, 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.

2. The method of claim 1 , comprising, prior to the receiving the selection of the plurality of data sources from the user, defining, responsive to user input, the slice of the dimensional database.

3. The method of claim 2 , wherein the defining comprises:
receiving a selection of a dimensional data source from a user;
providing a listing of measurements and dimensions associated with the dimensional data source;
receiving a selection of the at least one dimension and the at least one measurement; and
building a SQL-dialect query representative of the slice.

4. The method of claim 2 , wherein the defining comprises adding at least one virtual column.

5. The method of claim 2 , wherein the defining comprises showing a live view of the slice as the user manipulates the slice.

6. The method of claim 1 , comprising 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.

7. The method of claim 6 , wherein the parsing comprises:
translating the single query from the SQL dialect to SQL; and
parsing the translated single query to generate the dimensional query and the non-dimensional query.

8. The method of claim 6 , comprising:
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.

9. The method of claim 8 , comprising combining query results and returning resultant data.

10. The method of claim 9 , comprising presenting the resultant data to a user.

11. The method of claim 1 , wherein the slice comprises a SQL-dialect query, the single query including the SQL-dialect query in a subselect statement.

12. The method of claim 1 , wherein the single query comprises a table-identifier prefix for the slice and a table-identifier prefix for each of the one or more non-dimensional databases.

13. An information handling system comprising at least one processor, wherein the at least one processor is operable to implement a method comprising:
receiving a selection of a plurality of data sources from a user, the plurality of data sources comprising a slice of a dimensional database and one or more non-dimensional databases, the slice comprising at least one dimension and at least one measurement of the dimensional database, wherein the slice is expressable as a table;
providing, to the user, data attributes of each of the plurality of data sources;
permitting the user to graphically build a single query that queries the slice and the one or more non-dimensional databases;
receiving selected data attributes from the user responsive to the permitting; and
constructing the single query in a SQL dialect, 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.

14. The information handling system of claim 13 , the method comprising, prior to the receiving the selection of the plurality of data sources from the user, defining, responsive to user input, the slice of the dimensional database.

15. The information handling system of claim 14 , wherein the defining comprises:
receiving a selection of a dimensional data source from a user;
providing a listing of measurements and dimensions associated with the dimensional data source;
receiving a selection of the at least one dimension and the at least one measurement; and
building a SQL-dialect query representative of the slice.

16. The information handling system of claim 14 , wherein the defining comprises adding at least one virtual column.

17. The information handling system of claim 14 , wherein the defining comprises showing a live view of the slice as the user manipulates the slice.

18. The information handling system of claim 13 , the method comprising 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.

19. The information handling system of claim 18 , wherein the parsing comprises:
translating the single query from the SQL dialect to SQL; and
parsing the translated single query to generate the dimensional query and the non-dimensional query.

20. A computer-program product comprising a non-transitory computer-usable medium having computer-readable program code embodied therein, the computer-readable program code adapted to be executed to implement a method comprising:
receiving a selection of a plurality of data sources from a user, the plurality of data sources comprising a slice of a dimensional database and one or more non-dimensional databases, the slice comprising at least one dimension and at least one measurement of the dimensional database, wherein the slice is expressable as a table;
providing, to the user, data attributes of each of the plurality of data sources;
permitting the user to graphically build a single query that queries the slice and the one or more non-dimensional databases;
receiving selected data attributes from the user responsive to the permitting; and
constructing the single query in a SQL dialect, 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.

Assignees

• Dell Software Inc

Inventors

• Jonsson Jan Henrik
• Peabody Debbie M
• Bazhenov Aleksey Mikhailovich

Classifications

• G06F17/30563

  Physics · mapped topic

• G06F17/30982

  Physics · mapped topic

• G06F17/30592 Primary

  Physics · mapped topic

• G06F17/30864

  Physics · mapped topic

• G06F17/30418

  Physics · mapped topic