Development system with methods for maintaining data integrity of information stored as a data record in a database with a copy of the information displayed on a screen device

• US 5,608,898 A
• Filed: 11/12/1992
• Issued: 03/04/1997
• Est. Priority Date: 10/31/1990
• Status: Expired due to Term

• Current Assignee: Borland Software Corporation (Open Text Corporation)
• Original Assignee: Borland International, Inc. (Open Text Corporation)
• Inventors: Brown, Kevin L., Bogrett, Steven W., Turpin, William M.
• Primary Examiner(s): Kulik, Paul V.
• Application Number:
  US07/975,302
• Time in Patent Office: 1,573 Days
• Field of Search: 364/419.14, 364/419.15, 395/600, 395/149, 395/144, 395/145, 395/146
• US Class Current: 1/1
• CPC Class Codes: G06F 40/174 Form filling; Merging
• CPC Class Codes: G06F 8/34 Graphical or visual programming

Abstract

A development system having methods for maintaining data integrity of information stored as a data record in a database table with information displayed on a screen device is described. An exemplary method for maintaining data integrity, without continuous exclusive locking of a shared data record, includes the following steps. First, the system reads at least one field value from a database table, while the table is available to others (i.e., accessed with share access). This field value is displayed on screen to the user, whereupon the user may enter new information (i.e., new field value). In the event that the user has entered new information, the method performs the step of re-reading the field value from the database table. Accordingly, the method can determine whether the just-entered value differs from that stored in the database. In the event that the two differ, the method can update the database with the just-entered information displayed on screen or, alternatively, refresh the information displayed on screen with that which is now stored in the database table.

Claims

1. In a computer system, a computer-implemented method for maintaining data integrity of information stored as a data record in a database table with information displayed on a screen device without continuous, exclusive locking of a shared data record, the method comprising:

(a) reading at least one field value from said data record of said database table, said reading being performed by the system with shared access to said data record;

(b) displaying a form on the screen device said form displaying at least one field value read from the database;

(c) modifying said at least one field value as it is displayed on the screen device;

(d) in response to step (c), re-reading said at least one field value from said database table;

(e) determining whether said information stored in the database table differs from said information displayed on said screen device by comparing said at least one field value being displayed with said re-read at least one field value; and

(f) if said system determines at step (e) that said information stored in the database table differs from said information displayed on said screen device, performing, in response to user input, a selected one of;

(i) refreshing said information displayed on said screen device with said at least one field value re-read at step (d), and

(ii) updating said information stored in said database table with said information displayed on said screen device.

2. The method of claim 1, wherein step (f)(i) comprises:

if said displayed at least one field value differs from said re-read at least one field value at step (e), refreshing said at least one field value read from the database which is displayed on the screen device.

3. The method of claim 1, wherein step (f)(ii) comprises:

if said displayed at least one field value differs from said re-read at least one field value at step (e), updating the database table with said displayed at least one field value.

4. The method of claim 1, wherein steps (a)-(e) are performed without exclusive access to said data record.

5. The method of claim 3, where step (f) is performed with exclusive access to said data record.

6. The method of claim 1, wherein said without exclusive access comprises shared access which allows at least one other computer system to access said data record during steps (a)-(e).

7. The method of claim 1, wherein step (c) includes:

modifying said at least one field value in response to receiving a user-initiated event.

8. The method of claim 7, wherein said user-initiated event includes user-supplied input from a keyboard device.

9. The method of claim 1, wherein step (c) includes:

associating an event tree with said at least one field, so that said value is modified in response to occurrence of a particular event of interest;

monitoring for said particular event of interest; and

upon detecting occurrence of said particular event of interest, modifying said at least one field value.

10. The method of claim 9, wherein said particular event of interest includes a user-initiated event.

11. The method of claim 1, wherein step (f)(ii) includes:

obtaining exclusive access to said data record; and

updating said information stored in said database table with said information displayed on said screen device.

12. In a computer system, a method for automatic location of information stored in a database table having at least first, second, and third table fields, said information being stored in said database table as a plurality of database records, the method comprising:

indexing said database table by a composite key comprising key values derived from values stored by said first table field and said second table field of said plurality of table fields;

displaying on a screen display a database form having first, second, and third form fields, said first, second, and third form field displaying respective values from said first, second, and third table fields for a first database record;

changing the value of said second form field to a new value;

in response to said modifying step, locating a second database record storing a value at its second table field which matches said new value; and

upon locating said second database record, displaying at said first and third form fields, respective values from said first and third table fields for said second database record.

13. A data processing system with autolocate capability, the system comprising:

a computer having a processor and a memory;

storage means for storing a database table and a database form, said database table comprising a plurality of database records having a plurality of table fields, said database table having an index comprising key values derived from at least some of said table fields, said database form comprising a plurality of form fields, each form field corresponding to a particular one of said table fields;

display means for displaying at said form fields values from said table fields of a particular database record of said database table;

edit means for changing the displayed value of one of the form fields to a new value;

search means, responsive to said edit means, for automatically locating a different database record of said database table, said different database record having a corresponding table field whose value matches said new value; and

refresh means, responsive to said search means, for changing values displayed by said form fields other than said form field whose value has changed to values of their corresponding table fields.

14. The system of claim 13, wherein said edit means includes an input device for receiving user-supplied input.

15. The system of claim 13, wherein said edit means includes means for changing one of the fields to a new value upon occurrence of a particular event.

16. The system of claim 15, wherein said particular event comprises a user input event.

17. The system of claim 15, wherein said particular event comprises an event occurring in the system.

18. The system of claim 13, wherein said index comprises a composite index derived from at least two of said table fields.

19. The system of claim 13, wherein said search means includes:

means for locating, using said index, a different database record of said database table, said different database record having a corresponding table field whose value matches said new value.

20. The system of claim 13, wherein said refresh means includes:

means for reading field values from said table fields for corresponding form fields other than said form field whose value has changed; and

means for displaying said field values at their respective form fields.