:Base aw65.hlp
:Title Oracle Designer Systems Modeling
:Index Systems modeller =aw65.hlp; ;;;------Systems Modeler Keywords
:Index Dataflow Diagrammer =awd65.hlp
:Index Entity Relationship Diagrammer =awe65.hlp
:Index Function Hierarchy Diagrammer =awf65.hlp
:Index Table to Entity Retrofit =cwt65.hlp
:Index Process Modeler =bpmod65.hlp
:Index Database Design Transformer =smd65.hlp
:Index Application Design Transformer =smadw65.hlp
:Index Repository Concepts =rswelc65.hlp
:Index Version Control =rsvers65.hlp
:Link aw65.hlp; ;;;------Systems Modeler Keywords
:Link awd65.hlp
:Link awe65.hlp
:Link awf65.hlp
:Link cwt65.hlp
:Link bpmod65.hlp
:Link smd65.hlp
:Link smadw65.hlp
:Link rswelc65.hlp
:Link rsvers65.hlp
1 Welcome
2 Introducing the system modeling tools
3 About systems modeling tools=bcn_AboutSystemsModelingTools>main
3 Process Modeler=bcn_WhatIsProcessModeler@bpmod65.hlp>main
3 Entity Relationship Diagrammer=acn_WhatistheEntityRelationshipDiagrammer@awe65.hlp>main
3 Dataflow Diagrammer=acn_WhatIstheDataflowDiagrammer@awd65.hlp>main
3 Function Hierarchy Diagrammer=acn_WhatIstheFunctionHierarchyDiagrammer@awf65.hlp>main
2 Supporting features
3 Database Design Transformer=dcn_WhatistheDatabaseDesignTransformer@smd65.hlp>main
3 Application Design Transformer=ucn_WhatistheApplicationDesignWizard@smadw65.hlp>main
3 Table to Entity Retrofit utility=atn_AboutReverseEngineeringEntitiesfromTables@cwt65.hlp>main
3 Broadcast mechanism=COM_About_the_broadcast_mechanism>main
3 Exchanging information with other applications=COM_Exchanging_information_with_other_Applications@aw65.hlp>main
1 New Features
2 What's new for the Systems Modeling tools in 6i=AW_Whats_new_in_the_systems_modeling_tools_for_release_6_i@aw65.hlp>main
1 Getting Started
2 Starting the system modeling tools=AW_Starting_the_system_modeling_tools@aw65.hlp>main
2 Ensuring you have sufficient access to the repository=AW_Ensuring_you_have_sufficient_access_to_the_repository@aw65.hlp>main
:include bpmod65.cnt; Modeling business processes
:include awf65.cnt; Modeling business functions
:include awe65.cnt; Modeling entities and their relationships
:include awd65.cnt; Modeling dataflows
1 Generating preliminary database designs
2 Introducing the Database Design Transformer
3 About the Database Design Transformer=dcn_WhatistheDatabaseDesignTransformer@smd65.hlp>main
3 Principles of database design=dcn_ThePrinciplesofDatabaseDesign@smd65.hlp>main
3 How the Database Design Transformer works
4 What the Database Design Transformer does...=dcn_WhattheDatabaseDesignTransformerDoes@smd65.hlp>main
4 Creates tables to implement entities=dcn_TheMappingofEntitiestoTables@smd65.hlp>main
4 Creates tables to implement M:M relationships=dcn_IntersectionTablestoImplementmanytomanyRelationships@smd65.hlp>main
4 Creates columns to implement attributes=dcn_TheMappingofAttributestoColumns@smd65.hlp>main
4 Creates discriminator columns=dcn_DiscriminatorColumns@smd65.hlp>main
4 Creates columns to implement foreign keys=dcn_ForeignKeyColumns@smd65.hlp>main
4 Creates columns to implement surrogate primary keys=dcn_SurrogatePrimaryKeyColumns@smd65.hlp>main
4 Creates unique keys to implement unique identifiers=dcn_TheMappingofUIDstoUniqueKeys@smd65.hlp>main
4 Creates primary keys for all tables=dcn_TheCreationorAssignmentofPrimaryKeysforallTables@smd65.hlp>main
4 Creates foreign keys to implement relationships=dcn_TheMappingofRelationshipstoForeignkeys@smd65.hlp>main
4 Creates foreign keys to support sub-type mapping styles=dcn_ForeignKeystoSupportParticularMappingStyles@smd65.hlp>main
4 Creates foreign key arcs to implement entity relationship arcs=dcn_TheCreationofForeignKeyArcstoImplementEntityRelationshipArcs@smd65.hlp>main
4 Creates foreign key arcs to support sub-type mapping styles=dcn_ForeignKeyArcstoSupportMappingStyles@smd65.hlp>main
4 Creates indexes to support foreign keys=dcn_TheCreationofIndexesforForeignKeys@smd65.hlp>main
4 Creates allowable values for discriminator columns=dcn_AllowableValuesforDiscriminatorColumns@smd65.hlp>main
4 Creates allowable values for attribute columns=dcn_AllowableValuesforAttributeColumns@smd65.hlp>main
4 Dependencies in the Database Design Transformer=dcn_Dependencies@smd65.hlp>main
4 Database Design Transformer limitations=dcn_Limitations@smd65.hlp>main
4 Default values of the Database Design Transformer=dcn_DefaultvaluesoftheDatabaseDesignTransformer@smd65.hlp>main
2 Generating a default database design
3 Transforming the entity model
4 Transforming the entity model: step-by-step=dtn_TransformingtheEntityModelStepbyStep@smd65.hlp>main
4 Invoking the Database Design Transformer=dtn_InvokingtheDatabaseDesignTransformer@smd65.hlp>2nd
4 Choosing the mode of the Database Design Transformer=dtn_ChoosingtheModeoftheDatabaseDesignTransformer@smd65.hlp>2nd
4 Selecting the default run mode=dtn_Selectingthedefaultrunmode@smd65.hlp>2nd
4 Customizing the run set
5 Choosing the run set=dtn_ChoosingtheDatabaseDesignTransformerRunSet@smd65.hlp>2nd
5 Deciding how to implement entity sub-types=dtn_DecidingHowtoImplementEntitySubTypes@smd65.hlp>2nd
5 Implementing a single table approach to mapping sub-types=dtn_Toimplementsimplemappings@smd65.hlp>2nd
5 Implementing a separate table approach to mapping sub-types=dtn_Toimplementoverridemappings@smd65.hlp>2nd
5 Implementing an implicit sub-type approach=dtn_ImplementinganImplicitSubtypeApproach@smd65.hlp>2nd
5 Implementing an arc approach to mapping sub-types=dtn_Toimplementaugmentmappings@smd65.hlp>2nd
5 Specifying Database Design Transformer run options=dtn_SpecifyingtheRunOptions@smd65.hlp>2nd
5 Displaying the Database Design Transformer run set=dtn_Showingtherunset@smd65.hlp>2nd
5 Changing Database Design Transformer settings=dtn_Changingthesettings@smd65.hlp>2nd
5 Running the Database Design Transformer=dtn_RunningtheDatabaseDesignTransformer@smd65.hlp>2nd
5 Displaying tables generated by the Database Design Transformer=dtn_DisplayingTheTablesGeneratedByTheDatabaseDesignTransformer@smd65.hlp>2nd
5 Saving changes made by the Database Design Transformer=dtn_SavingChangesmadebytheDatabaseDesignTransformer@smd65.hlp>2nd
3 Modifying the generated database design
4 Modifying the design generated by the Transformer=dtn_ModifyingtheDesignGeneratedbytheTransformer@smd65.hlp>main
4 Changing entity to table mappings=dtn_ChangingtheEntitytoTableMappings@smd65.hlp>2nd
4 Changing attribute to column mappings=dtn_ChangingtheAttributetoColumnMappings@smd65.hlp>2nd
4 Changing unique identifier to unique or primary key mappings=dtn_ChangingtheUniqueIdentifiertoUniquePrimaryKeyMappings@smd65.hlp>2nd
4 Changing relationship to foreign key mappings=dtn_ChangingtheRelationshiptoForeignKeyMappings@smd65.hlp>2nd
4 Changing foreign key to index mappings=dtn_ChangingtheForeignKeytoIndexMappings@smd65.hlp>2nd
2 Reference
3 Properties of generated elements
4 About repository elements generated by the Database Design Transformer=dra_GeneratedElementProperties@smd65.hlp>main
4 Generated tables
5 Tables=dra_UseandDerivationofPropertiesforaTableDefinitionthatImplementsanEntity@smd65.hlp>main
5 Table implementations=dra_Derivationofpropertiesfortableimplementationsfortables@smd65.hlp>main
5 Table entity usages=dra_UseandDerivationofPropertiesforaTable_EntityElement@smd65.hlp>main
4 Generated columns
5 Columns=dra_UseandDerivationofPropertiesforaColumnthatImplementsanAttribute@smd65.hlp>main
5 Allowable column values=dra_UseandDerivationofPropertiesforanAttributeValueonaColumnthatImplementsanAttribute@smd65.hlp>main
5 Discriminator columns=dra_UseandDerivationofPropertiesforDiscriminatorColumns@smd65.hlp>main
5 Discriminator column values=dra_UseandDerivationofPropertiesforanAttributeValueonaDiscriminatorColumn@smd65.hlp>main
4 Generated unique and primary keys
5 Unique and primary keys=dra_UseandDerivationofPropertiesforaPrimaryorUniqueKeyConstraintthatImplementsauniqueidentifier@smd65.hlp>main
5 Unique and primary key components=dra_UseandDerivationofPropertiesforaKeyComponentofaPrimaryorUniqueKeywhichimplementsauniqueidentifier@smd65.hlp>main
5 Surrogate primary keys=dra_UseandDerivationofPropertiesforaSurrogatePrimaryKeyConstraint@smd65.hlp>main
5 Surrogate primary key components=dra_UseandDerivationofPropertiesfortheKeyComponentforaSurrogatePrimaryKey@smd65.hlp>main
5 Surrogate primary key columns=dra_UseandDerivationofPropertiesforaColumninaSurrogatePrimaryKey@smd65.hlp>main
5 Primary keys on arced sub-type tables=dra_UseandDerivationofPropertiesforaPrimaryKeyConstraintonanAugmentingTable@smd65.hlp>main
5 Index storage for unique and primary keys=dra_Derivationofpropertiesforindexstorageforuniquekeysandprimarykeys@smd65.hlp>main
4 Generated foreign keys
5 Foreign keys=dra_UseandDerivationofPropertiesforaForeignKeyConstraintwhichImplementsamanytooneoronetoonerelationship@smd65.hlp>main
5 Foreign key components=dra_UseandDerivationofPropertiesforForeignKeyComponents@smd65.hlp>main
5 Foreign key columns=dra_UseandDerivationofPropertiesforForeignKeyColumns@smd65.hlp>main
5 Foreign keys on arced sub-type tables=dra_UseandDerivationofPropertiesforaForeignKeyConstraintonanAugmentingTable@smd65.hlp>main
4 Generated intersection tables
5 Intersection tables=dra_UseandDerivationofPropertiesforIntersectionTableDefinitionswhichImplementmanytomany@smd65.hlp>main
5 Primary keys on intersection tables=dra_UseandDerivationofPropertiesforaPrimaryKeyConstraintonanIntersectionTable@smd65.hlp>main
5 Foreign keys on intersection tables=dra_UseandDerivationofthePropertiesforaForeignKeyConstraintonanIntersectionTable@smd65.hlp>main
4 Generated sequences
5 Surrogate primary key sequences=dra_UseandDerivationofPropertiesforaSequenceusedbyaSurrogatePrimaryKey@smd65.hlp>main
5 Sequence implementations=dra_Derivationofpropertiesforsequenceimplementationsforsequences@smd65.hlp>main
4 Generated indexes
5 Indexes=dra_DerivationofPropertiesforanIndexforaForeignKey@smd65.hlp>main
5 Index entries=dra_DerivationofPropertiesforIndexEntriesforForeignKeyComponents@smd65.hlp>main
5 Index storage for indexes=dra_Derivationofpropertiesforindexstorageforindexes@smd65.hlp>main
3 Database Design Transformer dialogs
4 Database Design Transformer dialog=drd_TheDatabaseDesignTransformerDialog@smd65.hlp>main
4 Database Design Transformer Settings dialog=drd_Settings@smd65.hlp>main
1 Generating preliminary application designs
2 Introducing the Application Design Transformer
3 About the Application Design Transformer=ucn_WhatistheApplicationDesignWizard@smadw65.hlp>main
3 How the Application Design Transformer works=ucn_HowtheApplicationDesignWizardWorks@smadw65.hlp>main
3 Module elements created by the Application Design Transformer=dra_TheElementsAndUsagesGeneratedByTheApplicationDesignWizard@smadw65.hlp>main
3 Candidate modules=dra_CandidateModules@smadw65.hlp>main
3 Module arguments (parameters)=dra_ModuleArgumentsParameters@smadw65.hlp>main
3 Module components=dra_DetailedDataUsages@smadw65.hlp>main
3 Candidate menu module networks=dra_CandidateMenuModules@smadw65.hlp>main
2 Generating a default application design
3 Generating a default application design from analysis data: step-by-step=UTN_GeneratingaDefaultApplicationSystemDesign@smadw65.hlp>main
3 Generating candidate modules=utn_GeneratingModulesfromSystemsModellerData@smadw65.hlp>2nd
3 Generating candidate menu module networks=utn_GeneratingAMenuNetworkfromSystemsModellerData@smadw65.hlp>2nd
3 Accepting candidate modules=utn_AcceptingCandidateModulesGeneratedByApplicationDesignTransfomer@smadw65.hlp>2nd
2 Reference
3 Application Design Transformer dialog box=URD_ApplicationDesignWizardDialogBox@smadw65.hlp>main
1 Creating entities from database tables
2 About the Table to Entity Retrofit utility=atn_AboutReverseEngineeringEntitiesfromTables@cwt65.hlp>main
2 Creating entity models from database tables=atn_Reverse_engineering_entities_from_tables@cwt65.hlp>2nd
2 Reference
3 Table to Entity Retrofit dialog box=ard_TabletoEntityRetrofitDialogBox@cwt65.hlp>main
1 Hints and tips for using the Systems Modeler tools
2 Using shortcut keys to work with the Systems Modeler diagrammers=ShortcutKeysForSystemsModelerDiagrammers@bpmod65.hlp
2 Working with the tools
3 Obtaining version information about a tool=COM_Obtaining_version_information_about_the_current_tool>main
3 Accessing the online documentation=COM_Accessing_the_online_documentation_system>main
3 Changing the database connection=COM_Changing_the_database_connection>main
3 Changing the workarea=COM_Changing_the_workarea>main
3 Setting the broadcast options=COM_Setting_the_broadcast_options>main
3 Showing or hiding the toolbar=COM_Showing_or_hiding_the_toolbar>main
3 Showing or hiding the status bar=COM_Showing_or_hiding_the_status_bar>main
3 Showing or hiding the tool palette=COM_Showing_or_hiding_the_tool_palette>main
3 Making diagrams and the repository consistent=COM_Requerying_elements>main
3 Embedding other applications=COM_Embedding_other_applications>main
2 Working with diagrams
3 Creating and managing diagrams
4 Opening diagrams=atn_openingadiagram>main
4 Saving diagrams=COM_Saving_diagrams>main
4 Closing diagrams=COM_Closing_diagrams>main
4 Deleting diagrams=COM_Deleting_diagrams>main
4 Getting diagram information=COM_Getting_diagram_information>main
3 Editing and viewing diagrams
4 Rescaling a diagram=atn_RescalingaDiagram>main
4 Copying, cutting and pasting=COM_Copying_cutting_and_pasting>main
4 Undoing the last actions=COM_Undoing_the_last_graphical_actions>main
4 Moving, creating and removing dog-legs=atn_CreatingDogLegs>main
4 Selecting items=COM_Selecting_items_on_diagrams>main
4 Navigating to Elements on a Diagram=COM_Navigating_to_elements_on_diagrams>main
4 Viewing diagrams=COM_Viewing_diagrams>main
3 Customizing diagrams
4 Changing the line width on diagrams=atn_ChangingtheLineWidth>main
4 Changing line color diagrams=atn_ChangingtheLineColor>main
4 Changing the fill color on diagrams=atn_ChangingtheFillColor>main
4 Changing the font on diagrams=atn_ChangingtheFont>main
3 Working with the grid
4 Displaying the grid=AW_COM_Displaying_the_grid>main
4 Changing the size of grid cells=AW_COM_Changing_the_size_of_grid_cells>main
4 Snapping diagram items to the grid=AW_COM_Snapping_diagram_items_to_the_grid>main
2 Working with windows
3 Opening new windows=COM_Opening_new_windows>main
3 Organizing windows=COM_Organizing_windows>main
3 Displaying open windows=COM_Displaying_open_windows>main
2 Printing
3 Printing diagrams=COM_Printing>main
3 Changing the print setup=COM_Changing_the_print_setup>main
3 Adding page numbers, titles and boundaries=COM_Adding_page_numbers_titles_and_boundaries_to_diagram_print_jobs>main
3 Minimizing the number of pages=COM_Minimizing_the_number_of_pages>main
:include rsvers65.cnt
:include hsd2000.cnt
:include cdmadv.cnt