Contents

List of Figures

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions
• Third-Party License Information

1 Data Modeler Concepts and Usage

• 1.1 Installing and Getting Started with SQL Developer Data Modeler
• 1.2 Data Modeler User Interface
  • 1.2.1 Menus for Data Modeler
  • 1.2.2 Context Menus
• 1.3 Working with SQL Developer Data Modeler
  • 1.3.1 Database Design
  • 1.3.2 Data Types Model
    • 1.3.2.1 Data Types Diagram and Subviews
    • 1.3.2.2 Distinct Types
    • 1.3.2.3 Structured Types
    • 1.3.2.4 Collection Types
    • 1.3.2.5 Logical Types
  • 1.3.3 Process Model
    • 1.3.3.1 Data Flow Diagrams
    • 1.3.3.2 Transformation Packages
  • 1.3.4 Logical Model
    • 1.3.4.1 Logical Diagram and Subviews
    • 1.3.4.2 Entities
    • 1.3.4.3 Attributes
    • 1.3.4.4 Unique Identifiers (UIDs)
    • 1.3.4.5 Inheritances
    • 1.3.4.6 Relations
    • 1.3.4.7 Arcs
    • 1.3.4.8 Type Substitution
    • 1.3.4.9 Views
  • 1.3.5 Relational Models
    • 1.3.5.1 Relational Diagram and Subviews
    • 1.3.5.2 Tables
    • 1.3.5.3 Columns
    • 1.3.5.4 Indexes
    • 1.3.5.5 Relations
    • 1.3.5.6 Relational Views
  • 1.3.6 Physical Models
    • 1.3.6.1 Clusters
    • 1.3.6.2 Contexts
    • 1.3.6.3 Dimensions
    • 1.3.6.4 Directories
    • 1.3.6.5 Disk Groups
    • 1.3.6.6 External Tables
    • 1.3.6.7 Indexes
    • 1.3.6.8 Roles
    • 1.3.6.9 Rollback Segments
    • 1.3.6.10 Segments (Segment Templates)
    • 1.3.6.11 Sequences
    • 1.3.6.12 Snapshots
    • 1.3.6.13 Stored Procedures
    • 1.3.6.14 Synonyms
    • 1.3.6.15 Structured Types
    • 1.3.6.16 Tables
    • 1.3.6.17 Tablespaces
    • 1.3.6.18 Users
    • 1.3.6.19 Views
  • 1.3.7 Business Information
    • 1.3.7.1 Contacts
    • 1.3.7.2 Documents
    • 1.3.7.3 Emails
    • 1.3.7.4 Locations
    • 1.3.7.5 Resource Locators
    • 1.3.7.6 Responsible Parties
    • 1.3.7.7 Telephones
• 1.4 Approaches to Data Modeling
  • 1.4.1 Top-Down Modeling
  • 1.4.2 Bottom-Up Modeling
  • 1.4.3 Targeted Modeling
• 1.5 Data Modeler Options (User Preferences)
  • 1.5.1 General
  • 1.5.2 Model
  • 1.5.3 Diagram
  • 1.5.4 Naming Standard
  • 1.5.5 DDL
  • 1.5.6 Third Party JDBC Drivers
• 1.6 Saving, Opening, Exporting, and Importing Designs
  • 1.6.1 Importing a DDL File
  • 1.6.2 Importing Cube Views Metadata
  • 1.6.3 Importing from Microsoft XMLA
  • 1.6.4 Importing an ERwin File
  • 1.6.5 Importing from a Data Dictionary
  • 1.6.6 Importing an Oracle Designer Model
  • 1.6.7 Importing a SQL Developer Data Modeler Design
  • 1.6.8 Importing a Domain
• 1.7 Data Modeler Reports
  • 1.7.1 Design Content reports
  • 1.7.2 Design Rules reports
• 1.8 Read-Only Data Modeler Viewer
• 1.9 Additional Resources for Data Modeling

2 Tutorial: Data Modeling for a Small Database

• 2.1 Develop the Logical Model
  • 2.1.1 Adding Domains
  • 2.1.2 Creating the Books Entity
  • 2.1.3 Creating the Patrons Entity
  • 2.1.4 Creating the Transactions Entity
  • 2.1.5 Creating Relations Between Entities
• 2.2 Develop the Relational Model
• 2.3 Generate DDL
• 2.4 Save the Design

3 Dialog Boxes for Data Modeler

• 3.1 Add Event
• 3.2 Arc Properties
• 3.3 Attribute Properties
• 3.4 Change Object Names Prefix
• 3.5 Change Request Properties
• 3.6 Collection Type Properties
• 3.7 Column Properties
• 3.8 Common Information in Dialog Boxes
• 3.9 Compare Mapping
• 3.10 Compare Modeling Designs
• 3.11 Compare Models
• 3.12 Contact Properties
• 3.13 Cube Properties
• 3.14 Data Dictionary Import (Metadata Extraction)
• 3.15 Database Connection Editor
• 3.16 DDL File Editor
• 3.17 DDL Generation Options
• 3.18 Design Properties
• 3.19 Design Rules
• 3.20 Dimension Properties
• 3.21 Display Properties
• 3.22 Distinct Type Properties
• 3.23 Document Properties
• 3.24 Domain Properties (Domains Model)
• 3.25 Domains Administration
• 3.26 Email Properties
• 3.27 Engineering
• 3.28 Entity Properties
• 3.29 Event Properties
• 3.30 Export Cube Views Metadata
• 3.31 Export to Microsoft XMLA
• 3.32 Export to Oracle Analytic Workspaces
• 3.33 Export to Reporting Schema
• 3.34 External Agent Properties
• 3.35 External Data Properties
• 3.36 Find Object
• 3.37 Flow Properties
• 3.38 Foreign Key Properties
• 3.39 Glossary Editor
• 3.40 Hierarchy Properties
• 3.41 Import Domains
• 3.42 Import Glossary (Naming Standard Definitions)
• 3.43 Import Mapped Models from VAR Files
• 3.44 Import Oracle Designer Model
• 3.45 Import SQL Developer Data Modeler Design
• 3.46 Import SQL Developer Database Connections
• 3.47 Import VAR File: Select Type of Import
• 3.48 Index Properties
• 3.49 Information Store Properties
• 3.50 Information Structure Properties
• 3.51 Join Properties
• 3.52 Unique Identifier (UID, or Key) Properties
• 3.53 Level Properties
• 3.54 Location Properties
• 3.55 Logical Type
• 3.56 Measure Folder Properties
• 3.57 Measure Properties
• 3.58 Measurement Properties
• 3.59 Method Properties
• 3.60 Model Properties - Business Information
• 3.61 Model Properties - <data-flow-diagram-name>
• 3.62 Model Properties - Data Types
• 3.63 Model Properties - Logical
• 3.64 Model Properties - <multidimensional-model-name>
• 3.65 Model Properties - Process Model
• 3.66 Model Properties - <name> (Relational)
• 3.67 Name Abbreviations
• 3.68 New/Update Database Connection
• 3.69 Process Properties
• 3.70 RDBMS Site Editor
• 3.71 Record Structure Properties
• 3.72 Relation Properties
• 3.73 Relational Models
• 3.74 Resource Locator Properties
• 3.75 Responsible Party Properties
• 3.76 Role Properties
• 3.77 Rollup Link Properties
• 3.78 SELECT DDL Files
• 3.79 Set Classification Types
• 3.80 Set Data Type
• 3.81 Slice Properties
• 3.82 Spatial Definition Properties
• 3.83 SQL Access to Oracle AW Properties
• 3.84 Structured Attribute Properties
• 3.85 Structured Type Properties
• 3.86 Subview Properties
• 3.87 Table Properties
• 3.88 Table to View
• 3.89 Telephone Properties
• 3.90 Transformation Package
• 3.91 Transformation <task-name>
• 3.92 Transformation Properties
• 3.93 Transformation Flow Properties
• 3.94 Types Administration
• 3.95 View Properties

Index