Hierarchical Model

A hierarchical database is a kind of database management system that links records together in a tree data structure 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 between different types of data can make it 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.

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

See also

Some well known hierarchical databases

External links

 

<< PreviousWord BrowserNext >>
lord kitchener
ibm 1720
faithless
poppy mallow
cookbook
angel cake
caroline records
flag of the philippines
urban dictionary
proteales
business jet
paul manship
nosferatu (world of darkness)
exit (performance art group)
welland, ontario
koko the clown
jules lger
trois rivires, quebec
seigneurial system
fumariaceae
swinburne university of technology
ranunculaceae
john harriman
foreign relations of china
how the west was won
austrobaileyales
new river gorge bridge
mars bar
the comic strip
mask
toreador
music of the netherlands
matador
einar rn benediktsson
treasury
sabotage (movie)
ninety nine (card game)
heterophobia
why cows moo
illustration
music of hungary
revenue
music of romania
ceratophyllum