1/8
Contents
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
Search
1.5.2.7
SQL Formatter
1.5.2.8
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 RTF, HTML, or PDF 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
Data Modeler Accessibility Information
1.11
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 Subview 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 Database Connection
3.16
Create Discovered Foreign Keys
3.17
Cube Properties
3.18
Data Dictionary Import (Metadata Extraction)
3.19
Database Connection Editor
3.20
DDL File Editor
3.21
DDL Generation Options
3.22
Design Properties
3.23
Design Rules
3.23.1
Design Rules
3.23.2
Custom Rules
3.23.3
Libraries
3.23.4
Transformations
3.24
Dimension Properties
3.25
Display Properties
3.26
Distinct Type Properties
3.27
Document Properties
3.28
Domain Properties (Domains Model)
3.29
Domains Administration
3.30
Email Properties
3.31
Engineering
3.32
Entity Properties
3.33
Event Properties
3.34
Export Cube Views Metadata
3.35
Export to Microsoft XMLA
3.36
Export to Oracle Analytic Workspaces
3.37
Export to Reporting Schema
3.38
Export Wizard
3.39
External Agent Properties
3.40
External Data Properties
3.41
Find Object (Search)
3.42
Flow Properties
3.43
Foreign Key Properties
3.44
Glossary Editor
3.45
Hierarchy Properties
3.46
Import Domains
3.47
Import Glossary (Naming Standard Definitions)
3.48
Import Mapped Models from VAR Files
3.49
Import Oracle Designer Model
3.50
Import Data Modeler Design
3.51
Import Database Connections
3.52
Import VAR File: Select Type of Import
3.53
Index, Primary Key, or Unique Key Properties
3.54
Information Store Properties
3.55
Information Structure Properties
3.56
Inheritance Relation Properties - <hierarchy-name>
3.57
Join Properties
3.58
Level Properties
3.59
Location Properties
3.60
Logical Type
3.61
Measure Folder Properties
3.62
Measure Properties
3.63
Measurement Properties
3.64
Method Properties
3.65
Model Properties - Business Information
3.66
Model Properties - <data-flow-diagram-name>
3.67
Model Properties - Data Types
3.68
Model Properties - Logical
3.69
Model Properties - <multidimensional-model-name>
3.70
Model Properties - Process Model
3.71
Model Properties - <name> (Relational)
3.72
Name Abbreviations
3.73
New/Update Database Connection
3.74
Object Names Administration
3.75
Process Properties
3.76
RDBMS Site Editor
3.77
Record Structure Properties
3.78
Relation Properties
3.79
Relational Models
3.80
Report Templates Management
3.81
Resource Locator Properties
3.82
Responsible Party Properties
3.83
Role Properties
3.84
Rollup Link Properties
3.85
Rule Set Properties
3.86
Schema Properties
3.87
SELECT DDL Files
3.88
Select File
3.89
Select Models/Subviews to Export
3.90
Set Classification Types
3.91
Set Common Properties
3.92
Set Data Type
3.93
Slice Properties
3.94
Spatial Definition Properties
3.95
SQL Access to Oracle AW Properties
3.96
Standard Reports Configurations
3.97
Structured Attribute Properties
3.98
Structured Type Properties
3.99
Subversion: Add Property
3.100
Subversion: Add to Source Control
3.101
Subversion: Apply Patch
3.102
Subversion: Branch/Tag
3.103
Subversion: Check Out from Subversion
3.104
Subversion: Commit Resources
3.105
Subversion: Commit Working Copy
3.106
Subversion: Confirm Checkout
3.107
Subversion: Create Remote Directory
3.108
Subversion: Create Subversion Repository
3.109
Subversion: Create/Edit Subversion Connection
3.110
Subversion: Delete Resources
3.111
Subversion: Edit Configuration File
3.112
Subversion: Export Files
3.113
Subversion: Export Subversion Connections
3.114
Subversion: History
3.115
Subversion: Ignore
3.116
Subversion: Import Subversion Connections
3.117
Subversion: Import to Subversion
3.118
Subversion: Lock Resources
3.119
Subversion: Merge
3.120
Subversion: Pending Changes
3.121
Subversion: Properties
3.122
Subversion: Remove from Subversion
3.123
Subversion: Repository Browser
3.124
Subversion: Revert Local Changes
3.125
Subversion: Switch
3.126
Subversion: Unlock Resources
3.127
Subversion: Update Resources
3.128
Subversion: Update Working Copy
3.129
Subversion: Versioning Properties
3.130
Subversion: XML Metadata Comparator
3.131
Subview Properties
3.132
Table Properties
3.133
Table to View
3.134
Telephone Properties
3.135
Transformation Package
3.136
Transformation <task-name>
3.137
Transformation Properties
3.138
Transformation Flow Properties
3.139
Types Administration
3.140
Types to Domains
3.141
Unique Identifier (UID, or Key) Properties
3.142
View Properties (Logical Model)
3.143
View Properties (Relational Model)
3.144
View to Table
3.145
Windows
Index
Scripting on this page enhances content navigation, but does not change the content in any way.