Patent Issued for Universal Analytical Data Mart And Data Structure For Same (USPTO 10,628,456)
2020 APR 01 (NewsRx) -- By a
The assignee for this patent, patent number 10,628,456, is
Reporters obtained the following quote 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 obtaining background information on this patent, NewsRx editors 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:
“What is claimed is:
“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.
“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 the 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 data is stored in at least one of a data warehouse, received via a third party interface, and data stored in a data lake.
“10. The system of claim 1 wherein the fact attribute is a payment amount and the dimensional attribute is the 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 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.
“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 the 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 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.
“19. The system 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 system 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.”
For more information, see this patent: Beznos,
(Our reports deliver fact-based news of research and discoveries from around the world.)
Barry, Carole Kaye, FAU donors, die of COVID-19 less than a week apart
AS UNINSURED RATE SKYROCKETS, JAYAPAL & KENNEDY LEAD 30 COLLEAGUES IN INTRODUCING LEGISLATION TO GUARANTEE HEALTH COVERAGE DURING COVID-19 PANDEMIC
Advisor News
- Social cultivation: How to talk with wealthy prospects
- How important is a written financial plan?
- Coalition wants to advise people impacted by policy changes in new administration
- Diagnosing miscommunication in retirement planning
- Election creates an opportunity for advisor/client dialogue
More Advisor NewsAnnuity News
Health/Employee Benefits News
- As Medicare Advantage plans pull out of rural areas, patients stand to lose access to critical care
- Beware of scams during open enrollment for insurance
- Vermonters may be eligible for better health coverage
- Munson Healthcare offers help for Affordable Care Act enrollment
- Doctor’s bills often come with sticker shock for patients – but health insurance could be reinvented to provide costs upfront
More Health/Employee Benefits NewsLife Insurance News