H
heterogeneous data
Data stored in multiple formats (for example, data stored in a SQL Server database, a text file, and an Excel spreadsheet).
hierarchy
A logical tree structure that organizes the members of a dimension such that each member has one parent member and zero or more child members. See also dimension hierarchy, level.
HOLAP
See hybrid OLAP (HOLAP).
homogeneous data
Data that comes from multiple data sources that are all managed by the same software (for example, data that comes from several Exchange spreadsheets or data that comes from several SQL Server 2000 instances). A SQL Server 2000 distributed query is homogeneous if all the data comes from SQL Server 2000 instances.
hop
In data communications, one segment of the path between routers on a geographically dispersed network. A hop is comparable to one leg of a journey that includes intervening stops between the starting point and the destination. The distance between each of those stops (routers) would be a communications hop.
horizontal partitioning
The process of segmenting a single table into multiple tables based on selected rows. Each of the multiple tables has the same columns but fewer rows. See also partitioning.
HTML
See Hypertext Markup Language (HTML).
huge dimension
In Analysis Services, a dimension that contains more than approximately 10 million members. Huge dimensions must use relational OLAP (ROLAP) storage mode. See also very large dimension.
hybrid OLAP (HOLAP)
A storage mode that uses a combination of multidimensional data structures and relational database tables to store multidimensional data. Analysis Services stores aggregations for a HOLAP partition in a multi-dimensional structure and stores facts in a relational database. See also multidimensional OLAP (MOLAP), relational OLAP (ROLAP).
Hypertext Markup Language (HTML)
A system of marking up, or tagging, a document so that it can be published on the World Wide Web. Documents prepared in HTML include reference graphics and formatting tags. You use a Web browser (such as Microsoft Internet Explorer) to view these documents.