Data management system and method for automatically propagating information to disparate information systems from a central location

• US 6,873,997 B1
• Filed: 08/04/2000
• Issued: 03/29/2005
• Est. Priority Date: 08/04/1999
• Status: Expired due to Term

• Current Assignee: Agile Software Corporation (Oracle Corporation)
• Original Assignee: Agile Software Corporation (Oracle Corporation)
• Inventors: Majjasie, Michelle, Teh, Jin T., Wise, Dorothy O., Hein, Raymond, Fazio, Joseph J., Lin, Raymond
• Primary Examiner(s): Channavajjala, Srirama
• Application Number:
  US09/632,454
• Time in Patent Office: 1,698 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-205, 700 95- 97, 700100-112, 705 26- 27, 705 1- 3, 705/10, 705/7, 709203-207, 709235-238, 706/925
• US Class Current: 1/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A data management system for automatically propagating changes in information related to a product being designed or manufactured from a central location to remote and disparate user information systems includes a central data base for storing and maintaining data, an administration module communicating with the central database and having software code that can configure the administration module to validate data related to a product; a product change module communicating with the central data base and having software code that can configure the product change module to poll the central data base to determine whether a change has been made to data related to a product; and a data server having code that extracts, formats and transmits changes in data stored in the central data base to a user system, the data being transferred according to predetermined data requirements of the disparate information system.

Claims

1. A data management system for automatically propagating changes in information related to a product being designed or manufactured from a central location to remote and disparate user information systems having varying data formats, comprising:

a central data base for storing and maintaining data that is related to a business process for manufacturing a product, including component serial numbers, change orders, and information pertaining to products, and is configured to format the data according to different aspects of the manufacturing business process for transfer to remote and disparate user information systems;

an administration module communicating with the central database and having software code that, when executed by a microprocessor, configures the administration module to validate data related to a product;

a product change module communicating with the central data base and having software code that, when executed by a microprocessor, configures the product change module to poll the central data base to determine whether a change has been made to data related to a product; and

to send a signal to the data server upon the detection of a change of product data in the central data base, and

a data server having code that, when executed by a microprocessor, prepares files for transfer to the disparate systems including setting the profile for the files that includes the format under which the file is configured and the file attributes to facilitate file transfer, receipt and processing by the respective user information systems, and configures the data server to extract, format and transmit changes in data stored in the central data base to the user information system, the data being transferred according to predetermined data requirements of the disparate user information systems, and further having code for source destination field mapping.

2. A system according to claim 1, wherein the product change module is incorporated into the data server in the form of software code, which, when executed by the data server, configures the data server to perform the functions of the product change module.

3. A system according to claim 1, further comprising:

an application adapter configured to receive data from the data server and to format the data according to the platform under which the user system'"'"'s computer system is based.

4. A system according to claim 1, wherein the administration module is further configured to validate the field length of data related to a product, the field format of the data, the list of values of the data including units of measure and required fields for the transfer of data to a user system.

5. A system according to claim 1, wherein the application adapter is configured to validate data changes sent by the data server, to update a user system database after data changes are validated and to generate status reports according to predefined criteria for the user system.

6. A system according to claim 1, further comprising a client information system configured to receive the data changes from the data server and to display the data for a user.

7. A system according to claim 1, further comprising a client computer system configured to modify the predefined criteria used by the data server to transmit the data changes.

8. A system according to claim 1, wherein the central data base is configured to store data pertaining to financial information.

9. The data management system of claim 1 wherein said data server has code for altering attribute properties to match properties of fields in target user information systems.

10. The data management system of claim 1 wherein said data server has code for modifying and creating attribute properties to conform the file to a target user information system.

11. The data management system of claim 1 wherein said data server has code for source destination field mapping from a data management server to a target user information system.

12. The data management system of claim 1 wherein said data server has code for establishing attributes that are set to be unchanged throughout a file transfer period.

13. The data management system of claim 1 wherein said data server has code for managing change orders and associated bills of materials and coordinating their release whereby released bills of material correspond to currently effective change orders.

14. The data management system of claim 1 wherein said change orders are chosen from the group consisting of manufacturing change orders and engineering change orders.