Method, system, and program for managing file names during the reorganization of a database object
First Claim
1. A method for reorganizing at least one database object, wherein the database object is comprised of at least one database file, and wherein each database file has a name, comprising:
- providing source database files including data for the database objects subject to a reorganization, wherein the source database files have source names;
creating shadow copies of the source database files;
generating shadow names for the shadow copies, wherein the source names and corresponding shadow names are different;
and reorganizing data in the shadow copies including database objects, wherein after the reorganization, the shadow names are used to access the database files for the reorganized database objects.
1 Assignment
0 Petitions
Accused Products
Abstract
Disclosed is a system, method, and program for reorganizing at least one database object. The database object is comprised of at least one database file. Each database file has a name. Source database files including data for the database objects subject to the reorganization have source names. Shadow copies of the source database files are created and shadow names for the shadow copies are generated, such that the source names and corresponding shadow names are different. The data in the shadow copies is reorganized. After the reorganization, the shadow names are used to access the database files for the reorganized database objects.
89 Citations
42 Claims
-
1. A method for reorganizing at least one database object, wherein the database object is comprised of at least one database file, and wherein each database file has a name, comprising:
-
providing source database files including data for the database objects subject to a reorganization, wherein the source database files have source names;
creating shadow copies of the source database files;
generating shadow names for the shadow copies, wherein the source names and corresponding shadow names are different;
andreorganizing data in the shadow copies including database objects, wherein after the reorganization, the shadow names are used to access the database files for the reorganized database objects. - View Dependent Claims (2, 3, 28, 29, 34, 35, 36)
providing indication of a name qualifier;
using the name qualifier to determine the shadow names; and
using the name qualifier to determine the source names after the reorganization.
-
-
35. The method of claim 34, wherein the name qualifier has one of two values, wherein using the name qualifier to determine the shadow names comprises using the name qualifier value for the shadow names that is different from a current name qualifier value.
-
36. The method of claim 35, further comprising:
changing the current name qualifier to the other value, wherein using the name qualifier to determine the source names comprises using the changed name qualifier value to determine the source names.
-
4. A method for reorganizing at least one database object, wherein the database object is comprised of at least one database file, and wherein each database file has a name, comprising:
-
providing source database files including data for the database objects subject to a reorganization, wherein the source database files have source names, and wherein a database file name is comprised of multiple elements including a qualifier element;
providing system information indicating names of the database files that include data for database objects, wherein providing the source database files includes processing the system information to determine the source database files that include data for the database objects subject to the reorganization;
creating shadow copies of the source database files;
generating shadow names for the shadow copies, wherein the source names and corresponding shadow names are different;
reorganizing data in the shadow copies, wherein after the reorganization, the shadow names are used to access the database files for the reorganized database objects; and
modifying the system information, after reorganizing the database objects, to indicate that the names of the database files comprising the reorganized database objects are the shadow names, wherein the shadow names are different from the source names of the source database files from which the shadow copies were created. - View Dependent Claims (5, 6, 7, 8, 9)
processing the system information to determine whether the qualifier element of the source database file is one of the first value and the second value;
setting the shadow name to the source name;
setting the qualifier element in the shadow name to the first value after determining that the qualifier element indicated in the system information is the second value; and
setting the qualifier element in the shadow name to the second value after determining that the qualifier element indicated in the system information is the first value.
-
-
8. The method of claim 7, further comprising:
-
performing additional instances of reorganizing the database files; and
updating, after the reorganization, the system information to reflect that the qualifier elements of the reorganized database files have one of the first value and the second value, wherein the qualifier element value is updated to the first value if the qualifier element value prior to the reorganization was the second value and is updated to the second value if the qualifier element value prior to the reorganization was the first value.
-
-
9. The method of claim 7, wherein the system information is modified after reorganizing the data in the shadow copies by indicating that the qualifier element of the reorganized database file names is the qualifier element in the shadow name, wherein, after the reorganization, the database program accesses the reorganized database objects by accessing the database file names having the modified qualifier element indicated in the system information.
-
10. A system for reorganizing at least one database object, wherein the database object is comprised of at least one database file, and wherein each database file has a name, comprising:
-
a computer system;
a memory area accessible to the computer system including system information indicating names of the database files that include data for database objects;
andprogram logic, executed by the computer system, comprising;
(i) means for providing source database files including data for the database objects to a reorganization, wherein the source database files have source names;
(ii) means for creating shadow copies of the source database files;
(iii) means for generating shadow names for the shadow copies, wherein the source names and corresponding shadow names are different; and
(iv) means for reorganizing data in the shadow copies including database objects, wherein after the reorganization, the shadow names are used to access the database files for the reorganized database objects. - View Dependent Claims (11, 12, 30, 31, 37, 38, 39)
means for providing indication of a name qualifier;
means for using the name qualifier to determine the shadow names; and
means for using the name qualifier to determine the source names after the reorganization.
-
-
38. The system of claim 37, wherein the name qualifier has one of two values, wherein the means for using the name qualifier to determine the shadow names comprises using the name qualifier value for the shadow names that is different from a current name qualifier value.
-
39. The system of claim 38, wherein the program logic further comprises:
means for changing the current name qualifier to the other value, wherein the means for using the name qualifier to determine the source names comprises using the changed name qualifier value to determine the source names.
-
13. A system for reorganizing at least one database object, wherein the database object is comprised of at least one database file, and wherein each database file has a name, comprisng:
-
a computer system;
a memory area accessible to the computer system including system information indicating names of the database files that include data for database objects;
andprogram logic, executed by the computer system, comprising;
(i) means for providing source database files including data for the database objects subject to a reorganization, wherein the source database files have source names, and wherein a database file name is comprised of multiple elements including a qualifier element;
(ii) means for providing system information indicating names of the database files that include data for database objects, wherein providing the source database files including processing the system information to determine the source database files that include data for the database objects subject to the reorganization;
(iii) means for creating shadow copies of the source database files;
(iv) means for generating shadow names for the shadow copies, wherein the source names and corresponding shadow names are different; and
(v) means for reorganizing data in the shadow copies, wherein after the reorganization, the shadow names are used to access the database files for the reorganized database objects; and
(vi) means for modifying the system information, after reorganizing the database objects, to indicate that the names of the database files comprising the reorganized database objects are the shadow names, wherein the shadow names are different from the source names of the source database files from which the shadow copies were created. - View Dependent Claims (14, 15, 16, 17, 18)
means for processing the system information to determine whether the qualifier element of the source database file is one of the first value and the second value;
means for setting the shadow name to the source name;
means for setting the qualifier element in the shadow name to the first value after determining that the qualifier element indicated in the system information is the second value; and
means for setting the qualifier element in the shadow name to the second value after determining that the qualifier element indicated in the system information is the first value.
-
-
17. The system of claim 16, wherein the program logic further comprises:
-
means for performing additional instances of reorganizing the database files; and
means for updating, after the reorganization, the system information in the memory area to reflect that the qualifier elements of the reorganized database files have one of the first value and the second value, wherein the qualifier element value is updated to the first value if the qualifier element value prior to the reorganization was the second value and is updated to the second value if the qualifier element value prior to the reorganization was the first value.
-
-
18. The system of claim 16, wherein the system information is modified after reorganizing the data in the shadow copies by indicating that the qualifier element of the reorganized database file names is the qualifier element in the shadow name, wherein, after the reorganization, the database program accesses the reorganized database object by accessing the database file names having the modified qualifier element indicated in the system information.
-
19. An article of manufacture for reorganizing at least one database object, wherein the database object is comprised of at least one database file, and wherein each database file has a name, the article of manufacture comprising computer usable media including at least one computer program embedded therein that is capable of causing a computer system to perform:
-
providing source database files including data for the database objects subject to a reorganization, wherein the source database files have source names;
creating shadow copies of the source database files;
generating shadow names for the shadow copies, wherein the source names and corresponding shadow names are different;
andreorganizing data in the shadow copies including database objects, wherein after the reorganization, the shadow names are used to access the database files for the reorganized database objects. - View Dependent Claims (20, 21, 32, 33, 40, 41, 42)
providing indication of a name qualifier;
using the name qualifier to determine the shadow names; and
using the name qualifier to determine the source names after the reorganization.
-
-
41. The article of manufacture of claim 40, wherein the name qualifier has one of two values, wherein using the name qualifier to determine the shadow names comprises using the name qualifier value for the shadow names that is different from a current name qualifier value.
-
42. The article of manufacture of claim 41, further causing the computer system to perform:
changing the current name qualifier to the other value, wherein using the name qualifier to determine the source names comprises using the changed name qualifier value to determine the source names.
-
22. An article of manufacture for reorganizing at least one database object, wherein the database object is comprised of at least one database file, and wherein each database file has a name, the article of manufacture comprising computer usable media including at least one computer program embedded therein that is capable of causing a computer system to perform:
-
providing system information indicating names of the database files that include data for database objects, wherein providing the source database files includes processing the system information to determine the source database files that include data for the database objects subject to the reorganization;
providing source database files including data for the database objects subject to a reorganization, wherein the source database files have source names, and wherein a database file name is comprised of multiple elements including a qualifier element;
creating shadow copies of the source database files;
generating shadow names for the shadow copies, wherein the source names and corresponding shadow names are different;
reorganizing data in the shadow copies, wherein after the reorganization, the shadow names are used to access the database files for the reorganized database objects; and
modifying the system information, after reorganizing the database objects, to indicate that the names of the database files comprising the reorganized database objects are the shadow names, wherein the shadow names are different from the source names of the source database files from which the shadow copies were created. - View Dependent Claims (23, 24, 25, 26, 27)
processing the system information to determine whether the qualifier element of the source database file is one of the first value and the second value;
setting the shadow name to the source name;
setting the qualifier element in the shadow name to the first value after determining that the qualifier element indicated in the system information is the second value; and
setting the qualifier element in the shadow name to the second value after determining that the qualifier element indicated in the system information is the first value.
-
-
26. The article of manufacture of claim 25, further causing the computer system to perform:
-
performing additional instances of reorganizing the database files; and
updating, after the reorganization, the system information to reflect that the qualifier elements of the reorganized database files have one of the first value and the second value, wherein the qualifier element value is updated to the first value if the qualifier element value prior to the reorganization was the second value and is updated to the second value if the qualifier element value prior to the reorganization was the first value.
-
-
27. The article of manufacture of claim 26, wherein the system information is modified after reorganizing the data in the shadow copies by indicating that the qualifier element of the reorganized database file names is the qualifier element in the shadow name, wherein, after the reorganization, the database program accesses the reorganized database objects by accessing the database file names having the modified qualifier element indicated in the system information.
Specification