Database storage system and associated method

• US 20060190476A1
• Filed: 01/04/2006
• Published: 08/24/2006
• Est. Priority Date: 02/18/2005
• Status: Abandoned Application

• Current Assignee: Siemens AB (Siemens AG), Siemens Corporate Research Incorporated (Siemens AG)
• Original Assignee: Siemens AB (Siemens AG)
• Inventors: Mettovaara, Risto Kalvei, Konovalov, Roman
• Application Number:
  US11/324,820
• Publication Number:
  US 20060190476A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/213 with details for schema evolution support

Abstract

A system is provided for saving data to a structurally changed database. The system comprises an input processor for validating ancillary data; a stored procedure generator for automatically re-generating a stored procedure using the validated ancillary data and metadata. The system further comprises a code generator for automatically re-generating source code for the data layer using the validated ancillary data and the metadata.

Claims

1. A system for saving data to a structurally changed database, comprising:

an input processor for validating ancillary data;

5 a stored procedure generator for automatically re-generating a stored procedure using said validated ancillary data and metadata; and

a code generator for automatically re-generating source code for a data layer using said validated ancillary data and said metadata.

2. A system according to claim 1, further comprising an update processor for replacing an existing stored procedure with said re-generated stored procedure and for replacing existing source code for the data layer with said re-generated source code for the data layer.

3. A system according to claim 2, further comprising storage means for storing said re-generated stored procedure and said re-generated source code for the data layer.

4. A system according to claim 1, wherein said metadata comprises information regarding fields of at least one structurally changed table of the structurally changed database 106

5. A system according to claim 4, wherein said metadata comprises at least one of, (a) a database identifier, (b) one or more tables of the identified database, (c) an operation identifier, and (d) a stored procedure identifier.

6. A system according to claim 1, wherein said ancillary data comprises information including at least one of, (a) a structurally changed database, (b) a table and associated fields of the structurally changed database, (c) a particular operation to be performed on information contained within the particular table and the table'"'"'s associated fields in the structurally changed database, and (d) an existing stored procedure identifier.

7. A system according to claim 1, wherein said source code for a data layer is configured to:

(a) unpack data received in a first data format, (b) validate said unpacked data, (c) convert said validated data from said first data format to a second data format acceptable by a re-generated stored procedure, and (d) provide said converted data to said re-generated stored procedure.

8. A system according to claim 1, wherein said at least one stored procedure is configured to:

(a) add new data into a selected table of the structurally changed database, (b) update existing data from the selected table of the structurally changed database, (c) retrieve data from the selected table of the structurally changed database.

9. A method for saving data to a structurally changed database, comprising the acts of:

unpacking data in a first format received from an end user application;

validating the unpacked data;

converting the validated data from said first format to a second format acceptable by a re-generated stored procedure;

providing the converted data to the re-generated stored procedure; and

saving the converted data to the structurally changed database.

10. A method for re-generating at least one calling function for calling a re-generated stored procedure for performing a particular database operation on at least one structurally changed table of a structurally changed database, the method comprising the steps of:

receiving ancillary data from a user;

retrieving metadata from the structurally changed table of a structurally changed database;

re-generating the at least one calling function from the received ancillary data and metadata; and

replacing at least one existing calling function with the re-generated at least one calling function.

11. The method of claim 10, wherein said ancillary data comprises information including at least one of, (a) a structurally changed database, (b) a table and associated fields of the structurally changed database, (c) a particular operation to be performed on information contained within the particular table and the table'"'"'s associated fields in the structurally changed database, and (d) an existing stored procedure identifier.

12. A system according to claim 10, wherein said metadata comprises information regarding fields of at the at least one structurally changed table of the structurally changed database.

13. The method of claim 12, wherein said metadata comprises at least one of, (a) a database identifier, (b) one or more tables of the identified database, (c) an operation identifier, and (d) a stored procedure identifier.

14. A method for re-generating at least one for stored procedure for performing a particular database operation on at least one structurally changed table of a structurally changed database, the method comprising the steps of:

receiving ancillary data from a user;

retrieving metadata from the structurally changed database;

re-generating the at least one stored procedure from said received ancillary data and said metadata; and

replacing an existing at least one stored procedure with the corresponding re-generated at least one stored procedure.

15. The method of claim 14, wherein said ancillary data comprises information including at least one of, (a) a structurally changed database, (b) a table and associated fields of the structurally changed database, (c) a particular operation to be performed on information contained within the particular table and the table'"'"'s associated. fields in the structurally changed database, and (d) an existing stored procedure identifier.

16. The method of claim 14, wherein said metadata comprises at least one of, (a) a database identifier, (b) one or more tables of the identified database, (c) an operation identifier, and (d) a stored procedure identifier.