Designated computing groups or pools of resources for storing and processing data based on its characteristics
Data or one or more operations can be provided, based on one or more characteristics associated with the data and/or operations, to a designated computing group or pool of computing resources designated for handling the data and/or operations with the particular data characteristic(s). The designated computing group can, for example, be one of multiple computing groups in the same system or device. As such, all of the computing groups can still function together in the same system or device, for example, in parallel. However, each one of the multiple computing groups can, for example, be defined or predefined to include one or more computing resources that are more suitable for storing and/or processing data with one or more data characteristics or handle operations with one or more determined characteristics.
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.
2. The method of claim 1 , the handling of the data includes one or more of the following: storing the data, performing an operation on the data, processing of the data, manipulation of the data, retrieval of the data, and processing of a database request associated with the data.
3. The method of claim 1 , the method further comprises:
not storing the first data of the first data characteristic to the second computing group of the computing groups of the database system.
4. A device that includes one or more physical processors handling data and one or more operations associated with the data in a database system, wherein the device is configured to:
provide 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;
assign a selected one of multiple computing groups of the computing resources of the computing 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;
provide 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;
provide 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 in 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 allow the first data of the first data characteristic to be provided to and processed by the second computing group;
not allow the second data of the second data characteristic to be provided to and processed by the first computing group; and
provide, 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.
5. The device of claim 4 , wherein the handling of the data includes one or more of the following: storing the data, performing an operation on the data, processing of the data, manipulation of the data, retrieval of the data, and processing of a database request associated with the data.
6. The device of claim 5 , wherein the device is further configured to not to store the first data of the first data characteristic to the second computing group of the computing groups of the database system.
7. A non-transitory computer readable storage medium storing at least executable code for a database system that handles data and one or more operations associated with data, wherein the executable code when executed by the database system cause the database system to:
provide 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;
assign a selected one of multiple computing groups of the computing resources of the computing 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;
provide 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;
provide 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 in 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 allow the first data of the first data characteristic to be provided to and processed by the second computing group;
not allow the second data of the second data characteristic to be provided to and processed by the first computing group; and
provide, 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.
8. The non-transitory computer readable storage medium of claim 7 , wherein the handling of the data includes one or more of the following: storing the data, performing an operation on the data, processing of the data, manipulation of the data, retrieval of the data, and processing of a request or database request associated with the data.