Index

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

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

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

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

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

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

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

hierarchies

properties, 3.50

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

JDBC drivers (third party), 1.5.2.6

joins

properties, 3.62

keyboard shortcuts, 1.5.6

keys

properties, 3.150

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

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

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

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

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

query builder, 3.151, 3.152

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

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

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

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

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

zoom in, 1.2.1

zoom out, 1.2.1

Index

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

Z