System and method of generating in-memory models from data warehouse models
AssigneeSap SE
InventorLalitendu Samantray
Life of this patent
Estimating the term…
Abstract
A system and method of outputting data from an in-memory database. The method includes converting a first data model (which is unable to be used by the in-memory database) into a second data model (which is), and outputting data according to the second data model. In this manner, a user does not have to rewrite the first data model in order to access the in-memory database.
Claims20
A computer-implemented method of outputting data by an in-memory database system that stores the data, comprising:
- storing, by the in-memory database system, a first data model that corresponds to accessing first data stored by a data warehouse system, wherein the first data model includes a data cube and a characteristic;
- storing second data by the in-memory database system, wherein the in-memory database system is unable to access the second data using the first data model;
- converting, by the in-memory database system, the first data model into a second data model that corresponds to accessing the second data, wherein converting the first data model into the second data model includes converting the data cube into an analytic view and converting the characteristic into a shared attribute view;
- and
- outputting, by the in-memory database system, the second data according to the second data model.
A system for outputting data, comprising:
- a memory implementing an in-memory database that is configured to store a first data model that corresponds to accessing first data stored by a data warehouse system, and is configured to store second data, wherein the first data model includes a data cube and a characteristic, and wherein the in-memory database system is unable to access the second data using the first data model;
- and
- a processor that is configured to convert the first data model into a second data model that corresponds to accessing the second data, wherein converting the first data model into the second data model includes converting the data cube into an analytic view and converting the characteristic into a shared attribute view,
- wherein the processor is configured to control the in-memory database to output the second data according to the second data model.
A non-transitory computer readable medium storing instructions to control a computer system for outputting data, comprising:
- an in-memory database component that is configured to control the computer system to store a first data model that corresponds to accessing first data stored by a data warehouse system, and is configured to store second data, wherein the first data model includes a data cube and a characteristic, and wherein the in-memory database system is unable to access the second data using the first data model;
- a processing component that is configured control the computer system to convert the first data model into a second data model that corresponds to accessing the second data, wherein converting the first data model into the second data model includes converting the data cube into an analytic view and converting the characteristic into a shared attribute view;
- and
- an output component that is configured control the computer system to output the second data according to the second data model.
Dependencies are inferred from the claim text.