Patent Issued for Universal analytical data mart and data structure for same (USPTO 11487790): Hartford Fire Insurance Company

2022 NOV 17 (NewsRx) -- By a News Reporter-Staff News Editor at Insurance Daily News -- A patent by the inventors Beznos, Vladislav Michael (Longmeadow, MA, US), Clark, Lynne C. (Bristol, CT, US), Drennan, III, Arthur Paul (West Granby, CT, US), Kuethman, David J. (Wethersfield, CT, US), Lewis, William C. (Avon, CT, US), Robinson, Fred A. (East Hartford, CT, US), filed on March 26, 2020, was published online on November 1, 2022, according to news reporting originating from Alexandria, Virginia, by NewsRx correspondents.

Patent number 11487790 is assigned to Hartford Fire Insurance Company (Hartford, Connecticut, United States).

The following quote was obtained by the news editors from the background information supplied by the inventors: “An entity may want to analyze or “mine” large amounts of data. For example, a company might want to analyze tens of thousands of files to look for patterns (e.g., a particular type of injury has occurred more frequently for employees who work in a particular industry). An entity might analyze this data in connection with different types of applications, and, moreover, different applications may need to analyze the data differently. For example, the term “IV” might referent to an “Insured Vehicle” when it appears in an automobile accident report and to “Intra-Venous” when it appears in a medical file. It can be difficult to identify patterns across such large amounts of data and different types of applications. In addition, manually managing the different needs and requirements (e.g., different business logic rules) associated with different applications can be a time consuming and error prone process. As a result, it would be desirable to provide systems and methods for efficiently and accurately preparing data for analysis, integrating the data to the workflow of the business, and inputting rules of users.”

In addition to the background information obtained for this patent, NewsRx journalists also obtained the inventors’ summary information for this patent: “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.

“A system and method are disclosed. The system and method allow data from disparate sources to be integrated, enabling streamlined business intelligence, reporting and ad hoc analysis. The system and method include a plurality of different data sources providing data 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 data from each of the plurality of different data sources, and a database for storing the processed dimensional and fact data from each of the plurality of different data sources as data in a datamart. The data in the datamart provides multiple frames of reference including at least two of people, places, objects, and events.

“The system and method allow data from disparate sources to be integrated, enabling streamlined business intelligence, reporting and ad hoc analysis. The system and method include 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. 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 the system 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.”

The claims supplied by the inventors are:

“1. A system enabling streamlined business intelligence, reporting and ad hoc analysis, the system comprising: at least one processor for processing data from at least one of a plurality of data sources including at least one data warehouse 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; 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 data including the plurality of data points from the plurality of data sources and providing 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 dimensional tables providing descriptors to the accessed fact table and access linked provided data including the plurality of data points.

“2. 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.

“3. 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.

“4. The system of claim 3 wherein the dimensional attributes are processed with Astage processing.

“5. 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.

“6. 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.

“7. The system of claim 6 wherein the geographic information is at various levels of view.

“8. The system of claim 1 wherein the at least two of people, places, objects, and events provide analytical/business value.

“9. The system of claim 1 wherein the at least one of a plurality of data sources includes upstream data sources within a company.

“10. The system of claim 1 wherein the fact attribute is a payment amount and the dimensional attribute is a payment type.

“11. 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.

“12. A method for enabling analysis of the integrated data from multiple perspectives, the method comprising: processing data points from at least one of a plurality of data sources including at least one data warehouse 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; linking the fact attributes back to the provided data including the plurality of data points from the plurality of data sources; and providing 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 an accessed fact table and access the linked provided data including the plurality of data points.

“13. 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.

“14. 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.

“15. The method of claim 12 wherein the at least two of people, places, objects, and events provide analytical/business value.

“16. The method of claim 12 wherein the fact attribute is a payment amount and the dimensional attribute is a payment type.

“17. 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.

“18. A non-transitory computer readable medium storing a program for enabling analysis of the integrated data from multiple perspectives, wherein the program, when executed by a processor, causes the processor to: process data points from at least one of a plurality of data sources including at least one data warehouse 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; store the processed dimensional and fact attributes from each of the plurality of data points as data in tables in a datamart; link the fact attributes back to the provided data including the plurality of data points from the plurality of data sources; and provide 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 an accessed fact table and access the linked provided data including the plurality of data points.

“19. 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 the described related fact.

“20. 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.”

URL and more information on this patent, see: Beznos, Vladislav Michael. Universal analytical data mart and data structure for same. U.S. Patent Number 11487790, filed March 26, 2020, and published online on November 1, 2022. Patent URL: http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO1&Sect2=HITOFF&d=PALL&p=1&u=%2Fnetahtml%2FPTO%2Fsrchnum.htm&r=1&f=G&l=50&s1=11487790.PN.&OS=PN/11487790RS=PN/11487790

(Our reports deliver fact-based news of research and discoveries from around the world.)