Dell products l.p. (20240134845). AUTOMATED CREATION OF OPTIMIZED PERSISTENT DATABASE VIEWS simplified abstract
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 Possible Prior Art
- 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 20240134845 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 receives queries made to a database, which generate respective database views.
- It generates a set of database maintained views based on the queries.
- Telemetry information about each generated view, including latency, memory space utilization, and processor utilization, is obtained.
- Each view is scored based on an base score modified by the obtained information to determine which views to make persistent.
- The system maintains the persistent views to produce an optimized set of database views.
- Later queries are adapted to use the optimized persistent views.
Potential Applications
This technology could be applied in various industries such as e-commerce, finance, healthcare, and more where databases are used extensively for data analysis and reporting.
Problems Solved
1. Manual optimization of database views can be time-consuming and error-prone. This technology automates the process, saving time and ensuring efficiency. 2. By persisting optimized views, the system reduces the workload on the database server, leading to improved performance and faster query processing.
Benefits
1. Improved database performance and query processing speed. 2. Reduction in manual effort required for database view optimization. 3. Enhanced overall efficiency and resource utilization.
Potential Commercial Applications
Optimized database views can benefit companies in various sectors by improving data analysis capabilities, streamlining operations, and enhancing decision-making processes.
Possible Prior Art
One possible prior art could be the use of query optimization techniques in database management systems to improve query performance and efficiency. Another could be the use of telemetry data for optimizing system performance in various computing environments.
What are the potential scalability challenges of implementing this technology in large-scale databases?
Large-scale databases may pose challenges in terms of processing power and memory utilization when optimizing and persisting a significant number of database views. Ensuring that the system can handle the increased workload efficiently and effectively would be crucial for scalability.
How does this technology compare to existing database optimization tools in terms of performance and effectiveness?
This technology offers automated optimization and persistence of database views based on telemetry information, which may provide more accurate and tailored optimizations compared to generic optimization tools. Evaluating its performance and effectiveness against existing tools would be essential to determine its superiority in real-world scenarios.
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.
