Skip to main content
SpringerLink
Log in

Multiversion Spatio-temporal Telemetric Data Warehouse

  • Conference paper
Book cover Advances in Databases and Information Systems (ADBIS 2009)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 5968))

Abstract

One of the crucial problems characterizing current data warehouses is the implicit assumption of dimension invariance with respect to the time dimension. This assumption inhibits the proper treatment of changes in dimension data. Meanwhile, we can give examples indicating that it is necessary to take into consideration the modifications of dimension data - ignoring such changes leads to incorrect analysis which then results in wrong decisions. This article describes the implemented temporal telemetric data warehouse system, which provides the user with the ability to query about the time interval embracing many structure versions. The system also informs the user about modifications which occurred in separated structure versions.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 74.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 99.00
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Baril, X., Bellahsène, Z.: Designing and Managing an XML Warehouse. In: Akmal, B., Chaudhri, A., Zicari, R., Awais Rashid, A. (eds.) XML Data Management. Native XML and XML-Enabled Database Systems, pp. 455–474. Addison-Wesley Professional, Reading (2003)

    Google Scholar 

  2. Bebel, B., Eder, J., Koncilia, C., Morzy, T., Wrembel, R.: Creation and Management of Versions in Multiversion Data Warehouse. In: ACM SAC, Nicosia, pp. 717–723 (2004)

    Google Scholar 

  3. Bellhase, Z.: Schema Evolution in Data Warehouses. Knowledge and Information Systems 4, 283–304 (2002)

    Article  Google Scholar 

  4. Eder, J., Koncilia, C.: Changes of Dimension Data in Temporal Data Warehouses. In: Kambayashi, Y., Winiwarter, W., Arikawa, M. (eds.) DaWaK 2001. LNCS, vol. 2114, p. 284. Springer, Heidelberg (2001)

    Chapter  Google Scholar 

  5. Golfarelli, M., Lechtenbörger, J., Rizzi, S., Vossen, G.: Schema Versioning in Data Warehouses. In: Wang, S., Tanaka, K., Zhou, S., Ling, T.-W., Guan, J., Yang, D.-q., Grandi, F., Mangina, E.E., Song, I.-Y., Mayr, H.C. (eds.) ER Workshops 2004. LNCS, vol. 3289, pp. 415–428. Springer, Heidelberg (2004)

    Google Scholar 

  6. Gorawski, M., Dyga, A.: Indexing of Spatio-Temporal Telemetric Data Based on Adaptive Multi-Dimensional Bucket Index. Fundamenta Informaticae 90(1-2) (2009)

    Google Scholar 

  7. Gorawski, M., Gorawski, M.J.: Multiversion spatio-temporal data warehouse. In: Grundspenkis, J., Morzy, T., Vossen, G. (eds.) ADBIS 2009. LNCS, vol. 5739, pp. 291–297. Springer, Heidelberg (2009)

    Google Scholar 

  8. Gorawski, M., Malczok, R.: On efficient storing and processing of long aggregate lists. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2005. LNCS, vol. 3589, pp. 190–199. Springer, Heidelberg (2005)

    Chapter  Google Scholar 

  9. Gorawski, M.: Extended Cascaded Star Schema and ECOLAP Operations for Spatial Data Warehouse. In: Corchado, E., Yin, H. (eds.) IDEAL 2009. LNCS, vol. 5788, pp. 251–259. Springer, Heidelberg (2009)

    Chapter  Google Scholar 

  10. Jensen, C.S., Dyreson, C.E.: The Consensus Glossary of Temporal Database Concepts. In: Temporal Databases, Dagstuhl (1997)

    Google Scholar 

  11. Mendelzon, A.O., Vaisman, A.A.: Temporal Queries in OLAP. In: 26th International Conference on Very Large Data Bases, VLDB 2000, Egypt, pp. 242–253 (2000)

    Google Scholar 

  12. Nabil, A., Vijayalakshmi, A., Yesha, Y., Yu, S.: Efficient Storage and Management of Environmental Information. In: IEEE Symposium on Mass Storage Systems (2002)

    Google Scholar 

  13. Papadias, D., Kalnis, P., Zhang, J., Tao, Y.: Efficient OLAP Operaions in Spatial Data Warehouses. In: Advances in Spatial and Temporal Databases, 7th International Symposium, SSTD, CA (2001)

    Google Scholar 

  14. Papadias, D., Tao, Y., Kalnis, P., Zhang, J.: Indexing Spatio-Temporal Data Warehouses. In: 18th International Conference on Data Engineering, ICDE, San Jose (2002)

    Google Scholar 

  15. Tao, Y., Papadias, D.: Historical spatio-temporal aggregation. ACM Transactions on Information, TOIS 23, 61–102 (2005)

    Article  Google Scholar 

  16. Vaisman, A.A., Mendelzon, A.O., Ruaro, W., Cymerman, S.G.: Supporting Dimension Updates in an OLAP Server. In: Pidduck, A.B., Mylopoulos, J., Woo, C.C., Ozsu, M.T. (eds.) CAiSE 2002. LNCS, vol. 2348, pp. 67–82. Springer, Heidelberg (2002)

    Chapter  Google Scholar 

  17. Wrembel, R., Koncilia, C.: Data Warehouses and OLAP: Concepts, Architectures and Solutions. In: Advances in Data Warehousing and Mining, p. 332. Idea Group, Inc., USA (2007)

    Google Scholar 

  18. Wrembel, R., Morzy, T.: Managing and Querying Versions of Multiversion Data Warehouse. In: Ioannidis, Y., Scholl, M.H., Schmidt, J.W., Matthes, F., Hatzopoulos, M., Böhm, K., Kemper, A., Grust, T., Böhm, C. (eds.) EDBT 2006. LNCS, vol. 3896, pp. 1121–1124. Springer, Heidelberg (2006)

    Chapter  Google Scholar 

  19. Wrembel, R.: Management of Schema anad Data Evolution in Multiversion data Warehouse. Dissertation 411, Pub. House of Poznan Univ. of Technology, p. 338 (2007)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institute of Computer Science, Silesian University of Technology, Akademicka 16, 44-100, Gliwice, Poland

    Marcin Gorawski

Authors
  1. Marcin Gorawski
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Dept. of Systems Theory and Design, Riga Technical University, Meza str 1/4, LV 1048, Riga, Latvia

    Janis Grundspenkis

  2. Institute of Applied Computer Systems, Riga Technical University, 1 Kalku, LV-1658, Riga, Latvia

    Marite Kirikova

  3. Dept. of Informatics, Aristotle University, 54124, Thessaloniki, Greece

    Yannis Manolopoulos

  4. Division of Applied Computer Systems Software, Riga Technical University, Meza str 1/4, LV 1048, Riga, Latvia

    Leonids Novickis

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Gorawski, M. (2010). Multiversion Spatio-temporal Telemetric Data Warehouse. In: Grundspenkis, J., Kirikova, M., Manolopoulos, Y., Novickis, L. (eds) Advances in Databases and Information Systems. ADBIS 2009. Lecture Notes in Computer Science, vol 5968. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-12082-4_9

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-12082-4_9

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-12081-7

  • Online ISBN: 978-3-642-12082-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation