Method, system, and program for updating records in a database when applications have different version levels

• US 6,901,417 B2
• Filed: 01/11/2002
• Issued: 05/31/2005
• Est. Priority Date: 01/11/2002
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Fruchtman, Barry, Kaczmarski, Michael Allen, Anglin, Matthew Joseph
• Primary Examiner(s): Robinson, Greta
• Assistant Examiner(s): Le, Debbie M.
• Application Number:
  US10/044,125
• Publication Number:
  US 20030135518A1
• Time in Patent Office: 1,236 Days
• Field of Search: 707 10-102, 707200-203, 707/104, 707/1, 707 4- 5, 709/203
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2329 using versioning
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99954 Version management

Abstract

Provided is a method, system, and program for updating data in a database table in response to requests from a requesting application comprising one of a first application at a first version level and a second application at a second version level. The first application recognizes the table as including a subset of columns in the table that is less than all the columns in the table and the second application recognizes the table as including all the columns in the table. A request is received from the requesting application for specified columns from one record in the table and the requested record is accessed. A data structure is generated including data from the specified columns in the requested record. A determination is made as to whether the requesting application is capable of recognizing all the columns in the table. If so, data from each column in the table that is not one of the subset of columns is added to the data structure. The data structure is returned to the requesting application.

Claims

1. A computerized method for updating data in a database table in response to requests from a requesting application comprising one of a first application at a first version level and a second application at a second version level, wherein the first application recognizes the table as including a subset of columns in the table that is less than all the columns in the table and wherein the second application recognizes the table as including all the columns in the table, comprising:

receiving a request from the requesting application for specified columns from one record in the table;

accessing the requested record;

generating a data structure including data from the specified columns in the requested record;

determining whether the requesting application is capable of recognizing all the columns in the table;

adding to the data structure data from each column in the table that is not one of the subset of columns if the requesting application is determined to not recognize all the columns in the table; and

returning the data structure to the requesting application.

2. The method of claim 1, wherein the second version level of the application includes additional functionality over the first version level.

3. The method of claim 1, further comprising:

receiving from the requesting application a request to delete the accessed record after returning the data structure to the requesting application; and

deleting the accessed record from the table.

4. The method of claim 3, wherein generating the data structure further comprises adding a record identifier identifying the accessed record in the table to the data structure, wherein the received request to delete from the requesting application requests to delete the record having the record identifier included in the data structure.

5. The method of claim 3, further comprising:

receiving the data structure returned to the requesting application including data updated by the requesting application;

generating a table record having columns including the data in the received data structure, including the data updated by the requesting application; and

inserting the generated table record into the table.

6. The method of claim 5, further comprising:

after deleting the table record, deleting an index record in an index on the table corresponding to the deleted table record; and

adding one index record to the index for the inserted table record, wherein the data updated by the requesting application comprises at least one index key column used to sort the index records in the index.

7. The method of claim 1, wherein the request from the requesting application comprises a request to update at least one column in the table that is a key column in one index record corresponding to the requested record in an index on the table, further comprising:

deleting the accessed record from the table and the index record corresponding to the accessed record; and

receiving the data structure returned to the requesting application including data modified by the requesting application in at least one column in the table that is one key column in the index.

8. The method of claim 7, further comprising:

generating one table record having columns including the data in the received data structure, including the data updated by the requesting application;

inserting the generated table record into the table after deleting the table record and index record; and

generating and inserting one index record into the index for the inserted table record, wherein the data updated by the requesting application comprises at least one index key column used to sort the index records in the index.

9. The method of claim 1, wherein the request for specified columns from one record comprises a database query.

10. A computerized method for updating data in a database table by a first application at a first version level, wherein the first application recognizes the table as including a subset of columns in the table that is less than all the columns in the table, wherein a second application at a second version level recognizes the table as including all the columns in the table, wherein the first application performs:

transmitting a request for specified columns from one record in the table to an application server managing access to the database table;

in response to the request, receiving from the application server a data structure including data from the specified columns in the requested record and data from each column in the table that is not one of the subset of columns recognized by the first application.

11. The method of claim 10, wherein the second version level of the application includes additional functionality over the first version level.

12. The method of claim 10, further comprising:

transmitting to the application server a request to delete the requested record from the table.

13. The method of claim 12, further comprising:

updating in the received data structure one of the subset of columns; and

returning the updated data structure to the application server to cause the application server to generate a table record having columns including the data in the updated data structure and insert the generated table record into the table.

14. The method of claim 13, wherein the request to delete further causes the application server to delete an index record in an index on the table corresponding to the deleted table record, wherein returning the updated data structure to the application server further causes the application server to add one index record to the index for the inserted table record, and wherein the data updated by the requesting application comprises at least one index key column used to sort the index records in the index.

15. The method of claim 10, wherein the request comprises a request to update at least one column in the table that is a key column in one index record corresponding to the requested record in an index on the table, wherein the transmitted request further causes the application server to delete the accessed record from the table and delete the index record corresponding to the accessed record, further comprising:

updating, in the received data structure, at least one key column in the index that is also one of the subset of columns; and

returning the updated data structure to the application server to cause the application server to generate and insert one table record in the table having columns including the data in the received data structure and generate and insert one index record into the index for the inserted table record.

16. A system for updating data in a database table in response to requests from a requesting application comprising one of a first application at a first version level and a second application at a second version level, wherein the first application recognizes the table as including a subset of columns in the table that is less than all the columns in the table and wherein the second application recognizes the table as including all the columns in the table, comprising:

a computer readable medium including the database table;

means for receiving a request from the requesting application for specified columns from one record in the table;

means for accessing the requested record;

means for generating a data structure including data from the specified columns in the requested record;

means for determining whether the requesting application is capable of recognizing all the columns in the table;

means for adding to the data structure data from each column in the table that is not one of the subset of columns if the requesting application is determined to not recognize all the columns in the table; and

means for returning the data structure to the requesting application.

17. The system of claim 16, wherein the second version level of the application includes additional functionality over the first version level.

18. The system of claim 16, further comprising:

means for receiving from the requesting application a request to delete the accessed record after returning the data structure to the requesting application; and

means for deleting the accessed record from the table.

19. The system of claim 18, further comprising:

means for receiving the data structure returned to the requesting application including data updated by the requesting application;

means for generating a table record in the database having columns including the data in the received data structure, including the data updated by the requesting application; and

means for inserting the generated table record into the table.

20. The system of claim 16, wherein the request from the requesting application comprises a request to update at least one column in the table that is a key column in one index record corresponding to the requested record in an index on the table in the database, further comprising:

means for deleting the accessed record from the table and the index record corresponding to the accessed record; and

means for receiving the data structure returned to the requesting application including data modified by the requesting application in at least one column in the table that is one key column in the index.

21. A system for updating data in a database table, comprising:

a first computer system;

a first application implemented in the first computer system at a first version level, wherein the first application recognizes the table as including a subset of columns in the table that is less than all the columns in the table, wherein the first application includes logic executed by the first computer system to perform;

(I) transmitting a request for specified columns from one record in the table to an application server managing access to the database table; and

(ii) receiving, in response to the request, from the application server a data structure including data from the specified columns in the requested record and data from each column in the table that is not one of the subset of columns recognized by the first application.

a second computer system; and

a second application implemented in the second computer system at a second version level that recognizes the table as including all the columns in the table.

22. The system of claim 21, wherein the first application further includes logic to transmit to the application server a request to delete the requested record from the table.

23. The system of claim 22, wherein the first application further includes logic to cause the first computer system to perform:

updating in the received data structure one of the subset of columns; and

returning the updated data structure to the application server to cause the application server to generate a table record having columns including the data in the updated data structure and insert the generated table record into the table.

24. An article of manufacture including code for updating data in a database table in response to requests from a requesting application comprising one of a first application at a first version level and a second application at a second version level, wherein the first application recognizes the table as including a subset of columns in the table that is less than all the columns in the table and wherein the second application recognizes the table as including all the columns in the table, wherein the code is capable of causing operations comprising:

receiving a request from the requesting application for specified columns from one record in the table;

accessing the requested record;

generating a data structure including data from the specified columns in the requested record;

determining whether the requesting application is capable of recognizing all the columns in the table;

adding to the data structure data from each column in the table that is not one of the subset of columns if the requesting application is determined to not recognize all the columns in the table; and

returning the data structure to the requesting application.

25. The article of manufacture of claim 24, wherein the second version level of the application includes additional functionality over the first version level.

26. The article of manufacture of claim 24, further comprising:

receiving from the requesting application a request to delete the accessed record after returning the data structure to the requesting application; and

deleting the accessed record from the table.

27. The article of manufacture of claim 26, further comprising:

receiving the data structure returned to the requesting application including data updated by the requesting application;

generating a table record having columns including the data in the received data structure, including the data updated by the requesting application; and

inserting the generated table record into the table.

28. The article of manufacture of claim 24, wherein the request from the requesting application comprises a request to update at least one column in the table that is a key column in one index record corresponding to the requested record in an index on the table, further comprising:

deleting the accessed record from the table and the index record corresponding to the accessed record; and

receiving the data structure returned to the requesting application including data modified by the requesting application in at least one column in the table that is one key column in the index.

29. An article of manufacture including code implemented in a first application at a first version level for updating data in a database table, wherein the first application recognizes the table as including a subset of columns in the table that is less than all the columns in the table, wherein a second application at a second version level recognizes the table as including all the columns in the table, wherein the code in the first application causes operations to be performed comprising:

transmitting a request for specified columns from one record in the table to an application server managing access to the database table;

in response to the request, receiving from the application server a data structure including data from the specified columns in the requested record and data from each column in the table that is not one of the subset of columns recognized by the first application.

30. The article of manufacture of claim 29, further comprising:

transmitting to the application server a request to delete the requested record from the table.

31. The article of manufacture of claim 29, further comprising:

updating in the received data structure one of the subset of columns; and

returning the updated data structure to the application server to cause the application server to generate a table record having columns including the data in the updated data structure and insert the generated table record into the table.