Contents

Expand All · Collapse All

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 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 Compare Mappings
    • 1.5.2.2 DDL
    • 1.5.2.3 Diagram
    • 1.5.2.4 Model
    • 1.5.2.5 Naming Standard
    • 1.5.2.6 Third Party JDBC Drivers
  • 1.5.3 Extensions
  • 1.5.4 Global Ignore List
  • 1.5.5 Mouseover Popups
  • 1.5.6 Shortcut Keys (Accelerator Keys)
  • 1.5.7 Versioning
  • 1.5.8 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 XML Files
  • 1.8.2 Using SQL Developer to View Exported Reporting Schema Data
    • 1.8.2.1 Design Content reports
    • 1.8.2.2 Design Rules reports
  • 1.8.3 Reporting Repository and Reporting Schema
• 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 Additional Resources for 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 Arc Properties
• 3.3 Attribute Properties
• 3.4 Change Object Names Prefix
• 3.5 Change Request Properties
• 3.6 Check for Updates
• 3.7 Collection Type Properties
• 3.8 Column Properties
• 3.9 Common Information in Dialog Boxes
• 3.10 Compare Mapping
• 3.11 Compare Modeling Designs
• 3.12 Compare Models
• 3.13 Configure Extension
• 3.14 Contact Properties
• 3.15 Create Discovered Foreign Keys
• 3.16 Cube Properties
• 3.17 Data Dictionary Import (Metadata Extraction)
• 3.18 Database Connection Editor
• 3.19 DDL File Editor
• 3.20 DDL Generation Options
• 3.21 Design Properties
• 3.22 Design Rules
  • 3.22.1 Design Rules
  • 3.22.2 Custom Rules
  • 3.22.3 Libraries
  • 3.22.4 Transformations
• 3.23 Dimension Properties
• 3.24 Display Properties
• 3.25 Distinct Type Properties
• 3.26 Document Properties
• 3.27 Domain Properties (Domains Model)
• 3.28 Domains Administration
• 3.29 Email Properties
• 3.30 Engineering
• 3.31 Entity Properties
• 3.32 Event Properties
• 3.33 Export Cube Views Metadata
• 3.34 Export to Microsoft XMLA
• 3.35 Export to Oracle Analytic Workspaces
• 3.36 Export to Reporting Schema
• 3.37 External Agent Properties
• 3.38 External Data Properties
• 3.39 Find Object
• 3.40 Flow Properties
• 3.41 Foreign Key Properties
• 3.42 Glossary Editor
• 3.43 Hierarchy Properties
• 3.44 Import Domains
• 3.45 Import Glossary (Naming Standard Definitions)
• 3.46 Import Mapped Models from VAR Files
• 3.47 Import Oracle Designer Model
• 3.48 Import Data Modeler Design
• 3.49 Import Database Connections
• 3.50 Import VAR File: Select Type of Import
• 3.51 Index, Primary Key, or Unique Key Properties
• 3.52 Information Store Properties
• 3.53 Information Structure Properties
• 3.54 Inheritance Relation Properties - <hierarchy-name>
• 3.55 Join Properties
• 3.56 Level Properties
• 3.57 Location Properties
• 3.58 Logical Type
• 3.59 Measure Folder Properties
• 3.60 Measure Properties
• 3.61 Measurement Properties
• 3.62 Method Properties
• 3.63 Model Properties - Business Information
• 3.64 Model Properties - <data-flow-diagram-name>
• 3.65 Model Properties - Data Types
• 3.66 Model Properties - Logical
• 3.67 Model Properties - <multidimensional-model-name>
• 3.68 Model Properties - Process Model
• 3.69 Model Properties - <name> (Relational)
• 3.70 Name Abbreviations
• 3.71 New/Update Database Connection
• 3.72 Process Properties
• 3.73 RDBMS Site Editor
• 3.74 Record Structure Properties
• 3.75 Relation Properties
• 3.76 Relational Models
• 3.77 Resource Locator Properties
• 3.78 Responsible Party Properties
• 3.79 Role Properties
• 3.80 Rollup Link Properties
• 3.81 Rule Set Properties
• 3.82 Schema Properties
• 3.83 SELECT DDL Files
• 3.84 Select File
• 3.85 Set Classification Types
• 3.86 Set Data Type
• 3.87 Slice Properties
• 3.88 Spatial Definition Properties
• 3.89 SQL Access to Oracle AW Properties
• 3.90 Structured Attribute Properties
• 3.91 Structured Type Properties
• 3.92 Subversion: Add Property
• 3.93 Subversion: Add to Source Control
• 3.94 Subversion: Apply Patch
• 3.95 Subversion: Branch/Tag
• 3.96 Subversion: Check Out from Subversion
• 3.97 Subversion: Commit Resources
• 3.98 Subversion: Commit Working Copy
• 3.99 Subversion: Confirm Checkout
• 3.100 Subversion: Create Remote Directory
• 3.101 Subversion: Create Subversion Repository
• 3.102 Subversion: Create/Edit Subversion Connection
• 3.103 Subversion: Delete Resources
• 3.104 Subversion: Edit Configuration File
• 3.105 Subversion: Export Files
• 3.106 Subversion: Export Subversion Connections
• 3.107 Subversion: History
• 3.108 Subversion: Ignore
• 3.109 Subversion: Import Subversion Connections
• 3.110 Subversion: Import to Subversion
• 3.111 Subversion: Lock Resources
• 3.112 Subversion: Merge
• 3.113 Subversion: Pending Changes
• 3.114 Subversion: Properties
• 3.115 Subversion: Remove from Subversion
• 3.116 Subversion: Repository Browser
• 3.117 Subversion: Revert Local Changes
• 3.118 Subversion: Switch
• 3.119 Subversion: Unlock Resources
• 3.120 Subversion: Update Resources
• 3.121 Subversion: Update Working Copy
• 3.122 Subversion: Versioning Properties
• 3.123 Subversion: XML Metadata Comparator
• 3.124 Subview Properties
• 3.125 Table Properties
• 3.126 Table to View
• 3.127 Telephone Properties
• 3.128 Transformation Package
• 3.129 Transformation <task-name>
• 3.130 Transformation Properties
• 3.131 Transformation Flow Properties
• 3.132 Types Administration
• 3.133 Types to Domains
• 3.134 Unique Identifier (UID, or Key) Properties
• 3.135 View Properties
• 3.136 View to Table
• 3.137 Windows

Index