Skip Headers

Oracle® SQL Developer Data Modeler User's Guide Release 2.0 Part Number E13677-01 |
Home | Book List | Contents | Contact Us

Previous
| View PDF

# Index

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

## A

  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

## B

  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

## C

  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

## D

  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

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

## F

  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

## G

  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

## H

  hierarchies
    properties, 3.40

## I

  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

## J

  JDBC drivers (third party), 1.5.6
  joins
    properties, 3.51

## K

  keys
    properties, 3.52

## L

  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

## M

  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

## N

  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

## O

  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

## P

  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

## R

  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

## S

  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

## T

  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

## U

  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

## V

  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

## Z

  Zachman framework, 1
  zoom in, 1.2.1
  zoom out, 1.2.1