System and process for managing data within an operational data store

• US 6,604,104 B1
• Filed: 11/14/2000
• Issued: 08/05/2003
• Est. Priority Date: 10/02/2000
• Status: Expired due to Fees

• Current Assignee: Green DUCK Corporation
• Original Assignee: SBI Scient, Inc.
• Inventors: Smith, Walter
• Primary Examiner(s): Rones, Charles
• Application Number:
  US09/711,071
• Time in Patent Office: 994 Days
• Field of Search: 705/37, 370/60, 358/434, 379/88.06, 707/10
• US Class Current: 1/1
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 40/04 Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange

Abstract

A system and method for managing the transfer of data within an operational store is disclosed. Data from a plurality of distributed data sources is received at a messaging workflow module. The messaging workflow module prioritizes incoming and outgoing data and requests for data. Data is transferred from messaging workflow module to a translation module which ensures that the data is in a proper format for the operational data store. Data is transferred from translation module to the operational data store.

Claims

1. A method for unifying data from disparate applications for an operational data store module, the method comprising the steps of:

receiving data from a plurality of data source modules, where the data is in a plurality of data formats;

prioritizing the transfer of the received data to a translation module;

transferring the received data to the translation module, where the data is translated from the plurality of data formats into an appropriate format for storage in the operational data store module, where the operational data store comprises one or more relational databases; and

transmitting the stored data from the operational data store module in response to a query request.

2. The method according to claim 1, where the operational data store module provides dynamic access to the data in real-time.

3. The method according to claim 1, where prioritizing the transfer of data further includes storing data for transfer at a later time.

4. A method for unifying data from disparate applications for an operational data store module comprising the steps of:

receiving a plurality of requests for data from a plurality of output modules, where each output module requires data in one of a plurality of formats and where each of the plurality of requests is a query;

prioritizing the transfer of the plurality of requests to an operational data store module, where the operational data store module comprises one or more relational databases;

transferring the plurality of requests to the operational data store;

receiving data based on the requests, where the data for each request has been translated by a translation module to a format required by the output module that made the request;

transferring the received data to the appropriate output module.

5. The method according to claim 4, further comprising the step of prioritizing the transfer of the received data.

6. The method according to claim 5, where prioritizing the transfer of the received data further includes storing data for transfer at a later time.

7. The method according to claim 4, further including a data warehouse for storing data received from the messaging workflow module, where the messaging workflow module transfers the data to the data warehouse per instructions from one or more of the plurality of output modules.

8. The method according to claim 4, where the operational data store module provides dynamic access to the data in real-time.

9. The method according to claim 4, where prioritizing the transfer of the plurality of requests further includes storing one of the plurality of requests for transfer at a later time.

10. One or more computer readable media, the one or more computer readable media storing computer readable code executable to perform a method for unifying data from disparate applications for an operational data store, the method comprising:

receiving a plurality of requests for data from a plurality of output modules, where each output module requires data in one of a plurality of formats and each of the plurality of requests is a query;

prioritizing the transfer of the plurality of requests to an operational data store module, where the operational data store module comprises one or more relational databases;

transferring the plurality of requests to the operational data store;

receiving data based on the requests, where the data for each request has been translated by a translation module to a format required by the output module that made the request; and

transferring the received data to the appropriate output module.

11. One or more computer readable media, the one or more computer readable media storing computer readable code executable to perform a method for unifying data from disparate applications for an operational data store module, the method comprising the steps of:

receiving data from a plurality of data source modules, where the data is in a plurality of data formats;

prioritizing the transfer of the received data to a translation module;

transferring the received data to the translation module, where the data is translated from the plurality of data formats into an appropriate format for storage in the operational data store module, where the operational data store module comprises one or more relational databases; and

transmitting the stored data from the operational data store module in response to a query request.

12. A system for unifying data from disparate applications comprising:

a plurality of data source modules for providing data in a plurality of data formats;

an operational data store module for storing the data, wherein the operational data store module comprises one or more relational databases;

a messaging workflow module for managing;

a) a transfer of data to and from the operational data store module and the plurality of data sources; and

b) a prioritization of the transfer of the data within the system;

c) transmission of data from the operational data store module in response to a query request; and

a translation module for processing the data, wherein processing the data includes converting the data in the plurality of data formats from the plurality of data source modules into a data format for the operational data store module.

13. The system according to claim 12, wherein managing the transfer of data further comprises the step of managing the transfer of data from the plurality of data source modules to the translation module.

14. The system according to claim 13, wherein managing the transfer of data further comprises prioritizing the transfer of data from each of the plurality of data source modules to the translation module.

15. The system according to claim 12, wherein managing the transfer of data further comprises prioritizing the transfer of data from each of the plurality of data source modules to the translation module.

16. The system according to claim 12, further comprising a plurality of output modules for accessing data from the operational data store module, wherein each of the plurality of output modules receives data in one of the plurality of formats and the translation module translates the data from the operational data store into the appropriate format for each of the plurality of output modules.

17. The system according to claim 16, wherein managing the transfer of data further comprises prioritizing the transfer of data from the translation module to each of the plurality of output modules.

18. The system according to claim 16, further including a data warehouse for storing data received from the messaging workflow module, where the messaging workflow module transfers the data to the data warehouse per instructions from one or more of the plurality of output modules.

19. The system according to claim 12, where the operational data store module provides dynamic access to the data in real-time.

20. The system according to claim 12, where prioritizing the transfer of data further includes storing data for transfer at a later time.

21. An information managing and translation system for data received from a plurality of distributed data sources for storage in an operational data store module, the system comprising:

a messaging workflow module for managing data, where managing the data comprises receiving the data from the plurality of distributed data sources, prioritizing the received data, transmitting the received data based on the prioritization to the operational data store module, and transmitting data from the operational data store module in response to a query request; and

a translation module for translating data into a specified data format;

wherein the translation module receives the prioritized data from the messaging workflow module, translates the prioritized data into a specified format, and transmits the data to the operational data store module, where the operational data store module comprises one or more relational databases.

22. The system according the claim 21, wherein the system further comprises a plurality of output modules for requesting the data via the query;

and where;

the translation module receives requested data from the operational data store module, translates the requested data into a specified format, and transmits the requested data to the messaging workflow module; and

the messaging workflow module receives the translated requested data, prioritizes the translated requested data, and transmits the translated requested data to one of the plurality of output modules based on the prioritization.

23. The system according to claim 22, wherein managing the transfer of data further comprises prioritizing the transfer of data to each of the plurality of output modules.

24. The system according to claim 22, further including a data warehouse for storing data received from the messaging workflow module, where the messaging workflow module transfers the data to the data warehouse per instructions from one or more of the plurality of output modules.

25. The system according to claim 22, where the operational data store module provides dynamic access to the data in real-time.

26. The system according to claim 22, where prioritizing the received data further includes storing data for transfer at a later time.