18151280. KEY RANGE QUERY OPTIMIZATION simplified abstract (Salesforce, Inc.)
Contents
KEY RANGE QUERY OPTIMIZATION
Organization Name
Inventor(s)
Kadir Ozdemir of San Jose CA (US)
Tanuj Khurana of Kirkland WA (US)
KEY RANGE QUERY OPTIMIZATION - A simplified explanation of the abstract
This abstract first appeared for US patent application 18151280 titled 'KEY RANGE QUERY OPTIMIZATION
The abstract of this patent application describes techniques for deriving a set of key ranges based on conditional expressions in a database query. The computer system performs logical operations on key spaces to reduce the number of key spaces and convert them into key ranges.
- The computer system receives a database query with conditional expressions affecting which records are returned.
- The set of conditional expressions is represented as key spaces.
- Logical operations are performed on pairs of key spaces to reduce their number.
- The reduced key spaces are converted into key ranges.
Potential Applications: - Database management systems - Data analysis tools - Information retrieval systems
Problems Solved: - Efficiently retrieving specific records from a database - Optimizing database query performance
Benefits: - Improved query execution speed - Enhanced database search capabilities
Commercial Applications: Title: "Enhanced Database Query Optimization Technology" This technology can be used in various industries such as e-commerce, finance, healthcare, and more to streamline database operations, improve data analysis, and enhance overall system performance.
Questions about Key Range Derivation: 1. How does this technology improve database query performance?
- This technology reduces the number of key spaces, making it easier to retrieve specific records efficiently.
2. What are the potential applications of key range derivation in different industries?
- Key range derivation can be applied in various sectors where database management and data retrieval are crucial for operations.
Original Abstract Submitted
Techniques are disclosed relating to deriving a set of key ranges. A computer system receives a database query to be executed against a database having a database table that stores records associated with keys. The database query specifies a set of conditional expressions that affect which ones of those records are returned. Based on the set of conditional expressions, the computer system derives a set of key ranges. The deriving can include representing the set of conditional expressions as a set of key spaces, performing a set of logical operations on pairs of those key spaces to reduce a number of key spaces in the set of key spaces, and converting the set of key spaces into the set of key ranges after performing the set of logical operations.
