×

Swapping Multiple Object Aliases in a Database System

  • US 20090049022A1
  • Filed: 08/15/2007
  • Published: 02/19/2009
  • Est. Priority Date: 08/15/2007
  • Status: Active Grant
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.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×