Relocating derived cache during data rebalance to maintain application performance

• US 10,642,837 B2
• Filed: 01/19/2017
• Issued: 05/05/2020
• Est. Priority Date: 03/15/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Umamageswaran, Kothanda, Meiyyappan, Krishnan, Ng, Adrian Tsz Him, Sridharan, Vijay, Zhang, Wei, Hu, Ke, Zeng, Xin
• Primary Examiner(s): Burke, Jeff A
• Assistant Examiner(s): Mincey, Jermaine A
• Application Number:
  US15/410,496
• Publication Number:
  US 20170206199A1
• Time in Patent Office: 1,202 Days
• Field of Search: None
• CPC Class Codes: G06F 16/24552 Database cache management
• 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

According to embodiments, a derived cache that is derived from a first instance of particular data is used to speed up queries and other operations over a second instance of the particular data. Traditionally, a DBMS generates and uses derived cache data only for the database data from which the derived data was derived. However, according to embodiments, derived cache data associated with a first instance of database data is relocated to the location of a second, newly created, instance of the database data. Since the derived cache data is derived from an identical copy of the database data, the cache data derived for the first instance can successfully be used to speed up applications running over the second instance of the database data.

Claims

1. A computer-executed method comprising:

maintaining a database on persistent storage of a storage device;

maintaining one or more derived caches in memory of the storage device;

wherein a particular derived cache, of the one or more derived caches, includes

information;

derived from a unit of data, from the database, that is stored persistently in a particular region of the persistent storage, and

that is accessed to compute one or more values for queries;

wherein the storage device is configured to compute the one or more values for the queries from values stored in the unit of data;

wherein the unit of data is in a different format from the particular derived cache;

determining to copy the unit of data, that is stored in the particular region of the persistent storage, to a second storage device;

in response to determining to copy the unit of data, that is stored in the particular region of the persistent storage, to the second storage device;

copying the unit of data, that is stored in the particular region of the persistent storage, to the second storage device, and

copying the particular derived cache to the second storage device;

wherein the copy of the unit of data is in a different format from the copy of the particular derived cache; and

accessing said particular derived cache at the second storage device to compute second one or more values for a particular query;

wherein the second storage device is configured to compute the second one or more values for the particular query from values stored in the copy of the unit of data;

wherein the method is performed by one or more computing devices.

2. The computer-executed method of claim 1, wherein the particular derived cache is a storage index.

3. The computer-executed method of claim 1, wherein the particular derived cache is a data summary that describes aspects of data from the particular region of the persistent storage.

4. The computer-executed method of claim 1, wherein the particular derived cache is a columnar cache.

5. The computer-executed method of claim 1, wherein:

data stored in the particular region of the persistent storage is stored in a first format;

the particular derived cache comprises data, from the particular region of the persistent storage, that is stored in a second format; and

the first format is different than the second format.

6. The computer-executed method of claim 1, wherein:

copying the particular derived cache to the second storage device produces a copy of the particular derived cache that is stored on the second storage device; and

accessing said particular derived cache at the second storage device to compute the second one or more values for the particular query comprises accessing the copy of the particular derived cache to compute the second one or more values.

7. The computer-executed method of claim 1, wherein:

copying the particular derived cache to the second storage device produces a copy of the particular derived cache that is stored on the second storage device;

the method further comprises, after copying the particular derived cache to the second storage device, associating the copy of the particular derived cache with metadata indicating a location, of the copy of the unit of data, within the second storage device.

8. One or more non-transitory computer-readable media storing instructions that, when executed by one or more processors, cause:

maintaining a database on persistent storage of a storage device;

maintaining one or more derived caches in memory of the storage device;

wherein a particular derived cache, of the one or more derived caches, includes information;

derived from a unit of data, from the database, that is stored persistently in a particular region of the persistent storage, and

that is accessed to compute one or more values for queries;

wherein the storage device is configured to compute the one or more values for the queries from values stored in the unit of data;

wherein the unit of data is in a different format from the particular derived cache;

determining to copy the unit of data, that is stored in the particular region of the persistent storage, to a second storage device;

in response to determining to copy the unit of data, that is stored in the particular region of the persistent storage, to the second storage device;

copying the unit of data, that is stored in the particular region of the persistent storage, to the second storage device, and

copying the particular derived cache to the second storage device;

wherein the copy of the unit of data is in a different format from the copy of the particular derived cache; and

accessing said particular derived cache at the second storage device to compute second one or more values for a particular query;

wherein the second storage device is configured to compute the second one or more values for the particular query from values stored in the copy of the unit of data.

9. The one or more non-transitory computer-readable media of claim 8, wherein the particular derived cache is a storage index.

10. The one or more non-transitory computer-readable media of claim 8, wherein the particular derived cache is a data summary that describes aspects of data from the particular region of the persistent storage.

11. The one or more non-transitory computer-readable media of claim 8, wherein the particular derived cache is a columnar cache.

12. The one or more non-transitory computer-readable media of claim 8, wherein:

data stored in the particular region of the persistent storage is stored in a first format;

the particular derived cache comprises data, from the particular region of the persistent storage, that is stored in a second format; and

the first format is different than the second format.

13. The one or more non-transitory computer-readable media of claim 8, wherein:

copying the particular derived cache to the second storage device produces a copy of the particular derived cache that is stored on the second storage device; and

accessing said particular derived cache at the second storage device to compute the second one or more values for the particular query comprises accessing the copy of the particular derived cache to compute the second one or more values.

14. The one or more non-transitory computer-readable media of claim 8, wherein:

copying the particular derived cache to the second storage device produces a copy of the particular derived cache that is stored on the second storage device;

instructions further comprise instructions that, when executed by one or more processors, cause, after copying the particular derived cache to the second storage device, associating the copy of the particular derived cache with metadata indicating a location, of the copy of the unit of data, within the second storage device.