Oracle international corporation (20240126816). SELF-DISCOVERY AND CONSTRUCTION OF TYPE-SENSITIVE COLUMNAR FORMATS ON TYPE-AGNOSTIC STORAGE SERVERS TO ACCELERATE OFFLOADED QUERIES simplified abstract

SELF-DISCOVERY AND CONSTRUCTION OF TYPE-SENSITIVE COLUMNAR FORMATS ON TYPE-AGNOSTIC STORAGE SERVERS TO ACCELERATE OFFLOADED QUERIES

Organization Name

oracle international corporation

Inventor(s)

Jorge Luis Issa Garcia of Zapopan (MX)

Teck Hua Lee of Newark CA (US)

Sheldon Andre Kevin Lewis of Zapopan (MX)

Bangalore Prashanth of Redwood City CA (US)

Hui Joe Chang of San Jose CA (US)

Zhen Hua Liu of San Mateo CA (US)

Aurosish Mishra of Foster City CA (US)

Shasank K. Chavan of Menlo Park CA (US)

SELF-DISCOVERY AND CONSTRUCTION OF TYPE-SENSITIVE COLUMNAR FORMATS ON TYPE-AGNOSTIC STORAGE SERVERS TO ACCELERATE OFFLOADED QUERIES - A simplified explanation of the abstract

This abstract first appeared for US patent application 20240126816 titled 'SELF-DISCOVERY AND CONSTRUCTION OF TYPE-SENSITIVE COLUMNAR FORMATS ON TYPE-AGNOSTIC STORAGE SERVERS TO ACCELERATE OFFLOADED QUERIES

Simplified Explanation

The patent application focuses on database query acceleration through the dynamic discovery of whether the contents of a persistent column can be stored in an accelerated representation in storage-side memory.

• The storage server autonomously decides to generate and store an accelerated representation of a persistent column based on the data type of the column values and the frequency of access of the column for offload computation requests.
• The accelerated representation of the persistent column stored in storage-side memory allows for the acceleration of offload computations requested for the column.
• The technology aims to improve the performance of database queries by optimizing the storage and retrieval of data based on data type discovery and access frequency analysis.

Potential Applications

The technology can be applied in various industries and scenarios where database query performance is crucial, such as finance, healthcare, e-commerce, and data analytics.

Problems Solved

1. Slow database query performance due to inefficient storage and retrieval of data. 2. Inefficient offload computation for persistent columns in databases.

Benefits

1. Improved database query performance. 2. Accelerated offload computation for specific columns. 3. Enhanced overall system efficiency and speed.

Potential Commercial Applications

The technology can be utilized in database management systems, cloud computing services, big data analytics platforms, and any application requiring fast and efficient data processing.

Possible Prior Art

One possible prior art could be the use of in-memory databases or caching mechanisms to accelerate data retrieval and processing in database systems.

Unanswered Questions

How does the technology handle updates or changes in the data type of persistent columns?

The patent abstract does not mention how the system adapts to changes in data types or if it requires manual intervention for updates.

What are the limitations of the technology in terms of scalability and compatibility with different database systems?

The abstract does not provide information on the scalability of the technology or its compatibility with various database management systems.

Original Abstract Submitted

herein is database query acceleration from dynamic discovery of whether contents of a persistent column can be stored in an accelerated representation in storage-side memory. in an embodiment, based on data type discovery, a storage server detects that column values in a persistent column have a particular data type. based on storage-side metadata including a frequency of access of the persistent column as an offload input column for offload computation requests on a certain range of memory addresses, the storage server autonomously decides to generate and store, in storage-side memory in the storage server, an accelerated representation of the persistent column that is based on the particular data type. the storage server receives a request to perform an offload computation for the offload input column. based on the accelerated representation of the persistent column, execution of the offload computation is accelerated.