Swapping Multiple Object Aliases in a Database System
First Claim
Patent Images
1. A method for swapping multiple alias names for multiple objects in a database management system, the method comprising:
- compiling a Structured Query Language (SQL) swap alias command to create a compiled SQL swap alias command, wherein the single SQL swap alias command is a single SQL statement that, when compiled, causes at least one alias name swap for multiple objects in the database management system; and
issuing the compiled SQL swap alias command to an SQL interface for the database management system, wherein the compiled SQL swap alias command performs the steps of;
in response to determining that an issuer of the swap alias command is authorized to issue the SQL swap alias command, determining if a particular alias name, for one of the multiple objects, is locked to prevent changing the particular alias name;
in response to determining that the particular alias name is locked, determining if the issuer has an authority to force the alias name swap of the particular alias name; and
in response to determining that the issuer has the authority to force the alias name swap of the particular alias name, swapping alias names of the particular alias name and all non-locked alias names for the multiple objects in the database management system.
2 Assignments
0 Petitions
Accused Products
Abstract
A novel Structure Query Language (SQL) command globally swaps multiple alias names for multiple objects in a database management system.
17 Citations
20 Claims
-
1. A method for swapping multiple alias names for multiple objects in a database management system, the method comprising:
-
compiling a Structured Query Language (SQL) swap alias command to create a compiled SQL swap alias command, wherein the single SQL swap alias command is a single SQL statement that, when compiled, causes at least one alias name swap for multiple objects in the database management system; and issuing the compiled SQL swap alias command to an SQL interface for the database management system, wherein the compiled SQL swap alias command performs the steps of; in response to determining that an issuer of the swap alias command is authorized to issue the SQL swap alias command, determining if a particular alias name, for one of the multiple objects, is locked to prevent changing the particular alias name; in response to determining that the particular alias name is locked, determining if the issuer has an authority to force the alias name swap of the particular alias name; and in response to determining that the issuer has the authority to force the alias name swap of the particular alias name, swapping alias names of the particular alias name and all non-locked alias names for the multiple objects in the database management system. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A system comprising:
-
a processor; a data bus coupled to the processor; a memory coupled to the data bus; and a computer-usable medium embodying computer program code, the computer program code comprising instructions executable by the processor and configured for swapping multiple alias names for multiple objects in a database management system by performing the steps of; compiling a Structured Query Language (SQL) swap alias command to create a compiled SQL swap alias command, wherein the SQL swap alias command is a single SQL statement that, when compiled, causes at least one alias name swap in the database management system; and issuing the compiled SQL swap alias command to an SQL interface for the database management system, wherein the compiled SQL swap alias command performs the steps of; in response to determining that an issuer of the swap alias command is authorized to issue the SQL swap alias command, determining if a particular underlying object, for a particular alias name, is locked to prevent changing the particular alias name; in response to determining that the particular underlying object is locked, determining if the issuer has an authority to force an alias name swap of the particular alias name; and in response to determining that the issuer has the authority to force the alias name swap of the particular alias name, swapping alias names of the particular alias name for the multiple objects in the database management system that have been listed in the SQL swap alias command, thereby forcing all locked resources to be freed. - View Dependent Claims (8, 9, 10, 11, 12)
-
- 13. A computer-readable medium on which is stored a Structured Query Language (SQL) swap alias command, wherein the SQL swap alias command is a single SQL statement that, when compiled, causes a global alias name swap for multiple objects in a database management system.
Specification