Systems and Methods for Interest-Driven Business Intelligence Systems Including Event-Oriented Data
First Claim
1. An interest-driven business intelligence system, comprising:
- raw data storage configured to contain raw data and perform extract, transform, and load (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 automatically;
generate metadata describing the raw data;
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, where compiling the interest-driven data pipeline comprises;
generating 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;
generating event-oriented data based on the aligned filtered raw data; and
storing the event-oriented data 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.
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.
26 Citations
26 Claims
-
1. An interest-driven business intelligence system, comprising:
-
raw data storage configured to contain raw data and perform extract, transform, and load (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 automatically; generate metadata describing the raw data; 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, where compiling the interest-driven data pipeline comprises; generating 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; generating event-oriented data based on the aligned filtered raw data; and storing the event-oriented data 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. - 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, comprising:
-
storing raw data in raw data storage using an interest-driven business intelligence system, where the raw data comprises unstructured data; generating metadata describing the raw data using the interest-driven business intelligence system; receiving report definitions generated utilizing the metadata describing the raw data using the interest-driven business intelligence system; automatically generating reporting data requirements derived from report definitions using the interest-driven business intelligence system; automatically compiling an interest-driven data pipeline that is part of the interest-driven business intelligence system using the reporting data requirements and the raw data; obtaining event-oriented data from the interest-driven data pipeline based on the generated reporting data requirements using the interest-driven business intelligence system, where the event-oriented data comprises a set of dimensions and the event-oriented data is ordered based on at least one dimension in the set of dimensions; generating reporting data from the reporting data requirements using the interest-driven data pipeline, where the reporting data is based on a portion of the event-oriented data; and storing the generated reporting data in a data mart within the interest-driven business intelligence system. - View Dependent Claims (22, 23, 24, 25)
-
-
26. An interest-driven business intelligence system, comprising:
-
raw data storage configured to contain raw data and perform extract, transform, and load (ETL) processes, where the raw data comprises unstructured data; an intermediate processing layer; a data mart configured to contain metadata that describes the raw data and contained within the intermediate processing layer; and an interest-driven data visualization system; wherein the intermediate processing layer is configured to automatically; generate metadata describing the raw data; 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, where compiling the interest-driven data pipeline comprises; generating 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, where the ordering data comprises time data; aligning the filtered raw data based on the ordering data; generating event-oriented data based on the aligned filtered raw data; and storing the event-oriented data in the data mart; generating ETL processing jobs to generate aggregate data from the raw data by; filtering the raw data based on the metadata describing the raw data; applying transformations to the raw data based on the metadata describing the raw data; generating aggregate data based on the transformed data; and storing the aggregate data in the data mart; generating ETL processing jobs to generate aggregate data from event-oriented data by; identifying at least one dimension within a piece of event-oriented data; obtaining raw data corresponding to the identified at least one dimension; applying transformations to the obtained raw data based on the metadata describing the obtained raw data; generating aggregate data based on the transformed data; and storing the aggregate data in the data mart; generating ETL processing jobs to generate event-oriented data from aggregate data by; identifying at least one dimension within a piece of aggregate data; obtaining raw data corresponding to the identified at least one dimension; filtering the obtained raw data based on the metadata describing the obtained raw data; determining ordering data based on the metadata describing the obtained raw data; aligning the filtered obtained raw data based on the ordering data; generating event-oriented data based on the aligned data; and storing the event-oriented data in the data mart; generating reporting data including data satisfying the reporting data requirements based on the event-oriented data; generating reporting data including data satisfying the reporting data requirements based on the aggregate data; and storing the reporting data in the data mart for exploration by an interest-driven data visualization system; wherein the raw data storage is a data warehouse; and wherein the interest-driven data visualization system is configured to; receive metadata describing the raw data from the intermediate processing layer; and generate a user interface enabling user exploration of the metadata to define at least one report specification, where the user exploration involves selection of additional reporting data based on the metadata.
-
Specification