Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

  Easy Data Modeling
Practical methods for Oracle & SQL Server

TBD

 
ISBN xxx Library of Congress Number
200 pages - Perfect bind - 9x7 Publication Date - TBD
Shelving: Database IT in-Focus: Series # xx

Retail Price $39.95 /  £27.95

Key Features   About the Authors
Table of Contents   Errata
Reader Comments    

Only $27.95

 


A good data model is the most critical of all database activities.  You cannot tune a poorly designed database and a firm understanding of data modeling is critical to a successful implementation.

Unfortunately, many of the theory books are extremely complex and fail to provide a plain English guidelines for  creating a robust data mode.  This book addresses that issue and provides proven guidelines that you can apply to any database. 

This practical book explores all aspects of data modeling and shows you a proven real-world approach that ensures that your data is easy to retrieve and manage.

 
Key Features

* Learn the essential principles of successful data modeling.

* See application of techniques using included freeware & sample models.

* See how to avoid the most common data modeling pitfalls.

* Understand how to apply reusable data modeling patterns.

 

 

About the Authors:

 

Bert Scalzo
Bert Scalzo is one of the world's most highly-respected Oracle professionals with a breadth of experience spanning over two decades (beginning with Oracle 4).

A former Oracle employee (Oracle Education and Consulting). Dr. Scalzo holds several Oracle Masters certifications, a BS, MS and PhD in Computer Science and a Masters Degree in Business Administration (MBA).

Dr. Scalzo is very active in the database community and he has written landmark articles for Oracle Technology Network (OTN), Oracle Informant, Oracle Magazine, PC Week, Linux Journal, Dell Power Edge Magazine, www.orafaq.com and www.linux.com

Dr Scalzo is also the author of many database books, including TOAD Handbook, Toad Pocket Reference for Oracle (Pocket Reference (O'Reilly) and Oracle DBA Guide to Data Warehousing and Star Schemas.

   


Ramon Graham
Ramon Graham is a senior product manager at Quest Software and is responsible for leading the development efforts for Toad for Oracle. He has been with Quest since 1999, progressing through several roles including product management, requirements analysis and technical support. Prior to Quest, Ramon worked in various IT development roles for several companies in Southern California on Oracle and Web development projects.

He holds a B.S. in Engineering Physics from the University of California Berkley and is a member of both Pragmatic Marketing and the Project Management Institute. Ramon speaks regularly at Oracle and Toad User Groups around the world.

Table of Contents:

 
  1. Introduction to Data Modeling
     
    1. Why Do We Model
    2. Everyone Data Models
    3. History of Data Modeling
    4. Common Data Modeling Terms
    5. Software Development Life Cycle
    6. Various Data Modeling Notations
    7. Numerous Data Modeling Tools
       
  2. Logical Data Models
     
    1. It’s All About the Business
    2. Information Gathering
    3. Entities
    4. Attributes
    5. Relationships
    6. Unique Identifiers
    7. Surrogate Identifiers
    8. Bridging or Intersection Entities
    9. Super and Sub-Types
    10. Other Business Rules
    11. Logical Sub-Models
       
  3. Physical Data Models
     
    1. It’s All About the Database
    2. Reverse Engineering
    3. Tables
    4. Columns
    5. Foreign Keys
    6. Primary and Unique Keys
    7. Other Constraints
    8. Surrogate Keys
    9. Additional Indexing
    10. Database Constraints
    11. Physical Sub-Models
       
  4. Translating Logical to Physical
     
    1. Basic Transformation Process
    2. Tailor to Database Platform Specifics
    3. Typical Information Systems Additions
    4. Common Pitfalls to Avoid

           i.     Many To Many Relationships

          ii.     Avoid Partial Unique Keys

           iii.     Avoid Candidate Key Loss

            iv.     Avoid Surrogate Key Loss

            v.     Avoid Partial Foreign Keys

            vi.     Avoid Indirect Foreign Keys

           vii.     Avoid Bogus Foreign Keys

          viii.     Problematic Relationships

            ix.     Using Proper Normal Forms

             x.     Super and Sub-Types Choices

 

 

  1. Reusable Modeling Patterns
     
    1. Not Everything is Custom
    2. Side Effects of Customization
    3. Benefits of Reusable Models
    4. Roles
    5. Assemblies
       
  2. Model Based Database Change Management
     
    1. All Databases Change with Time
    2. Key Change Management Goals
    3. Common Change Management  Tasks
    4. Change Management Handling Options
    5. Why Data Models Should be the Source
    6. Example Change Management via Model
       
  3. Dimensional Modeling
     
    1. Known Your Application
    2. Star Schema Design
    3. Dimension Hierarchies
    4. Avoid Snowflakes
    5. Common Aggregations
    6. Specialized Index Design
    7. Tuning Star Schema Queries
       
  4. Other Modeling Considerations
     
    1. Organizing Models
    2. Printing Large Models
    3. Keeping Models Current
    4. Running “JAD” Sessions
    5. Switching Modeling Tools
    6. Shared Modeling Among Teams
    7. Migrating Database Platforms
    8. Best Practices

 

Errata


 
   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks