Non-recursive method for parameter evaluation within an informat

Details Non-recursive method for parameter evaluation within an informat Non-recursive method for parameter evaluation within an informat

1996-12-23

1998-12-22

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 707100, 707101, G06F 1730

Patent

active

058528180

ABSTRACT:
A method for non-recursive data driven parameter evaluation within an information management system (e.g., a relational database management system, RDBMS). Parameters are attributes within an RDBMS system whose value can be modified to influence the manner in which a database environment responds. Depending on the character of the data within a database environment or the hardware resources allocated to the database, the parameter values have a large influence on the performance efficiency of the database. For instance, a parameter value may influence the memory size of certain data storage areas within a database environment and, if set too small, can cause an inefficiently large amount of input/output accesses to occur as data is moved in and out of disk storage. Also, many parameters are data dependent on other parameters. The novel system presents an automated system for evaluating parameters using a non-recursive evaluation process. By using a non-recursive approach, the evaluation process is streamlined in that only one pass yields an optimum parameter evaluation and the results are reproducible. The novel system identifies a set of parameters within an environment to be tuned, eliminates cyclic dependencies, and orders the parameters based on independence, levels of dependence, impact on system performance and common data usage. The present invention is data driven because rules within a respective parameter are then evaluated based on data availability to arrive at a set of parameter value recommendations. In one embodiment instance, tablespace, system environment, and schema parameters can be evaluated within a RDBMS tuning session.

REFERENCES:
patent: 5202981 (1993-04-01), Shackelford
patent: 5446891 (1995-08-01), Kaplan et al.
patent: 5471629 (1995-11-01), Risch
patent: 5546570 (1996-08-01), McPherson, Jr. et al.
patent: 5566333 (1996-10-01), Olson et al.
patent: 5581482 (1996-12-01), Wiedenman et al.
patent: 5627760 (1997-05-01), Slutsker et al.
patent: 5659727 (1997-08-01), Velissaropoulos et al.
patent: 5659742 (1997-08-01), Beattie et al.
patent: 5664106 (1997-09-01), Caccavale
patent: 5675788 (1997-10-01), Husick et al.
patent: 5708590 (1998-01-01), Slutsker et al.
patent: 5732240 (1998-03-01), Caccavale

Affiliated with

Also associated with

Rating

Non-recursive method for parameter evaluation within an informat does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Non-recursive method for parameter evaluation within an informat, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Non-recursive method for parameter evaluation within an informat will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2056132