# US 12,182,170 B2 · Universal analytical data mart and data structure for same > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 12,182,170 B2 - Document ID: US12182170B2 - Status: Granted - Kind: B2 - Application number: 17/973,214 - Filed: 2022-10-25 - Published: 2023-02-23 - Granted: 2024-12-31 - Earliest claimed: 2015-10-30 - Assignees: Hartford Fire Insurance Company - Applicants: Hartford Fire Insurance Company - Inventors: Vladislav Michael Beznos; Lynne C. Clark; Arthur Paul Drennan, III; David J. Kuethman; William C. Lewis; Fred A. Robinson - Web page: https://patentgrep.com/patent/US12182170B2 ## CPC - G06F 16/285: {Clustering or classification} - G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses} - G06Q 20/102: {Bill distribution or payments} - G06Q 40/08: Insurance - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR ## 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. ## Claims ### Claim 1 A system enabling streamlined business intelligence, reporting and ad hoc analysis, the system comprising: at least one processor communicatively coupled to a database, the processor operating with the database to: process data from at least one of a plurality of data sources by processing dimensional and fact attributes from each of a 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 with the fact attributes being associated with the dimensional attributes, the fact attributes being configured in a first table and the dimensional attributes being configured in a second table, the processing of dimensional and fact attributes from each of a plurality of data points being configured to link the fact attributes back to the data including the plurality of data points from the plurality of data sources, and the processing of dimensional and fact attributes from each of a plurality of data points being configured to provide multiple frames of reference including at least two of people, places, objects, and events, when accessing the first table for one of the multiple frames of reference by providing access to the second table providing descriptors to the accessed first table and access linked provided data including the plurality of data points to provide a framework of data linked to a given fact from at least one frame of reference. ### Claim 2 (depends on 1) The system of claim 1 further comprising determining at least one metric for at least one of the fact attributes and storing the at least one metric with the at least one of the fact attributes in the fact table. ### Claim 3 (depends on 1) The system of claim 1 wherein the processing of the dimensional attributes includes generating an anchor identification for providing a key to link the dimensional attribute to a described related fact. ### Claim 4 (depends on 3) The system of claim 3 wherein the dimensional attributes are processed with Astage processing. ### Claim 5 (depends on 1) The system of claim 1 wherein a plurality of pointers are created from the processing fact attributes, the plurality of pointers linking ones of the fact attributes back to the provided data. ### Claim 6 (depends on 1) The system of claim 1 wherein people include parties and actors, wherein objects include insured properties, automobiles and machinery, wherein events include milestones which happen at points in time, and wherein places include addresses with geographic information. ### Claim 7 (depends on 6) The system of claim 6 wherein the geographic information is at various levels of view. ### Claim 8 (depends on 1) The system of claim 1 wherein the data includes at least two of people, places, objects, and events which provide analytical/business value. ### Claim 9 (depends on 1) The system of claim 1 wherein the at least one of a plurality of data sources includes upstream data sources within a company. ### Claim 10 (depends on 1) The system of claim 1 wherein the fact attribute is a payment amount and the dimensional attribute is a payment type. ### Claim 11 (depends on 1) The system of claim 1 wherein the fact attributes and dimensional attributes are processed and linked using at least one extract transform and load process. ### Claim 12 A method for enabling analysis of integrated data from multiple perspectives, the method comprising: processing data from at least one of a plurality of data sources by processing dimensional and fact attributes from each of a 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 with the fact attributes being associated with the dimensional attributes, the fact attributes being configured in a first table and the dimensional attributes being configured in a second table; linking the fact attributes back to the data including the plurality of data points from the plurality of data sources; and providing multiple frames of reference when accessing the first table for one of the multiple frames of reference including at least two of people, places, objects, and events, by providing access to the second table providing descriptors to the accessed first table and access linked provided data including the plurality of data points to provide a framework of data linked to a given fact from at least one frame of reference. ### Claim 13 (depends on 12) The method of claim 12 wherein the processing of dimensional attributes includes reformatting the dimensional attribute to a common format, comparing the reformatted dimensional attribute and creating an anchor identification, performing Astage processing and combining alike entities. ### Claim 14 (depends on 12) The method of claim 12 wherein the processing of fact attributes includes reformatting the fact attribute, picking an identification population and generating an identifier, performing Astage processing and combining alike entities. ### Claim 15 (depends on 12) The method of claim 12 wherein the data includes at least two of people, places, objects, and events which provide analytical/business value. ### Claim 16 (depends on 12) The method of claim 12 wherein the fact attribute is a payment amount and the dimensional attribute is a payment type. ### Claim 17 (depends on 12) The method of claim 12 wherein the fact attributes and dimensional attributes are processed and linked using at least one extract transform and load process including Astage processing and generating anchor identification. ### Claim 18 A non-transitory computer readable medium storing a program for enabling analysis of integrated data from multiple perspectives, wherein the program, when executed by a processor, causes the processor to: process data from at least one of a plurality of data sources by processing dimensional and fact attributes from each of a 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 with the fact attributes being associated with the dimensional attributes, the fact attributes being configured in a first table and the dimensional attributes being configured in a second table; link the fact attributes back to the data including the plurality of data points from the plurality of data sources; and provide multiple frames of reference when accessing the first table for one of the multiple frames of reference including at least two of people, places, objects, and events, by providing access to the second table providing descriptors to the accessed first table and access linked provided data including the plurality of data points to provide a framework of data linked to a given fact from at least one frame of reference. ### Claim 19 (depends on 18) The computer readable medium of claim 18 wherein the processing of the dimensional attributes includes generating an anchor identification for providing a key to link the dimensional attribute to a described related fact. ### Claim 20 (depends on 18) The computer readable medium of claim 18 wherein a plurality of pointers are created from the processing fact attributes, the plurality of pointers linking ones of the fact attributes back to the provided data.