Skip Headers
Oracle® SQL Developer Data Modeler User's Guide
Release 3.1

Part Number E25257-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  Z 

A

accelerator (shortcut) keys, 1.5.6
accelerator keys
for menus, 1.2
Apply Custom Transformation Scripts command, 1.2.2
Apply Naming Standards to Keys and Constraints command, 1.2.2
arcs
definition, 1.3.4.7
properties, 3.2
attributes
definition of, 1.3.4.3
properties, 3.3
auto route
adjusting lines in diagrams, 1.2.2
context menu command, 1.2.2
AutoLayout
context menu command, 1.2.2

B

Bachman notation, 1.3.4.1
background color
in diagrams, 1.2.2
Barker notation, 1.3.4.1
Berkeley DB
data storage for Subversion repository, 3.103
bind variables
for reports, 1.8.2
blogs
SQL Developer, 1.11
bottom-up modeling, 1.4.2
business information, 1.3.7

C

cardinality
definition of, 1.3.4.6
Change Object Names Prefix command, 1.2.2
change request
properties, 3.5
Check for Updates feature, 3.6
classification types
setting for entities and tables, 1.2.2
specifying colors for in diagrams, 1.5.2.3
collection type
properties, 3.7
collection types, 1.3.2.4
color
background in diagrams, 1.2.2
columns
properties, 3.8
comparing models, 1.2.1
composite process
definition of, 1.3.3
connections
creating, editing, or selecting, 3.72
Oracle Database, 3.72, 3.72
contacts
definition of, 1.3.7.1
properties, 3.14
context menus (right-click menus), 1.2.2
cubes
properties, 3.17
custom design rules, 3.23.2
custom transformation scripts
applying, 1.2.2
custom transformations, 3.23.4
customizing Data Modeler
setting preferences, 1.5

D

data flow
definition of, 1.3.3
data flow diagrams, 1.3.3.1
Data Modeler preferences, 1.5
data modeling
concepts and usage information, 1
data store
definition of, 1.3.3
data types
administering, 1.2.1, 3.134
model, 1.3.2
database connections
creating, editing, or selecting, 3.72
Oracle Database, 3.72, 3.72
DDL file editor, 3.20
DDL files
selecting for import, 3.85
DDL generation
options, 3.21
defaultdomains.xml file, 3.45
design rules
checking a design for violations, 1.2.1
custom, 3.23.2
explanation and usage information, 3.23
diagram color
background, 1.2.2
diagrams
adjusting lines in (auto route setting), 1.2.2
dimensions
properties, 3.24
directories (directory objects), 1.3.6.4
Discover Foreign Keys command, 1.2.2
discussion forum
SQL Developer, 1.11
displays, 1.2.2
distinct types, 1.3.2.2
properties, 3.26
documents
definition of, 1.3.7.2
properties, 3.27
domains
administering, 1.2.1, 3.29
importing, 3.45
preferred, 1.5.2.4
properties, 3.28
types to domains wizard, 3.135

E

elbows
adding vertices in diagrams, 1.2.2
disabling Auto Route before adding vertices in diagrams, 1.2.2
removing vertices in diagrams, 1.2.2
emails
definition of, 1.3.7.3
properties, 3.30
entities
definition of, 1.3.4.2
properties, 3.32
events
adding, 3.1
properties, 3.33
extensions
SQL Developer, 1.5.3
external agents
definition, 1.3.3
properties, 3.38
external data
properties, 3.39

F

F10 key
for File menu, 1.2
fit screen
adjusting sizes and shapes to fit diagram window, 1.2.1
flows
properties, 3.41
showing name in diagrams, 1.2.2
foreign keys
discovering, 1.2.2
properties, 3.42
forward engineering, 1.2.2

G

glossaries
concepts (explanations), 3.43
creating, 1.2.1
editing, 1.2.1
glossary
importing, 3.46
glossary editor, 3.43
graphical user interface (GUI)
Data Modeler, 1.2
grid
showing and hiding, 1.2.2

H

hierarchies
properties, 3.44

I

identifying relationship, 3.76
indexes
definition of, 1.3.6.7
properties, 3.52
information store
definition of, 1.3.3
information stores
properties, 3.53
information structures
properties, 3.54
inheritance
definition of, 1.3.4.5

J

JDBC drivers (third party), 1.5.2.6
joins
properties, 3.56

K

keyboard shortcuts, 1.5.6
keys
properties, 3.136

L

layout
automatically rearranging in diagrams (AutoLayout), 1.2.2
levels
properties, 3.57
libraries
transformation, 3.23.3
line auto route
adjusting lines in diagrams, 1.2.2
context menu command, 1.2.2
locations
definition of, 1.3.7.4
properties, 3.58
logical model, 1.3.4
logical types, 1.3.2.5
preferred, 1.5.2.4

M

measure folders
properties, 3.60
measurements
properties, 3.62
measures
properties, 3.61
merging models, 1.2.1
methods
properties, 3.63
modeling
data modeling concepts and usage information, 1
Multimedia
Oracle Multimedia logical types, 1.3.2.5

N

name abbreviations, 3.71
specifying file with, 1.2.1
name translation
applying during engineering, 3.31
naming standard definitions
importing, 3.46
naming standards
applying to keys and constraints, 1.2.2
specifying, 1.5.2.5
neighbors
selecting in diagrams, 1.2.2

O

object names prefix
changing, 1.2.2
Oracle by Example (OBE)
Data Modeler, 1.11
Oracle Database connections, 3.72, 3.72
Oracle Multimedia
logical types, 1.3.2.5
ORD* types
Oracle Multimedia logical types, 1.3.2.5
OTN page
SQL Developer, 1.11

P

physical models, 1.3.6
preferences
customizing Data Modeler, 1.5
exporting and importing, 1.7
restoring to original settings, 1.7.1
preferred domains, 1.5.2.4
preferred logical types, 1.5.2.4
prefixes
Change Object Names Prefix command, 1.2.2
primitive process
definition of, 1.3.3
process model, 1.3.3
processes
definition, 1.3.3
properties, 3.73

Q

query builder, 3.137

R

RDBMS site
definition of, 1.3.6
editing, 3.74
RDBMS sites
administering, 1.2.1
record structures
properties, 3.75
relational models, 1.3.5
relations
definition of, 1.3.4.6, 1.3.5.5
properties, 3.76
relationship
identifying, 3.76
report templates, 3.78
reporting repository, 1.8
reports, 1.8
bind variables for, 1.8.2
generating as RTF, HTML, or PDF, 1.8
resource locators
definition of, 1.3.7.5
properties, 3.79
responsible parties
definition of, 1.3.7.6
properties, 3.80
reverse engineering, 1.2.2
right-click menus (context menus), 1.2.2
role
definition of, 1.3.3
roles
properties, 3.81
rollup links
properties, 3.82
rule sets, 3.23.1
properties, 3.83

S

Saxon XSLT 2.0 .jar file
specifying, 1.5.2
schemas
properties, 3.84
select neighbors
context menu command, 1.2.2
Select Relational Models dialog box
controlling display of, 1.5.2
sequences
definition of, 1.3.6.11
settings
exporting and importing, 1.7
shortcut keys, 1.5.6
for menus, 1.2
restoring to default scheme, 1.5.6
slices
properties, 3.89
spatial definitions
properties, 3.90
SQL Access to Oracle AW
properties, 3.91
structured types, 1.3.2.3
Subversion
Data Modeler support for, 1.9
preferences for, 1.5.7
subviews
creating from selected objects, 1.2.2, 1.2.2
properties, 3.126
synchronize with tree
option, 1.5.2.3
synonyms
creating, 1.2.2

T

table to view wizard, 1.2.1, 3.128, 3.138
tables
definition of, 1.3.5.2, 1.3.6.16
properties, 3.127
targeted modeling, 1.4.3
telephones
definition of, 1.3.7.7
properties, 3.129
templates
report, 3.78
third party JDBC drivers, 1.5.2.6
top-down modeling, 1.4.1
transformation flows
properties, 3.133
transformation packages, 1.3.3.2
properties, 3.130
transformation processes, 1.3.3.2
transformation tasks
definition, 1.3.3
properties, 3.131
transformations
custom, 3.23.4
libraries, 3.23.3
properties, 3.132
tutorial
creating models for a small database, 2
type substitution, 1.3.4.8
types
administering, 1.2.1, 3.134
data types model, 1.3.2
types to domains wizard, 3.135

U

unique identifiers (UIDs)
definition of, 1.3.4.4
properties, 3.136
updates
checking for SQL Developer updates, 3.6
URLs
resource locator objects, 1.3.7.5
resource locator properties, 3.79
user interface (UI)
Data Modeler, 1.2

V

versioning
Data Modeler support for, 1.9
preferences for, 1.5.7
vertices (elbows)
disabling Auto Route before adding elbows in diagrams, 1.2.2
view to table wizard, 1.2.1
viewlets
Data Modeler, 1.11
views
definition of, 1.3.6.19
properties, 3.137
table to view wizard, 3.128, 3.138
virtual columns (Computed property for a column), 3.8

Z

zoom in, 1.2.1
zoom out, 1.2.1