| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
WarehouseArchitect - User's Guide |
![[-]](/dwicons/i_colpse.gif)
| Part 3 WarehouseArchitect Model |
|
| Chapter 12: Building a WarehouseArchitect Model |
|
| Defining tables |
| Creating a table |
| Table properties |
![[+]](/dwicons/i_expand.gif)
| Modifying table properties |
| Arranging items in a list attached to a table |
| Naming a table constraint |
| Displaying text in table symbols |
|
| Defining domains |
| Creating a domain |
| Domain properties |
| Indicating data type, length, and precision |
| Selecting a data type for a domain |
| Specifying an abstract data type for a domain |
| Selecting a data profile for a domain |
| Displaying columns that use a domain |
| Enforcing domains in a WAM |
| Specifying an abstract data type |
|
| Defining columns |
| Creating a column |
| Column properties |
| Attaching a column to a domain |
| Selecting a data type for a column |
| Selecting an abstract data type for a column |
| Duplicating a column |
| Making a column mandatory or optional |
| Naming a column constraint |
| Configuring the display of the list of columns |
|
| Defining references |
| Reference properties |
| Defining a code option for references |
|
| Creating a reference |
| Sorting the list of references |
| Rebuilding references |
| Rebuilding a selected reference |
| Using referential integrity |
| Referential integrity properties |
| Defining referential integrity |
| Displaying text with reference symbols |
|
| Modifying a reference graphically |
|
| Defining keys |
| Designating a primary key |
| Designating a foreign key |
| Auto-migrating foreign keys |
| Designating an alternate key |
|
| Naming key constraints |
|
| Defining indexes |
| Index properties |
|
| Creating an index |
| Removing a column from an index |
|
| Rebuilding indexes |
|
| Deleting an index |
|
| Defining views |
| Creating a view |
| View properties |
|
| Modifying view properties |
| Selecting tables and references for a view |
| Selecting columns for a view |
| Assigning an alias to a table or a column |
| Inserting clauses in a query |
| Displaying query syntax |
| Editing a query |
| Verifying SQL query syntax |
| Displaying text in view symbols |
|
| Defining extended attributes |
| Extended attribute properties |
| Standard types of extended attributes |
| OLAP extended attributes |
| Creating extended attributes |
| Defining a constant |
| Using a constant as a default value |
| Modifying the value of an extended attribute |
| Importing extended attributes |
| Exporting extended attributes |
| Defining default extended attributes |
| Defining default physical options |
|
|