Simplified query language for accessing metadata

Patent metadata

Field	Value
Publication number	US-9542439-B1
Application number	US-201313917999-A
Country	US
Kind code	B1
Filing date	Jun 14, 2013
Priority date	Jun 14, 2013
Publication date	Jan 10, 2017
Grant date	Jan 10, 2017

Abstract

A CaQL API is provided by receiving a query directed to a catalog that includes metadata. A catalog access target is determined based at least in part on one or more of the following: a CaQL keyword which is included in the query, a name of a table in the catalog which is included in the query, or a predicate which is included in the query. A catalog function is generated based at least in part on the CaQL keyword and the catalog function is performed on the catalog access target.

First claim

What is claimed is:

1. A method for providing a catalog query language (CaQL) application programming interface (API), comprising:
receiving, at a processor which performs the CaQL API, a query associated with performing an operation on a first table in a catalog, wherein the catalog includes metadata;
using the processor to determine a catalog access target, wherein:
determination of the catalog access target is based at least in part on one or more of the following: a catalog query language (CaQL) keyword which identifies the operation and is included in the query, the name of the first table in the catalog which is included in the query, or a predicate which is included in the query;
the first table is located in a plurality of locations in the catalog, including two or more of the following: a heap, an index, a system table, or a system cache; and
determination of the catalog access target includes selecting, based at least in part on the operation, a location from the plurality of locations such that the selected location includes one and only one of the following: the heap, the index, the system table, or the system cache;

using the processor to determine if there is a preexisting lock on a second table that can be reused for the first table, wherein the first table is different from the second table;
in the event it is determined that there is a preexisting lock on the second table that can be reused for the first table, using the processor to determine if the strength of the preexisting lock on the second table is sufficient;
in the event: (a) it is determined that there is a preexisting lock on the second table that can be reused for the first table and (b) it is determined that the strength of the preexisting lock on the second table is not sufficient, obtaining a new lock for the first table;
in the event: (1) it is determined that there is a preexisting lock on the second table that can be reused for the first table and (2) it is determined that the strength of the preexisting lock on the second table is sufficient, reusing the preexisting lock on the second table for the first table;
generating, based at least in part on the CaQL keyword, a catalog function; and
performing the catalog function on the selected location, and wherein
in the event there is a lock on the second table and the first table depends from the second table, it is determined that there is a preexisting lock on the second table that can be reused for the first table; and
in the event there is a lock on the second table and the first table does not depend from the second table, the lock on the second table does not count as a preexisting lock on the second table that can be reused for the first table.

2. The method of claim 1 , wherein the method is performed by one or more of the following: an external catalog system or a unified catalog service (UCS) supported system.

3. The method of claim 1 , wherein the CaQL keyword is associated with a Data Manipulation Language (DML) and excludes a Data Definition Language (DDL).

4. The method of claim 1 , wherein the CaQL keyword is associated with one or more of the following: selecting content in a table, inserting content into a table, or deleting content in a table without dropping the entire table.

5. The method of claim 1 further comprising providing an interface for creating a user-defined locking mode, including by:
receiving a name for the user-defined locking mode;
receiving, for the user-defined locking mode, locking information; and
storing at least the locking information, wherein the name and the locking information are associated so that the stored locking information is able to be retrieved using the name.

6. The method of claim 5 further comprising:
determining if the name of the user-defined locking mode is received;
in the event the name of the user-defined locking mode is not received, performing a default locking process; and
in the event the name of the user-defined locking mode is received:
obtaining the stored locking information using the name; and
performing the user-defined locking process based at least in part on the stored locking information.

7. A system for providing a catalog query language (CaQL) application programming interface (API), comprising:
a processor; and
a memory coupled with the processor, wherein the memory is configured to provide the processor with instructions which when executed cause the processor to:
receive, at the processor, a query associated with performing an operation on a first table in a catalog, wherein the catalog includes metadata;
determine a catalog access target, wherein:
determination of the catalog access target is based at least in part on one or more of the following: a catalog query language (CaQL) keyword which identifies the operation and is included in the query, the name of the first table in the catalog which is included in the query, or a predicate which is included in the query;
the first table is located in a plurality of locations in the catalog, including two or more of the following: a heap, an index, a system table, or a system cache; and
determination of the catalog access target includes selecting, based at least in part on the operation, a location from the plurality of locations such that the selected location includes one and only one of the following: the heap, the index, the system table, or the system cache;

determine if there is a preexisting lock on a second table that can be reused for the first table, wherein the first table is different from the second table;
in the event it is determined that there is a preexisting lock on the second table that can be reused for the first table, determine if the strength of the preexisting lock on the second table is sufficient;
in the event: (a) it is determined that there is a preexisting lock on the second table that can be reused for the first table and (b) it is determined that the strength of the preexisting lock on the second table is not sufficient, obtain a new lock for the first table;
in the event: (1) it is determined that there is a preexisting lock on the second table that can be reused for the first table and (2) it is determined that the strength of the preexisting lock on the second table is sufficient, reuse the preexisting lock on the second table for the first table;
generate, based at least in part on the CaQL keyword, a catalog function; and
perform the catalog function on the selected location, and wherein in the event there is a lock on the second table and the first table depends from the second table, it is determined that there is a preexisting lock on the second table that can be reused for the first table; and
in the event there is a lock on the second table and the first table does not depend from the second table, the lock on the second table does not count as a preexisting lock on the second table that can be reused for the first table.

8. The system of claim 7 , wherein the memory is further configured to provide the processor with instructions which when executed cause the processor to provide an interface for creating a user-defined locking mode, including by:
receiving a name for the user-defined locking mode;
receiving, for the user-defined locking mode, locking information; and
storing at least the locking information, wherein the name and the locking information are associated so that the stored locking information is able to be retrieved using the name.

9. The system of claim 8 , wherein the memory is further configured to provide the processor with instructions which when executed cause the processor to:
determine if the name of the user-defined locking mode is received;
in the event the na

Assignees

• Emc Corp

Inventors

• Cohen Jeffrey Ira
• Harriman Kurt
• Mccline Matthew Clark

Classifications

• G06F17/30359

  Physics · mapped topic

• G06F17/30362

  Physics · mapped topic

• G06F17/30404 Primary

  Physics · mapped topic

• G06F16/2336

  Pessimistic concurrency control approaches, e.g. locking or multiple versions without time stamps · CPC title

• G06F16/25

  Integrating or interfacing systems involving database management systems · CPC title