Chapter 15 DBMS-Specific Features
A join index has the following properties:
| Property | Description |
|---|---|
| Name | The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users. |
| Code | The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces. |
| Stereotype | Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined. |
| Comment | Descriptive label for the join index. |
| Base table | Name of the table that stores the join index. |
You can define a join index:
A fact corresponds to the focus of a decision support investigation. For example, Sales, Revenue, and Budget are facts. A table containing facts is set as a fact table in the table property sheet.
A dimension defines the axis of the investigation of a fact. For example, Product, Region, and Time are the axes of investigation of the Sales fact. A table containing dimensions is linked to a fact table and is set as a dimension table in the table property sheet.
For more information about setting table properties, see chapter Building Physical Diagrams.
| Copyright (C) 2006. Sybase Inc. All rights reserved. |
| |