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

E48205-04
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
arcs
definition, 1.3.4.7
properties, 3.3
attributes
definition of, 1.3.4.3
properties, 3.4
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.112
bind variables
for reports, 1.8.3
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 request
properties, 3.6
Change Subview Object Names Prefix command, 1.2.2
Check for Updates feature, 3.7
classification types
specifying colors for in diagrams, 3.23
collection type
properties, 3.8
collection types, 1.3.2.4
color
background in diagrams, 1.2.2
columns
properties, 3.9
comparing models, 1.2.1
composite process
definition of, 1.3.3
configurations
export, 3.91
report, 3.100
connections
creating, editing, or selecting, 3.75
Oracle Database, 3.75, 3.75
contacts
definition of, 1.3.7.1
properties, 3.15
context menus (right-click menus), 1.2.2
cubes
properties, 3.18
custom design rules, 3.24.2
custom transformation scripts
applying, 1.2.2
custom transformations, 3.24.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 redaction
mask templates administration, 3.62
data store
definition of, 1.3.3
data types
administering, 1.2.1, 3.144
model, 1.3.2
database connections
creating, editing, or selecting, 3.75
Oracle Database, 3.75, 3.75
DDL file editor, 3.21
DDL files
selecting for import, 3.89
DDL generation
options, 3.22
default size
adjusting sizes and shapes to fit diagram window, 1.2.1
defaultdomains.xml file, 3.47
design rules
checking a design for violations, 1.2.1
custom, 3.24.2
explanation and usage information, 3.24
diagram color
background, 1.2.2
diagrams
adjusting lines in (auto route setting), 1.2.2
dimensions
properties, 3.25
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.27
documents
definition of, 1.3.7.2
properties, 3.28
domains
administering, 1.2.1, 3.30
importing, 3.47
preferred, 1.5.2.3
properties, 3.29
types to domains wizard, 3.145
dynamic properties, 3.10

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.31
entities
definition of, 1.3.4.2
properties, 3.33
events
adding, 3.1
properties, 3.34
export configurations, 3.91
extensions
SQL Developer, 1.5.3
external agents
definition, 1.3.3
properties, 3.40
external data
properties, 3.41

F

F10 key
for File menu, 1.2
fit screen
adjusting sizes and shapes to fit diagram window, 1.2.1
fixing (making unchangeable) object names, 3.76
flows
properties, 3.43
showing name in diagrams, 1.2.2
foreign keys
discovering, 1.2.2
properties, 3.44
forward engineering, 1.2.2

G

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

H

hierarchies
properties, 3.46

I

identifying relationship, 3.80
identity column, 3.9
indexes
definition of, 1.3.6.7
properties, 3.54
information store
definition of, 1.3.3
information stores
properties, 3.55
information structures
properties, 3.56
inheritance
definition of, 1.3.4.5

J

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

K

keyboard shortcuts, 1.5.6
keys
properties, 3.146

L

layout
automatically rearranging in diagrams (AutoLayout), 1.2.2
levels
properties, 3.59
libraries
transformation, 3.24.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.60
logical model, 1.3.4
logical types, 1.3.2.5
preferred, 1.5.2.3

M

mask templates
administering, 3.62
measure folders
properties, 3.63
measurements
properties, 3.65
measures
properties, 3.64
merging models, 1.2.1
methods
properties, 3.66
modeling
data modeling concepts and usage information, 1
Multimedia
Oracle Multimedia logical types, 1.3.2.5

N

name abbreviations, 3.74
specifying file with, 1.2.1
name translation
applying during engineering, 3.32
naming standard definitions
importing, 3.48
neighbors
selecting in diagrams, 1.2.2

O

object names
administration, 3.76
fixing (making unchangeable), 3.76
object names prefix
changing, 1.2.2
older style views
parsing, 3.148
Oracle by Example (OBE)
Data Modeler, 1.11
Oracle Database connections, 3.75, 3.75
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

page grid
showing and hiding, 1.2.2
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.3
preferred logical types, 1.5.2.3
prefixes
Change Subview 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.77

Q

query builder, 3.147, 3.148

R

RDBMS site
definition of, 1.3.6
editing, 3.78
RDBMS sites
administering, 1.2.1
record structures
properties, 3.79
redaction
mask templates administration, 3.62
relational models, 1.3.5
relations
definition of, 1.3.4.6, 1.3.5.5
properties, 3.80
relationship
identifying, 3.80
report configurations, 3.100
report templates, 3.82
reporting repository, 1.8
reports, 1.8
bind variables for, 1.8.3
generating as RTF, HTML, or PDF, 1.8
resource locators
definition of, 1.3.7.5
properties, 3.83
responsible parties
definition of, 1.3.7.6
properties, 3.84
reverse engineering, 1.2.2
right-click menus (context menus), 1.2.2
role
definition of, 1.3.3
roles
properties, 3.85
rollup links
properties, 3.86
rule sets, 3.24.1
properties, 3.87

S

Saxon XSLT 2.0 .jar file
specifying, 1.5.2
schemas
properties, 3.88
select neighbors
context menu command, 1.2.2
Select Relational Models dialog box
controlling display of, 1.5.2
sensitive type
properties, 3.92
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.97
spatial definitions
properties, 3.98
SQL Access to Oracle AW
properties, 3.99
structured types, 1.3.2.3
Subversion
Data Modeler support for, 1.9
preferences for, 1.5.8
subviews
adding elements to, 3.2
creating from selected objects, 1.2.2, 1.2.2
properties, 3.135
synchronize with tree
option, 1.5.2.2
synonyms
creating, 1.2.2

T

table to view wizard, 1.2.1, 3.137, 3.149
tables
definition of, 1.3.5.2, 1.3.6.16
properties, 3.136
targeted modeling, 1.4.3
telephones
definition of, 1.3.7.7
properties, 3.138
templates
report, 3.82
third party JDBC drivers, 1.5.2.6
top-down modeling, 1.4.1
transformation flows
properties, 3.142
transformation packages, 1.3.3.2
properties, 3.139
transformation processes, 1.3.3.2
transformation tasks
definition, 1.3.3
properties, 3.140
transformations
custom, 3.24.4
libraries, 3.24.3
properties, 3.141
TSDP (Transparent Sensitive Data Protection) policies
properties, 3.143
sensitive type properties, 3.92
tutorial
creating models for a small database, 2
type substitution, 1.3.4.8
types
administering, 1.2.1, 3.144
data types model, 1.3.2
types to domains wizard, 3.145

U

unique identifiers (UIDs)
definition of, 1.3.4.4
properties, 3.146
updates
checking for SQL Developer updates, 3.7
URLs
resource locator objects, 1.3.7.5
resource locator properties, 3.83
usage reporting, 1.5.7
user interface (UI)
Data Modeler, 1.2

V

versioning
Data Modeler support for, 1.9
preferences for, 1.5.8
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
older style, 3.148
properties, 3.147, 3.148
table to view wizard, 3.137, 3.149
validating, 3.148
virtual columns (Computed property for a column), 3.9

Z

zoom in, 1.2.1
zoom out, 1.2.1