Table of Contents

• List of Figures
• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Product Accessibility
  • Related Documents
  • Conventions
  • Third-Party License Information
    • ActiveDBSoft
    • Apache FOP 0.95
    • Batik Version 1.8
    • PDFBox 2.0.13
    • Apache POI 3.17
    • RSyntaxTextArea 2.0.3
    • SVNKit 1.0.0
• 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 Reports
      • 1.5.2.5 Search
      • 1.5.2.6 Third Party JDBC Drivers
    • 1.5.3 Format
    • 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 from Microsoft XMLA
    • 1.6.3 Importing an ERwin File
    • 1.6.4 Importing from a Data Dictionary
    • 1.6.5 Importing an Oracle Designer Model
    • 1.6.6 Importing a Data Modeler Design
    • 1.6.7 Importing a Domain
  • 1.7 Exporting and Importing Preferences and Other Settings
    • 1.7.1 Restoring the Original Data Modeler Preferences
  • 1.8 Sharing Diagrams with SQL Developer Web
  • 1.9 Data Modeler Reports
    • 1.9.1 Generating Reports as RTF, HTML, or PDF Files
    • 1.9.2 Using the Reporting Repository and Reporting Schema
    • 1.9.3 Using SQL Developer to View Exported Reporting Schema Data
      • 1.9.3.1 Design Content reports
      • 1.9.3.2 Design Rules reports
  • 1.10 Using Versioning
    • 1.10.1 About Subversion and Data Modeler
      • 1.10.1.1 Pending Changes
    • 1.10.2 Basic Workflow: Using Subversion with a Design
    • 1.10.3 Using Git with Data Modeler
  • 1.11 For More Information About Data Modeling
• 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 Change Requests Administration
  • 3.9 Check for Updates
  • 3.10 Choose Directory
  • 3.11 Collection Type Properties
  • 3.12 Column Properties
  • 3.13 Common Information in Dialog Boxes
  • 3.14 Compare Mapping
  • 3.15 Compare Modeling Designs
  • 3.16 Compare Models
  • 3.17 Color Palette and Custom Colors
  • 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 Connections
  • 3.25 Data Dictionary Import (Metadata Extraction)
  • 3.26 Database Connection Editor
  • 3.27 DDL File Editor
  • 3.28 DDL Generation Options
  • 3.29 Design Properties
  • 3.30 Design Rules
    • 3.30.1 Design Rules
    • 3.30.2 Custom Rules
    • 3.30.3 Libraries
    • 3.30.4 Transformations
  • 3.31 Dimension Properties
  • 3.32 Display Properties
  • 3.33 Distinct Type Properties
  • 3.34 Document Properties
  • 3.35 Domain Properties (Domains Model)
  • 3.36 Domains Administration
  • 3.37 Email Properties
  • 3.38 Engineering
  • 3.39 Entity Properties
  • 3.40 Event Properties
  • 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 Git: Add
  • 3.53 Git: Add All
  • 3.54 Git: Add to .gitignore File
  • 3.55 Git: Branch Compare
  • 3.56 Git: Checkout Revision
  • 3.57 Git: Clone from Git
  • 3.58 Git: Commit
  • 3.59 Git: Commit All
  • 3.60 Git: Create Branch
  • 3.61 Git: Create Tag
  • 3.62 Git: Export Committed Changes
  • 3.63 Git: Export Uncommitted Changes
  • 3.64 Git: Fetch from Git
  • 3.65 Git: Import to Git
  • 3.66 Git: Initialize Repository
  • 3.67 Git: Merge
  • 3.68 Git: Pending Changes
  • 3.69 Git: Pull from Git
  • 3.70 Git: Push to Git
  • 3.71 Git: Rebase
  • 3.72 Git: Reset
  • 3.73 Git: Revert and Revert Commit
  • 3.74 Git: Stash Changes
  • 3.75 Glossary Editor
  • 3.76 Hierarchy Properties
  • 3.77 Import Domains
  • 3.78 Import Glossary (Naming Standard Definitions)
  • 3.79 Import Mapped Models from VAR Files
  • 3.80 Import Oracle Designer Model
  • 3.81 Import Data Modeler Design
  • 3.82 Import Database Connections
  • 3.83 Import VAR File: Select Type of Import
  • 3.84 Index, Primary Key, or Unique Key Properties
  • 3.85 Information Store Properties
  • 3.86 Information Structure Properties
  • 3.87 Inheritance Relation Properties - <hierarchy-name>
  • 3.88 Join Properties
  • 3.89 Level Properties
  • 3.90 Location Properties
  • 3.91 Manage Features and Updates
  • 3.92 Logical Type
  • 3.93 Mask Templates Administration
  • 3.94 Measure Folder Properties
  • 3.95 Measure Properties
  • 3.96 Measurement Properties
  • 3.97 Method Properties
  • 3.98 Model Properties - Business Information
  • 3.99 Model Properties - <data-flow-diagram-name>
  • 3.100 Model Properties - Data Types
  • 3.101 Model Properties - Logical
  • 3.102 Model Properties - <multidimensional-model-name>
  • 3.103 Model Properties - Process Model
  • 3.104 Model Properties - <name> (Relational)
  • 3.105 Name Abbreviations
  • 3.106 New/Edit SSH Connection
  • 3.107 New/Update Database Connection
  • 3.108 Object Names Administration
  • 3.109 Process Properties
  • 3.110 RDBMS Site Editor
  • 3.111 Record Structure Properties
  • 3.112 Relation Properties
  • 3.113 Relational Models
  • 3.114 Report Templates Management
  • 3.115 Resource Locator Properties
  • 3.116 Responsible Party Properties
  • 3.117 Revision Lister
  • 3.118 Role Properties
  • 3.119 Rollup Link Properties
  • 3.120 Rule Set Properties
  • 3.121 Search Profile
  • 3.122 Schema Properties
  • 3.123 SELECT DDL Files
  • 3.124 Select File
  • 3.125 Select Models/Subviews to Export
  • 3.126 Sensitive Type Properties
  • 3.127 Set Classification Types
  • 3.128 Set Common Properties
  • 3.129 Set Data Type
  • 3.130 Show/Hide Elements
  • 3.131 Slice Properties
  • 3.132 Spatial Definition Properties
  • 3.133 SQL Access to Oracle AW Properties
  • 3.134 Standard Reports Configurations
  • 3.135 Structured Attribute Properties
  • 3.136 Structured Type Properties
  • 3.137 Subversion: Add Property
  • 3.138 Subversion: Add to Source Control
  • 3.139 Subversion: Apply Patch
  • 3.140 Subversion: Branch/Tag
  • 3.141 Subversion: Check Out from Subversion
  • 3.142 Subversion: Commit Resources
  • 3.143 Subversion: Commit Working Copy
  • 3.144 Subversion: Confirm Checkout
  • 3.145 Subversion: Create Remote Directory
  • 3.146 Subversion: Create Subversion Repository
  • 3.147 Subversion: Create/Edit Subversion Connection
  • 3.148 Subversion: Delete Resources
  • 3.149 Subversion: Edit Configuration File
  • 3.150 Subversion: Export Files
  • 3.151 Subversion: Export Subversion Connections
  • 3.152 Subversion: History
  • 3.153 Subversion: Ignore
  • 3.154 Subversion: Import Subversion Connections
  • 3.155 Subversion: Import to Subversion
  • 3.156 Subversion: Lock Resources
  • 3.157 Subversion: Merge
  • 3.158 Subversion: Pending Changes
  • 3.159 Subversion: Properties
  • 3.160 Subversion: Remove from Subversion
  • 3.161 Subversion: Repository Browser
  • 3.162 Subversion: Revert Local Changes
  • 3.163 Subversion: Switch
  • 3.164 Subversion: Unlock Resources
  • 3.165 Subversion: Update Resources
  • 3.166 Subversion: Update Working Copy
  • 3.167 Subversion: Versioning Properties
  • 3.168 Subversion: XML Metadata Comparator
  • 3.169 Subview Properties
  • 3.170 Table Properties
  • 3.171 Table to View
  • 3.172 Table DDL Transformation Scripts
  • 3.173 Telephone Properties
  • 3.174 Transformation Package
  • 3.175 Transformation <task-name>
  • 3.176 Transformation Properties
  • 3.177 Transformation Flow Properties
  • 3.178 TSDP Policy Properties
  • 3.179 Types Administration
  • 3.180 Types to Domains
  • 3.181 Unable to Connect
  • 3.182 Unique Identifier (UID, or Key) Properties
  • 3.183 View Properties (Logical Model)
  • 3.184 View Properties (Relational Model)
  • 3.185 View to Table
  • 3.186 Windows
• Index