CONTENTS Title Page Copyright Page Preface 1 Introduction to the Schema Editor 1.1 Introduction 1.2 Use of the Schema Editor 1.3 Invoking the Schema Editor 1.4 Main Windows 1.4.1 Directory Window 1.4.2 Schema Editor Window 1.5 Schema Editor Directory Structure 1.6 Creating a Sample Database Design 1.7 Integration with RdbExpert 2 Getting Started with the Schema Editor 2.1 Starting a Schema Editor Session 2.2 Invoking the Schema Editor Window 2.3 Common Methods of Using the Schema Editor 2.3.1 Creating a New Logical Schema 2.3.2 Modifying an Existing Physical Schema 2.4 Ending a Schema Editor Session 2.5 Getting Help 2.6 Handling the Schema Editor Errors 2.7 Suggestions and Recommendations 2.7.1 Using the Schema Editor with Multiple Designers 2.7.2 Maintaining Main Design Directory Databases 2.7.3 Improving Performance on Schema Import Operations 3 Design Directory Operations 3.1 Introduction 3.2 Directory Window File Menu 3.2.1 Opening a Main Design Directory 3.2.2 Creating Design Directories 3.2.3 Deleting a Main Design Directory 3.2.4 Printing the Output Design Elements 3.3 Directory Window Design Menu 3.3.1 Creating a Conceptual Design Directory 3.3.2 Creating a Logical Design Directory 3.3.2.1 Creating a Logical Schema 3.3.2.2 Importing the Logical Schema 3.3.3 Creating a Physical Design Directory 3.3.4 Examining Directory Elements 3.3.5 Copying Design Directories 3.3.6 Editing Design Directories 3.3.7 Deleting Design Directories and Design Elements 3.4 Directory Window Generate Menu 3.4.1 Generating the Redesign Procedure 3.4.2 Redesign Command Procedure 3.4.3 The Effect of Sorted Indexes on Table Placement 3.5 Directory Window Report Menu 3.5.1 Creating the Physical Schema Report 3.5.2 Physical Schema Report Description 3.5.2.1 Overview Interpretation 3.5.2.2 Area Summary Interpretation 3.5.2.3 Area Mappings Interpretation 3.6 Directory Window View Menu 3.6.1 Viewing the Design Hierarchy 3.6.1.1 Viewing More Information 3.6.1.2 Viewing Less Information 3.6.1.3 Faster Methods 4 Schema Editor Operations 4.1 Schema Editor Window 4.1.1 Using the Schema Editor Window 4.1.2 Using the Mouse Buttons in the Schema Editor 4.1.2.1 Using MB1 and the Shift Key for Extended Selection 4.1.2.2 Using MB1 and the Ctrl Key for Extended Selection 4.1.3 Using the Expanded Schema Editor Window 4.2 File Menu 4.3 Edit Menu 4.4 Tools Menu 4.5 Browser Menu 4.5.1 Using the Locate Table Option 4.5.2 Using the Where Referenced Option 4.5.3 Using the Navigate . . . Option 4.5.3.1 Using the Navigation Window 4.6 Schema Menu 4.6.1 Using the Select and Create Submenus 4.6.1.1 Using the Select <element> Dialog Box 4.6.1.2 Editing or Creating a Column 4.6.1.3 Create Column Dialog Box 4.6.1.4 Editing or Creating a Collating Sequence 4.6.1.5 Editing or Creating a Constraint 4.6.1.6 Editing or Creating a Domain 4.6.1.7 Editing or Creating Grants 4.6.1.8 Editing or Creating an Index 4.6.1.9 Editing a Schema 4.6.1.10 Editing or Creating a Storage Area 4.6.1.11 Editing or Creating a Table Storage Map 4.6.1.11.1 Edit Table Storage Map, Store In 4.6.1.11.2 Edit Table Storage Map, Store Across 4.6.1.11.3 Edit Table Storage Map, Store Using 4.6.1.12 Editing or Creating a List Storage Map 4.6.1.13 Editing or Creating a Table 4.6.1.14 Editing or Creating a Trigger 4.6.1.15 Editing or Creating a View 4.6.2 Constraints 4.6.3 Create Constraint Dialog Box 4.6.3.1 Using Foreign Key Constraint Links 4.7 Delete Submenu of the Schema Menu A Schema Editor Command-Line Statements A.1 Invoking the Schema Editor for Command-Line Use A.2 Schema Editor Command-Line Statements-A Summary A.3 Schema Editor Statements command_notes @ (Execute Procedure) Statement CLEAR Statement CLOSE DIRECTORY Statement COPY Statement CREATE Statement DCL Statement DEFINE KEY Statement DELETE Statement DIRECTORY Statement ECHO Statement EDIT Statement EXIT Statement EXPORT Statement HELP Statement IMPORT Statement Init-file MOVE Statement ON Statement OPEN Statement Path-names REPORT Statement RESERVE Statement SET Statement SHOW Statement SPAWN Statement UNRESERVE Statement B Keys for Window and Dialog Box Operations B.1 Using Keys for Menu Navigation B.1.1 Activating the Menu Bar for Keyboard Use B.1.2 Navigating Across the Menu Bar by Using the Keyboard B.1.3 Selecting Menu Choices by Using the Keyboard B.1.4 Leaving Menu Selection by Keyboard B.2 Working with Schema Editor Windows B.2.1 Selecting Entries B.2.2 Moving Between Cells B.2.3 Other Operations B.3 Working with Dialog Boxes B.4 Working with Text Fields B.4.1 Editing Fields B.4.2 Selecting Fields B.4.3 Other Field Operations C Logical Names Used by the Schema Editor Schema Editor Glossary EXAMPLES 1-1 Directory Structure 3-1 Physical Schema Report FIGURES 1-1 Directory Window 1-2 Schema Editor Window 2-1 Directory Window 2-2 Schema Editor Window 2-3 Save All Open Design Elements 2-4 Help Window with Schema Editor Window Description 3-1 Directory Window File Menu 3-2 Opening a Main Design Directory 3-3 Creating a Main Design Directory 3-4 Deleting a Main Design Directory 3-5 Print Dialog Box 3-6 Directory Window Design-Create Menu 3-7 Design Menu for Creating a Conceptual Design 3-8 Creating a Conceptual Design Directory 3-9 Design Menu for Creating a Logical Design 3-10 Creating a Logical Design Directory 3-11 Importing the Logical Schema 3-12 Design Menu for Creating a Logical Schema 3-13 Creating a Logical Schema 3-14 Design Menu for Importing a Logical Schema 3-15 Importing a Logical Schema 3-16 Design Menu for Creating a Physical Design 3-17 Creating a Physical Design Directory 3-18 Examining Elements in the Directory Window 3-19 Copying a Conceptual Design Directory 3-20 Editing a Physical Design Directory 3-21 Deleting Design Directories or Elements 3-22 Directory Window Generate Menu 3-23 Output Design Procedure Execution 3-24 Directory Window Report Menu 3-25 Creating the Physical Schema Report 3-26 Directory Window View Menu 3-27 Directory Window with the Directory Structure Partially Expanded 3-28 Directory Window with the Directory Structure Expanded 4-1 Schema Editor Window 4-2 Expanded Main Window of the Schema Editor 4-3 FiLE MENU 4-4 Edit Menu 4-5 Tools Menu 4-6 Browser Menu 4-7 Navigation Window 4-8 Schema Menu 4-9 Select Submenu of the Schema Menu 4-10 Create Submenu of the Schema Menu 4-11 Select Column Dialog Box 4-12 Edit Column Dialog Box Showing Comments, Constraints, and Sql-Dtr Dialog Boxes 4-13 Create Column Dialog Box 4-14 Edit Collating Sequence Dialog Box 4-15 Edit Foreign Key (Column) Constraint Dialog Box 4-16 Edit Table Constraint Dialog Boxes 4-17 Edit Domain Dialog Boxes 4-18 Grants Dialog Box 4-19 Create/Edit Index Dialog Box 4-20 Index Store Clause Dialog Box 4-21 Edit Database Schema Dialog Box 4-22 Storage Area Dialog Box 4-23 Create/Edit Storage Map, Table-In Dialog Box 4-24 Store Lists Storage Map Dialog Box 4-25 Edit Table Dialog Box 4-26 Create/Edit Trigger Dialog Box 4-27 Edit/Create View Dialog Box 4-28 Edit/Create Primary Key (Table) Constraint Dialog Box 4-29 Edit/Create Primary Key (Column) Constraint Dialog Box 4-30 Delete Submenu of the Schema Menu TABLES 3-1 Directory Window File Menu Choices 3-2 Directory Window Design (Create and Import) Menu Choices 3-3 Directory Window Generate Menu Choices 3-4 Directory Window Report Menu Choices 3-5 Physical Schema Overview Description 3-6 Directory Window View Menu Choices 4-1 File Menu Options 4-2 Edit Menu Options 4-3 Tools Menu Options 4-4 Browser Menu Options 4-5 Schema Menu Options 4-6 Select and Create Submenu Options 4-7 Select Column Dialog Box Options 4-8 Fields in the Edit Column Dialog Box 4-9 Edit Column Supplementary Dialog Boxes 4-10 Rootfile Parameters 4-11 Edit Table Dialog Box Options A-1 Summary of Schema Editor Statements B-1 Keys for Selecting Entries B-2 Keys for Moving Between Cells B-3 Keys for Working with Dialog Boxes B-4 Keys for Editing Text Fields B-5 Keys for Selecting Fields C-1 Logical Names Used by the Schema Editor