Database item versioning
First Claim
Patent Images
1. A computer system for providing version control over at least one item in a database while keeping the database operable, comprising:
- a source code control system to store versions of the database item in a data storage device;
a first program to check in and check out the database item, such that modification of the database item is restricted when the first program checks in the database item, and such that the first program checks in the database item after the first program checks out the database item;
a database having the database item, wherein the database invokes the first program upon receiving a request to access the database item, and the database continues to provide the requested access to the database item during the invocation of the first program; and
an editor to manipulate the database item after the first program checks out the database item, wherein the first program compares the version of the database item in the source code control system with the version of the database item in the database, and the editor manipulates the database item as a function of the comparison.
3 Assignments
0 Petitions
Accused Products
Abstract
The invention provides database item versioning, such as items like stored procedures found in databases such as Standard Query Language (SQL) databases. In one embodiment, the invention includes a program such as an editor, a database, a source code control and a mechanism. An editor program provides for editing a stored procedure. The databases includes the stored procedure. The SCC source code control system stores versions of the stored procedure. The mechanism checks in and checks out the stored procedure to provide for effective versioning thereof of the stored procedure.
26 Citations
8 Claims
-
1. A computer system for providing version control over at least one item in a database while keeping the database operable, comprising:
-
a source code control system to store versions of the database item in a data storage device; a first program to check in and check out the database item, such that modification of the database item is restricted when the first program checks in the database item, and such that the first program checks in the database item after the first program checks out the database item; a database having the database item, wherein the database invokes the first program upon receiving a request to access the database item, and the database continues to provide the requested access to the database item during the invocation of the first program; and an editor to manipulate the database item after the first program checks out the database item, wherein the first program compares the version of the database item in the source code control system with the version of the database item in the database, and the editor manipulates the database item as a function of the comparison. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
Specification