Database element versioning system and method

• US 9,727,593 B2
• Filed: 07/09/2013
• Issued: 08/08/2017
• Est. Priority Date: 12/29/2008
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Brown, David Lawrence
• Primary Examiner(s): Fan, Shiow-Jy
• Application Number:
  US13/937,453
• Publication Number:
  US 20130297577A1
• Time in Patent Office: 1,491 Days
• Field of Search: 707695
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477

Abstract

This disclosure relates to database systems and, more particularly, to database systems with version controlled data. A version controlled database program resides on a computer readable medium, having a plurality of instructions stored thereon, which, when executed by a processor, cause the processor to perform operations. The operations include defining a version object software layer. The version object software layer may be configured to read and write data of a version controlled database to a physical storage medium, maintain one or more versions of at least one element of the data, and provide access to the data. The operations may also include defining a database management software layer. The database management software layer may be configured to read and write data to the version object software layer and provide a database access interface for accessing the data.

Claims

1. A computer implemented method comprising:

maintaining, by one or more processors, a plurality of data elements within a version controlled database residing on a physical storage medium, wherein each data element of the plurality of data elements on the physical storage medium has a plurality of versions, wherein the physical storage medium is configured as a version object management (“

VOM”

) database;

retrieving, by the one or more processors, particular versions of the plurality of data elements from the version controlled database;

providing, by the one or more processors, the particular versions of the plurality of data elements to a client device requesting the particular versions of the plurality of data elements;

wherein providing the particular versions of the plurality of data elements includes creating a private branch of the plurality of data elements by providing a data view to the client device requesting the particular versions of the plurality of data elements that displays the particular versions of the plurality of data elements according to the data view, including creating a copy of the particular versions of the plurality of data elements and storing the copy to a location on a temporary physical storage medium of the version controlled database, wherein the temporary physical storage medium is configured as an optimized database management system (“

DBMS”

), wherein the temporary physical storage medium is separated from the physical storage medium by a DBMS to VOM interface;

modifying the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium as requested by the client device according to the data view; and

performing, by the one or more processors, a versioning-compatible save operation to store the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium to the version controlled database, the versioning-compatible save operation including determining if the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium has been modified and, if the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium has been modified, saving the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium to a same location within a file from which the particular versions of the plurality of data elements was retrieved on the physical storage medium.

2. The computer implemented method of claim 1, wherein the plurality of data elements includes a plurality of database elements.

3. The computer implemented method of claim 2, wherein retrieving the particular versions of the plurality of data elements includes retrieving one of the plurality of database elements.

4. The computer implemented method of claim 1, wherein the plurality of data elements includes a plurality of database elements and one or more sets of changes to the plurality of database elements.

5. The computer implemented method of claim 4, wherein retrieving the particular versions of the plurality of data elements includes retrieving the plurality of database elements, retrieving a particular set of changes to the plurality of database elements, and applying the particular set of changes to the plurality of database elements.

6. The computer implemented method of claim 1, further including providing one or more data view interfaces that provide access to the plurality of data elements in the version controlled database.

7. A computer program product residing on a non-transitory computer readable medium, having a plurality of instructions stored thereon, which, when executed by a processor, cause the processor to perform operations comprising:

maintaining a plurality of data elements within a version controlled database residing on a physical storage medium, wherein each data element of the plurality of data elements on the physical storage medium has a plurality of versions, wherein the physical storage medium is configured as a version object management (“

VOM”

) database;

retrieving particular versions of the plurality of data elements from the version controlled database;

providing the particular versions of the plurality of data elements to a client device requesting the particular versions of the plurality of data elements;

wherein providing the particular versions of the plurality of data elements includes creating a private branch of the plurality of data elements by providing a data view to the client device requesting the particular versions of the plurality of data elements that displays the particular versions of the plurality of data elements according to the data view, including creating a copy of the particular versions of the plurality of data elements and storing the copy to a location on a temporary physical storage medium of the version controlled database, wherein the temporary physical storage medium is configured as an optimized database management system (“

DBMS”

), wherein the temporary physical storage medium is separated from the physical storage medium by a DBMS to VOM interface;

modifying the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium as requested by the client device according to the data view; and

performing a versioning-compatible save operation to store the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium to the version controlled database, the versioning-compatible save operation including determining if the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium has been modified and, if the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium has been modified, saving the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium to a same location within a file from which the particular versions of the plurality of data elements was retrieved on the physical storage medium.

8. The computer program product of claim 7, wherein the plurality of data elements includes a plurality of database elements.

9. The computer program product of claim 8, wherein retrieving the particular versions of the plurality of data elements includes retrieving one of the plurality of database elements.

10. The computer program product of claim 7, wherein the plurality of data elements includes a plurality of database elements and one or more sets of changes to the plurality of database elements.

11. The computer program product of claim 10, wherein retrieving the particular versions of the plurality of data elements includes retrieving the plurality of database elements, retrieving a particular set of changes to the plurality of database elements, and applying the particular set of changes to the plurality of database elements.

12. The computer program product of claim 7, further including providing one or more data view interfaces that provide access to the plurality of data elements in the version controlled database.

13. A computing system comprising a processor device and a memory module coupled with the processors device, the processor device configured for:

maintaining a plurality of data elements within a version controlled database residing on a physical storage medium, wherein each data element of the plurality of data elements on the physical storage medium has a plurality of versions, wherein the physical storage medium is configured as a version object management (“

VOM”

) database;

retrieving particular versions of the plurality of data elements from the version controlled database;

providing the particular versions of the plurality of data elements to a client device requesting the particular versions of the plurality of data elements;

wherein providing the particular versions of the plurality of data elements includes creating a private branch of the plurality of data elements by providing a data view to the client device requesting the particular versions of the plurality of data elements that displays the particular versions of the plurality of data elements according to the data view, including creating a copy of the particular versions of the plurality of data elements and storing the copy to a location on a temporary physical storage medium of the version controlled database, wherein the temporary physical storage medium is configured as an optimized database management system (“

DBMS”

), wherein the temporary physical storage medium is separated from the physical storage medium by a DBMS to VOM interface;

modifying the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium as requested by the client device according to the data view; and

performing a versioning-compatible save operation to store the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium to the version controlled database, the versioning-compatible save operation including determining if the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium has been modified and, if the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium has been modified, saving the copy of the particular versions of the plurality of data elements stored to the location on the temporary physical storage medium to a same location within a file from which the particular versions of the plurality of data elements was retrieved on the physical storage medium.

14. The computing system of claim 13, wherein the plurality of data elements includes a plurality of database elements.

15. The computing system of claim 14, wherein retrieving the particular versions of the plurality of data elements includes retrieving one of the plurality of database elements.

16. The computing system of claim 13, wherein the plurality of data elements includes a plurality of database elements and one or more sets of changes to the plurality of database elements.

17. The computing system of claim 16, wherein retrieving the particular versions of the plurality of data elements includes retrieving the plurality of database elements, retrieving a particular set of changes to the plurality of database elements, and applying the particular set of changes to the plurality of database elements.