DATA PROVIDER WITH TRANSIENT UNIVERSE

• US 20110093487A1
• Filed: 10/16/2009
• Published: 04/21/2011
• Est. Priority Date: 10/16/2009
• Status: Abandoned Application

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects Incorporated (SAP SE)
• Inventors: Calvente, Juan Francisco, O'Byrne, John, Le Biannic, Yann
• Application Number:
  US12/580,787
• Publication Number:
  US 20110093487A1
• Time in Patent Office: Days
• US Class Current: 707/765
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A computer-implemented system to receive an instruction to initialize a data provider associated with an analysis cube and a dataset, and, in response to the instruction, acquire first metadata associated with the analysis cube and generate, based on the first metadata, second metadata of an abstraction layer comprising a plurality of objects. A query comprising a first plurality of objects of the abstraction layer is received, the query is transformed to a query state based on the second metadata of the abstraction layer, and a result set is acquired from the dataset using the query state and the analysis cube.

Claims

1. A computer-implemented method comprising:

receiving an instruction to initialize a data provider associated with an analysis cube and a dataset;

in response to the instruction, acquiring first metadata associated with the analysis cube and generating, based on the first metadata, second metadata of an abstraction layer comprising a plurality of objects;

receiving a query comprising a first plurality of objects of the abstraction layer;

transforming the query to a query state based on the second metadata of the abstraction layer; and

acquiring a result set from the dataset using the query state and the analysis cube.

2. A method according to claim 1, further comprising:

receiving an instruction to refresh the data provider; and

in response to the instruction, acquiring third metadata associated with the analysis cube and generating, based on the third metadata, fourth metadata of a second abstraction layer comprising a second plurality of objects.

3. A method according to claim 2, further comprising:

receiving an instruction to refresh the query;

transforming the query to a new query state based on the fourth metadata of the second abstraction layer; and

acquiring a second result set from the dataset using the new query state and the analysis cube.

4. A method according to claim 3, further comprising:

receiving a query representation embodying a second query state and associated with the analysis cube;

generating a query specification based on the second query state and on the fourth metadata of the second abstraction layer; and

acquiring a third result set from the dataset using the second query state and the analysis cube.

5. A method according to claim 1, further comprising:

receiving a query representation embodying a second query state and associated with the analysis cube;

generating a query specification based on the second query state and on the second metadata of the abstraction layer; and

acquiring a second result set from the dataset using the second query state and the analysis cube.

6. A method according to claim 1, wherein receiving the query comprises receiving values of one or more variables associated with the analysis cube.

7. A method according to claim 6, further comprising:

updating the second metadata based on the values of the one or more variables.

8. A computer-readable medium having stored thereon program code, the program code executable by a computer to:

receive an instruction to initialize a data provider associated with an analysis cube and a dataset;

in response to the instruction, acquire first metadata associated with the analysis cube and generate, based on the first metadata, second metadata of an abstraction layer comprising a plurality of objects;

receive a query comprising a first plurality of objects of the abstraction layer;

transform the query to a query state based on the second metadata of the abstraction layer; and

acquire a result set from the dataset using the query state and the analysis cube.

9. A medium according to claim 8, the program code further executable by a computer to:

receive an instruction to refresh the data provider; and

in response to the instruction, acquire third metadata associated with the analysis cube and generate, based on the third metadata, fourth metadata of a second abstraction layer comprising a second plurality of objects.

10. A medium according to claim 9, the program code further executable by a computer to:

receive an instruction to refresh the query;

transform the query to a new query state based on the fourth metadata of the second abstraction layer; and

acquire a second result set from the dataset using the new query state and the analysis cube.

11. A medium according to claim 10, the program code further executable by a computer to:

receive a query representation embodying a second query state and associated with the analysis cube;

generate a query specification based on the second query state and on the fourth metadata of the second abstraction layer; and

acquire a third result set from the dataset using the second query state and the analysis cube.

12. A medium according to claim 8, the program code further executable by a computer to:

receive a query representation embodying a second query state and associated with the analysis cube;

generate a query specification based on the second query state and on the second metadata of the abstraction layer; and

acquire a second result set from the dataset using the second query state and the analysis cube.

13. A medium according to claim 8, wherein the program code executable by a computer to receive the query comprises program code executable by a computer to:

receive values of one or more variables associated with the analysis cube.

14. A medium according to claim 8, the program code further executable by a computer to:

update the second metadata based on the values of the one or more variables.

15. A system comprising:

a dataset; and

a data provider to;

receive a reference to an analysis cube associated with a dataset;

in response to the reference, acquire first metadata associated with the analysis cube and generate, based on the first metadata, second metadata of an abstraction layer comprising a plurality of objects;

receive a query comprising a first plurality of objects of the abstraction layer;

transform the query to a query state based on the second metadata of the abstraction layer; and

acquire a result set from the dataset using the query state and the analysis cube.

16. A system according to claim 15, the data provider further to:

receive an instruction to refresh itself; and

in response to the instruction, acquire third metadata associated with the analysis cube and generate, based on the third metadata, fourth metadata of a second abstraction layer comprising a second plurality of objects.

17. A system according to claim 16, the data provider further to:

receive an instruction to refresh the query;

transform the query to a new query state based on the fourth metadata of the second abstraction layer; and

acquire a second result set from the dataset using the new query state and the analysis cube.

18. A system according to claim 17, the data provider further to:

receive a query representation embodying a second query state and associated with the analysis cube;

generate a query specification based on the second query state and on the fourth metadata of the second abstraction layer; and

acquire a third result set from the dataset using the second query state and the analysis cube.

19. A system according to claim 15, the data provider further to:

receive a query representation embodying a second query state and associated with the analysis cube;

generate a query specification based on the second query state and on the second metadata of the abstraction layer; and

acquire a second result set from the dataset using the second query state and the analysis cube.

20. A system according to claim 15, wherein reception of the query comprises:

reception of values of one or more variables associated with the analysis cube.

21. A system according to claim 15, the data provider further to:

update the second metadata based on the values of the one or more variables.