Benefits of using the relational database management systems than the earlier systems
The earlier database
management systems where hierarchical and network models. There are
many disadvantages of using them when compared to the relational database
management systems that are available now-a-days. In the earlier models
a child segment could not have more than one parent segment. In relational
database management systems this is possible. The relational database
management systems developed by Codd is superior to the earlier systems.
The features of the relational database systems are worthy to note. They have atomic values as their column values. All the columns in a particular table have unique names and the column values belong to one group for a particular column. It is not important that the order of the columns and rows to be in a particular order. The sequence of the columns and the rows is not at all important.
The tables and their relationships are defined for a particular table. You should know that a table has a set of records and the same columns in each row. It is not necessary that all the columns in a particular row should have values. Null values are also allowed which means that it is not compulsory to store a value in it. These are all defined in the table.
A table can have a key. Mostly they have a key in them. This key is important for linking it to other tables. Based on this key only you will be retrieving values from other tables that have the same key value. Having a key in the table enables you to retrieve values faster than in a table that does not have one. Indexing is another factor that you should consider in a table that is used to search for values. For example if you are going to search for a term in a text field, then it is wise to create an index on that column so that the search is performed faster.
of going for object oriented database management systems | Benefits
of using the relational database management systems than the earlier
How the relational database management systems differ from the earlier
systems | Modern
database Management How to go about it | Some
of the object oriented database management system to ponder upon
need for a configuration management database | The
need for a contact management database | The
need to go for a Database Management Software |
Understanding Distributed Database Management | Understanding
the definition of object oriented database management | Understanding
the types of Database Management Systems | What
is database management | When
to go for a Distributed Database Management System |
Copyright - © 2005 - 2017 - www.management-hub.com