Table of Contents
- List of Figures
- Title and Copyright Information
- Preface
-
1
Data Modeler Concepts and Usage
- 1.1 Installing and Getting Started with SQL Developer Data Modeler
- 1.2 Data Modeler User Interface
-
1.3
Working with Data Modeler
- 1.3.1 Database Design
- 1.3.2 Data Types Model
- 1.3.3 Process Model
- 1.3.4 Logical Model
- 1.3.5 Relational Models
-
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.4 Approaches to Data Modeling
- 1.5 User Preferences for Data Modeler
- 1.6 Saving, Opening, Exporting, and Importing Designs
- 1.7 Exporting and Importing Preferences and Other Settings
- 1.8 Sharing Diagrams with SQL Developer Web
- 1.9 Printing Diagrams to PDF
- 1.10 Data Modeler Reports
-
1.11
Using Versioning
- 1.11.1 About Subversion and Data Modeler
- 1.11.2 Basic Workflow: Using Subversion with a Design
- 1.11.3 Using Git with Data Modeler
- 1.12 For More Information About Data Modeling
- 2 Data Modeler Tutorial: Modeling for a Small Database
-
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.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.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 Implied Foreign Keys Dialog
- 3.78 Import Domains
- 3.79 Import Glossary (Naming Standard Definitions)
- 3.80 Import Mapped Models from VAR Files
- 3.81 Import Oracle Designer Model
- 3.82 Import Data Modeler Design
- 3.83 Import Database Connections
- 3.84 Import VAR File: Select Type of Import
- 3.85 Index, Primary Key, or Unique Key Properties
- 3.86 Information Store Properties
- 3.87 Information Structure Properties
- 3.88 Inheritance Relation Properties - <hierarchy-name>
- 3.89 Join Properties
- 3.90 Level Properties
- 3.91 Location Properties
- 3.92 Manage Features and Updates
- 3.93 Logical Type
- 3.94 Mask Templates Administration
- 3.95 Measure Folder Properties
- 3.96 Measure Properties
- 3.97 Measurement Properties
- 3.98 Method Properties
- 3.99 Model Properties - Business Information
- 3.100 Model Properties - <data-flow-diagram-name>
- 3.101 Model Properties - Data Types
- 3.102 Model Properties - Logical
- 3.103 Model Properties - <multidimensional-model-name>
- 3.104 Model Properties - Process Model
- 3.105 Model Properties - <name> (Relational)
- 3.106 Name Abbreviations
- 3.107 New/Edit SSH Connection
- 3.108 New/Update Database Connection
- 3.109 Object Names Administration
- 3.110 Process Properties
- 3.111 RDBMS Site Editor
- 3.112 Record Structure Properties
- 3.113 Relation Properties
- 3.114 Relational Models
- 3.115 Report Templates Management
- 3.116 Resource Locator Properties
- 3.117 Responsible Party Properties
- 3.118 Revision Lister
- 3.119 Role Properties
- 3.120 Rollup Link Properties
- 3.121 Rule Set Properties
- 3.122 Search Profile
- 3.123 Schema Properties
- 3.124 SELECT DDL Files
- 3.125 Select File
- 3.126 Select Models/Subviews to Export
- 3.127 Sensitive Type Properties
- 3.128 Set Classification Types
- 3.129 Set Common Properties
- 3.130 Set Data Type
- 3.131 Show/Hide Elements
- 3.132 Slice Properties
- 3.133 Spatial Definition Properties
- 3.134 SQL Access to Oracle AW Properties
- 3.135 Standard Reports Configurations
- 3.136 Structured Attribute Properties
- 3.137 Structured Type Properties
- 3.138 Subversion: Add Property
- 3.139 Subversion: Add to Source Control
- 3.140 Subversion: Apply Patch
- 3.141 Subversion: Branch/Tag
- 3.142 Subversion: Check Out from Subversion
- 3.143 Subversion: Commit Resources
- 3.144 Subversion: Commit Working Copy
- 3.145 Subversion: Confirm Checkout
- 3.146 Subversion: Create Remote Directory
- 3.147 Subversion: Create Subversion Repository
- 3.148 Subversion: Create/Edit Subversion Connection
- 3.149 Subversion: Delete Resources
- 3.150 Subversion: Edit Configuration File
- 3.151 Subversion: Export Files
- 3.152 Subversion: Export Subversion Connections
- 3.153 Subversion: History
- 3.154 Subversion: Ignore
- 3.155 Subversion: Import Subversion Connections
- 3.156 Subversion: Import to Subversion
- 3.157 Subversion: Lock Resources
- 3.158 Subversion: Merge
- 3.159 Subversion: Pending Changes
- 3.160 Subversion: Properties
- 3.161 Subversion: Remove from Subversion
- 3.162 Subversion: Repository Browser
- 3.163 Subversion: Revert Local Changes
- 3.164 Subversion: Switch
- 3.165 Subversion: Unlock Resources
- 3.166 Subversion: Update Resources
- 3.167 Subversion: Update Working Copy
- 3.168 Subversion: Versioning Properties
- 3.169 Subversion: XML Metadata Comparator
- 3.170 Subview Properties
- 3.171 Table Properties
- 3.172 Table to View
- 3.173 Table DDL Transformation Scripts
- 3.174 Telephone Properties
- 3.175 Transformation Package
- 3.176 Transformation <task-name>
- 3.177 Transformation Properties
- 3.178 Transformation Flow Properties
- 3.179 TSDP Policy Properties
- 3.180 Types Administration
- 3.181 Types to Domains
- 3.182 Unable to Connect
- 3.183 Unique Identifier (UID, or Key) Properties
- 3.184 View Properties (Logical Model)
- 3.185 View Properties (Relational Model)
- 3.186 View to Table
- 3.187 Windows
- Index