Providing metadata to database systems and environments with multiple processing units or modules

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.

What is claimed is: 
     
         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;   storing or at least facilitating storage of a copy of the one or more objects pertaining to the metadata 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 pertaining to the metadata without sharing its own copy with the other one of the first and second processing units; and   accessing by each one of the first and second processing units its respective own copy of the one or more database objects pertaining to the metadata 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 processors configured to:
 obtain 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   facilitate storage of a copy of the one or more objects pertaining to metadata 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 pertaining to metadata without sharing its own copy with the other one of the first and second processing units; and   access by each one of the first and second processing units its respective own copy of the one or more database objects pertaining to the metadata 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;   executable computer code configured to store or at least facilitate storage of a copy of the one or more objects pertaining to metadata 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 pertaining to metadata without sharing its own copy with the other one of the first and second processing units; and   executable computer code configured to access by each one of the first and second processing units its respective own copy of the one or more database objects pertaining to the metadata without sharing its own copy with the other one of the first and second processing units.