You are previewing Oracle SQL Developer Data Modeler for Database Design Mastery.
O'Reilly logo
Oracle SQL Developer Data Modeler for Database Design Mastery

Book Description

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. Configure Oracle SQL Developer Data Modeler Perform requirement analysis Translate requirements into a formal conceptual data model and process models Transform the conceptual (logical) model into a relational model Manage physical database design Generate data definition language (DDL) scripts to create database objects Design a data warehouse database Use subversion for version control and to enable a multiuser environment Document an existing database Use the reporting tools in Oracle SQL Developer Data Modeler Compare designs and the database

Table of Contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Dedication Page
  5. About the Author
  6. Contents at a Glance
  7. Contents
  8. Forewords
  9. Acknowledgments
  10. Introduction
  11. 1 Introducing Database Design and Oracle SQL Developer Data Modeler
    1. What Is Oracle SQL Developer Data Modeler?
    2. Designing Databases with Oracle SQL Developer Data Modeler
    3. Summary
  12. 2 Getting Started with Oracle SQL Developer Data Modeler
    1. Downloading and Exploring the Tool
      1. What Is a Design?
      2. Exploring the Interface
      3. Customizing the Interface
    2. Tuning Oracle SQL Developer Data Modeler
      1. Setting Preferences
      2. Introducing Design Properties
      3. Introducing Glossaries
      4. Introducing Domains
      5. Introducing Design Rules
    3. Performance Tuning
    4. Summary
  13. 3 Introducing Requirements Analysis
    1. Gathering Requirements for the Logical Model
    2. Gathering Requirements for the Process Model
      1. Introducing Data Flow Diagrams
      2. Introducing Transformation Packages
    3. Adding Business Information
    4. Summary
  14. 4 Introducing Conceptual Database Design (Logical Model)
    1. Setting Preferences and Properties
    2. Introducing the Logical Model
      1. An Entity and Its Attributes
      2. A Relationship
      3. Constraints
      4. Entity Views
      5. Inheritance
      6. Subviews
      7. Displays
    3. Summary
  15. 5 Introducing Logical Database Design (Relational Model)
    1. Setting Preferences and Properties
    2. Transforming from a Logical Model to a Relational Model
      1. Setting Transformation Rules
      2. Engineer to Relational Model
    3. Introducing the Relational Model
      1. Tables
      2. Views
    4. Name Abbreviations and Prefix Management
      1. Name Abbreviation
      2. Prefix Management
    5. Tuning and Refactoring Your Model
    6. Summary
  16. 6 Introducing Physical Database Design
    1. Setting Preferences and Properties
    2. Creating a Physical Model
      1. Administering RDBMS Sites
      2. A New Physical Model
    3. Defining Physical Model Properties
      1. Defining Users and Roles
      2. Storage Templates and LOB Storages
      3. Tablespaces
      4. Synonyms
      5. Tables
      6. Sequences
      7. Views
      8. Materialized Views
      9. Stored Procedures, Functions, and Packages
      10. Triggers
      11. User-Defined Data Types
      12. Other Elements
    4. Propagating Properties
    5. Indexing
    6. Partitioning
    7. Summary
  17. 7 Generating DDL Scripts for Creating Database Objects
    1. Setting Preferences and Properties
    2. Exporting a DDL File
      1. Exploring DDL Generation Options
    3. Summary
  18. 8 Designing a Data Warehouse Database
    1. Introducing Dimensional Modeling Techniques
    2. Exploring Dimensional Design
      1. Star Schema or Snowflake
      2. Data Vault
      3. Physical Database Design and DDLs
    3. Introducing Multidimensional Design
      1. Creating a Multidimensional Model
      2. Creating the Physical Model and Exports
      3. Reporting
    4. Using Dynamic Properties and User-Defined Properties
    5. Summary
  19. 9 Using Version Control and Working in a Multiuser Environment (Subversion)
    1. Setting Preferences and Properties
    2. Introducing Subversion
    3. Connecting to Subversion
    4. Using Subversion in Oracle SQL Developer Data Modeler
      1. Exploring the Oracle SQL Developer Data Modeler Tools for Subversion
      2. Adding a Design to Subversion
      3. Making Changes to a Design You Have Worked with Before
      4. Checking Out a Design from Subversion
      5. Solving Conflicts
      6. Making Changes Based on an Older Revision
      7. Understanding Branches, Changes, and Synchronizing
      8. Sharing Files
    5. Working in a Multiuser Environment with Microsoft Excel
    6. Summary
  20. 10 Documenting an Existing Database
    1. Setting Preferences and Properties
    2. Reverse Engineering an Existing Database
      1. Reverse Engineering from a Data Dictionary
      2. Importing a DDL File
      3. Discovering Foreign Keys
      4. Engineering to the Logical Model
    3. Importing Documentation from a Third-Party Modeling Tool
      1. Importing from Oracle Designer
    4. Summary
  21. 11 Generating Reports and Using Search
    1. Setting Preferences and Properties
    2. Generating Reports Based on Open Designs
    3. Introducing the Reporting Repository
      1. Creating a Reporting Repository
      2. Exporting a Design to the Reporting Repository
      3. Running Reports from the Reporting Repository
    4. Using Search
      1. Reporting with Search
      2. Simple Mode
      3. Advanced Mode
    5. Setting Common Properties
    6. Summary
  22. 12 Comparing Designs and the Database
    1. Setting Preferences and Properties
    2. Comparing Two Designs
      1. Importing a Data Modeler Design
      2. Comparing/Merging Models
    3. Comparing a Design to the Database
    4. Summary
  23. Index