Oracle SQL Developer Data Modeler for Database Design Mastery

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