Skip to main content

Canonical Data Model for Data Warehouse

  • Conference paper
  • First Online:
New Trends in Databases and Information Systems (ADBIS 2016)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 637))

Abstract

In the frame of our approach to data integration an extensible canonical model is developed. In the present paper we consider an extension of the canonical model to support materialized integration of data during data warehouse creation. The considered data warehouse is based on the concept of grid file. To extract data from several sources, to create the materialized view, and to effectively organize queries on the multidimensional data a computationally complete language is used.

This work was supported by the RA MES State Committee of Science, in the frames of the research project N 15T-18350.

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
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

Notes

  1. 1.

    The detailed discussion of the canonical model query language is beyond the topic of this paper.

References

  1. http://cassandra.apache.com

  2. http://neo4j.com

  3. http://paradigm4.com

  4. https://www.mongodb.org

  5. http://www.couchbase.com

  6. Abrial, J.-R.: The B-Book-Assigning Programs to Meaning. Cambridge University Press, Great Britain (1996)

    Book  MATH  Google Scholar 

  7. Chang, F., Dean, J., Ghemawat, S., Hsieh, W., Wallach, D.A., Burrows, M., Chandra, T., Fikes, A., Gruber, R.E.: Bigtable: a distributed storage system for structured data. In: OSDI 2006, November 2006

    Google Scholar 

  8. Drawar, M.: Openmath: an overview. ACM SIGSAM Bull. 34(2), 2–5 (2000)

    Article  Google Scholar 

  9. Garcia-Molina, H., Ullman, J., Widom, J.: Database Systems: The Complete Book. Prentice Hall, USA (2009)

    Google Scholar 

  10. Gevorgyan, G.R., Manukyan, M.G.: Effective algorithms to support grid files. RAU Bull. 2, 22–38 (2015)

    Google Scholar 

  11. Hindley, J.R., Seldin, J.P.: Introduction to Combinators and \(\lambda \)-Calculus. Cambridge University Press, Great Britain (1986)

    MATH  Google Scholar 

  12. Kalinichenko, L.A.: Data model transformation method based on axiomatic data model extension. In: 4th International Conference on VLDB, pp. 549–555. Springer, Germany, September 1978

    Google Scholar 

  13. Kalinichenko, L.A.: Methods and Tools for Integration of Heterogeneous Databases (in Russian). Science, USSR (1983)

    Google Scholar 

  14. Kalinichenko, L.A.: Methods and tools for equivalent data model mapping construction. In: Bancilhon, F., Zhang, J., Thanos, C. (eds.) EDBT 1990. LNCS, vol. 416, pp. 92–119. Springer, Heidelberg (1990)

    Chapter  Google Scholar 

  15. Luo, C., Hou, W.C., Wang, C.F., Want, H., Yu, X.: Grid file for efficient data cube storage. Computers and their Applications, pp. 424–429 (2006)

    Google Scholar 

  16. Manukyan, M.G.: Extensible data model. In: Advances in Databases and Information Systems, pp. 42–57. Finland (2008)

    Google Scholar 

  17. Manukyan, M.G.: Canonical model: construction principles. In: iiWAS2014, pp. 320–329. ACM, Vietnam, December 2014

    Google Scholar 

  18. Manukyan, M.G., Gevorgyan, G.R.: An approach to information integration based on the amn formalism. In: First Workshop on Programming the Semantic Web, USA, pp. 1–13, November 2012. https://web.archive.org/web/20121226215425/, http://www.inf.puc-rio.br/~psw12/program.html

  19. Nievergelt, J., Hinterberger, H.: The grid file: an adaptable, symmetric, multikey file structure. ACM Trans. Database Syst. 9(1), 38–71 (1984)

    Article  Google Scholar 

  20. Papadopoulos, A.N., Manolopoulos, Y., Theodoridis, Y., Tsoras, V.: Grid file (and family). In: Encyclopedia of Database Systems, pp. 1279–1282 (2009)

    Google Scholar 

  21. Robinson, I., Webber, J., Eifrem, E.: Graph Databases. O’Reilly, USA (2015)

    Google Scholar 

  22. Sharma, S., Tim, U.S., Wong, J., Gadia, S., Sharma, S.: A brief review on leading big data models. Data Sci. J. 13, 138–157 (2014)

    Article  Google Scholar 

  23. Stonebraker, M., Brown, P., Poliakov, A., Raman, S.: The architecture of SciDB. In: Bayard Cushing, J., French, J., Bowers, S. (eds.) SSDBM 2011. LNCS, vol. 6809, pp. 1–16. Springer, Heidelberg (2011)

    Chapter  Google Scholar 

  24. The SciDB Development Team http://www.scidb.org. Overview of scidb. In: SIGMOD 2010, June 2010

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Manuk Manukyan .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this paper

Cite this paper

Manukyan, M., Gevorgyan, G. (2016). Canonical Data Model for Data Warehouse. In: Ivanović, M., et al. New Trends in Databases and Information Systems. ADBIS 2016. Communications in Computer and Information Science, vol 637. Springer, Cham. https://doi.org/10.1007/978-3-319-44066-8_8

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-44066-8_8

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-44065-1

  • Online ISBN: 978-3-319-44066-8

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics