NDLI: Time-HOBI: indexing dimension hierarchies by means of hierarchically organized bitmaps

Please wait, while we are loading the content...

Time-HOBI: indexing dimension hierarchies by means of hierarchically organized bitmaps

Content Provider	ACM Digital Library
Author	Wrembel, Robert Morzy, Tadeusz Chmiel, Jan
Abstract	One of the important research and technological problems in data warehousing is the optimization of star queries. So far, most of the research focused on optimizing such queries by means of join indexes and bitmap join indexes. In this paper we propose an index, called Time-HOBI, for optimizing star queries and computing aggregates along dimension hierarchies. Time-HOBI, created on a dimension hierarchy, is composed of: (1) a hierarchically organized bitmap index (HOBI), one bitmap index for one dimension level and (2) a time index (TI) that implicitly encodes time in every dimension. HOBI allows to quickly search for fact rows that fulfill selection criteria. With the support of TI joining a fact table with the Time dimension is avoided. Time-HOBI was implemented and evaluated experimentally on a real dataset, coming from the biggest East-European Internet auction platform Allegro.pl. The experiments show that Time-HOBI offers a promising star query performance.
Starting Page	69
Ending Page	76
Page Count	8
File Format	PDF
ISBN	9781450303835
DOI	10.1145/1871940.1871957
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	2010-10-30
Publisher Place	New York
Access Restriction	Subscribed
Subject Keyword	Indexing dimensions Bitmap index Hierarchical index Data warehouse Star query
Content Type	Text
Resource Type	Article

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in