×

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

  • US 10,042,907 B2
  • Filed: 11/29/2012
  • Issued: 08/07/2018
  • Est. Priority Date: 11/29/2012
  • Status: Active Grant
First Claim
Patent Images

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 configured 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 describing the organization of data stored in the database system and needed for processing of database queries of the data stored in the database system, to be provided to at least the first and second processing units of the at least one database node of the database system;

    storing a copy of the same one or more obtained 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, wherein each one of the first and second local storages are partitioned into multiple portions for storing multiple types of database objects pertaining to organization of data stored in the database system, wherein the storing or at least facilitating storage of a copy of the one or more obtained objects stores or at least facilitates storage of the copy of the one or more obtained objects in a respective portion of the first and second local storages corresponding to the type of the one or more obtained objects;

    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, stored in its respective one of the first and second local storages by searching its own local storage, without sharing its own copy with the other one of the first and second processing units;

    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, stored in its respective one of the first and second local storages by searching its own local storage, without accessing data from an external source being external to the database system; and

    searching, by each one of the multiple database nodes, its own copy of the one or more database objects pertaining to the metadata needed for processing of the database queries of the data stored in the database system, in response to the database queries of the database.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×