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 Data Modeler Reports
- 1.10 Using Versioning
- 1.11 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 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.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