Hierarchy / Hierarchies / Hierarchical Relationships

Hierarchies - Describe organizational structures and logical parent-child relationships within the data (e.g. global corporation => country => region => district => market => individual store).

[Category=Database Management ]

Source: Northwest Database Services, 10 November 2009 07:54:10, http://www.nwdatabase.com/database-glossary-h.htm

---

These advertisers support this free service

---

Hierarchy - Defines a strata of summary dimension attributes arranged in parent-child relationships. For many warehouse tools, this pre-defines the manner in which the user can drill down to a lower level of detail. An example: within the Geography summary dimension might be Nation, State and ZIP Code. (data warehouse definition)

Source: The Data Governance Institute, 09 December 2009 09:14:43, http://www.datagovernance.com/glossary-governance/

---

Hierarchy - Organization of data into a logical tree structure. Dimensions can have one or more hierarchies. A Time dimension, for example, could have a Calendar hierarchy and a Fiscal hierarchy. Hierarchies contain levels, which organize data into a logical structure.

It is the combination of a multidimensional with a hierarchical view in Business Intelligence (BI) Software that allows users to grasp large amounts of data. If each member in a level has 5 to 10 children that are members at the next lower level, the user has a better chance of understanding the significance of the data.

Moving between the levels of a hierarchy is called drilling up and drilling down.

[Category=Data Warehousing ]

Source: SDG Computing Inc., 08 May 2010 09:07:17, SDG Computing, now offline

---

Hierarchical Relationships - Any dimension's members may be organized based on parent- child relationships, typically where a parent member represents the consolidation of the members which are its children. The result is a hierarchy, and the parent/child relationships are hierarchical relationships.

[Category=Information Management ]

Source: Information-Management.com, 21 June 2010 08:29:39, http://www.information-management.com/glossary/f.html

---

Hierarchical Relationships - Any dimension's members may be organized based on parent- child relationships, typically where a parent member represents the consolidation of the members which are its children. The result is a hierarchy, and the parent/child relationships are hierarchical relationships.

[Category=Data Management ]

Source: DataMentors, 21 August 2010 08:58:32, http://www.datamentors.com/News-and-Resources/Glossary.html

---

Hierarchy - A hierarchy defines the navigating path for drilling up and drilling down. All attributes in a hierarchy belong to the same dimension.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 12 December 2010 10:52:44, http://www.aexis.eu/DataWarehouse-Glossary/

---

Hierachy - Indicates order in which records or information from records or files will be selected. This usually relates to data suppression and how files are ranked or deduplication and how individuals or data fields are ranked.

[Category=Database Marketing ]

Source: DBG, 06 May 2011 07:55:47, http://www.dbg.co.uk/glossary/1015