18140152. EFFICIENT EVALUATION OF QUERIES ACROSS MULTIPLE COLUMNAR STORAGE TIERS simplified abstract (Oracle International Corporation)
Contents
- 1 EFFICIENT EVALUATION OF QUERIES ACROSS MULTIPLE COLUMNAR STORAGE TIERS
- 1.1 Organization Name
- 1.2 Inventor(s)
- 1.3 EFFICIENT EVALUATION OF QUERIES ACROSS MULTIPLE COLUMNAR STORAGE TIERS - A simplified explanation of the abstract
- 1.4 Simplified Explanation
- 1.5 Potential Applications
- 1.6 Problems Solved
- 1.7 Benefits
- 1.8 Potential Commercial Applications
- 1.9 Possible Prior Art
- 1.10 Unanswered Questions
- 1.11 Original Abstract Submitted
EFFICIENT EVALUATION OF QUERIES ACROSS MULTIPLE COLUMNAR STORAGE TIERS
Organization Name
Oracle International Corporation
Inventor(s)
SHELDON ANDRE KEVIN Lewis of San Mateo CA (US)
TECK HUA Lee of San Mateo CA (US)
EFFICIENT EVALUATION OF QUERIES ACROSS MULTIPLE COLUMNAR STORAGE TIERS - A simplified explanation of the abstract
This abstract first appeared for US patent application 18140152 titled 'EFFICIENT EVALUATION OF QUERIES ACROSS MULTIPLE COLUMNAR STORAGE TIERS
Simplified Explanation
The abstract describes a multiple-tier operation that evaluates a query across storage tiers in columnar format. The operation involves accessing subsets of rows in different tiers to generate results and aggregating those results to form a query result set.
- The innovation involves evaluating queries across storage tiers in columnar format.
- The operation accesses subsets of rows in different tiers to generate results.
- The results are aggregated to form a query result set.
Potential Applications
This technology could be applied in data analytics, business intelligence, and data warehousing systems.
Problems Solved
This technology solves the problem of efficiently processing queries across different storage tiers in columnar format.
Benefits
The benefits of this technology include improved query performance, reduced storage costs, and enhanced data processing capabilities.
Potential Commercial Applications
A potential commercial application of this technology could be in cloud-based data analytics platforms.
Possible Prior Art
One possible prior art for this technology could be the use of columnar storage formats in database systems.
Unanswered Questions
How does this technology handle large datasets?
This article does not address how the technology handles large datasets and if there are any limitations in processing them efficiently.
What are the security implications of using this technology?
The article does not discuss the security implications of using this technology and how sensitive data is protected during query processing.
Original Abstract Submitted
A multiple-tier operation evaluates a query across storage tiers in columnar format. A database server receives from a client a query for reading values from a set of columns of a database table. The multiple-tier operation comprises accessing a first subset of rows for the set of columns in columnar format in a first tier to generate a first set of results and accessing a second subset of rows for the set of columns in columnar format in a second tier to generate a second subset of results. The multiple-tier operation further comprises aggregating the first set of results and the second set of results to form a query result set and returning the query result set to the client.
