Index

accelerator keys

for menus, 1.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

line auto route option, 1.5.3

AutoLayout

context menu command, 1.2.2

Bachman notation, 1.3.4.1

background color

in diagrams, 1.5.3

Barker notation, 1.3.4.1

bind variables

for reports, 1.7

blogs

SQL Developer, 1.9

bottom-up modeling, 1.4.2

business information, 1.3.7

cardinality

definition of, 1.3.4.6

Change Object Names Prefix command, 1.2.2

change request

properties, 3.5

classification types

setting for entities and tables, 1.2.2

specifying colors for in diagrams, 1.5.3

collection type

properties, 3.6

collection types, 1.3.2.4

color

background in diagrams, 1.5.3

columns

properties, 3.7

comparing models, 1.2.1

composite process

definition of, 1.3.3

connections

creating, editing, or selecting, 3.68

Oracle Database, 3.68, 3.68

contacts

definition of, 1.3.7.1

properties, 3.12

context menus (right-click menus), 1.2.2

cubes

properties, 3.13

data flow

definition of, 1.3.3

data flow diagrams, 1.3.3.1

data modeling

concepts and usage information, 1

data store

definition of, 1.3.3

data types

administering, 1.2.1, 3.94

model, 1.3.2

database connections

creating, editing, or selecting, 3.68

Oracle Database, 3.68, 3.68

DDL file editor, 3.16

DDL files

selecting for import, 3.78

DDL generation

options, 3.17

design rules

checking a design for violations, 1.2.1

explanation and usage information, 3.19

diagram color

background, 1.5.3

diagrams

adjusting lines in (auto route setting), 1.2.2

dimensions

properties, 3.20

directories (directory objects), 1.3.6.4

discussion forum

SQL Developer, 1.9

distinct types, 1.3.2.2

properties, 3.22

documents

definition of, 1.3.7.2

properties, 3.23

domains

administering, 1.2.1, 3.25

importing, 3.41

properties, 3.24

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.26

entities

definition of, 1.3.4.2

properties, 3.28

events

adding, 3.1

properties, 3.29

external agents

definition, 1.3.3

properties, 3.34

external data

properties, 3.35

F10 key

for File menu, 1.2

fit screen

adjusting sizes and shapes to fit diagram window, 1.2.1

flows

properties, 3.37

showing name in diagrams, 1.5.3

foreign keys

properties, 3.38

forward engineering, 1.2.1

glossaries

concepts (explanations), 3.39

creating, 1.2.1

editing, 1.2.1

glossary

importing, 3.42

glossary editor, 3.39

graphical user interface (GUI)

Data Modeler, 1.2

grid

showing and hiding, 1.5.3

hierarchies

properties, 3.40

indexes

definition of, 1.3.6.7

properties, 3.48

information store

definition of, 1.3.3

information stores

properties, 3.49

information structures

properties, 3.50

inheritance

definition of, 1.3.4.5

JDBC drivers (third party), 1.5.6

joins

properties, 3.51

keys

properties, 3.52

layout

automatically rearranging in diagrams (AutoLayout), 1.2.2

levels

properties, 3.53

line auto route

adjusting lines in diagrams, 1.2.2

context menu command, 1.2.2

option, 1.5.3

locations

definition of, 1.3.7.4

properties, 3.54

logical model, 1.3.4

logical types, 1.3.2.5

measure folders

properties, 3.56

measurements

properties, 3.58

measures

properties, 3.57

merging models, 1.2.1

methods

properties, 3.59

modeling

data modeling concepts and usage information, 1

Multimedia

Oracle Multimedia logical types, 1.3.2.5

name abbreviations, 3.67

specifying file with, 1.2.1

name translation

applying during engineering, 3.27

naming standard definitions

importing, 3.42

naming standards

applying to keys and constraints, 1.2.2

specifying, 1.5.4

neighbors

selecting in diagrams, 1.2.2

object names prefix

changing, 1.2.2

Oracle by Example (OBE)

Data Modeler, 1.9

Oracle Database connections, 3.68, 3.68

Oracle Multimedia

logical types, 1.3.2.5

ORD* types

Oracle Multimedia logical types, 1.3.2.5

OTN page

SQL Developer, 1.9

physical models, 1.3.6

preferences

for data modeling, 1.5

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.69

RDBMS site

definition of, 1.3.6

editing, 3.70

RDBMS sites

administering, 1.2.1

read-only data modeling viewer, 1.8

record structures

properties, 3.71

relational models, 1.3.5

relations

definition of, 1.3.4.6, 1.3.5.5

properties, 3.72

reporting repository, 1.7

reports, 1.7

bind variables for, 1.7

resource locators

definition of, 1.3.7.5

properties, 3.74

responsible parties

definition of, 1.3.7.6

properties, 3.75

reverse engineering, 1.2.1

right-click menus (context menus), 1.2.2

role

definition of, 1.3.3

roles

properties, 3.76

rollup links

properties, 3.77

select neighbors

context menu command, 1.2.2

Select Relational Models dialog box

controlling display of, 1.5.1

sequences

definition of, 1.3.6.11

shortcut keys

for menus, 1.2

slices

properties, 3.81

spatial definitions

properties, 3.82

SQL Access to Oracle AW

properties, 3.83

SQL Developer preferences

for data modeling, 1.5

structured types, 1.3.2.3

subviews

creating from selected objects, 1.2.2

properties, 3.86

synchronize with tree

option, 1.5.3

synonyms

creating, 1.2.2

table to view wizard, 1.2.1, 3.88

tables

definition of, 1.3.5.2, 1.3.6.16

properties, 3.87

targeted modeling, 1.4.3

telephones

definition of, 1.3.7.7

properties, 3.89

third party JDBC drivers, 1.5.6

top-down modeling, 1.4.1

transformation flows

properties, 3.93

transformation packages, 1.3.3.2

properties, 3.90

transformation tasks

definition, 1.3.3

properties, 3.91

transformations

properties, 3.92

tutorial

creating models for a small database, 2

type substitution, 1.3.4.8

types

administering, 1.2.1, 3.94

data types model, 1.3.2

unique identifiers (UIDs)

definition of, 1.3.4.4

URLs

resource locator objects, 1.3.7.5

resource locator properties, 3.74

user interface (UI)

Data Modeler, 1.2

vertices (elbows)

disabling Auto Route before adding elbows in diagrams, 1.2.2

viewer (read-only) data modeling tool, 1.8

viewlets

Data Modeler, 1.9

views

definition of, 1.3.6.19

properties, 3.95

table to view wizard, 3.88

Zachman framework, 1

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

R

S

T

U

V

Z