Introduction to Data Modeling. Presented by Bert Scalzo, PhD [email protected] About the Author. Oracle DBA for 18+ years, versions 4 through 10g Worked for Oracle Education & Consulting Holds several Oracle Masters (DBA & CASE) BS, MS, PhD in Computer Science and also an MBA
We provide application management solutions that enable customers to Design, Develop, Deploy, Manage and Maintain enterprise applications without downtime
A holistic approach of managing the entire
application not individual components
We surround the application infrastructure:
Microsoft Infrastructure Management
Would you build an office without a blueprint?
The Architect will create the first high level drawings to validate the concept with the client and then make a more detailed plan (i.e. the blueprint ) for the Contractor …
The Contractor will take thisblueprint and optimise it basedon technical constraints. The Contractor will then create the actual office.
Business Process Modeling
(OOM - UML)
Conceptual Data Modeling
(CDM – E/R)
Physical Data Modeling
QDesigner synchronizes models from all levels in a single tool
Some shops just treat this as one big “Design” task
Failure to discover & document attribute meta-data is where many data models fail
Failure to capture this meta-data results in ineffective databases: that’s where bad data is allowed
Next few slides show Quest’s QDesigner – other modeling tools will have similar screens
X means Exclusive
This Super/Sub meta-data only important for transforming conceptual to physical model…
(next data modeling e-seminar)
EACH entity1MAY2role_name31 OR MORE4entity5
MUST2 1 AND ONLY 14Read the Relationships
In a dependent association, one entity is partially identified by another. Each entity must have an identifier. In some cases, however, the attributes of an entity are not sufficient to identify an occurrence of the entity. For these entities, their identifiers incorporate the identifier of another entity with which they have a dependent association.
Employee’s can be Customers – right?
Carefully pick the DBMS generation options
Remember the Conceptual model’s meta-data?