The Relational and CODASYL models are examples of two different approaches by which a Database Management System will be classified. Make a detailed comparison of each of these models, indicating clearly the relative advantages and disadvantages of each.
What will be an ideal response?
CODASYL
– records in chains/rings
– parent-child links
– many parents for a child
– ordering of all records
– fixed access paths
– potential for automatic referential integrity.
Relational
– set of tables (as perceived by users)
– rows/columns
– variety of possible storage structures
– no repeating groups
– no links/pointers
– use of join columns.
CODASYL Data Model Advantages
longevity and availability of DBMSs for this model
– all data relationships can be modeled
– standards exist
– good performance
– data independence.
CODASYL Data Model Disadvantages
– complex navigation
– complexity.
Relational Data Model Advantages
– simplicity
– high level of data independence
– strong theoretical foundation.
Relational Data Model Disadvantages
– performance needs improvement
– referential integrity not supported.
You might also like to view...
In the cases when you encounter situations where some variables are related, it is easier and more efficient to treat the related variables separately.
Answer the following statement true (T) or false (F)
Both the Form Header and Form Footer sections display on every ________ page
A) query B) table C) report D) form
A PSO configured for a __________ takes precedence over a PSO configured for a ___________ to which the user belongs
a. Group, domain b. Domain, group c. User, group d. Distribution group, security group
What are the four tasks to be performed by an assembler?
What will be an ideal response?