Editing Data hierarchy

'''Data hierarchy''' refers to the systematic organization of data, often in a hierarchical form. Data organization involves characters, fields, records, files and so on.<ref name="Buchholz_1962"/><ref name="Laudon_2007"/> This concept is a starting point when trying to see what makes up data and whether data has a structure. For example, how does a person make sense of data such as 'employee', 'name', 'department', 'Marcy Smith', 'Sales Department' and so on, assuming that they are all related? One way to understand them is to see these terms as smaller or larger components in a hierarchy. One might say that Marcy Smith is one of the employees in the Sales Department, or an example of an employee in that Department. The data we want to capture about all our employees, and not just Marcy, is the name, ID number, address etc.

== Purpose of the data hierarchy ==
"Data hierarchy" is a basic concept in data and [[database theory]] and helps to show the relationships between smaller and larger components in a database or data file.  It is used to give a better sense of understanding about the components of data and how they are related.

It is particularly important in databases with [[referential integrity]], [[third normal form]], or [[perfect key]].  "Data hierarchy" is the result of proper arrangement of data without redundancy.  Avoiding redundancy eventually leads to proper "data hierarchy" representing the relationship between data, and revealing its relational structure.

== Components of the data hierarchy ==
The components of the data hierarchy are listed below.

A [[field (computer science)|data field]] holds a single fact or attribute of an entity. Consider a date field, e.g. "19 September 2004". This can be treated as a single date field (e.g. birthdate), or three fields, namely, day of month, month and year.

A [[record (computer science)|record]] is a collection of related fields. An Employee record may contain a name field(s), address fields, birthdate field and so on.

A [[Computer file|file]] is a collection of related records. If there are 100 employees, then each employee would have a record (e.g. called Employee Personal Details record) and the collection of 100 such records would constitute a file (in this case, called Employee Personal Details file).

Files are integrated into a [[database]].<ref name="Marston"/> This is done using a Database Management System. If there are other facets of employee data that we wish to capture, then other files such as Employee Training History file and Employee Work History file could be created as well.

== Illustration of the data hierarchy ==
An illustration of the above description is shown in this diagram below:

[[File:Data Hierarchy diagram showing Employee database example by JeffTan.gif|500px|Data Hierarchy diagram]]

The following terms are for better clarity. With reference to the example in the above diagram:

Data field label = Employee Name or EMP_NAME

Data field value = Jeffrey Tan

The above description is a view of data as understood by a user e.g. a person working in Human Resource Department.

The above structure can be seen in the [[hierarchical model]], which is one way to organize data in a database.<ref name="Laudon_2007"/>

In terms of data storage, data fields are made of [[byte]]s and these in turn are made up of [[bit]]s.

==See also==
* {{annotated link|Data dictionary}}
* {{annotated link|Data element}}
* {{annotated link|Data acquisition}}

==References==
{{Reflist|refs=
<ref name="Laudon_2007">{{cite book |author-last1=Laudon |author-first1=Kenneth C. |author-last2=Laudon |author-first2=Jane P. |title=Management Information Systems - Managing the Digital Firm |year=2007 |edition=9 |publisher=[[Pearson Prentice Hall]] |location=Upper Saddle River, USA |isbn=978-0-13-157984-2 |pages=226, 229}}</ref>
<ref name="Marston">{{cite web |author-last=Marston |author-first=Tony |title=The Relational Data Model - Normalisation and Effective Database Design |url=http://www.database-books.us/databasesystems_0011.php |access-date=2013-08-20 |archive-url=https://web.archive.org/web/20120117020235/http://www.database-books.us/databasesystems_0011.php |archive-date=2012-01-17 |url-status=dead }}</ref>
<ref name="Buchholz_1962">{{citation |title=Planning a Computer System – Project Stretch |author-first1=Gerrit Anne |author-last1=Blaauw |author-link1=Gerrit Anne Blaauw |author-first2=Frederick Phillips |author-last2=Brooks, Jr. |author-link2=Frederick Phillips Brooks, Jr. |author-first3=Werner |author-last3=Buchholz |author-link3=Werner Buchholz |editor-first=Werner |editor-last=Buchholz |editor-link=Werner Buchholz |publisher=[[McGraw-Hill Book Company, Inc.]] / The Maple Press Company, York, PA. |lccn=61-10466 |year=1962 |chapter=4: Natural Data Units |pages=39–40 |chapter-url=http://archive.computerhistory.org/resources/text/IBM/Stretch/pdfs/Buchholz_102636426.pdf |access-date=2017-04-03 |url-status=dead |archive-url=https://web.archive.org/web/20170403014651/http://archive.computerhistory.org/resources/text/IBM/Stretch/pdfs/Buchholz_102636426.pdf |archive-date=2017-04-03 }}</ref>
}}

{{DEFAULTSORT:Data Hierarchy}}
[[Category:Data modeling]]