Systems and methods for interest-driven business intelligence systems including event-oriented data
First Claim
1. An interest-driven business intelligence system for processing business data, comprising:
- raw data storage comprising at least one hardware processor and at least one memory, containing raw data and capable of executing extract, transform, and load (ETL) processes; and
an intermediate processing layer comprising at least one hardware processor, at least one memory, and a data mart containing metadata that describes the raw data;
wherein the intermediate processing layer is configured to automatically;
generate metadata describing the raw data;
store the generated metadata using the data mart;
derive reporting data requirements from at least one report specification based on the metadata; and
compile an interest-driven data pipeline based upon the reporting data requirements, wherein compiling the interest-driven data pipeline comprises;
generating ETL processing jobs to generate event-oriented data from the raw data by;
obtaining raw data from a plurality of fact tables stored using the raw data storage;
filtering the raw data based on the metadata describing the raw data;
determining ordering data based on the metadata describing the raw data, wherein the ordering data comprises at least one dimension described in the plurality of fact tables;
aligning, based on the ordering data, the filtered raw data to generate event-oriented data, wherein the aligned filtered raw data comprises data taken from the plurality of fact tables and ordered based on at least one dimension described in the ordering;
data, wherein the aligning of the filtered raw data comprises;
mapping the ordering data to the filtered raw data, wherein the ordering data is mapped to the at least one dimension of the filtered raw data; and
resolving differences between the ordering data and the metadata to obtain the event-oriented data;
storing the event-oriented data in the data mart;
generating event-oriented metadata describing the event-oriented data; and
storing the event-oriented metadata in the data mart;
generating reporting data including data satisfying the reporting data requirements based on the event-oriented data; and
storing the reporting data in the data mart for exploration by an interest-driven data visualization system; and
update the event-oriented data based on a request received from the interest-driven data visualization system, wherein updating the event-oriented data comprises determining redundancies between the event-oriented data and updated event-oriented data, wherein determining the redundancies is based at least in part on the event-oriented metadata.
2 Assignments
0 Petitions
Accused Products
Abstract
Systems and methods for interest-driven business intelligence systems including event-oriented data in accordance with embodiments of the invention are illustrated. In one embodiment, an interest-driven business intelligence system includes raw data storage configured to contain raw data and perform ETL processes, a data mart configured to contain metadata that describes the raw data, and an intermediate processing layer, wherein the intermediate processing layer is configured to compile an interest-driven data pipeline configured to generate ETL processing jobs to generate event-oriented data from the raw data by filtering the raw data based on the metadata describing the raw data, determining ordering data based on the metadata describing the raw data, aligning the filtered raw data based on the ordering data, and generating event-oriented data based on the aligned filtered raw data, and storing the event-oriented data in the data mart.
81 Citations
25 Claims
-
1. An interest-driven business intelligence system for processing business data, comprising:
-
raw data storage comprising at least one hardware processor and at least one memory, containing raw data and capable of executing extract, transform, and load (ETL) processes; and an intermediate processing layer comprising at least one hardware processor, at least one memory, and a data mart containing metadata that describes the raw data; wherein the intermediate processing layer is configured to automatically; generate metadata describing the raw data; store the generated metadata using the data mart; derive reporting data requirements from at least one report specification based on the metadata; and compile an interest-driven data pipeline based upon the reporting data requirements, wherein compiling the interest-driven data pipeline comprises; generating ETL processing jobs to generate event-oriented data from the raw data by; obtaining raw data from a plurality of fact tables stored using the raw data storage; filtering the raw data based on the metadata describing the raw data; determining ordering data based on the metadata describing the raw data, wherein the ordering data comprises at least one dimension described in the plurality of fact tables; aligning, based on the ordering data, the filtered raw data to generate event-oriented data, wherein the aligned filtered raw data comprises data taken from the plurality of fact tables and ordered based on at least one dimension described in the ordering;
data, wherein the aligning of the filtered raw data comprises;
mapping the ordering data to the filtered raw data, wherein the ordering data is mapped to the at least one dimension of the filtered raw data; and
resolving differences between the ordering data and the metadata to obtain the event-oriented data;storing the event-oriented data in the data mart; generating event-oriented metadata describing the event-oriented data; and storing the event-oriented metadata in the data mart; generating reporting data including data satisfying the reporting data requirements based on the event-oriented data; and storing the reporting data in the data mart for exploration by an interest-driven data visualization system; and update the event-oriented data based on a request received from the interest-driven data visualization system, wherein updating the event-oriented data comprises determining redundancies between the event-oriented data and updated event-oriented data, wherein determining the redundancies is based at least in part on the event-oriented metadata. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20)
-
-
21. A method for creating a report utilizing an interest-driven business intelligence system for processing business data, comprising:
-
storing raw data in a raw data storage; automatically generating metadata describing the raw data; automatically storing the generated metadata in a data mart; automatically deriving reporting data requirements from at least one report specification based on the metadata; automatically compiling an interest-driven data pipeline based upon the reporting data requirements, wherein compiling the interest-driven data pipeline comprises; generating ETL processing jobs to generate event-oriented data from the raw data by; obtaining raw data from a plurality of fact tables stored using the raw data storage; filtering the raw data based on the metadata describing the raw data; determining ordering data based on the metadata describing the raw data, wherein the ordering data comprises at least one dimension described in the plurality of fact tables; aligning, based on the ordering data, the filtered raw data to generate event-oriented data, wherein the aligned filtered raw data comprises data taken from the plurality of fact tables and ordered based on at least one dimension described in the ordering data, wherein the aligning of the filtered raw data comprises; mapping the ordering data to the filtered raw data, wherein the ordering data is mapped to the at least one dimension of the filtered raw data; and resolving differences between the ordering data and the metadata to obtain the event-oriented data; storing the event-oriented data in the data mart; generating event-oriented metadata describing the event-oriented data; and storing the event-oriented metadata in the data mart; generating reporting data including data satisfying the reporting data requirements based on the event-oriented data; and storing the reporting data in the data mart for exploration by an interest-driven data visualization system; and automatically updating the event-oriented data based on a request received from the interest-driven data visualization system, wherein updating the event-oriented data comprises determining redundancies between the event-oriented data and updated event-oriented data, wherein determining the redundancies is based at least in part on the event-oriented metadata. - View Dependent Claims (22, 23, 24, 25)
-
Specification