17541322. PERFORMANCE OF SQL EXECUTION SEQUENCE IN PRODUCTION DATABASE INSTANCE simplified abstract (INTERNATIONAL BUSINESS MACHINES CORPORATION)
Contents
PERFORMANCE OF SQL EXECUTION SEQUENCE IN PRODUCTION DATABASE INSTANCE
Organization Name
INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventor(s)
PERFORMANCE OF SQL EXECUTION SEQUENCE IN PRODUCTION DATABASE INSTANCE - A simplified explanation of the abstract
This abstract first appeared for US patent application 17541322 titled 'PERFORMANCE OF SQL EXECUTION SEQUENCE IN PRODUCTION DATABASE INSTANCE
Simplified Explanation
The patent application describes a method, computer program product, and computer system for improving the performance of a sequence of SQL statements. Here is a simplified explanation of the abstract:
- The method involves recording the sequence of SQL statements in an event log.
- The original results of executing the SQL statements and the original CPU cost are recorded in a logical log.
- An analysis of the event log and the logical log is performed to generate a new access path.
- The SQL statements are then executed according to the new access path, resulting in new results and a new CPU cost.
- If the new results replicate the original results and the new CPU cost is lower than the original CPU cost, the original access path is replaced with the new access path.
Potential applications of this technology:
- Database optimization: This technology can be used to improve the performance of SQL execution sequences in databases, leading to faster query processing and improved overall database performance.
- Performance tuning: It can help identify and optimize inefficient SQL statements, reducing CPU costs and improving the overall efficiency of database operations.
Problems solved by this technology:
- Inefficient SQL execution: By analyzing the event log and logical log, this technology can identify and optimize the access path of SQL statements, addressing performance issues caused by inefficient execution sequences.
- High CPU costs: The method helps reduce the CPU costs associated with executing SQL statements by replacing the original access path with a more efficient one.
Benefits of this technology:
- Improved performance: By optimizing the SQL execution sequence and reducing CPU costs, this technology can significantly improve the performance of database operations.
- Cost savings: The reduced CPU costs can lead to cost savings for organizations that rely heavily on database operations.
- Enhanced user experience: Faster query processing and improved overall database performance can result in a better user experience for applications relying on the database.
Original Abstract Submitted
A method, computer program product, and computer system for improving performance of a SQL execution sequence of SQL statements. The SQL execution sequence is recorded in an event log. Original results of executing the SQL statements and an original CPU cost of executing the SQL statements in accordance with the original access path are recorded in a logical log. A new access path is generated from analysis of the event log and the logical log. The SQL statements are executed in accordance with the new access path resulting in new results of executing the SQL statements including a new CPU cost of executing the SQL statements in accordance with the new access path. In response to a determination that the new results replicate the original results and that the new CPU cost is less than the original CPU cost, the original access path is replaced with the new access path.
