Regular Sparsity in OLAP System

Kalinka Kaloyanova () and Ina Naydenova ()
Additional contact information
Kalinka Kaloyanova: St. Kliment Ohridski University of Sofia
Ina Naydenova: St. Kliment Ohridski University of Sofia

A chapter in Emerging Themes in Information Systems and Organization Studies, 2011, pp 115-123 from Springer

Abstract: Abstract One of the primary challenges of storing multidimensional data is the degree of sparsity that is often encountered. Because the extremely sparse cubes are frequent phenomenon, OLAP engines offer different methods of increasing the performance of sparse cubes, but all of these methods do not take account of the sparsity nature and did not divide the sparsity into any types. Our experience leads us to a following division of the empty areas in the multidimensional cubes: (a) areas that are empty because of the semantics of the business (the semantics enforces lack of value) and (b) areas that are empty by a chance. To formally distinguish these types of sparsity, we introduce a new object (“regular sparsity map”) which provides business analysts with the ability to define rules and place data constraints over the multidimensional cube. In this paper we present our regular sparsity map editor and discuss how it can be used for the purpose of data errors detection and selection of relevant dimension elements.

Keywords: Empty Cell; Rectangular Domain; Business Rule; Business Intelligence System; Travel Insurance (search for similar items in EconPapers)
Date: 2011
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:sprchp:978-3-7908-2739-2_9

Ordering information: This item can be ordered from
http://www.springer.com/9783790827392

DOI: 10.1007/978-3-7908-2739-2_9

Access Statistics for this chapter

More chapters in Springer Books from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().