Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions
• Third-Party License Information
  • Batik Version 1.7
  • Log4j 1.2.9
  • POI 2.5.1
  • RSyntaxTextArea 2.0.3

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 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 Processes and 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 User Preferences for Data Modeler
  • 1.5.1 Environment
  • 1.5.2 Data Modeler
    • 1.5.2.1 DDL
    • 1.5.2.2 Diagram
    • 1.5.2.3 Model
    • 1.5.2.4 Search
    • 1.5.2.5 SQL Formatter
    • 1.5.2.6 Third Party JDBC Drivers
  • 1.5.3 Extensions
  • 1.5.4 Global Ignore List
  • 1.5.5 Mouse Actions
  • 1.5.6 Shortcut Keys (Accelerator Keys)
  • 1.5.7 SSH (Secure Shell)
  • 1.5.8 Usage Reporting
  • 1.5.9 Versioning
  • 1.5.10 Web Browser and Proxy
• 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 Data Modeler Design
  • 1.6.8 Importing a Domain
• 1.7 Exporting and Importing Preferences and Other Settings
  • 1.7.1 Restoring the Original Data Modeler Preferences
• 1.8 Data Modeler Reports
  • 1.8.1 Generating Reports as RTF, HTML, or PDF Files
  • 1.8.2 Using the Reporting Repository and Reporting Schema
  • 1.8.3 Using SQL Developer to View Exported Reporting Schema Data
    • 1.8.3.1 Design Content reports
    • 1.8.3.2 Design Rules reports
• 1.9 Using Versioning
  • 1.9.1 About Subversion and Data Modeler
    • 1.9.1.1 Pending Changes
  • 1.9.2 Basic Workflow: Using Subversion with a Design
• 1.10 Data Modeler Accessibility Information
• 1.11 For More Information About Data Modeling
• 1.12 Third-Party License Information
  • 1.12.1 Batik Version 1.7

2 Data Modeler Tutorial: 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 Data Modeler Dialog Boxes

• 3.1 Add Event
• 3.2 Add/Remove Objects
• 3.3 Advanced Properties (Connections)
• 3.4 Arc Properties
• 3.5 Attribute Properties
• 3.6 Change Subview Object Names Prefix
• 3.7 Change Request Properties
• 3.8 Check for Updates
• 3.9 Choose Directory
• 3.10 Collection Type Properties
• 3.11 Column Properties
• 3.12 Common Information in Dialog Boxes
• 3.13 Compare Mapping
• 3.14 Compare Modeling Designs
• 3.15 Compare Models
• 3.16 Color Palette and Custom Colors
• 3.17 Configure Extension
• 3.18 Connection Information
• 3.19 Contact Properties
• 3.20 Create Database Connection
• 3.21 Create Discovered Foreign Keys
• 3.22 Cube Properties
• 3.23 Custom Reports Template
• 3.24 Data Dictionary Import (Metadata Extraction)
• 3.25 Database Connection Editor
• 3.26 DDL File Editor
• 3.27 DDL Generation Options
• 3.28 Design Properties
• 3.29 Design Rules
  • 3.29.1 Design Rules
  • 3.29.2 Custom Rules
  • 3.29.3 Libraries
  • 3.29.4 Transformations
• 3.30 Dimension Properties
• 3.31 Display Properties
• 3.32 Distinct Type Properties
• 3.33 Document Properties
• 3.34 Domain Properties (Domains Model)
• 3.35 Domains Administration
• 3.36 Email Properties
• 3.37 Engineering
• 3.38 Entity Properties
• 3.39 Event Properties
• 3.40 Export Cube Views Metadata
• 3.41 Export to Microsoft XMLA
• 3.42 Export to Oracle Analytic Workspaces
• 3.43 Export to Reporting Schema
• 3.44 Export Wizard
• 3.45 Export/Import Connections
  • 3.45.1 Export Connections
  • 3.45.2 Import Connections
• 3.46 External Agent Properties
• 3.47 External Data Properties
• 3.48 File Processing
• 3.49 Find Object (Search)
• 3.50 Flow Properties
• 3.51 Foreign Key Properties
• 3.52 Glossary Editor
• 3.53 Hierarchy Properties
• 3.54 Import Domains
• 3.55 Import Glossary (Naming Standard Definitions)
• 3.56 Import Mapped Models from VAR Files
• 3.57 Import Oracle Designer Model
• 3.58 Import Data Modeler Design
• 3.59 Import Database Connections
• 3.60 Import VAR File: Select Type of Import
• 3.61 Index, Primary Key, or Unique Key Properties
• 3.62 Information Store Properties
• 3.63 Information Structure Properties
• 3.64 Inheritance Relation Properties - <hierarchy-name>
• 3.65 Join Properties
• 3.66 Level Properties
• 3.67 Location Properties
• 3.68 Manage Features and Updates
• 3.69 Logical Type
• 3.70 Mask Templates Administration
• 3.71 Measure Folder Properties
• 3.72 Measure Properties
• 3.73 Measurement Properties
• 3.74 Method Properties
• 3.75 Model Properties - Business Information
• 3.76 Model Properties - <data-flow-diagram-name>
• 3.77 Model Properties - Data Types
• 3.78 Model Properties - Logical
• 3.79 Model Properties - <multidimensional-model-name>
• 3.80 Model Properties - Process Model
• 3.81 Model Properties - <name> (Relational)
• 3.82 Name Abbreviations
• 3.83 New/Edit SSH Connection
• 3.84 New/Update Database Connection
• 3.85 Object Names Administration
• 3.86 Process Properties
• 3.87 RDBMS Site Editor
• 3.88 Record Structure Properties
• 3.89 Relation Properties
• 3.90 Relational Models
• 3.91 Report Templates Management
• 3.92 Resource Locator Properties
• 3.93 Responsible Party Properties
• 3.94 Revision Lister
• 3.95 Role Properties
• 3.96 Rollup Link Properties
• 3.97 Rule Set Properties
• 3.98 Search Profile
• 3.99 Schema Properties
• 3.100 SELECT DDL Files
• 3.101 Select File
• 3.102 Select Models/Subviews to Export
• 3.103 Sensitive Type Properties
• 3.104 Set Classification Types
• 3.105 Set Common Properties
• 3.106 Set Data Type
• 3.107 Show/Hide Elements
• 3.108 Slice Properties
• 3.109 Spatial Definition Properties
• 3.110 SQL Access to Oracle AW Properties
• 3.111 Standard Reports Configurations
• 3.112 Structured Attribute Properties
• 3.113 Structured Type Properties
• 3.114 Subversion: Add Property
• 3.115 Subversion: Add to Source Control
• 3.116 Subversion: Apply Patch
• 3.117 Subversion: Branch/Tag
• 3.118 Subversion: Check Out from Subversion
• 3.119 Subversion: Commit Resources
• 3.120 Subversion: Commit Working Copy
• 3.121 Subversion: Confirm Checkout
• 3.122 Subversion: Create Remote Directory
• 3.123 Subversion: Create Subversion Repository
• 3.124 Subversion: Create/Edit Subversion Connection
• 3.125 Subversion: Delete Resources
• 3.126 Subversion: Edit Configuration File
• 3.127 Subversion: Export Files
• 3.128 Subversion: Export Subversion Connections
• 3.129 Subversion: History
• 3.130 Subversion: Ignore
• 3.131 Subversion: Import Subversion Connections
• 3.132 Subversion: Import to Subversion
• 3.133 Subversion: Lock Resources
• 3.134 Subversion: Merge
• 3.135 Subversion: Pending Changes
• 3.136 Subversion: Properties
• 3.137 Subversion: Remove from Subversion
• 3.138 Subversion: Repository Browser
• 3.139 Subversion: Revert Local Changes
• 3.140 Subversion: Switch
• 3.141 Subversion: Unlock Resources
• 3.142 Subversion: Update Resources
• 3.143 Subversion: Update Working Copy
• 3.144 Subversion: Versioning Properties
• 3.145 Subversion: XML Metadata Comparator
• 3.146 Subview Properties
• 3.147 Table Properties
• 3.148 Table to View
• 3.149 Table DDL Transformation Scripts
• 3.150 Telephone Properties
• 3.151 Transformation Package
• 3.152 Transformation <task-name>
• 3.153 Transformation Properties
• 3.154 Transformation Flow Properties
• 3.155 TSDP Policy Properties
• 3.156 Types Administration
• 3.157 Types to Domains
• 3.158 Unable to Connect
• 3.159 Unique Identifier (UID, or Key) Properties
• 3.160 View Properties (Logical Model)
• 3.161 View Properties (Relational Model)
• 3.162 View to Table
• 3.163 Windows

Index