Big data computing architecture
First Claim
1. A computer-implemented method comprising:
- receiving, via an adapter, raw data characterizing each of a plurality of transactions, the adapter being coupled to at least one data source;
populating, using the raw data, at least one first table according to a normalized data model;
detecting changes in the at least one first table using database triggers;
populating, by applying a key figure data model to transform and enrich the at least one first table, at least one second table that is de-normalized and optimized for data analysis operations, the at least one second table being populated by replicating a subset of data stored in the at least one first table and providing additional enrichment data derived from the application of the key figure data model, the key figure data model defining how key figures are calculated, the additional enrichment data including direct and indirect key figures generated from calculations from data encapsulated in the at least one first table;
initiating at least one data analysis operation on the data populated in at least one second table to characterize one or more aspects of the transactions; and
providing data characterizing the initiated at least one data operation;
wherein;
the at least one second table is populated in response to the detected changes in the at least one first table;
the at least one first table is persisted in physical data storage separate and distinct from the in-memory database.
2 Assignments
0 Petitions
Accused Products
Abstract
Raw data is received that characterizes each of a plurality of transactions. The data can be received, for example, via an adapter coupled to at least one data source. At least one first table is populated using the raw data according to a normalized data model. At least one second table is then populated, by applying a key figure data model to transform and enrich the at least one first table, such that it is optimized for data analysis operations. The at least one second table can include a subset of data stored in the at least one first table and additional enrichment data. At least one data analysis operation can later be initiated on the data populated in at least one second table to characterize one or more aspects of the transactions. Data can be provided that characterizes the initiated at least one data operation.
15 Citations
20 Claims
-
1. A computer-implemented method comprising:
-
receiving, via an adapter, raw data characterizing each of a plurality of transactions, the adapter being coupled to at least one data source; populating, using the raw data, at least one first table according to a normalized data model; detecting changes in the at least one first table using database triggers; populating, by applying a key figure data model to transform and enrich the at least one first table, at least one second table that is de-normalized and optimized for data analysis operations, the at least one second table being populated by replicating a subset of data stored in the at least one first table and providing additional enrichment data derived from the application of the key figure data model, the key figure data model defining how key figures are calculated, the additional enrichment data including direct and indirect key figures generated from calculations from data encapsulated in the at least one first table; initiating at least one data analysis operation on the data populated in at least one second table to characterize one or more aspects of the transactions; and providing data characterizing the initiated at least one data operation; wherein; the at least one second table is populated in response to the detected changes in the at least one first table; the at least one first table is persisted in physical data storage separate and distinct from the in-memory database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A system comprising:
-
at least one data processor; memory storing instructions which, when executed by the at least one data processor, result in operations comprising; receiving, via an adapter, raw data characterizing each of a plurality of transactions, the adapter being coupled to at least one data source; populating, using the raw data, at least one first table according to a normalized data model; detecting changes in the at least one first table using database triggers; populating, by applying a key figure data model to transform and enrich the at least one first table, at least one second table that is de-normalized and optimized for data analysis operations, the at least one second table being populated by replicating a subset of data stored in the at least one first table and providing additional enrichment data derived from the application of the key figure data model, the key figure data model defining how key figures are calculated, the additional enrichment data including direct and indirect key figures generated from calculations from data encapsulated in the at least one first table; initiating at least one data analysis operation on the data populated in at least one second table to characterize one or more aspects of the transactions; and providing data characterizing the initiated at least one data operation; wherein; the at least one second table is populated in response to the detected changes in the at least one first table; the at least one first table is persisted in physical data storage separate and distinct from the in-memory database. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A non-transitory machine-readable medium storing instructions which, when executed by at least one data processor, result in operations comprising:
-
receiving, via an adapter, raw data characterizing each of a plurality of transactions, the adapter being coupled to at least one data source; populating, using the raw data, at least one first table according to a normalized data model; detecting changes in the at least one first table using database triggers; populating, by applying a key figure data model to transform and enrich the at least one first table, at least one second table that is de-normalized and optimized for data analysis operations, the at least one second table being populated by replicating a subset of data stored in the at least one first table and providing additional enrichment data derived from the application of the key figure data model, the key figure data model defining how key figures are calculated, the additional enrichment data including direct and indirect key figures generated from calculations from data encapsulated in the at least one first table; initiating at least one data analysis operation on the data populated in at least one second table to characterize one or more aspects of the transactions; and providing data characterizing the initiated at least one data operation; wherein; the at least one second table is populated in response to the detected changes in the at least one first table; the at least one first table is persisted in physical data storage separate and distinct from the in-memory database. - View Dependent Claims (18, 19, 20)
-
Specification