System and method for recovery units in databases
First Claim
1. A method of generating recoverable units in a database, the method comprising:
- partitioning the database into a first and a second unit;
creating a primary catalog comprising metadata of logical elements of the units, the primary catalog referencing the units;
creating multiple logs such that any one unit is associated with only one log;
creating two secondary catalogs, each secondary catalog corresponding to a respective unit and comprising metadata of physical elements for the respective unit;
linking the primary catalog to the secondary catalogs; and
maintaining the secondary catalogs such that the first unit is recoverable independently from the second unit.
2 Assignments
0 Petitions
Accused Products
Abstract
The creation of multiple recoverable units within a database allows a database partition to be reconstructed during maintenance and disaster recovery operations. A method of creating a recovery unit includes partitioning a database into at least two recovery units. A primary catalog of metadata relating to the logical elements of a database such as tables, indexes, and file groups is created. A secondary catalog of metadata relating to the physical elements of a database such as pages, files, B-Trees, and log streams is created for each recovery unit. The primary and secondary metadata catalogs are linked such that only one log stream is associated with any one recovery unit. A single recovery unit may then be exercised to perform recovery or maintenance operations while the remaining recovery units of the database remain online.
-
Citations
17 Claims
-
1. A method of generating recoverable units in a database, the method comprising:
-
partitioning the database into a first and a second unit;
creating a primary catalog comprising metadata of logical elements of the units, the primary catalog referencing the units;
creating multiple logs such that any one unit is associated with only one log;
creating two secondary catalogs, each secondary catalog corresponding to a respective unit and comprising metadata of physical elements for the respective unit;
linking the primary catalog to the secondary catalogs; and
maintaining the secondary catalogs such that the first unit is recoverable independently from the second unit. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A system having a database, the system comprising:
a processor having access to memory, the memory having instructions which, when executed, perform the method comprising;
partitioning the database into a first and a second unit;
creating a primary catalog comprising metadata of logical elements of the units, the primary catalog referencing the units;
creating multiple logs such that any one unit is associated with only one log;
creating two secondary catalogs, each secondary catalog corresponding to a respective unit and comprising metadata of physical elements for the respective unit;
linking the primary catalog to the secondary catalogs; and
maintaining the secondary catalogs such that the first unit is recoverable independently from the second unit. - View Dependent Claims (8, 9, 10, 11)
-
12. A computer-readable medium having computer-executable instructions for performing a method, the method comprising:
-
partitioning the database into a first and a second unit;
creating a primary catalog comprising metadata of logical elements of the units, the primary catalog referencing the units;
creating multiple logs such that any one unit is associated with only one log;
creating two secondary catalogs, each secondary catalog corresponding to a respective unit and comprising metadata of physical elements for the respective unit;
linking the primary catalog to the secondary catalogs; and
maintaining the secondary catalogs such that the first unit is recoverable independently from the second unit. - View Dependent Claims (13, 14, 15, 16, 17)
-
Specification