Database Reference
In-Depth Information
Determine information requirements.
Identify data to be collected and stored.
Review data access patterns.
Establish data volumes.
Organize information requirements into data groups.
Document information requirements.
Design
Logical Design
Create semantic data model.
Form user data views from data groups defined in the requirements definition
phase.
Integrate data views into the semantic data model.
Include design of the following in the semantic data model:
Business object sets or entity types
Relationships between objects or entities
Generalization and specialization of objects or entities
Any special object types and relationships
Complete the semantic data model diagram.
Create conventional data model (relational).
Select method for creating conventional data model.
If applicable, use model transformation method:
Transform object sets into relations.
Map attributes to columns.
Map instance identifiers to primary keys.
Transform relationships by including foreign keys.
If applicable, use normalization method:
Normalize into fundamental normal forms.
Normalize into higher normal forms.
Consolidate normalized data structures into relational data model.
Physical Design
Transform the logical data model into the physical data model.
Map components of relations into files, data blocks, records, and file.
Set the proper file organization for each file.
Define key and other constraints.
Establish performance mechanisms.
Define primary indexes.
Define secondary indexes.
Search WWH ::
Custom Search