book

Oracle SQL Developer Data Modeler for Database Design Mastery

by Heli Helskyaho

May 2015

Intermediate to advanced

336 pages

8h 58m

English

McGraw Hill Computing

Read now

Unlock full access

What Is Oracle SQL Developer Data Modeler?Designing Databases with Oracle SQL Developer Data ModelerSummary
Downloading and Exploring the ToolWhat Is a Design?Exploring the InterfaceCustomizing the InterfaceTuning Oracle SQL Developer Data ModelerSetting PreferencesIntroducing Design PropertiesIntroducing GlossariesIntroducing DomainsIntroducing Design RulesPerformance TuningSummary
Gathering Requirements for the Logical ModelGathering Requirements for the Process ModelIntroducing Data Flow DiagramsIntroducing Transformation PackagesAdding Business InformationSummary
Setting Preferences and PropertiesIntroducing the Logical ModelAn Entity and Its AttributesA RelationshipConstraintsEntity ViewsInheritanceSubviewsDisplaysSummary
Setting Preferences and PropertiesTransforming from a Logical Model to a Relational ModelSetting Transformation RulesEngineer to Relational ModelIntroducing the Relational ModelTablesViewsName Abbreviations and Prefix ManagementName AbbreviationPrefix ManagementTuning and Refactoring Your ModelSummary
Setting Preferences and PropertiesCreating a Physical ModelAdministering RDBMS SitesA New Physical ModelDefining Physical Model PropertiesDefining Users and RolesStorage Templates and LOB StoragesTablespacesSynonymsTablesSequencesViewsMaterialized ViewsStored Procedures, Functions, and PackagesTriggersUser-Defined Data TypesOther ElementsPropagating PropertiesIndexingPartitioningSummary
Setting Preferences and PropertiesExporting a DDL FileExploring DDL Generation OptionsSummary
Introducing Dimensional Modeling TechniquesExploring Dimensional DesignStar Schema or SnowflakeData VaultPhysical Database Design and DDLsIntroducing Multidimensional DesignCreating a Multidimensional ModelCreating the Physical Model and ExportsReportingUsing Dynamic Properties and User-Defined PropertiesSummary
Setting Preferences and PropertiesIntroducing SubversionConnecting to SubversionUsing Subversion in Oracle SQL Developer Data ModelerExploring the Oracle SQL Developer Data Modeler Tools for SubversionAdding a Design to SubversionMaking Changes to a Design You Have Worked with BeforeChecking Out a Design from SubversionSolving ConflictsMaking Changes Based on an Older RevisionUnderstanding Branches, Changes, and SynchronizingSharing FilesWorking in a Multiuser Environment with Microsoft ExcelSummary
Setting Preferences and PropertiesReverse Engineering an Existing DatabaseReverse Engineering from a Data DictionaryImporting a DDL FileDiscovering Foreign KeysEngineering to the Logical ModelImporting Documentation from a Third-Party Modeling ToolImporting from Oracle DesignerSummary
Setting Preferences and PropertiesGenerating Reports Based on Open DesignsIntroducing the Reporting RepositoryCreating a Reporting RepositoryExporting a Design to the Reporting RepositoryRunning Reports from the Reporting RepositoryUsing SearchReporting with SearchSimple ModeAdvanced ModeSetting Common PropertiesSummary
Setting Preferences and PropertiesComparing Two DesignsImporting a Data Modeler DesignComparing/Merging ModelsComparing a Design to the DatabaseSummary

Overview

Design Databases with Oracle SQL Developer Data Modeler

In this practical guide, Oracle ACE Director Heli Helskyaho explains the process of database design using Oracle SQL Developer Data Modeler—the powerful, free tool that flawlessly supports Oracle and other database environments, including Microsoft SQL Server and IBM DB2. Oracle SQL Developer Data Modeler for Database Design Mastery covers requirement analysis, conceptual, logical, and physical design, data warehousing, reporting, and more. Create and deploy high-performance enterprise databases on any platform using the expert tips and best practices in this Oracle Press book.