Abstract
Multidimensional database concepts such as cubes, dimensions with hierarchies, and measures are a cornerstone of business intelligence. However, the standard data models and system implementations (OLAP) for multidimensional databases are sometimes not able to capture the complexities of advanced real-world application domains. This lecture will focus on how to manage such complex multidimensional data, including complex dimension hierarchies, complex measures, and integration of multidimensional data with complex external data. We will look at how complex multidimensional data emerge in complex application domains such as medical data, location-based services, music data, web data, and text data, and present solutions for these domains that support multidimensional business intelligence.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Abelló, A., Samos, J., Saltor, F.: YAM2: a multidimensional conceptual model extending UML. Information Systems 31(6), 541–567 (2006)
Agrawal, R., Gupta, A., Sarawagi, S.: Modeling multidimensional databases. In: ICDE, pp. 232–243 (1997)
Boussaid, O., Boukraa, D.: Multidimensional Modeling of Complex Data. In: Wang, J. (ed.) Encyclopedia of Data Warehousing and Mining, 2nd edn. (2008)
Cabibbo, L., Torlone, R.: Querying Multidimensional Databases. In: Cluet, S., Hull, R. (eds.) DBPL 1997. LNCS, vol. 1369, pp. 319–335. Springer, Heidelberg (1998)
Codd, E.F.: Providing OLAP (on-line analytical processing) to user-analysts: An IT mandate. E.F. Codd and Assoc. (1993)
Datta, A., Thomas, H.: A conceptual model and algebra for on-line analytical processing in decision support databases. In: WOITS, pp. 91–100 (1997)
Deliège, F., Chua, B.Y., Pedersen, T.B.: High-Level Audio Features: Distributed Extraction and Similarity Search. In: ISMIR, pp. 565–570 (2008)
Deliège, F., Pedersen, T.B.: Fuzzy Song Sets for Music Warehouses. In: ISMIR, pp. 21–26 (2007)
Deliège, F., Pedersen, T.B.: Using Fuzzy Lists for Playlist Management. In: Satoh, S., Nack, F., Etoh, M. (eds.) MMM 2008. LNCS, vol. 4903, pp. 198–209. Springer, Heidelberg (2008)
Deliège, F., Pedersen, T.B.: Position list word aligned hybrid: optimizing space and performance for compressed bitmaps. In: EDBT, pp. 228–239 (2010)
Dyreson, C.E., Pedersen, T.B., Jensen, C.S.: Incomplete information in multidimensional databases. In: Rafanelli, M. (ed.) Multidimensional Databases: Problems and Solutions. Idea Group Publishing (2003)
Dyreson, C.E.: Information retrieval from an incomplete data cube. In: VLDB, pp. 532–543 (1996)
Eisenberg, A., Melton, J.: SQL standardization: The next steps. SIGMOD Record 29(1), 63–67 (2000)
Gray, J., Chaudhuri, S., Bosworth, A., Layman, A., Venkatrao, M., Reichart, D., Pellow, F., Pirahesh, H.: Data cube: A relational aggregation operator generalizing group-by, cross-tab and sub-totals. DMKD 1(1), 29–54 (1997)
Gyssens, M., Lakshmanan, L.V.S.: A foundation for multi-dimensional databases. In: VLDB, pp. 106–115 (1997)
Hurtado, C.A., Gutiérrez, C., Mendelzon, A.O.: Capturing summarizability with integrity constraints in OLAP. TODS 30(3), 854–886 (2005)
Jagadish, H.V., Lakshmanan, L.V.S., Srivastava, D.: What can hierarchies do for data warehouses? In: VLDB, pp. 503–541 (1999)
Jensen, C.S., Kligys, A., Pedersen, T.B., Timko, I.: Multidimensional data modeling for location-based services. VLDBJ 13(1), 1–21 (2004)
Jensen, C.A., Mungure, E.M., Pedersen, T.B., Sørensen, K.: A Data and Query Model for Dynamic Playlist Generation. In: ICDE Workshops, pp. 65–74 (2007)
Jensen, C.A., Mungure, E.M., Pedersen, T.B., Sørensen, K., Deliège, F.: Effective Bitmap Indexing for Non-metric Similarities. In: Bringas, P.G., Hameurlain, A., Quirchmayr, G. (eds.) DEXA 2010, Part I. LNCS, vol. 6261, pp. 137–151. Springer, Heidelberg (2010)
Jespersen, S.E., Thorhauge, J., Pedersen, T.B.: A Hybrid Approach to Web Usage Mining. In: Kambayashi, Y., Winiwarter, W., Arikawa, M. (eds.) DaWaK 2002. LNCS, vol. 2454, pp. 73–82. Springer, Heidelberg (2002)
Kimball, R.: The Data Warehouse Toolkit. Wiley Computer Publishing (1996)
Lehner, W.: Modeling Large Scale OLAP Scenarios. In: Schek, H.-J., Saltor, F., Ramos, I., Alonso, G. (eds.) EDBT 1998. LNCS, vol. 1377, pp. 153–167. Springer, Heidelberg (1998)
Lehner, W., Ruf, T.: A redundancy-based optimization approach for aggregation in multidimensional scientific and statistical databases. In: DASFAA, pp. 253–262 (1997)
Lenz, H., Shoshani, A.: Summarizability in OLAP and statistical data bases. In: SSDBM, pp. 39–48 (1997)
Li, C., Wang, X.S.: A data model for supporting on-line analytical processing. In: CIKM, pp. 81–88 (1996)
Liu, X., Thomsen, C., Pedersen, T.B.: 3XL: Supporting efficient operations on very large OWL Lite triple-stores. Information Systems 36(4), 765–781 (2011)
Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data and Knowledge Engineering 59(2), 348–377 (2006)
Mendelzon, A.O., Vaismann, A.A.: Temporal queries in OLAP. In: VLDB, pp. 242–253 (2000)
Microsoft. Microsoft SQL server: Analysis services, http://www.microsoft.com/sql/technologies/analysis/default.mspx (Current as of March 26, 2012)
National Health Service. Read Codes version 3. NHS (1999)
Pedersen, T.B.: Warehousing The World: A Vision for Data Warehouse Research. Annals of Information Systems, Special Issue: New Trends in Data Warehousing and Data Analysis, 1–17 (2009)
Pedersen, T.B.: Research challenges for cloud intelligence: invited talk. In: EDBT/ICDT Workshops (2010)
Pedersen, T.B., Jensen, C.S.: Clinical data warehousing—a survey. In: MEDICON, p. 20.3 (1998)
Pedersen, T.B., Jensen, C.S.: Multidimensional data modeling for complex data. In: ICDE, pp. 336–345 (1999)
Pedersen, T.B., Jensen, C.S.: Research issues in clinical data warehousing. In: SSDBM, pp. 43–52 (1999)
Pedersen, T.B., Jensen, C.S., Dyreson, C.E.: Extending practical pre-aggregation in on-line analytical processing. In: VLDB, pp. 663–674 (1999)
Pedersen, T.B., Jensen, C.S., Dyreson, C.E.: A foundation for capturing and querying complex multidimensional data. Information Systems 26(5), 383–423 (2001)
Pedersen, D., Pedersen, J., Pedersen, T.B.: Integrating XML Data in the TARGIT OLAP System. In: ICDE, pp. 778–781 (2004)
Pedersen, D., Pedersen, T.B., Riis, K.: The Decoration Operator: A Foundation for On-Line Dimensional Data Integration. In: IDEAS, pp. 357–366 (2004)
Pedersen, D., Riis, K., Pedersen, T.B.: XML-Extended OLAP Querying. In: SSDBM, pp. 195–206 (2002)
Pérez, J.M., Berlanga Llavori, R., Aramburu Cabo, M.J., Pedersen, T.B.: A Relevance-Extended Multi-dimensional Model for a Data Warehouse Contextualized with Documents. In: DOLAP, pp. 19–28 (2005)
Pérez, J.M., Berlanga Llavori, R., Aramburu Cabo, M.J., Pedersen, T.B.: R-Cubes: OLAP Cubes Contextualized with Documents. In: ICDE, pp. 1477–1478 (2007)
Pérez, J.M., Berlanga Llavori, R., Aramburu Cabo, M.J., Pedersen, T.B.: Integrating Data Warehouses with Web Data: A Survey. IEEE TKDE 20(7), 940–955 (2008)
Pérez-Martínez, J.M., Berlanga Llavori, R., Aramburu Cabo, M.J., Pedersen, T.B.: Contextualizing data warehouses with documents. Decision Support Systems 45(1), 77–94 (2008)
Rafanelli, M., Shoshani, A.: Storm: A Statistical Object Representation Model. In: Michalewicz, Z. (ed.) SSDBM 1990. LNCS, vol. 420, pp. 14–29. Springer, Heidelberg (1990)
Spofford, G., Harinath, S., Webb, C., Huang, D.H., Civardi, F.: MDX-Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase. Wiley (2006)
Thomsen, C., Pedersen, T.B.: A Survey of Open Source Tools for Business Intelligence. International Journal of Data Warehousing and Mining 5(3), 56–75 (2009)
Thomsen, E.: OLAP Solutions: Building Multidimensional Information Systems. Wiley (1997)
Thomsen, E., Spofford, G., Chase, D.: Microsoft OLAP Solutions. Wiley (1999)
Trujillo, J., Palomar, M., Gómez, J., Song, I.-Y.: Designing Data Warehouses with OO Conceptual Models. IEEE Computer 34(12), 66–75 (2001)
Vaisman, A., Zimányi, E.: What Is Spatio-Temporal Data Warehousing? In: Pedersen, T.B., Mohania, M.K., Tjoa, A.M. (eds.) DaWaK 2009. LNCS, vol. 5691, pp. 9–23. Springer, Heidelberg (2009)
Vassiliadis, P.: Modeling multidimensional databases, cubes, and cube operations. In: SSDBM, pp. 53–62 (1998)
Vassiliadis, P., Sellis, T.K.: A survey of logical models for OLAP databases. SIGMOD Record 28(4), 64–69 (1999)
Yahoo! Yahoo!, http://www.yahoo.com (Current as of March 27, 2012)
Zurek, T., Sinnwell, M.: Data warehousing has more colours than just black and white. In: VLDB, pp. 726–729 (1999)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Pedersen, T.B. (2013). Managing Complex Multidimensional Data. In: Aufaure, MA., Zimányi, E. (eds) Business Intelligence. eBISS 2012. Lecture Notes in Business Information Processing, vol 138. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-36318-4_1
Download citation
DOI: https://doi.org/10.1007/978-3-642-36318-4_1
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-36317-7
Online ISBN: 978-3-642-36318-4
eBook Packages: Computer ScienceComputer Science (R0)