View source for 18151280. KEY RANGE QUERY OPTIMIZATION simplified abstract (Salesforce, Inc.)

=KEY RANGE QUERY OPTIMIZATION=


==Organization Name==

[[:Category:Salesforce, Inc.|Salesforce, Inc.]]


[[Category:Salesforce, Inc.]]

==Inventor(s)==

[[:Category:Kadir Ozdemir of San Jose CA (US)|Kadir Ozdemir of San Jose CA (US)]][[Category:Kadir Ozdemir of San Jose CA (US)]]

[[:Category:Tanuj Khurana of Kirkland WA (US)|Tanuj Khurana of Kirkland WA (US)]][[Category: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.



[[Category:G06F16/2453]]
[[Category:G06F16/242]]
[[Category:CPC_G06F16/24542]]