Database optimization apparatus and method

Details Database optimization apparatus and method Database optimization apparatus and method

2006-08-08

2006-08-08

Gaffin, Jeffrey (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07089260

ABSTRACT:
A database optimizer collects statistics regarding which types of applications are accessing the database, and makes one or more changes to the database schema to optimize performance according to the collected statistics. In a first embodiment, the optimizer detects when a certain type of application accesses the database a percentage of time that exceeds a predefined threshold level, and if the data in the database is stored in a less-than-optimal format for the application, the data type of one or more columns in the database is changed to a more optimal format for the application. This means that the database optimizer must recognize when a different type of application requests data from any changed column, and must potentially perform a conversion from the new data type to the old data type before returning the requested data. In a second embodiment, the optimizer detects when one type of application accesses a column a percentage of time that exceeds a first predefined threshold level and that accesses the column a percentage of time that is less than a second predefined threshold level. In this case, a new column is created in the database so the data is present in both formats, thereby optimizing the performance of both old and new applications that access the data. The database optimizer looks at what type of application requested data, and returns the data in the format optimized for that type of application.

REFERENCES:
patent: 5226161 (1993-07-01), Khoyi et al.
patent: 6009428 (1999-12-01), Kleewein et al.
patent: 6418451 (2002-07-01), Maimone
patent: 6484185 (2002-11-01), Jain et al.
patent: 6529901 (2003-03-01), Chaudhuri et al.
patent: 6658625 (2003-12-01), Allen
patent: 6678700 (2004-01-01), Moore et al.
patent: 6694325 (2004-02-01), Jas
patent: 6745176 (2004-06-01), Probert et al.
patent: 2003/0033317 (2003-02-01), Ziglin

Affiliated with

Also associated with

Rating

Database optimization apparatus and method does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Database optimization apparatus and method, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database optimization apparatus and method will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3656171