20240054128. AUTOMATIC DATABASE QUERY LOAD ASSESSMENT AND ADAPTIVE HANDLING simplified abstract (Oracle International Corporation)

From WikiPatents
Jump to navigation Jump to search

AUTOMATIC DATABASE QUERY LOAD ASSESSMENT AND ADAPTIVE HANDLING

Organization Name

Oracle International Corporation

Inventor(s)

Stephen P. Sheldon of San Diego CA (US)

AUTOMATIC DATABASE QUERY LOAD ASSESSMENT AND ADAPTIVE HANDLING - A simplified explanation of the abstract

This abstract first appeared for US patent application 20240054128 titled 'AUTOMATIC DATABASE QUERY LOAD ASSESSMENT AND ADAPTIVE HANDLING

Simplified Explanation

The abstract describes a system for managing query loads on a database system by defining and comparing fingerprints of queries to determine their impact on the system.

  • The system defines a fingerprint for each query received for execution on the database system.
  • If a query's fingerprint does not match an existing fingerprint, the system executes the query and sets a classification indicating whether it needs evaluation or is permissible.
  • If a query's fingerprint matches an existing fingerprint, the system evaluates statistics to determine the potential negative impact on the system and modifies the classification accordingly.
  • The system controls the execution of queries based on their fingerprint classification.

Potential Applications

  • Database management systems
  • Query optimization tools
  • Performance monitoring software

Problems Solved

  • Efficient management of query loads
  • Identification of potentially harmful queries
  • Optimization of database performance

Benefits

  • Improved system performance
  • Reduction in system downtime
  • Enhanced query optimization and management


Original Abstract Submitted

systems, methods, and other embodiments associated with managing query loads are described. in one embodiment, a system is configured to define a fingerprint for received queries that are requested for execution on a database system and determine whether the defined fingerprint matches or does not match an existing fingerprint. for queries having a fingerprint that does not match an existing fingerprint: the system executes the query to completion and sets a classification for the fingerprint indicating the query (i) is flagged for evaluation or (ii) is permissible. for queries having a fingerprint that matches an existing fingerprint: determine whether the fingerprint was previously flagged and evaluate statistics for the fingerprint to determine whether execution will cause a negative impact on the system. the classification of the fingerprint is modified accordingly. the system controls execution of the query based on the classification of the fingerprint.

Retrieved from "http://wikipatents.org/index.php?title=20240054128._AUTOMATIC_DATABASE_QUERY_LOAD_ASSESSMENT_AND_ADAPTIVE_HANDLING_simplified_abstract_(Oracle_International_Corporation)&oldid=34137"