Skip Headers
Oracle® SQL Developer Data Modeler User's Guide
Release 2.0
Part Number E13677-01
Home
Book List
Index
Contact Us
Next
View PDF
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 SQL Developer 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 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
Data Modeler Options (User Preferences)
1.5.1
General
1.5.2
Model
1.5.3
Diagram
1.5.4
Naming Standard
1.5.5
DDL
1.5.6
Third Party JDBC Drivers
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 SQL Developer Data Modeler Design
1.6.8
Importing a Domain
1.7
Data Modeler Reports
1.7.1
Design Content reports
1.7.2
Design Rules reports
1.8
Read-Only Data Modeler Viewer
1.9
Additional Resources for Data Modeling
2
Tutorial: Data 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
Dialog Boxes for Data Modeler
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
Collection Type Properties
3.7
Column Properties
3.8
Common Information in Dialog Boxes
3.9
Compare Mapping
3.10
Compare Modeling Designs
3.11
Compare Models
3.12
Contact Properties
3.13
Cube Properties
3.14
Data Dictionary Import (Metadata Extraction)
3.15
Database Connection Editor
3.16
DDL File Editor
3.17
DDL Generation Options
3.18
Design Properties
3.19
Design Rules
3.20
Dimension Properties
3.21
Display Properties
3.22
Distinct Type Properties
3.23
Document Properties
3.24
Domain Properties (Domains Model)
3.25
Domains Administration
3.26
Email Properties
3.27
Engineering
3.28
Entity Properties
3.29
Event Properties
3.30
Export Cube Views Metadata
3.31
Export to Microsoft XMLA
3.32
Export to Oracle Analytic Workspaces
3.33
Export to Reporting Schema
3.34
External Agent Properties
3.35
External Data Properties
3.36
Find Object
3.37
Flow Properties
3.38
Foreign Key Properties
3.39
Glossary Editor
3.40
Hierarchy Properties
3.41
Import Domains
3.42
Import Glossary (Naming Standard Definitions)
3.43
Import Mapped Models from VAR Files
3.44
Import Oracle Designer Model
3.45
Import SQL Developer Data Modeler Design
3.46
Import SQL Developer Database Connections
3.47
Import VAR File: Select Type of Import
3.48
Index Properties
3.49
Information Store Properties
3.50
Information Structure Properties
3.51
Join Properties
3.52
Unique Identifier (UID, or Key) Properties
3.53
Level Properties
3.54
Location Properties
3.55
Logical Type
3.56
Measure Folder Properties
3.57
Measure Properties
3.58
Measurement Properties
3.59
Method Properties
3.60
Model Properties - Business Information
3.61
Model Properties - <data-flow-diagram-name>
3.62
Model Properties - Data Types
3.63
Model Properties - Logical
3.64
Model Properties - <multidimensional-model-name>
3.65
Model Properties - Process Model
3.66
Model Properties - <name> (Relational)
3.67
Name Abbreviations
3.68
New/Update Database Connection
3.69
Process Properties
3.70
RDBMS Site Editor
3.71
Record Structure Properties
3.72
Relation Properties
3.73
Relational Models
3.74
Resource Locator Properties
3.75
Responsible Party Properties
3.76
Role Properties
3.77
Rollup Link Properties
3.78
SELECT DDL Files
3.79
Set Classification Types
3.80
Set Data Type
3.81
Slice Properties
3.82
Spatial Definition Properties
3.83
SQL Access to Oracle AW Properties
3.84
Structured Attribute Properties
3.85
Structured Type Properties
3.86
Subview Properties
3.87
Table Properties
3.88
Table to View
3.89
Telephone Properties
3.90
Transformation Package
3.91
Transformation <task-name>
3.92
Transformation Properties
3.93
Transformation Flow Properties
3.94
Types Administration
3.95
View Properties
Index
Scripting on this page enhances content navigation, but does not change the content in any way.