Browse Prior Art Database

SYSTEM, METHOD FOR AUTONOMIC INTEGRATED SQL TUNING TOOLS AND ADVISORS

IP.com Disclosure Number: IPCOM000193793D
Publication Date: 2010-Mar-09
Document File: 3 page(s) / 163K

Publishing Venue

The IP.com Prior Art Database

Abstract

System and methodology for autonomic tuning tools and advisors integration and interaction for SQL performance tuning in an RDBMS. We already had theory and methodology to SQL performance by individual tuning tools and design advisors. A DBA or an application developer needs to determine what's the root cause of the problematic SQL by referring to tuning tools or design advisors separately. Actually, we could give them a better view if we combined all the results together. For example, for a particular table's access path, if a relational scan is suspicious by an access path advisor, as well as no statistics detected by statistics advisor. Currently, we don't have such a mechanism to build the connection between them. Patents: Automatic SQL tuning advisor (http://www.google.com/patents?id=RbWWAAAAEBAJ&zoom=4&pg=PA1#v=onepage&q=&f=false) Method, system, and program for performance tuning a database query (http://www.google.com/patents?id=9y59AAAAEBAJ&zoom=4&pg=PA1#v=onepage&q=&f=false) SQL tuning base (http://www.google.com/patents?id=nICWAAAAEBAJ&zoom=4&pg=PA1#v=onepage&q=&f=false)

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 91% of the total text.

Page 1 of 3

SYSTEM

SYSTEMSYSTEM,

,,, METHOD FOR AUTONOMIC INTEGRATED SQL TUNING TOOLS AND ADVISORSMETHOD FOR AUTONOMIC INTEGRATED SQL TUNING TOOLS AND ADVISORSMETHOD FOR AUTONOMIC INTEGRATED SQL TUNING TOOLS AND ADVISORS

METHOD FOR AUTONOMIC INTEGRATED SQL TUNING TOOLS AND ADVISORS

A. The currently work flow and methodology to tuning a SQL performance by using individual tuning tools and design advisors , they will be executed one by one separately , DBA or application developer still needs additional deep skills or extra effort to analyze a SQL performance problem .

B. Actually these design advisors could be integrated for better and higher confident advisors' advice. Tuning tools can be interacted with each other and all the design advisors for better SQL analysis view .

1

[This page contains 38 pictures or other non-text objects]

Page 2 of 3

C. Some foreseeing implementations by this disclosure :

Advisors integration: suppose we have a suspicious table in a problematic SQL , the statistics advisor reports statistics missing in this table , and the access path advisor reports tablespace scan is chosen as table access , at the same time, since we have a stage 2 predicate causes existing indexes can 't be chosen. Actually, we could integrate all the information and tell what might be the root cause and what action to take .

Tuning tools interaction : when a SQL element is selected , all the other components highlight related information at the same time . We won't have separ...