Relational database schema version management
First Claim
1. A method for generating an installation file for a particular version of a relational database comprising:
- automatically determining a first set of data definition language (DDL) scripts associated with the particular version of the relational database;
automatically determining a second set of data manipulation language scripts associated with the particular version of the relational database; and
generating an installation file comprising a union of the first set and the second set.
2 Assignments
0 Petitions
Accused Products
Abstract
Techniques for managing multiple versions of relational database schema data are described. Schema data associated with multiple versions of a relational database are maintained according to a database schema version management structure. Laws of set theory are applied to the structured database schema data to identify data definition language (DDL) and data manipulation language (DML) scripts that are associated with a particular version of the relational database. The identified scripts are then copied into an installation file that can be executed to create a full install of the particular version of the relational database. Similarly, laws of set theory are applied to the structured database schema data to identify DDL scripts, DML scripts, and drop scripts that are to be applied to upgrade from one version of the relational database to a newer version of the relational database.
-
Citations
31 Claims
-
1. A method for generating an installation file for a particular version of a relational database comprising:
-
automatically determining a first set of data definition language (DDL) scripts associated with the particular version of the relational database;
automatically determining a second set of data manipulation language scripts associated with the particular version of the relational database; and
generating an installation file comprising a union of the first set and the second set. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A method for generating an upgrade file to upgrade version i of a relational database to version j of the relational database, where j>
- i, the method comprising;
determining a set A of data definition language (DDL) scripts that, when executed, perform creates, alters, and drops of DDL objects associated with version i of the relational database, resulting in DDL objects associated with version j of the relational database;
determining a set B of data manipulation language (DML) scripts that, when executed, create DML objects that are associated with version j of the relational database, but that are not associated with version i of the relational database;
determining a set C of DML scripts that, when executed, modify DML objects that are associated with both version i and version j of the relational database, but that differ between version i and version j of the relational database;
determining a set D of DML drop scripts that, when executed, drop DML objects that are associated with version i of the relational database, but that are not associated with version j of the relational database; and
generating an upgrade file comprising a union of sets A, B, C, and D (A∪
B∪
C∪
D). - View Dependent Claims (14, 15, 16, 17, 18, 19)
- i, the method comprising;
-
20. A system comprising:
-
one or more data definition language (DDL) scripts, each associated with one or more versions of a relational database;
one or more data manipulation language (DML) scripts, each associated with one or more versions of the relational database;
a database schema version management structure definition;
schema data associated with multiple versions of the relational database, the schema data organized according to the database schema version management structure definition; and
an installation file generator configured to apply laws of set theory to the schema data to generate a file comprising the one or more DDL scripts associated with a particular one of the multiple versions of the relational database, and the one or more DML scripts associated with the particular one of the multiple versions of the relational database. - View Dependent Claims (21, 22)
-
-
23. A system comprising:
-
A memory;
A processor; and
a database schema version management system stored in the memory, executed on the processor, and configured to manage schema data associated with multiple versions of a relational database. - View Dependent Claims (24, 25, 26, 27, 28)
-
-
29. One or more computer-readable media comprising computer-readable instructions which, when executed, cause a computer system to:
-
maintain schema data that identifies scripts associated with database objects of multiple sequential versions of a relational database; and
generate an installation file associated with an initial version of the relational database by applying laws of set theory to the schema data to identify scripts associated with the database objects of the initial version of the relational database. - View Dependent Claims (30, 31)
-
Specification