PROVIDING METADATA TO DATABASE SYSTEMS AND ENVIRONMENTS WITH MULTIPLE PROCESSING UNITS OR MODULES

• US 20140149349A1
• Filed: 11/29/2012
• Published: 05/29/2014
• Est. Priority Date: 11/29/2012
• Status: Active Grant

• Current Assignee: Teradata Corporation
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Milby, Gregory Howard, Reed, Michael Leon, Li, Guofang, Virgil, Kevin Dean
• Granted Patent: US 10,042,907 B2
• Time in Patent Office: Days
• US Class Current: 707/626
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

Metadata can be provided to multiple processing units of a database system by using local storages respectively provided for the processing units, such that a local storage is accessible only to its respective processing unit. As a result, processing units can access metadata when needed (e.g., when needed to process a database request at runtime) without having to access a source external to the database system. In addition, metadata (e.g., an XML object, XML schema, XSLT stylesheets, XQuery modules) can be provided using a database request or command, for example, by using a register statement.

Claims

1. A computer-implemented method of providing data objects to a database system that includes multiple processing units in one or more database nodes that each include at least one processor operable to process at least a portion of data for the database system, wherein at least one of the database nodes includes first and second processing units, and first and second local storages that can be accessed only by the first and second processing units, respectively, and wherein the computer-implemented method comprises:

obtaining one or more data objects, pertaining to metadata for data associated with the database system, to be provided to least the first and second processing units of the at least one database node of the database system; and

storing or at least facilitating storage of a copy of the one or more objects in each one of the first and second local storages for access only by the first and second processing units, respectively, thereby allowing each one of the first and second processing units to access its own copy of the one or more database objects without sharing its own copy with the other one of the first and second processing units.

2. The computer-implemented method of claim 1, wherein the facilitating of the storage of the copy of the one or more objects in each one of the first and second local storages for access only the first and second processing units, respectively, also allows each one of the first and second processing units to access its own copy of the one or more database objects without accessing data from an external source being external to the database system.

3. The computer-implemented method of claim 2, wherein the external source can be accessed by the database system via a computer network.

4. The computer-implemented method of claim 3, wherein the computer network is one of the following:

the Internet, a public network, a computer network that is not secured.

5. The computer-implemented method of claim 1, wherein at least one of the first and second local storages includes a local unhashed dictionary repository that can be searched by each one of the multiple database nodes to retrieve the one or more objects.

6. The computer-implemented method of claim 5, wherein the local unhashed dictionary repository is partitioned into multiple portions for storing multiple types of the one or more database objects.

7. The computer-implemented method of claim 1, wherein the one or more data objects include one or more XML objects or XML data.

8. The computer-implemented method of claim 7, wherein the one or more XML objects include at least one of:

one or more XML schema, one or more XSLT stylesheet, and one or more XQuery modules.

9. The computer-implemented method of claim 1,

wherein the obtaining of the one or more data objects pertaining to metadata associated with the database system comprises:

receiving a database request that includes the one or more database objects, and

wherein the facilitating of the storage of the copy of the one or more objects in each one of the first and second local storages for access only the first and second processing units comprises;

storing the one or more objects in each of respective local unhashed dictionary repositories of the processing units that can be searched by each one of the processing units to retrieve the one or more objects in response to a database request requiring the one or more database objects.

10. The computer-implemented method of claim 9, wherein the database request includes a SQL registration request or command that can be input by a user of the database system, and wherein the database request requiring the one or more database objects is a SQL list registered data that can be input by a user of the database system.

11. The computer-implemented method of claim 1, wherein the database nodes are shared nothing database nodes arranged not to share access to data.

12. The computer-implemented method of claim 10, wherein the computer-implemented method further comprises:

determining, at the first processing unit, to access the one or more data objects;

looking up the one or more objects, by the first processing unit, a first local storage of the local storages designated for access only by the first database node;

thereafter, accessing by the processing unit, the first local storage to retrieve the one or more data objects for processing data associated with the database system.

13. An apparatus that includes one or more processers configured to:

obtaining one or more data objects, pertaining to metadata for data associated with a database system, to be provided to least first and second processing units of at least one database node of the database system; and

at least facilitate storage of a copy of the one or more objects in each one of first and second local storages provided for access only the by first and second processing units, respectively, thereby allowing each one of the first and second processing units to access its own copy of the one or more database objects without sharing its own copy with the other one of the first and second processing units.

14. The apparatus of claim 13, wherein the facilitating of the storage of the copy of the one or more objects in each one of the first and second local storages for access only the first and second processing units, respectively, also allows each one of the first and second processing units to access its own copy of the one or more database objects without accessing data from an external source being external to the database system.

15. The apparatus of claim 13, wherein the external source can be accessed by the database system via a computer network.

16. The apparatus of claim 15, wherein the computer network is one of the following:

the Internet, a public network, a computer network that is not secured.

17. The apparatus of claim 13, wherein at least one of the first and second local storages includes a local unhashed dictionary repository that can be searched by each one of the multiple database nodes to retrieve the one or more objects.

18. The apparatus of claim 13, wherein at least one of the first and second local storages includes a local unhashed dictionary repository that can be searched by each one of the multiple database nodes to retrieve the one or more objects.

19. The apparatus of claim 18, wherein the local unhashed dictionary repository is partitioned into multiple portions for storing multiple types of the one or more database objects.

20. A non-transitory computer readable storage medium storing at least computer executable code configured to provide data objects to a database system that includes multiple processing units in one or more database nodes that each include at least one processor operable to process at least a portion of data for the database system, wherein at least one of the database nodes includes first and second processing units, and first and second local storages that can be accessed only by the first and second processing units, respectively, and wherein the executable computer code includes:

executable computer code configured to obtain one or more data objects, pertaining to metadata for data associated with the database system, to be provided to least the first and second processing units of the at least one database node of the database system; and

executable computer code configured to store or at least facilitate storage of a copy of the one or more objects in each one of the first and second local storages for access only by the first and second processing units, respectively, thereby allowing each one of the first and second processing units to access its own copy of the one or more database objects without sharing its own copy with the other one of the first and second processing units.