Swapping multiple object aliases in a database system

• US 7,822,729 B2
• Filed: 08/15/2007
• Issued: 10/26/2010
• Est. Priority Date: 08/15/2007
• Status: Expired due to Fees

• Current Assignee: LinkedIn Corporation (Microsoft Corporation)
• Original Assignee: International Business Machines Corporation
• Inventors: Bender, Michael, Fisher, Bruce A.
• Primary Examiner(s): Trujillo; James
• Assistant Examiner(s): PHILLIPS, III, ALBERT M
• Application Number:
  US11/839,388
• Publication Number:
  US 20090049022A1
• Time in Patent Office: 1,168 Days
• Field of Search: 707/704
• US Class Current: 707/704
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

A novel Structure Query Language (SQL) command globally swaps multiple alias names for multiple objects in a database management system.

Claims

1. A method for swapping multiple alias names for multiple objects in a database management system via execution of a single command, 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 comprises a list of multiple different objects whose aliases are to be swapped and which, when compiled and executed, causes a global alias swap of at least one alias name swap for different objects among the multiple different objects in the database management system, wherein the global alias swap of the at least one alias name swap for the multiple different objects is triggered by execution of the compiled SQL swap alias command; 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 of the swap alias command has an authority to force the alias name swap of the particular alias name;

in response to determining that the issuer has the authority to force the alias name swap of the particular alias name, swapping multiple alias names including the particular alias name and all non-locked alias names for the multiple objects in the database management system, wherein said swapping is performed as a global alias swap via execution of the compiled SQL swap alias command generated from the single SQL swap alias command;

when the issuer does not have the authority to force the alias name swap of the particular alias name;

issuing an error message if the SQL swap alias command fails because the issuer is not authorized to force the alias name swap of the particular object; and

swapping only the alias names of each of multiple other objects whose alias names are non-locked or for which the issuer has authority to force the alias name swap, wherein said swapping is performed as a global alias swap via execution of the compiled SQL swap alias command generated from the single SQL swap alias command.

2. The method of claim 1, wherein the database management system is a DB2 system.

3. The method of claim 1, wherein the multiple objects are tables of data in the database management system.

4. The method of claim 1, further comprising:

issuing an error message if the swap alias command fails because the issuer is not authorized to issue the SQL swap alias command.

5. The method of claim 1, wherein the SQL swap alias command has a syntax of “

SWAP ALIASGROUPS [alias_n becomes object.sub.-n] [multiple iterations] [force]”

, wherein “

alias_n”

defines an alias name that is redirected to point to “

object_n”

, “

multiple iterations”

defines that the swap alias command is to be applied to multiple objects in the database management system, wherein one or more [alias_x becomes object_x] can be defined, and “

force”

defines whether the command is to force the alias name swap.

6. 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 single 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 comprises a list of multiple different objects whose aliases are to be swapped and which, when compiled and executed, causes a global alias swap of at least one alias name swap for different objects among the multiple different objects in the database management system, wherein the global alias swap of the at least one alias name swap for the multiple different objects is triggered by execution of the compiled SQL swap alias command; 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 alias name is locked, determining if the issuer of the swap alias command has an authority to force the alias name swap of the particular alias name;

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 single SQL swap alias command, thereby forcing all locked resources to be freed, wherein said swapping is performed as a global alias swap via execution of the compiled SQL swap alias command generated from the single SQL swap alias command;

when the issuer does not have the authority to force the alias name swap of the particular alias name;

issuing an error message if the SQL swap alias command fails because the issuer is not authorized to force the alias name swap of the particular object; and

swapping only the alias names of each of multiple other objects whose alias names are non-locked or for which the issuer has authority to force the alias name swap, wherein said swapping is performed as a global alias swap via execution of the compiled SQL swap alias command generated from the single SQL swap alias command.

7. The system of claim 6, wherein the database management system is a DB2 system.

8. The system of claim 6, wherein the multiple objects are tables of data in the database management system.

9. The system of claim 6, wherein the instructions are further configured for:

issuing an error message if the SQL swap alias command fails because the issuer is not authorized to issue the swap alias command.

10. The system of claim 6, wherein the SQL swap alias command has a syntax of “

SWAP ALIASGROUPS [alias_n becomes object_n] [multiple iterations] [force]”

, wherein “

alias_n”

defines an alias name that is redirected to point to “

object_n”

, “

multiple iterations”

defines that the swap alias command is to be applied to multiple objects in the database management system, wherein one or more [alias_x becomes object_x] can be defined, and “

force”

defines whether the command is to force the alias name swap.

11. 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 comprises a list of multiple different objects whose aliases are to be swapped and which, when compiled and executed, causes a global alias name swap for multiple objects in a database management system;

wherein the SQL swap alias command, when compiled and issued as a compiled SQL swap alias command to an SQL interface for the database management system, performs the steps of;

in response to determining that an issuer of the SQL 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 to point to a different underlying table/view;

in response to determining that the particular alias name is locked, determining if the issuer of the swap alias command has an authority to force the alias name swap of the particular alias name;

in response to determining that the issuer has the authority to force the alias name swap of the particular alias name;

swapping alias names for all objects using the particular alias name in the database management system; and

concurrently swapping multiple alias names of all non-locked alias names for the multiple objects in the database management system, wherein said swapping is performed as a global alias swap;

when the issuer does not have the authority to force the alias name swap of the particular alias name;

issuing an error message if the SQL swap alias command fails because the issuer is not authorized to force the alias name swap; and

swapping only the alias names of each of multiple other objects whose alias names are non-locked or for which the issuer has authority to force the alias name swap, wherein said swapping is performed as a global alias swap via execution of the compiled SQL swap alias command generated from the single SQL swap alias command.

12. The computer-readable medium of claim 11, wherein the SQL swap alias command, when compiled, performs the step of:

issuing an error message if the SQL swap alias command fails because the issuer is not authorized to issue the swap alias command.

13. The computer-readable medium of claim 11, wherein the database management system is a DB2 system.

14. The computer-readable medium of claim 11, wherein the SQL swap alias command has a syntax of “

SWAP ALIASGROUPS [alias_n becomes object_n] [multiple iterations] [force]”

, wherein “

alias_n”

defines an old alias name that is replaced with a new alias name “

object_n”

, “

multiple iterations”

defines that the swap alias command is to be applied to multiple objects in the database management system, and “

force”

defines whether the command is to force the alias name swap.

15. The computer-readable medium of claim 11, wherein the computer-usable medium is a component of a remote server, and wherein the computer executable instructions are deployable to a local computer from the remote server.

16. The computer-readable medium of claim 11, wherein the computer executable instructions are capable of being provided by a service provider to a customer on an on-demand.