Extreme visualization enabling extension for large data sets

Patent metadata

Field	Value
Publication number	US-9396240-B2
Application number	US-201314095441-A
Country	US
Kind code	B2
Filing date	Dec 3, 2013
Priority date	Dec 3, 2013
Publication date	Jul 19, 2016
Grant date	Jul 19, 2016

Abstract

The present disclosure describes methods, systems, and computer program products for enabling extreme visualization for large data sets stored in a database. One computer-implemented method includes receiving a request for an input schema to feed to a data specification language (DaSL) and a metadata outline of typed objects exposed by a database view identified in the request, requesting extraction of the input schema and metadata outline from the database, creating an instance of a DaSL compiler based upon the input schema, generating, by a computer, a DaSL query corresponding to objects selected from the metadata outline, requesting compilation of the DaSL query, and receiving a calculation plan and topology cursors responsive to the compilation of the DaSL query.

First claim

What is claimed is:

1. A computer-implemented method comprising:
receiving a request for an input schema to feed to a data specification language (DaSL) and a metadata outline of typed objects exposed by a database view identified in the request, the database view associated with the database selected using a graphical user interface;
requesting extraction of the input schema and metadata outline from the database;
creating an instance of a DaSL compiler based upon the input schema;
generating, by a computer, a DaSL query corresponding to objects selected from the metadata outline, the DaSL query including low-level primitive queries compiled into a computing language construct supported by the database, mapped to a specific DaSL operator, dynamically compiled at query runtime, and executed to retrieve data from the database conforming to the request;
requesting compilation of the DaSL query;
receiving a calculation plan and topology cursors responsive to the compilation of the DaSL query; and
initiating visualization of a dataset responsive to the execution of the calculation plan using the topology cursors.

2. The method of claim 1 , wherein the extraction of the input schema and metadata outline is performed by a model extraction component.

3. The method of claim 1 , further comprising transmitting the metadata outline for display.

4. The method of claim 1 , further comprising compiling the DaSL query into the calculation plan and topology cursors used to visualize data.

5. The method of claim 1 , further comprising executing the calculation plan in the database.

6. A non-transitory, computer-readable medium storing computer-readable instructions executable by a computer and operable to:
receive a request for an input schema to feed to a data specification language (DaSL) and a metadata outline of typed objects exposed by a database view identified in the request, the database view associated with the database selected using a graphical user interface;
request extraction of the input schema and metadata outline from the database;
create an instance of a DaSL compiler based upon the input schema;
generate a DaSL query corresponding to objects selected from the metadata outline, the DaSL query including low-level primitive queries compiled into a computing language construct supported by the database, mapped to a specific DaSL operator, dynamically compiled at query runtime, and executed to retrieve data from the database conforming to the request;
request compilation of the DaSL query;
receive a calculation plan and topology cursors responsive to the compilation of the DaSL query; and
initiate visualization of a dataset responsive to the execution of the calculation plan using the topology cursors.

7. The medium of claim 6 , wherein the extraction of the input schema and metadata outline is performed by a model extraction component.

8. The medium of claim 6 , further comprising instructions operable to transmit the metadata outline for display.

9. The medium of claim 6 , further comprising instructions operable to compile the DaSL query into the calculation plan and topology cursors used to visualize data.

10. The medium of claim 6 , further comprising instructions operable to execute the calculation plan in the database.

11. A system, comprising:
at least one computer interoperably coupled with a memory storage and configured to:
receive a request for an input schema to feed to a data specification language (DaSL) and a metadata outline of typed objects exposed by a database view identified in the request, the database view associated with the database selected using a graphical user interface;
request extraction of the input schema and metadata outline from the database;
create an instance of a DaSL compiler based upon the input schema;
generate a DaSL query corresponding to objects selected from the metadata outline, the DaSL query including low-level primitive queries compiled into a computing language construct supported by the database, mapped to a specific DaSL operator, dynamically compiled at query runtime, and executed to retrieve data from the database conforming to the request;
request compilation of the DaSL query;
receive a calculation plan and topology cursors responsive to the compilation of the DaSL query; and
initiate visualization of a dataset responsive to the execution of the calculation plan using the topology cursors.

12. The system of claim 11 , wherein the extraction of the input schema and metadata outline is performed by a model extraction component.

13. The system of claim 11 , further configured to transmit the metadata outline for display.

14. The system of claim 11 , further configured to compile the DaSL query into the calculation plan and topology cursors used to visualize data.

15. The system of claim 11 , further configured to
execute the calculation plan in the database.

Assignees

• Marinoiu Bogdan
• Le Biannic Yann
• Business Objects Software Ltd

Inventors

• Marinoiu Bogdan
• Le Biannic Yann

Classifications

• G06F17/30572

  Physics · mapped topic

• G06F17/30563 Primary

  Physics · mapped topic

• G06F16/26 Primary

  Visual data mining; Browsing structured data · CPC title

• G06F16/254 Primary

  Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses · CPC title