General information Relative merits of the data models
U929-J-Z125-9-76 35
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007 18. Oktober 2007 Stand 11:29.48 Pfad: G:\vogt\fsc\ud s\Manuale\en\udsent_e\uds ent.k02
2.2.3 Relative merits of the data models
Comparing the data models with one another in terms of quality is difficult and possible only
from the perspective of a specific field of application. Especiall y an attempt to weight the
relative advantages and disadvantages of the models can be made only for a specific appli-
cation.
Basically, all data structures can be implemented with either of the two models.
Advantages of the relational model
The clear advantage of the relational model is its greater flexibility in regard to data str uc-
tures.
Since the application programs are not dependent on the data str uctures, the data struc-
tures can in many cases be changed without affecting the applications. Through the use of
views, the underlying data structures can be hidden complete ly from the users.
Advantages of the CODASYL model
A major advantage of the CODASYL model lies in the performance of the application.
The CODASYL model explicitly defines not only the record types and tables, but also their
relationships to one another. This means that the relationships between th e record types
must also be known to the applications. Since the applications build on the defined data
structures, the applications are optimally adjusted to t hem. This adaptation of the applica-
tions to the data structures known to the database system has a very favorable effect on the
applications’ performance.
Of course, this favorable influence of the data structures on the applications is achi eved at
the cost of flexibility. In many cases, alterations to the data structures have an effect on the
applications.
A further advantage of the CODASYL model lies in its monitoring of referential integrity.
A database system based on the CODASYL model automatical ly ensures that the defined
logical relationships between the record types are not violated .