Go to main content
1/10
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
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 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
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 Cube Views Metadata
3.42
Export to Microsoft XMLA
3.43
Export to Oracle Analytic Workspaces
3.44
Export to Reporting Schema
3.45
Export Wizard
3.46
Export/Import Connections
3.46.1
Export Connections
3.46.2
Import Connections
3.47
External Agent Properties
3.48
External Data Properties
3.49
File Processing
3.50
Find Object (Search)
3.51
Flow Properties
3.52
Foreign Key Properties
3.53
Glossary Editor
3.54
Hierarchy Properties
3.55
Import Domains
3.56
Import Glossary (Naming Standard Definitions)
3.57
Import Mapped Models from VAR Files
3.58
Import Oracle Designer Model
3.59
Import Data Modeler Design
3.60
Import Database Connections
3.61
Import VAR File: Select Type of Import
3.62
Index, Primary Key, or Unique Key Properties
3.63
Information Store Properties
3.64
Information Structure Properties
3.65
Inheritance Relation Properties - <hierarchy-name>
3.66
Join Properties
3.67
Level Properties
3.68
Location Properties
3.69
Manage Features and Updates
3.70
Logical Type
3.71
Mask Templates Administration
3.72
Measure Folder Properties
3.73
Measure Properties
3.74
Measurement Properties
3.75
Method Properties
3.76
Model Properties - Business Information
3.77
Model Properties - <data-flow-diagram-name>
3.78
Model Properties - Data Types
3.79
Model Properties - Logical
3.80
Model Properties - <multidimensional-model-name>
3.81
Model Properties - Process Model
3.82
Model Properties - <name> (Relational)
3.83
Name Abbreviations
3.84
New/Edit SSH Connection
3.85
New/Update Database Connection
3.86
Object Names Administration
3.87
Process Properties
3.88
RDBMS Site Editor
3.89
Record Structure Properties
3.90
Relation Properties
3.91
Relational Models
3.92
Report Templates Management
3.93
Resource Locator Properties
3.94
Responsible Party Properties
3.95
Revision Lister
3.96
Role Properties
3.97
Rollup Link Properties
3.98
Rule Set Properties
3.99
Search Profile
3.100
Schema Properties
3.101
SELECT DDL Files
3.102
Select File
3.103
Select Models/Subviews to Export
3.104
Sensitive Type Properties
3.105
Set Classification Types
3.106
Set Common Properties
3.107
Set Data Type
3.108
Show/Hide Elements
3.109
Slice Properties
3.110
Spatial Definition Properties
3.111
SQL Access to Oracle AW Properties
3.112
Standard Reports Configurations
3.113
Structured Attribute Properties
3.114
Structured Type Properties
3.115
Subversion: Add Property
3.116
Subversion: Add to Source Control
3.117
Subversion: Apply Patch
3.118
Subversion: Branch/Tag
3.119
Subversion: Check Out from Subversion
3.120
Subversion: Commit Resources
3.121
Subversion: Commit Working Copy
3.122
Subversion: Confirm Checkout
3.123
Subversion: Create Remote Directory
3.124
Subversion: Create Subversion Repository
3.125
Subversion: Create/Edit Subversion Connection
3.126
Subversion: Delete Resources
3.127
Subversion: Edit Configuration File
3.128
Subversion: Export Files
3.129
Subversion: Export Subversion Connections
3.130
Subversion: History
3.131
Subversion: Ignore
3.132
Subversion: Import Subversion Connections
3.133
Subversion: Import to Subversion
3.134
Subversion: Lock Resources
3.135
Subversion: Merge
3.136
Subversion: Pending Changes
3.137
Subversion: Properties
3.138
Subversion: Remove from Subversion
3.139
Subversion: Repository Browser
3.140
Subversion: Revert Local Changes
3.141
Subversion: Switch
3.142
Subversion: Unlock Resources
3.143
Subversion: Update Resources
3.144
Subversion: Update Working Copy
3.145
Subversion: Versioning Properties
3.146
Subversion: XML Metadata Comparator
3.147
Subview Properties
3.148
Table Properties
3.149
Table to View
3.150
Table DDL Transformation Scripts
3.151
Telephone Properties
3.152
Transformation Package
3.153
Transformation <task-name>
3.154
Transformation Properties
3.155
Transformation Flow Properties
3.156
TSDP Policy Properties
3.157
Types Administration
3.158
Types to Domains
3.159
Unable to Connect
3.160
Unique Identifier (UID, or Key) Properties
3.161
View Properties (Logical Model)
3.162
View Properties (Relational Model)
3.163
View to Table
3.164
Windows
Index
Scripting on this page enhances content navigation, but does not change the content in any way.