IP Library › Granted Patent US 12705242
Granted Patent B2
US 12705242 · App. 18/372,921 · Granted Aug 11, 2026

System and method for caching object data in a cloud database system

Inventors: Bhashyam Ramesh (Secunderabad, IN); Stephen Brobst (Henderson, NV); Shambhu Sree Vegunta (Hyderabad, IN); Chandrasekhar Tekur (Hyderabad, IN); Diwakar Mishra (Hyderabad, IN); Bhargav Reddi (Andhra Pradesh, IN)
Assignee: Teradata US, Inc.
G06F16/24552G06F16/254
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12705242
App. No.
18/372,921
Granted
Aug 11, 2026
Kind
B2
Abstract

In a cloud database system employing multiple types of storage, such as external object store, managed object store. block storage, and compute node memory, each type of storage having different kinds of file organization, different types of data organization, different forms of storage access, and different latency and throughput costs, a system and method for caching different data transformations created during query executions involving different data stores. Transformed versions of data read from external object storage are saved to a multi-layered warehouse cache for use in subsequent query executions.

Claims (56)

1 . A database system comprising:

a primary compute cluster including a processor and a non-transitory storage medium containing instructions executable on said processor for executing database management system (DBMS);

at least one additional compute cluster;

multiple data storage systems providing different kinds of file organization, different kinds of data organization, and different forms of storage access, said primary and additional compute clusters having access to said multiple data storage; and

a warehouse cache containing transformed versions of data read from a first one of said multiple data storage systems to a second one of said multiple data storage systems during query executions by said compute clusters, said transformed versions of data comprising multiple copies of said data in multiple formats including respective file formats or data formats, said transformed versions of data concurrently stored within said warehouse cache being available for use in subsequent query executions by said compute clusters, and said transformed versions are physically distinct from one another.

2 . A database system in accordance with claim 1 , wherein said multiple data storage systems include an external cloud object storage and at least one of:

a managed cloud storage;

a block storage; and

a database compute node memory.

3 . A database system in accordance with claim 2 , wherein said transformed versions of data include at least one of:

data read from said external cloud object storage, transformed, and saved as managed data within said managed cloud storage;

data read from said external cloud object storage, transformed, and saved to said block storage;

data read from said managed cloud object storage, transformed, and saved to said block storage;

data read from said external cloud object storage, transformed, and saved to said database compute node memory;

data read from said managed cloud object storage, transformed, and saved to said database compute node memory; and

data read from said block storage, transformed, and saved to said database compute node memory.

4 . A database system in accordance with claim 1 , wherein said transformed versions of data saved to said warehouse cache include metadata associated with said transformed versions of data.

5 . A database system in accordance with claim 1 , wherein said transformed versions of data saved to said warehouse cache include index data associated with said transformed versions of data.

6 . A database system in accordance with claim 1 , wherein said warehouse cache comprises multiple caches wherein said transformed versions of data are distributed among different ones of said multiple data storage systems.

7 . A database system in accordance with claim 6 , wherein said multiple caches are organized in a cache hierarchy that can store multiple synchronized transformed versions of data.

8 . In a database system comprising a processor and a non-transitory storage medium containing instructions executable on said processor for executing a database management system (DBMS) and multiple data storage systems accessible to said DBMS providing different kinds of file organization, different kinds of data organization, and different forms of storage access;

the improvement comprising:

a warehouse cache containing transformed versions of data read from a first one of said multiple data storage systems to a second one of said multiple data storage systems during query executions by said DBMS, said transformed versions of data comprising multiple copies of said data in multiple formats including respective file formats or data formats, said transformed versions of data concurrently stored within said warehouse cache being available for use in subsequent query executions by said DBMS, and said transformed versions are physically distinct from one another.

9 . A database system in accordance with claim 8 , wherein said multiple data storage systems include an external cloud object storage and at least one of:

a managed cloud storage;

a block storage; and

a database compute node memory.

10 . A database system in accordance with claim 9 , wherein said transformed versions of data include at least one of:

data read from said external cloud object storage, transformed, and saved as managed data within said managed cloud storage;

data read from said external cloud object storage, transformed, and saved to said block storage;

data read from said managed cloud object storage, transformed, and saved to said block storage;

data read from said external cloud object storage, transformed, and saved to said database compute node memory;

data read from said managed cloud object storage, transformed, and saved to said database compute node memory; and

data read from said block storage, transformed, and saved to said database compute node memory.

11 . A database system in accordance with claim 8 , wherein said transformed versions of data saved to said warehouse cache include metadata associated with said transformed versions of data.

12 . A database system in accordance with claim 8 , wherein said transformed versions of data saved to said warehouse cache include index data associated with said transformed versions of data.

13 . A database system in accordance with claim 8 , wherein said warehouse cache comprises multiple caches wherein said transformed versions of data are distributed among different ones of said multiple data storage systems.

14 . A database system in accordance with claim 13 , wherein said multiple caches are organized in a cache hierarchy that can store multiple synchronized transformed versions of data.

15 . A method for caching data within a database system, said database system comprising a processor and a non-transitory storage medium containing instructions executable on said processor for executing a database management system (DBMS) and multiple data storage systems accessible to said DBMS providing different kinds of file organization, different kinds of data organization, and different forms of storage access;

the method comprising the steps of:

caching to a warehouse cache transformed versions of data read from a first one of said multiple data storage systems to a second one of said multiple data storage systems during query executions by said DBMS, said transformed versions of data comprising multiple copies of said data in multiple formats including respective file formats or data formats, said transformed versions of data concurrently stored within said warehouse cache being available for use in subsequent query executions by said DBMS, and said transformed versions are physically distinct from one another.

16 . A method in accordance with claim 15 , wherein said multiple data storage systems include an external cloud object storage and at least one of:

a managed cloud storage;

a block storage; and

a database compute node memory.

17 . A method in accordance with claim 16 , wherein said transformed versions of data include at least one of:

data read from said external cloud object storage, transformed, and saved as managed data within said managed cloud storage;

data read from said external cloud object storage, transformed, and saved to said block storage;

data read from said managed cloud object storage, transformed, and saved to said block storage;

data read from said external cloud object storage, transformed, and saved to said database compute node memory;

data read from said managed cloud object storage, transformed, and saved to said database compute node memory; and

data read from said block storage, transformed, and saved to said database compute node memory.

18 . A method in accordance with claim 15 , wherein said transformed versions of data saved to said warehouse cache include metadata associated with said transformed versions of data.

19 . A method in accordance with claim 15 , wherein said transformed versions of data saved to said warehouse cache include index data associated with said transformed versions of data.

20 . A method in accordance with claim 15 , wherein said warehouse cache comprises multiple caches wherein said transformed versions of data are distributed among different ones of said multiple data storage systems.

21 . A method in accordance with claim 20 , wherein said multiple caches are organized in a cache hierarchy that can store multiple synchronized transformed versions of data.