17970200. AUTOMATED CREATION OF OPTIMIZED PERSISTENT DATABASE VIEWS simplified abstract (Dell Products L.P.)
Contents
- 1 AUTOMATED CREATION OF OPTIMIZED PERSISTENT DATABASE VIEWS
- 1.1 Organization Name
- 1.2 Inventor(s)
- 1.3 AUTOMATED CREATION OF OPTIMIZED PERSISTENT DATABASE VIEWS - 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 Unanswered Questions
- 1.10 Original Abstract Submitted
AUTOMATED CREATION OF OPTIMIZED PERSISTENT DATABASE VIEWS
Organization Name
Inventor(s)
Amihai Savir of Newton MA (US)
Ofir Ezrielev of Be'er Sheva (IL)
Oshry Ben Harush of Cedar Park TX (US)
AUTOMATED CREATION OF OPTIMIZED PERSISTENT DATABASE VIEWS - A simplified explanation of the abstract
This abstract first appeared for US patent application 17970200 titled 'AUTOMATED CREATION OF OPTIMIZED PERSISTENT DATABASE VIEWS
Simplified Explanation
The patent application describes a system for automatically optimizing and persisting database views based on telemetry information obtained from queries made to a database. The system generates a set of database maintained views, scores each view based on various factors, and determines which views to make persistent to produce an optimized set of database views.
- Telemetry information obtained for each generated view includes latency, memory space utilization, and processor utilization, among other factors.
- Views are scored based on an base score modified by the obtained information to determine which views to make persistent.
- The system adapts later queries to use the optimized persistent views.
Potential Applications
This technology could be applied in various industries where database optimization is crucial, such as e-commerce, healthcare, finance, and more.
Problems Solved
1. Manual optimization of database views can be time-consuming and error-prone. This technology automates the process, saving time and reducing the risk of human error. 2. Maintaining optimal database views can improve overall system performance and efficiency, leading to better user experience and cost savings.
Benefits
1. Improved database performance and efficiency. 2. Automated optimization process saves time and resources. 3. Enhanced user experience through faster query responses.
Potential Commercial Applications
Optimized database views can benefit companies in various sectors, including online retailers, healthcare providers, financial institutions, and more. A section on possible prior art is not provided.
Unanswered Questions
The patent application does not provide details on how the system addresses security and privacy issues when collecting telemetry data from queries.
What is the scalability of the system in handling a large volume of queries and views?
The patent application does not mention the scalability of the system in managing a high volume of queries and views.
Original Abstract Submitted
Embodiments for automatically optimizing and persisting database views by receiving queries made to a database, wherein each query generates a respective database view, and generating a set of database maintained views generated by the queries. The system obtains, for each generated view, certain telemetry information about a respective view including latency, memory space utilization, and processor utilization, among other factors. It then scores each view of the generated views based on an base score modified by the obtained information to determine which one or more of the generated views to make persistent, and maintains the one or more persistent views to produce an optimized persistent set of database views. It further adapts later queries to use the optimized persistent views.
