SHARE
SPREAD
HELP

The Tradition of Sharing

Help your friends and juniors by posting answers to the questions that you know. Also post questions that are not available.


To start with, Sr2Jr’s first step is to reduce the expenses related to education. To achieve this goal Sr2Jr organized the textbook’s question and answers. Sr2Jr is community based and need your support to fill the question and answers. The question and answers posted will be available free of cost to all.

 

#
Authors:
Elmasri Navathe
Chapter:
System Concepts And Architecture
Exercise:
Review Questions
Question:2 | ISBN:9780133970777 | Edition: 7

Question

Discuss the main categories of data models. What are the basic differences
among the relational model, the object model, and the XML model?

 

TextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbook

Answer

a collection of concepts that
can be used to describe the structure of a database is a data model.

main categories of data model are:categorize according to the types of concepts they use to describe the database structure. 

High-level or conceptual data models :concepts such as entities, attributes, and relationships.An entity represents a real-world object or concept, such as an employee or a project  that is described in the database. An attribute represents some property of an entity, such as the employee’s name  or  salary.Arelationship among two or more entities represents an association among the entities, for example, a works-on relationship between an employee and a project. 

low-level or physical data models:concepts that describe the details of how data is stored on the computer storage media. Concepts provided by physical data models are generally meant for computer specialists, not for end users.To overcome this problem we use representational data models.These are easily understood by end users but that are not too far removed from the way data is organized in computer storage. Representational data models hide many details of data storage on disk but can be implemented on a computer system directly.Representational data models represent data by using record structures and hence are .sometimes called record-based data models.
We can regard the object data model as an example of a new family of higher-level.

Physical data models describe how data is stored as files in the computer by representing information such as record formats, record orderings, and access paths. An access path is a  search for particular database records efficient, such as indexing or hashing.  An index is an example of an access path that allows direct access to data using an index term or a keyword. 

Another class of data models is known as self-describing data models. The data storage in systems based on these models combines the description of the data with the data values themselves. In traditional DBMSs, the description (schema) is separated from the data. These models include XML as well as many of the key-value stores and NOSQL systems that were recently created for managing big data.

 

0 0

Discussions

Post the discussion to improve the above solution.