Database item versioning

• US 7,444,363 B2
• Filed: 06/15/2004
• Issued: 10/28/2008
• Est. Priority Date: 01/21/1999
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Kruy, Steven J., Dengler, Patrick, Ramos, William W., Liuson, Julia Zhenglei
• Primary Examiner(s): Rones; Charles
• Assistant Examiner(s): Lewis; Alicia M
• Application Number:
  US10/868,111
• Publication Number:
  US 20040230616A1
• Time in Patent Office: 1,596 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477
• CPC Class Codes: G06F 16/2443 Stored procedures
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99954 Version management

Abstract

Database item versioning, such as items like stored procedures found in databases such as Standard Query Language (SQL) databases. In one embodiment, a program such as an editor, a database, a source and a mechanism. An editor program provides for editing a stored procedure. The databases includes the stored procedure. The SCC system stores versions of the stored procedure. The mechanism checks in and checks out the stored procedure to provide for effective versioning thereof.

Claims

1. A computer-implemented method for a user to check out a database item from a source code control system, comprising:

comparing a database item stored in the source code control system with a database item stored in a database;

determining whether the compared database item in the source code control system is identical to the compared database item in the database;

if it is determined that the compared database item in the source code control system is identical to the compared database item in the database, checking out the database item; and

if it is determined that the compared database item in the source code control system is not identical to the compared database item in the database;

providing the user a choice to select one of the database item in the source code control system and the database item in the database; and

checking out the selected database item;

wherein a historic record of the checked out database item is maintained, permitting changes to the database item to be traced thus enabling determination of when a change was introduced.

2. The computer-implemented method of claim 1, further comprising, prior to comparing:

retrieving the database item from the source code control system; and

retrieving the database item from the database.

3. The computer-implemented method of claim 1, further comprising saving the database item in the source code control system as the stream of the database item in the database, when the user selects the database item in the source code control system.

4. The computer-implemented method of claim 1, further comprising:

comparing a version of the database item stored in the source code control system with a version of the database item stored in a database; and

determining whether the version of the database item in the source code control system is the same as a version of the database item in the database.

5. The computer-implemented method of claim 1, further comprising the database checking out the database item.

6. The computer-implemented method of claim 1, further comprising a program other than the database checking out the database item.

7. The computer-implemented method of claim 1, further comprising wherein the database item selected by the user is at least one of the following:

the same version of the database item, an older version of the database item, a newer version of the database item.

8. The computer-implemented method of claim 1, further comprising wherein the database item selected by the user is at least one of the following:

the version stored in the database and the version stored in the source code control system.

9. The computer-implemented method of claim 1, further comprising manipulating the database item.

10. The computer-implemented method of claim 9, further comprising storing the manipulated database item in the source code control system.

11. The computer-implemented method of claim 9, further comprising further comprising storing the manipulated database item in the database.

12. The computer-implemented method of claim 1, further comprising restricting modification of the selected database item.

13. A computer-readable storage medium having instructions stored thereon for execution by a computer to perform a method, comprising:

comparing a database item stored in the source code control system with a database item stored in a database;

if it is determined that the compared database item in the source code control system is identical to the compared database item in the database, checking out the database item; and

if it is determined that the compared database item in the source code control system is not identical to the compared database item in the database;

providing the user a choice to select one of the database item in the source code control system and the database item in the database; and

checking out the selected database item;

wherein a historic record of the checked out database item is maintained, permitting changes to the database item to traced thus enabling determination of when a change was introduced.

14. The computer-readable storage medium of claim 13, the method further comprising, prior to comparing:

retrieving the database item from the source code control system; and

retrieving the database item from the database.

15. The computer-readable storage medium of claim 13, the method further comprising saving the database item in the source code control system as the stream of the database item in the database, when the database item in the source code control system is selected.

16. The computer-readable storage medium of claim 13, the method further comprising:

comparing a version of the database item stored in the source code control system with a version of the database item stored in a database; and

determining whether the version of the database item in the source code control system is the same as a version of the database item in the database.

17. The computer-readable storage medium of claim 13, the method further comprising the database checking out the database item.

18. The computer-readable storage medium of claim 13, the method further comprising a program other than the database checking out the database item.

19. The computer-readable storage medium of claim 13, the method further comprising wherein the selected database item is at least one of the following:

the same version of the database item, an older version of the database item, a newer version of the database item.

20. The computer-readable storage medium of claim 13, the method further comprising wherein the selected database item is at least one of the following:

the version stored in the database and the version stored in the source code control system.

21. The computer-readable storage medium of claim 13, the method further comprising manipulating the database item.

22. The computer-readable storage medium of claim 21, the method further comprising storing the manipulated database item in the source code control system.

23. The computer-readable storage medium of claim 21, the method further comprising storing the manipulated database item in the database.

24. The computer-readable storage medium of claim 13, the method further comprising restricting modification of the selected database item.