Data models

.

Relational Model
    1. The relational model uses a collection of tables to represent both data and the relationships among those data.
    1. Each table has multiple columns, and each column has a unique name.
    1. The data is arranged in a relation which is visually represented in a two dimensional table.
    1. The data is inserted into the table in the form of tuples (which are nothing but rows).
    1. A tuple is formed by one or more than one attributes, which are used as basic building blocks in the formation of various expressions that are used to derive a meaningful information.
    1. There can be any number of tuples in the table, but all the tuple contain fixed and same attributes with varying values.
    1. The relational model is implemented in database where a relation is represented by a table, a tuple is represented by a row, an attribute is represented by a column of the table, attribute name is the name of the column such as ‘identifier’, ‘name’, ‘city’ etc., attribute value contains the value for column in the row. Constraints are applied to the table and form the logical schema. In order to facilitate the selection of a particular row/tuple from the table, the attributes i.e. column names are used, and to expedite the selection of the rows some fields are defined uniquely to use them as indexes, this helps in searching the required data as fast as possible.
    1. All the relational algebra operations, such as Select, Intersection, Product, Union, Difference, Project, Join, Division, Merge etc. can also be performed on the Relational Database Model.
    1. Operations on the Relational Database Model are facilitated with the help of different conditional expressions, various key attributes, pre-defined constraints etc.

 

Other Data Models:
  1. The object-oriented data model is another data model that has seen increasing attention. It can be seen as extending the E-R model with notions object-oriented data model.

 

  1. The object-relational data model combines features of the object-oriented data model and relational data model.
  1. Semistructured data models permit the specification of data where individual data items of the same type may have different sets of attributes. This is in contrast with the data models mentioned earlier, where every data item of a particular type must have the same set of attributes. The extensible markup language (XML) is widely used to represent semistructured data.
    1. Historically, two other data models, the network data model and the hierarchical data model, preceded the relational data model. These models were tied closely to the underlying implementation, and complicated the task of modeling data. As a result they are little used now, except in old database code that is still in service in some places. They are outlined in Appendices A and B, for interested readers.

Back

 

 

DBMS & SQl by P. Muthulakshmi & v. vanthana