Choose Index below for a list of all words and phrases defined in this glossary.


Hierarchy / Hierarchies / Hierarchical Relationships

index | Index

Hierarchy / Hierarchies / Hierarchical Relationships - definitions

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 External


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/ External


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 External


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 External


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/ External


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 External 

 

 


Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: dqglossary@grcdi.nl