StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Hierarchical Database Models - Research Paper Example

Cite this document
Summary
[Name of the Writer] [Name of the Professor] [Name of the Course] [Date] Hierarchical Database Model The data is organized in a tree like fashion in hierarchical database model. The data is arranged in parent-child fashion. The main theme of this model is the containment of repeating information in the child nodes as data segments…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER91.5% of users find it useful
Hierarchical Database Models
Read Text Preview

Extract of sample "Hierarchical Database Models"

Download file to see previous pages

Along with this the data related to the children of an employee would be considered as child data segment. These segments would be linked with the employee record on the basis of 1:n mapping. Further collective instances of records are like tables in relational model. This arrangement contains parent records or nodes which further linked with children data segments, row wise. The popularity of hierarchical databases was established in late 1960s. Network Database Model In the network database model it is allowed to create parent-child relationship on many to many basis.

This model follows the organization of graph in which there can be multiple interconnection of a node with other nodes. A conference named CODASYL (Conference on Data Systems Language) was held in 1971 to formally state the properties of network database model. This data model gained a side by side popularity along with the hierarchical model almost. The concept of set is the basic construct in this model. A set comprises of three components namely, owner type record, name and member type record.

A member type record is allowed to be associated with multiple sets. This enables the implementation of more the concept of more than one parents. In this database model the network of records’ relationships is indicated through pairwise sets. Relational Model The relational database model is the basis of Relational Database Management System (RDBMS). The theory and concept of relational model was given by a statistician named E.F. Codd. At the core of the relational model lies the process of normalization.

There are more than 5 levels of normalization but usually a 3 levels normalized database is considered as a relational database. The basic procedure comprises of the following steps: Gathering related data in a tabular manner as a flat file. Each row has to represent a unique record. Identification of separate columns and fields to manage data properly. Splitting the flat file into multiple tables in order to curb redundancy. Establishment of relationship by declaring and link primary and foreign keys.

Enforcement of referential integrity constraints is the part of relationship establishment. There are certain properties of Relational Database Tables which are as follows, Atomic values (the values listed under a single field cannot be decomposed further) Unique records (The data in a rows represents a unique instance of an entity and duplication is not allowed). Homogenous field data (The type of data listed under a field is always same). The columns can be arranged in any manner. Same rule goes with the rows.

The results of queries do not get effected due to the any sequential arrangements of either columns or rows. The label of each field is always unique. This assures correct referral of fields in queries. Fields can be set as keys to identify records uniquely. A key may also be composed of more than one field. There are three types of relationships namely One to One, One to Many and Many to Many. The Many to Many relationship is implemented via two decomposed One to many relationships with an intermediate joining table.

One to Many relationships are usually represented through the association of two related tables connected in a Master/Transaction fashion. Collective and comprehensive results can be acquired against the queries performed on joined tables (multiple connected tables). The key in a table (Master table) is referred to as

...Download file to see next pages Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Hierarchical Database Models Research Paper Example | Topics and Well Written Essays - 750 words”, n.d.)
Retrieved from https://studentshare.org/information-technology/1437735-database-models
(Hierarchical Database Models Research Paper Example | Topics and Well Written Essays - 750 Words)
https://studentshare.org/information-technology/1437735-database-models.
“Hierarchical Database Models Research Paper Example | Topics and Well Written Essays - 750 Words”, n.d. https://studentshare.org/information-technology/1437735-database-models.
  • Cited: 1 times

CHECK THESE SAMPLES OF Hierarchical Database Models

Information System Reasarch Project

ifferent data base models A bird's eye view of the database models popularly used today is (2):Flat model: This database is made up of a single, two-dimensional collection of data elements in which all the data programmed in is assumed to have similar values and all the objects row-wise are assumed to be related to each other.... There are several ways of setting up a schema to organize a database; these are referred to as data models or data base models (5)....
3 Pages (750 words) Article

Images and Database Technology

Digital images are widely used instead of traditional pictures, photographs, movies, etc. The research paper different aspects of database technology, existing models of database management and their advantages compared to traditional way of data processing.... Information systems differ from the file system as they allow the following features: database Management Systems (DBMS) are the applied informational systems for management and processing of structured information....
12 Pages (3000 words) Essay

Database Architecture and Administration

The aim of this essay is to present an evolutionary history of various database models over the four decades of their existence.... Due to these limitations, navigational database models became outdated by 1980s, though a form of the hierarchical model is still used in XML applications.... As the paper declares the navigational Model encompasses the “network model” and “hierarchical model” of database interfaces.... The network model was developed by Charles Bachman in 1971 to define and set a standard for database systems....
9 Pages (2250 words) Essay

Managing Business Information

It also highlights the database and spreadsheets models, which are used in the recent years for development of the informative system in an organisation.... Even so, while defining database, it can be outlined as the prime technique for developing an information system in the modern business process.... The spreadsheets and database are highly used by organisations for proper running of their business.... However, it is noticed that the use of database is preferred against that of spreadsheets, in present business scenario....
5 Pages (1250 words) Assignment

Structured Query Language: History, and Usage

here have essentially been three types of database models – Hierarchical Databases, Network Databases, and Relational Databases.... Both the hierarchical and network models had limitations.... SQL is an open standard database language.... SQL is supported by all the major database players such as Oracle, Sybase, Microsoft SQL Server, IBM DB2, MySQL, Microsoft Access, and Lotus Approach.... SQL is used in varied environments of client-server programming, web programming, and host-based database programming....
5 Pages (1250 words) Report

Effective Management of Data Tables

According to the database administrators, flat models are suitable for native format storage models as well as stand-alone applications.... The most common types of flat models include spreadsheets and the Comma Separated Values (CSV).... The paper 'Effective Management of Data Tables' presents some of the relational database systems which include SQLite, Oracle, IBM DB2, Ms.... Relational database systems are very common in most of the business organizations....
7 Pages (1750 words) Case Study

Database Management System

This review ''database Management System'' are exceptionally composed software applications that connect with the user, different applications, and the database itself to catch and dissect data.... A few functions of a DBMS perform to guarantee data trustworthiness and consistency of data in the database.... Such as data word reference management, data stockpiling management, data change and presentation, security management, multiuser access control, reinforcement and recuperation management, data trustworthiness management, database access dialects, and application programming interfaces, database correspondence interfaces, and transaction management....
5 Pages (1250 words) Case Study

Relational Database Management Systems and their Alternatives

However, like other database models, a relational database also supports several other functions such as insert, update and delete (Oloke & Edwards, 2008; Couchbase, 2013; Monash, 2008).... The basic objective of this review ''Relational database Management Systems and their Alternatives'' is to discuss some of the basic aspects of a relational database management system.... nbsp;… In this scenario, relational database management systems provide an excellent support to companies for the management of their complex data in an effective and efficient manner (Jingmin & Wang, 2001)....
6 Pages (1500 words) Literature review
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us