Browse Prior Art Database

Method and System for Managing Saving and Analysis of Queries Run Against a Database Object in a Database Management System

IP.com Disclosure Number: IPCOM000236267D
Publication Date: 2014-Apr-16
Document File: 4 page(s) / 50K

Publishing Venue

The IP.com Prior Art Database

Abstract

A method and system is disclosed for managing saving and analysis of queries run against a database object in a database management system (DBMS).

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 51% of the total text.

Page 01 of 4

Method and System for Managing Saving and Analysis of Queries Run Against a Database Object in a Database Management System

Disclosed is a method and system for managing saving and analysis of queries run against a database object in a database management system (DBMS). The method and system enables a database advisor to save queries run against a database object in the DBMS. The method and system also provides analytics to improve the queries that run long, run frequently or trend up in run time. The method and system enables defining system configurations to choose the queries to be saved. In addition, system configurations can be defined that enable the analytics to determine the queries to be analyzed based on one or more of frequency of a query, amount of time the query runs and run time increases that the query shows over a configurable length of time.

In one implementation, the method and system is an expansion to the DBMS, wherein the DBMS stores queries run against database objects. This enables the method and system to recommend tuning based on facts of knowing how long existing queries are running and the frequency of the queries when deciding if a change to the database characteristics is logical in deciding the cost/benefit of the change. By providing the ability to look at a spectrum of queries, the database advisor has the ability to do full analysis of the problem.

Running of the database advisor is scheduled inside the DBMS based on further configurations to the system catalog. If the database advisor finds recommended changes, warning messages are issued by the DBMS for future investigation. The database advisor reviews characteristics of the database object when the query is provided as input to the database advisor. The output of the database advisor includes recommended changes to the object such as, but not limited to, creation of additional indices, partitioning, creating summarized tables, and other characteristics that improve performance of the query based on the input.

In one embodiment, the database advisor runs against a full spectrum of queries run against the database objects, wherein the queries are saved in an enriched system catalog of the database. The objects that are c...