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.

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

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