US Patent No. 10,366,057

DESIGNATED COMPUTING GROUPS OR POOLS OF RESOURCES FOR STORING AND PROCESSING DATA BASED ON ITS CHARACTERISTICS


Patent No. 10,366,057
Issue Date July 30, 2019
Title Designated Computing Groups Or Pools Of Resources For Storing And Processing Data Based On Its Characteristics
Inventorship John Mark Morris, San Diego, CA (US)
Donald Raymond Pederson, San Diego, CA (US)
Douglas P. Brown, Rancho Santa Fe, CA (US)
Assignee Teradata US, Inc., San Diego, CA (US)

Claim of US Patent No. 10,366,057

1. A method, at least partly implemented by a device, for handling data and one or more operations associated with the data in a database system, wherein the method comprises:providing multiple computing resources each configured to store and process the data independently from each other and to independently provide the stored data in response to database queries from the database system;
assigning a selected one of multiple computing groups of the computing resources of the database system to handle the data and one or more of the database queries associated with the data, including storing and processing of database requests associated with the data, based on one or more determined characteristics associated with the data, wherein
each one of the multiple computing groups of the computing resources includes one or more of the computing resources designated to be part of that computing group,
each one of the multiple computing resources includes one or more designated processors designated to process respective data stored only in one or more designated storage devices that are designated to store the respective data only for the computing resource, such that the one or more processors are configured to process database requests for the respective data stored only in the one or more storage devices, and
at least one of the computing groups includes one or more computing resources that are within a determined range of similarity;
providing first data of a first data characteristic to a first computing group of the computing groups of the database system designated for storing and processing of the data of the first data characteristic, wherein the first data characteristic includes not being indexed by the first computing group, and the first data is stored in one or more designated storage devices associated with the first computing group as non-indexed data;
providing second data of a second data characteristic to a second computing group of the computing groups of the database system designated for storing and processing of the data of the second data characteristic, wherein the second data characteristic includes being indexed by the second computing group, and the second data is stored one or more designated storage devices associated with the second computing group as indexed data by indexing the second data with respect to at least one data index;
not allowing the first data of the first data characteristic to be provided to and processed by the second computing group;
not allowing the second data of the second data characteristic to be provided to and processed by the first computing group; and
providing, independently by the first or second computing group, the stored first or second data in response to the one or more database queries of the database system.