Universal analytical data mart and data structure for same
First Claim
1. A system to allow data from disparate sources to be integrated, enabling streamlined business intelligence, reporting and ad hoc analysis, the system comprising:
- a plurality of different data sources providing data including a plurality of data points stored in a plurality of storage devices;
at least one processor for processing data from each of the plurality of different data sources by processing dimensional and fact attributes from each of the plurality of data points wherein the fact attributes are measurable attributes of the data points and the dimensional attributes are descriptors of the fact attributes; and
a database for storing the processed dimensional and fact attributes from each of the plurality of data points as data in tables in a datamart and linking the fact attributes back to the provided data including the plurality of data points from the plurality of different data sources,wherein the data in the datamart provides multiple frames of reference including at least two of people, places, objects, and events by accessing a fact table for one of the multiple frames of reference by providing access to the dimensional tables providing descriptors to the accessed fact table and access the linked provided data including the plurality of data points.
1 Assignment
0 Petitions
Accused Products
Abstract
A device and method are described for a universal analytical data mart and data structure for same. The analytical data mart (ADM) associated data structure is designed to allow data from disparate sources to be integrated, enabling streamlined business intelligence, reporting and ad hoc analysis. Conceptually, the ADM enables analytics and business intelligence from multiple frames of reference including people, such as parties and actors including individuals and organizations, places, such as addresses with geographic information at various levels of view, objects, such as insured properties, automobiles and machinery, and events, milestones which happen at points in time and provide analytical/business value.
-
Citations
20 Claims
-
1. A system to allow data from disparate sources to be integrated, enabling streamlined business intelligence, reporting and ad hoc analysis, the system comprising:
-
a plurality of different data sources providing data including a plurality of data points stored in a plurality of storage devices; at least one processor for processing data from each of the plurality of different data sources by processing dimensional and fact attributes from each of the plurality of data points wherein the fact attributes are measurable attributes of the data points and the dimensional attributes are descriptors of the fact attributes; and a database for storing the processed dimensional and fact attributes from each of the plurality of data points as data in tables in a datamart and linking the fact attributes back to the provided data including the plurality of data points from the plurality of different data sources, wherein the data in the datamart provides multiple frames of reference including at least two of people, places, objects, and events by accessing a fact table for one of the multiple frames of reference by providing access to the dimensional tables providing descriptors to the accessed fact table and access the linked provided data including the plurality of data points. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A method for integrating data from disparate sources enabling analysis of the integrated data from multiple perspectives, the method comprising:
-
storing data from a plurality of different data sources including a plurality of data points in a plurality of storage devices; processing data points from each of the plurality of different data sources by processing dimensional and fact attributes from each of the plurality of data points wherein the fact attributes are measurable attributes of the data points and the dimensional attributes are descriptors of the fact attributes; storing the processed dimensional and fact attributes from each of the plurality of data points as data in tables in a datamart; and linking the fact attributes back to the provided data including the plurality of data points from the plurality of different data sources, wherein the data in the datamart provides multiple frames of reference including at least two of people, places, objects, and events by accessing a fact table for one of the multiple frames of reference by providing access to the dimensional tables providing descriptors to the accessed fact table and access the linked provided data including the plurality of data points. - View Dependent Claims (13, 14, 15, 16, 17)
-
-
18. A system to allow data from disparate sources to be integrated, enabling streamlined business intelligence, reporting and ad hoc analysis, the system comprising:
-
a plurality of different data sources providing data including a plurality of data points stored in a plurality of storage devices; at least one processor for processing data from each of the plurality of different data sources by processing dimensional and fact attributes from each of the plurality of data points wherein the fact attributes are measurable attributes of the data points and the dimensional attributes are descriptors of the fact attributes; and a database for storing the processed dimensional and fact attributes from each of the plurality of data points as data in tables in a datamart, wherein the data in the datamart provides multiple frames of reference including at least two of people, places, objects, and events by accessing a fact table for one of the multiple frames of reference. - View Dependent Claims (19, 20)
-
Specification