Database item versioning

• US 20040230616A1
• Filed: 06/15/2004
• Published: 11/18/2004
• Est. Priority Date: 01/21/1999
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Dengler, Patrick, Ramos, William W., Liuson, Julia Zhenglei, Kruy, Steven J.
• Granted Patent: US 7,444,363 B2
• Time in Patent Office: Days
• US Class Current: 707/104.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 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 database item in the source code control system is identical to the database item in the database;

providing a 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 database item selected by a user.

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 providing the user with the choice, upon determining that the database item in the source code control system is different than the database item in the database.

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 same version of the database item, an older version of the database item, a newer version of the database item.

9. 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.

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

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

12. The computer-implemented method of claim 10, further comprising Further comprising storing the manipulated database item in the database.

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

14. A computer-readable 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;

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

providing a 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 database item selected by a user.

15. The computer-readable medium of claim 14, 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.

16. The computer-readable method of claim 14, 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 user selects the database item in the source code control system.

17. The computer-readable method of claim 14, 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.

18. The computer-readable method of claim 14, the method further comprising the database checking out the database item.

19. The computer-readable method of claim 14, the method further comprising a program other than the database checking out the database item.

20. The computer-readable method of claim 14, the method further comprising providing the user with the choice, upon determining that the database item in the source code control system is different than the database item in the database.

21. The computer-readable method of claim 14, the method 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.

22. The computer-readable method of claim 14, the method 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.

23. The computer-readable method of claim 14, the method further comprising manipulating the database item.

24. The computer-readable method of claim 23, the method further comprising storing the manipulated database item in the source code control system.

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

26. The computer-readable method of claim 14, the method further comprising restricting modification of the selected database item.