Transformation engine

• US 8,631,050 B1
• Filed: 03/08/2013
• Issued: 01/14/2014
• Est. Priority Date: 06/11/2009
• Status: Active Grant

• Current Assignee: Corefount, LLC
• Original Assignee: Eliving, LLC
• Inventors: Gayle, Noel G.
• Primary Examiner(s): Coby, Frantz
• Application Number:
  US13/791,546
• Time in Patent Office: 312 Days
• Field of Search: 707/602, 707/604, 707/609, 707/641, 707/654, 707/769, 707/802, 707/804, 707/805, 707/941
• US Class Current: 707/803
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

A transformation engine is disclosed that retrieves source data from a plurality of disparate data sources and provides source data that is consistent and normalized. the transformation engine comprises a plurality of interfaces that receive source data from a plurality of disparate databases. The source data comprises a plurality of data elements. The transformation engine further comprises a converter that aggregates and converts the received source data so that the plurality of data elements are recognizable as being substantially equivalent; a data processor that formats the received source data by merging and preparing the received source data; and a business rule applicator that filters the received source data.

Claims

1. A computer comprising a transformation engine that retrieves source data from a plurality of disparate data sources and provides source data that is consistent and normalized, the transformation engine comprising:

a plurality of interfaces that receive source data from a plurality of disparate databases, the source data comprising a plurality of data elements;

an aggregator that aggregates the received source data to create aggregated source data;

a converter-normalizer that applies a normalization algorithm to at least a portion of the aggregated source data to create normalized source data;

a data processor that categorizes the normalized source data into a plurality of data categories;

a business rule applicator that applies one or more business rules to the plurality of data categories to identify pertinent data; and

,

a model generator that generates an application model based at least in part on the identified pertinent data.

2. The computer comprising the transformation engine of claim 1, further comprising:

a converter-normalizer that analyzes a first source data and a second source data in the received source data and formats the first source data or the second source data so that a quantity of a first data element in the plurality of data elements is determined to be equivalent to a quantity of a second data element.

3. The computer comprising the transformation engine of claim 1, wherein the data processor is configured to receive a first source data and a second source data and format the first source data or the second source data in accordance with an input format of the business rule applicator.

4. The computer comprising the transformation engine of claim 1, wherein the plurality of interfaces comprise an application program interface.

5. The computer comprising the transformation engine of claim 1, wherein plurality of interfaces comprise an open database connectivity.

6. The computer comprising the transformation engine of claim 1, wherein plurality of interfaces comprise an input-output-interface.

7. The computer comprising the transformation engine of claim 4, wherein the application program interface is executed by the computer to access at least one of:

a USDA database;

an FDA database;

a PDR database;

an ADA database;

an MDM database;

an IM database;

an RDA/RDI database;

a REF database; and

an RMMS database.

8. The computer comprising the transformation engine of claim 1, wherein the business rule applicator identifies pertinent data based at least in part on the input requirements of at least one of:

a nutrient caloric intake processor;

a drug interaction processor; and

a nutrient impact processor.

9. The computer comprising a condition engine that includes the transformation engine of claim 1.

10. A method for transforming source data that is received from a plurality of disparate data sources to source data that is consistent, mapped and correlated, the method comprising:

receiving, at a plurality of interfaces, the source data from the plurality of disparate data sources, the source data comprising a first data element and a second data element;

converting and normalizing the received source data from the plurality of disparate data sources so that the first data element and the second data element are recognizable as being equivalent;

parsing the converted and normalized source data;

categorizing the parsed source data; and

applying a business rule to the categorized source data to identify pertinent data; and

,

generating an application model based at least in part on the identified pertinent data.

11. The method of claim 10, further comprising:

analyzing the received source data; and

formatting the received source data so that a quantity of the first data element is determined to be equivalent to a quantity of a third data element.

12. The method of claim 10, wherein the parsing the converted and normalized source data and the categorizing the parsed source data are performed in accordance with an input format of a business rule applicator.

13. The method of claim 10, wherein pertinent data is identified based at least in part on input requirements of at least one of:

a nutrient caloric intake processor;

a drug interaction processor; and

a nutrient impact processor.

14. A computer comprising a transformation engine, comprising:

a plurality of interfaces, each of which is configured to receive source data from at least of a plurality of disparate databases, the source data comprising a first data element and a second data element;

a converter-normalizer configured to convert and normalize source data received from the plurality of disparate databases so that the first data element and the second data element are recognizable as being equivalent;

a data processor configured to categorize the normalized data into a plurality of data categories;

a business rule applicator that applies one or more business rules to the plurality of data categories to identify pertinent data; and

,

a model generator that generates an application model based at least in part on the identified pertinent data.

15. The computer comprising the transformation engine of claim 14, further comprising:

a converter-normalizer configured to analyze and format a quantity of the first data element and a quantity of a third data element as being equivalent.

16. The computer comprising the transformation engine of claim 14, wherein the data processor is further configured to receive the normalized data and format the normalized data in accordance with an input format of the business rule applicator.

17. The computer comprising the transformation engine of claim 14, wherein the plurality of interfaces comprise an application program interface.

18. The computer comprising the transformation engine of claim 14, wherein the plurality of interfaces comprise an open database connectivity.

19. The computer comprising the transformation engine of claim 14, wherein the plurality of interfaces comprise an input-output-interface.

20. The computer comprising the transformation engine of claim 17, wherein the application program interface is executed by the computer to access at least one of:

a USDA database;

an FDA database;

a PDR database;

an ADA database;

an MDM database;

an IM database;

an RDA/RDI database;

a REF database; and

an RMMS database.