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

E48205-06
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.4
attributes
definition of, 1.3.4.3
properties, 3.5
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.116
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.7
Change Subview Object Names Prefix command, 1.2.2
Check for Updates feature, 3.8
classification types
specifying colors for in diagrams, 3.25
collection type
properties, 3.9
collection types, 1.3.2.4
color
background in diagrams, 1.2.2
columns
properties, 3.10
comparing models, 1.2.1
composite process
definition of, 1.3.3
configurations
export, 3.95
report, 3.104
connections
creating, editing, or selecting, 3.79
Oracle Database, 3.79, 3.79
contacts
definition of, 1.3.7.1
properties, 3.16
context menus (right-click menus), 1.2.2
cubes
properties, 3.19
custom design rules, 3.26.2
custom report templates, 3.20
custom transformation scripts
applying, 1.2.2
custom transformations, 3.26.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.66
data store
definition of, 1.3.3
data types
administering, 1.2.1, 3.148
model, 1.3.2
database connections
creating, editing, or selecting, 3.79
Oracle Database, 3.79, 3.79
DDL file editor, 3.23
DDL files
selecting for import, 3.93
DDL generation
options, 3.24
default size
adjusting sizes and shapes to fit diagram window, 1.2.1
defaultdomains.xml file, 3.51
design rules
checking a design for violations, 1.2.1
custom, 3.26.2
explanation and usage information, 3.26
diagram color
background, 1.2.2
diagrams
adjusting lines in (auto route setting), 1.2.2
dimensions
properties, 3.27
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.29
documents
definition of, 1.3.7.2
properties, 3.30
domains
administering, 1.2.1, 3.32
importing, 3.51
preferred, 1.5.2.3
properties, 3.31
types to domains wizard, 3.149
dynamic properties, 3.11

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.33
entities
definition of, 1.3.4.2
properties, 3.35
events
adding, 3.1
properties, 3.36
export configurations, 3.95
extensions
SQL Developer, 1.5.3
external agents
definition, 1.3.3
properties, 3.43
external data
properties, 3.44

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.80
flows
properties, 3.47
showing name in diagrams, 1.2.2
foreign keys
discovering, 1.2.2
properties, 3.48
forward engineering, 1.2.2

G

glossaries
concepts (explanations), 3.49
creating, 1.2.1
editing, 1.2.1
glossary
importing, 3.52
glossary editor, 3.49
graphical user interface (GUI)
Data Modeler, 1.2
grid
showing and hiding, 1.2.2
grid size
option, 1.5.2.2

H

hierarchies
properties, 3.50

I

identifying relationship, 3.84
identity column, 3.10
indexes
definition of, 1.3.6.7
properties, 3.58
information store
definition of, 1.3.3
information stores
properties, 3.59
information structures
properties, 3.60
inheritance
definition of, 1.3.4.5

J

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

K

keyboard shortcuts, 1.5.6
keys
properties, 3.150

L

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

M

mask templates
administering, 3.66
measure folders
properties, 3.67
measurements
properties, 3.69
measures
properties, 3.68
merging models, 1.2.1
methods
properties, 3.70
modeling
data modeling concepts and usage information, 1
Multimedia
Oracle Multimedia logical types, 1.3.2.5

N

name abbreviations, 3.78
specifying file with, 1.2.1
name translation
applying during engineering, 3.34
naming standard definitions
importing, 3.52
neighbors
selecting in diagrams, 1.2.2

O

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

Q

query builder, 3.151, 3.152

R

RDBMS site
definition of, 1.3.6
editing, 3.82
RDBMS sites
administering, 1.2.1
record structures
properties, 3.83
redaction
mask templates administration, 3.66
relational models, 1.3.5
relations
definition of, 1.3.4.6, 1.3.5.5
properties, 3.84
relationship
identifying, 3.84
report configurations, 3.104
report templates, 3.20, 3.86
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.87
responsible parties
definition of, 1.3.7.6
properties, 3.88
reverse engineering, 1.2.2
right-click menus (context menus), 1.2.2
role
definition of, 1.3.3
roles
properties, 3.89
rollup links
properties, 3.90
rule sets, 3.26.1
properties, 3.91

S

Saxon XSLT 2.0 .jar file
specifying, 1.5.2
schemas
properties, 3.92
select neighbors
context menu command, 1.2.2
Select Relational Models dialog box
controlling display of, 1.5.2
sensitive type
properties, 3.96
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.101
spatial definitions
properties, 3.102
SQL Access to Oracle AW
properties, 3.103
standard report templates
modifying, 3.86
Start Page for Data Modeler, 1.11
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.139
synchronize with tree
option, 1.5.2.2
synonyms
creating, 1.2.2

T

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

U

unique identifiers (UIDs)
definition of, 1.3.4.4
properties, 3.150
updates
checking for SQL Developer updates, 3.8
URLs
resource locator objects, 1.3.7.5
resource locator properties, 3.87
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.152
properties, 3.151, 3.152
table to view wizard, 3.141, 3.153
validating, 3.152
virtual columns (Computed property for a column), 3.10

Z

zoom in, 1.2.1
zoom out, 1.2.1