Database management system hierarchical model // IT Management Solutions

Database management system hierarchical model

We analyzed the pros and cons of the relational and network database model. We discussed how each model works and highlights the strengths, weaknesses and capabilities within each model. The differences between these two models can lead to the success or failure in developing an application.

The following discusses how each model works and highlights the strengths, weaknesses and capabilities within each model. The differences between these two models can lead to the success or failure in developing an application.

Relational Database Model

You are wanting to see your favorite movie with your favorite Bruce Willis. On second thought, you want to listen to his solo country album (The Return of Bruno). The iPhone’s spotlight search is nice. Type in “Bruce Willis” as the keyword, and the media player will seamlessly find both their music and movies – two different categories – stored on the device.

Relational Data Model

Common operations like the ones above usually make use of a relational database management system (RDBMS). The database, let’s call it Media Collection, defines three tables ARTIST, ALBUM and MOVIE where the names of the artists, albums and movie titles are stored respectively. When a particular artist is selected, like Bruce Willis in our example, a SQL query is issued to retrieve all the albums and movie titles that belong to the selected artist. SQL- a typical source of issuing the data in the body. The data returned is displayed on the iPhone screen, usually in alphabetical order. Speaking of a different view of the data, such as data visualization , we can cite as an example TIBCO. The main plus EntranceConsulting TIBCO services - analysis of data at high speed.

Relational Data Model Weaknesses

Network Data Model

These seemingly simple steps reveal two fundamental weaknesses inherent with the relational data model. The first weakness is the fact that each relationship requires duplicate columns in both tables associated with it. For example, both the ARTIST and ALBUM tables must contain and thus maintain a column that stores the names of the artists so a link between an artist and their albums can be established. This means extra storage space as well as programming overhead are required to keep the two columns “in sync.” Changing the name of an artist means that all the ALBUM entries for that artist need to have their “artist name” column updated.

The second weakness, and the more relevant aspect of this article, is the fact that a single relationship may only contain two tables, the primary key (main) table and the foreign key (referencing) table. Within the Music Collection database, both the ALBUM table and the MOVIE table need to reference the ARTIST table. Due to this limitation, two separate relationships need to be defined; one that includes the ALBUM table reference to the ARTIST table and one that has the MOVIE table referencing the ARTIST table.

See also:
  • kinel enterprises ia-phone

You might also like

Internet Domain Name Functions

by gnostic2012

March 14, 2014
NTIA Announces Intent to Transition Key Internet Domain Name Functions

To support and enhance the multistakeholder model of Internet policymaking and governance, the U.S. Commerce Department’s National Telecommunications and Information Administration (NTIA) today announces its intent to transition key Internet domain name functions to the global multistakeholder community.
As the first step, NTIA is asking the Internet Corporation for Assigned Names and Numbers (ICANN) to convene global stakeholders to develop a proposal to transition the current role played by NTIA in the coordination of the Internet’s domain name system (DNS)

eBooks (PHI Learning Private Limited)


— 中关村在线
CMDB(Configuration Management Database) 配置管理数据库(以下简称:CMDB),将IT基础架构的所有组件存储为配置项,维护每个配置项的详细数据,维护各配置项之间的关系数据以及事件、变更历史等管理数据。通过将这些数 ..

Springer Formal Methods in Systems Biology: First International Workshop, FMSB 2008, Cambridge, UK, June 4-5, 2008, Proceedings (Lecture Notes in Computer Science / Lecture Notes in Bioinformatics)
Book (Springer)
PHI Engineering Economics, Second Edition
eBooks (PHI)
PHI Design and Analysis of Experiments
eBooks (PHI)
Springer Independent Component Analysis and Signal Separation: 8th International Conference, ICA 2009, Paraty, Brazil, March 15-18, 2009, Proceedings (Lecture ... Computer Science and General Issues)
Book (Springer)

Related Posts

Copyright © . All Rights Reserved