18374852. OPTIMIZE WORKLOAD PERFORMANCE BY AUTOMATICALLY DISCOVERING AND IMPLEMENTING IN-MEMORY PERFORMANCE FEATURES simplified abstract (Oracle International Corporation)

OPTIMIZE WORKLOAD PERFORMANCE BY AUTOMATICALLY DISCOVERING AND IMPLEMENTING IN-MEMORY PERFORMANCE FEATURES

Organization Name

Oracle International Corporation

Inventor(s)

Nirav Vyas of Bangalore (IN)

Hariharan Lakshmanan of Brisbane CA (US)

Shasank Kisan Chavan of Menlo Park CA (US)

Gary Smith of Auburn CA (US)

OPTIMIZE WORKLOAD PERFORMANCE BY AUTOMATICALLY DISCOVERING AND IMPLEMENTING IN-MEMORY PERFORMANCE FEATURES - A simplified explanation of the abstract

This abstract first appeared for US patent application 18374852 titled 'OPTIMIZE WORKLOAD PERFORMANCE BY AUTOMATICALLY DISCOVERING AND IMPLEMENTING IN-MEMORY PERFORMANCE FEATURES

Simplified Explanation

The patent application describes techniques for optimizing workload performance by automatically discovering and implementing performance optimizations for in-memory units (IMUs) in a database system.

• The system maintains a set of IMUs for processing database operations.
• It obtains database workload information and filters it to identify operations that may benefit from optimizations.
• The system analyzes the operations, ranks potential optimizations, and generates new versions of IMUs reflecting the optimizations.
• Verification tests are performed on the new IMUs to determine performance benefits.
• IMUs are categorized into sets to be retained or discarded, with the retained set made available to the workload.

Potential Applications

The technology can be applied in various database systems to improve performance and efficiency of database operations.

Problems Solved

- Manual optimization of database operations can be time-consuming and error-prone. - Identifying and implementing performance optimizations can be challenging without automated tools.

Benefits

- Improved performance of database operations. - Increased efficiency in workload processing. - Reduction in manual effort for optimization tasks.

Potential Commercial Applications

Optimizing database performance in e-commerce platforms, financial institutions, healthcare systems, and other industries can lead to enhanced user experience and cost savings.

Possible Prior Art

One possible prior art could be the use of query optimization techniques in database management systems to improve performance.

What are the specific performance optimizations implemented by the system?

The specific performance optimizations implemented by the system are identified by analyzing database operations and ranking them based on their potential benefit. The system then selects a subset of these optimizations to be applied to the IMUs, generating new versions that reflect the optimizations.

How does the system determine which IMUs to retain and which to discard?

The system categorizes the new set of IMUs into a first set to be retained and a second set to be discarded based on the results of verification tests. If the new versions of IMUs yield expected performance benefits, they are retained and made available to the current workload. Otherwise, they are discarded.

Original Abstract Submitted

Techniques are provided for optimizing workload performance by automatically discovering and implementing performance optimizations for in-memory units (IMUs). A system maintains a set of IMUs for processing database operations in a database. The system obtains a database workload information for the database system and filters the database workload information to identify database operations in the database workload information that may benefit from performance optimizations. The system analyzes the database operations to identify a set of performance optimizations and ranks the performance optimizations based on their potential benefit. The system selects a subset of the performance optimizations, based on their ranking, and generates new versions of IMUs that reflect the performance optimizations. The system performs verification tests on the new versions of IMUs and analyzes the tests to determine whether the new versions of IMUs yield expected performance benefits. The system then categorizes the new set of IMUs into a first set of IMUs to be retained and a second set of IMUs to be discarded. The system then makes the first set of IMUs available to the current workload and discards the second set of IMUs.