Browse Prior Art Database

EXPLOITATION OF DB2 UNIVERSAL DATABASE DESIGN RULES IN GRAPHICAL REPRESENTATIONS

IP.com Disclosure Number: IPCOM000013954D
Original Publication Date: 2000-Nov-01
Included in the Prior Art Database: 2003-Jun-19
Document File: 3 page(s) / 77K

Publishing Venue

IBM

Abstract

Relational and physical database design is driven by a database designer's heuristic knowledge of database design. The present invention utilizes a set of DB2 designer rules derived for DB2 Universal Database (UDB) Parallel Edition and DB2 UDB physical database objects. These rules are useful to designers in the performance of various tasks in physical design, such as the creation of indexes to optimize the access path for minimal costs; the assignment of tables to appropriate tablespaces; or in the parallel database environment, table collocation, which will occur if two large sized tables are involved in frequent joins. Each design advice action is connected to a set of heuristic rules. Through the graphical representation of DB2 UDB design rules users can access the set of rules and tailor the set or individual rules to meet the need of their database applications. Examples of rule sets include activate rules, deactivate rules and modify rules. A set of heuristic rules takes the provided data load and workload values when it generates a design proposal. If no information is available, the heuristic rule set will use predefined default values with its rules. The following figure shows Creation of Index Rules using graphical representations. 1 The advice generated using the rule set is given in the form of a report that lists the design steps to consider. When design proposals are requested, one can either accept or reject a design proposals. The following two figures show proposed actions and a proposed report for a table object using graphical representations:

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 77% of the total text.

Page 1 of 3

  EXPLOITATION OF DB2 UNIVERSAL DATABASE DESIGN RULES IN GRAPHICAL REPRESENTATIONS

Relational and physical database design is driven by a database designer's heuristic knowledge of database design. The present invention utilizes a set of DB2 designer rules derived for DB2 Universal Database (UDB) Parallel Edition and DB2 UDB physical database objects. These rules are useful to designers in the performance of various tasks in physical design, such as the creation of indexes to optimize the access path for minimal costs; the assignment of tables to appropriate tablespaces; or in the parallel database environment, table collocation, which will occur if two large sized tables are involved in frequent joins.

Each design advice action is connected to a set of heuristic rules. Through the graphical representation of DB2 UDB design rules users can access the set of rules and tailor the set or individual rules to meet the need of their database applications. Examples of rule sets include activate rules, deactivate rules and modify rules. A set of heuristic rules takes the provided data load and workload values when it generates a design proposal. If no information is available, the heuristic rule set will use predefined default values with its rules. The following figure shows Creation of Index Rules using graphical representations.

1

Page 2 of 3

---------------------------------------------------------------------------------------------------------------------------------...