Encyclopedia > Hierarchical model

  Article Content

Hierarchical model

Hierarchical Database:
 

A kind of database management system that links records together like a family tree such that each record type has only one owner, e.g. an order is owned by only one customer. Hierarchical structures were widely used in the first mainframe database management systems. However, due to their restrictions, they often cannot be used to relate structures that exist in the real world.

Hierarchical relationships among different types of data.

can be very easy to answer some questions, but very difficult to answer others if one-to-many relationship is violated (e.g., a patient can have more than one physician) then the hierarchy becomes a network.

Hierarchical Terms •Field “smallest unit of data”

•Segment “groups of fields; nodes of the tree structure”

•Data base record “a collection of related segments; a particular tree structure”

•Data base “composed of database records”

•Data base description “how data base records are defined; set of assembly-language macro instructions”

•Root “first segment”

•Sequence field “one field in each segment used to order the occurrences of a given type”



All Wikipedia text is available under the terms of the GNU Free Documentation License

 
  Search Encyclopedia

Search over one million articles, find something about almost anything!
 
 
  
  Featured Article
Battle Creek, Michigan

... from 18 to 24, 29.5% from 25 to 44, 21.0% from 45 to 64, and 13.5% who are 65 years of age or older. The median age is 35 years. For every 100 females there are 91.9 ...

 
 
 
This page was created in 49.8 ms