SYSTEM, METHOD, AND ARTICLE OF MANUFACTURE FOR MODIFYING RECORDS IN A DATABASE

• US 20060117069A1
• Filed: 11/30/2004
• Published: 06/01/2006
• Est. Priority Date: 11/30/2004
• Status: Abandoned Application

• Current Assignee: General Electric Company
• Original Assignee: General Electric Company
• Inventors: Van Der Leeden, Cees
• Application Number:
  US10/904,820
• Publication Number:
  US 20060117069A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/275 Synchronous replication

Abstract

A system and a method for modifying a data record in a database are provided. The system allows a user to view a proposed change to the data record in the database during a data synchronization process of a first computer and a second computer. Further, the system allows the user to either approve or reject the proposed change to the data record prior to changing the data record based on the proposed change.

Claims

1. A method for modifying a data record in a database associated with a first computer, the first computer operably communicating with a second computer, comprising:

sending a first message from the second computer to the first computer having a task identifier identifying at least a first data record having at least a first data unit, the first data record being stored in the database;

retrieving the first data record from the database utilizing the first computer and sending a second message having the task identifier and the first data unit to the second computer;

inputting a first input value using the second computer for modifying the first data unit;

generating a third message having the task identifier and the first input value utilizing the second computer;

sending the third message containing the task identifier and the first input value from the second computer to the first computer;

querying a user for a second selection value indicating that the task identifier and the first data unit are either approved or rejected by the user; and

modifying the first data unit in the first data record of the database based on the first input value when the second selection value indicates that the task identifier and the first data unit are approved by the user.

2. The method of claim 1, further comprising displaying the task identifier and the first input value on a display device communicating with the first computer.

3. The method of claim 1, further comprising generating a voice message indicating the task identifier and the first input value utilizing a voice-synthesizer operably coupled to the first computer.

4. The method of claim 1, further comprising generating an electronic message having the task identifier and the first input value using the first computer.

5. The method of claim 1, further comprising disposing of the third message when the second selection value indicates that the task identifier and the first data unit are not approved by the user.

6. The method of claim 1, wherein the first data record further comprises an asset identifier, the second and third messages further comprising the asset identifier, the querying step comprising:

querying the user for the second selection value indicating that the task identifier, the asset identifier, and the first data unit are either approved or rejected by the user.

7. The method of claim 1, wherein the first data unit comprises data associated with a physical asset.

8. The method of claim 7, wherein the physical asset comprises at least one of an electrical device, a mechanical device, and an electro-mechanical device.

9. A system for modifying a data record in a database, comprising:

a first computer configured to operably communicate with a second computer, the first computer being operably coupled to the database, the database having a first data record, the second computer is configured to send a first message to the first computer having a task identifier identifying at least the first data record having at least a first data unit, the first computer is configured to retrieve the first data record from the database and to send a second message having the task identifier and the first data unit to the second computer, the first computer is further configured to receive a first input value from a user for modifying the first data unit, the second computer is further configured to generate a third message having the task identifier and the first input value, the second computer is further configured to send the third message containing the task identifier and the first input value to the first computer, the first computer is further configured to query a user for a second selection value indicating that the task identifier and the first data unit are either approved or rejected by the user, the first computer is further configured to modify the first data unit in the first data record of the database based on the first input value when the second selection value indicates that the task identifier and the first data unit are approved by the user.

10. The system of claim 9, further comprising a display device operably coupled to the first computer, the first computer further configured to display the task identifier and the first input value on the display device.

11. The system of claim 9, further comprising a voice-synthesizer operably coupled to the first computer, the voice synthesizer configured to generate a voice message indicating the task identifier and the first input value.

12. The system of claim 9, wherein the first computer is further configured to generate an electronic message having the task identifier and the first input value.

13. The system of claim 9, wherein the first computer is further configured to dispose of the third message when the second selection value indicates that the task identifier and the data unit are not approved by the user.

14. The system of claim 9, wherein the first data record further comprises an asset identifier, the second and third messages further comprising the asset identifier, the first computer further configured to query the user for the second selection value indicating that the task identifier, the asset identifier, and the first data unit are either approved or rejected by the user.

15. The system of claim 9, wherein the first data unit comprises data associated with a physical asset.

16. The system of claim 15, wherein the physical asset comprises at least one of an electrical device, a mechanical device, and an electro-mechanical device.

17. An article of manufacture, comprising:

a computer storage medium having a computer program encoded therein for modifying a data record in a database associated with a first computer, the first computer operably communicating with a second computer, the computer storage medium comprising;

code for sending a first message from the second computer to the first computer having a task identifier identifying at least a first data record having at least a first data unit, the first data record being stored in the database;

code for retrieving the first data record from the database utilizing the first computer and sending a second message having the task identifier and the first data unit to the second computer;

code for inputting a first input value using the second computer for modifying the first data unit;

code for generating a third message having the task identifier and the first input value on the second computer;

code for sending the third message containing the task identifier and the first input value from the second computer to the first computer;

code for querying a user for a second selection value indicating that the task identifier and the first data unit are either approved or rejected by the user; and

code for modifying the first data unit in the first data record of the database based on the first input value when the second selection value indicates that the task identifier and the first data unit are approved by the user.

18. The article of manufacture of claim 17, wherein the computer storage medium further comprises code for disposing of the third message when the second selection value indicates that the task identifier and the first data unit are not approved by the user.

19. The article of manufacture of claim 17, wherein the first data record further comprises an asset identifier, the second and third messages further comprising the asset identifier, the computer storage medium further comprising code for querying the user for the second selection value indicating that the task identifier, the asset identifier, and the first data unit are either approved or rejected by the user.

20. The article of manufacture of claim 17, wherein the first data unit comprises data associated with a physical asset.