View source for 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==

[[:Category:oracle international corporation|oracle international corporation]]


[[Category:oracle international corporation]]

==Inventor(s)==

[[:Category:Jorge Luis Issa Garcia of Zapopan (MX)|Jorge Luis Issa Garcia of Zapopan (MX)]][[Category:Jorge Luis Issa Garcia of Zapopan (MX)]]

[[:Category:Teck Hua Lee of Newark CA (US)|Teck Hua Lee of Newark CA (US)]][[Category:Teck Hua Lee of Newark CA (US)]]

[[:Category:Sheldon Andre Kevin Lewis of Zapopan (MX)|Sheldon Andre Kevin Lewis of Zapopan (MX)]][[Category:Sheldon Andre Kevin Lewis of Zapopan (MX)]]

[[:Category:Bangalore Prashanth of Redwood City CA (US)|Bangalore Prashanth of Redwood City CA (US)]][[Category:Bangalore Prashanth of Redwood City CA (US)]]

[[:Category:Hui Joe Chang of San Jose CA (US)|Hui Joe Chang of San Jose CA (US)]][[Category:Hui Joe Chang of San Jose CA (US)]]

[[:Category:Zhen Hua Liu of San Mateo CA (US)|Zhen Hua Liu of San Mateo CA (US)]][[Category:Zhen Hua Liu of San Mateo CA (US)]]

[[:Category:Aurosish Mishra of Foster City CA (US)|Aurosish Mishra of Foster City CA (US)]][[Category:Aurosish Mishra of Foster City CA (US)]]

[[:Category:Shasank K. Chavan of Menlo Park CA (US)|Shasank K. Chavan of Menlo Park CA (US)]][[Category: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.



[[Category:G06F16/903]]