Skip to main content
Springer Nature Link
Log in

Data Warehouses Federation as a Single Data Warehouse

  • Conference paper
  • First Online:
Computational Collective Intelligence (ICCCI 2016)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 9875))

Included in the following conference series:

  • 1443 Accesses

Abstract

In this paper author presents an experiment, which shows that it is possible to form a federation of data warehouses that may simulate effectively one, “super” data warehouse. There is no need to create complete ETL tool to load data from source data warehouses into one, dedicated data warehouse. Good relations between global schema and local schemas extracted during schema integration are indispensable to create an effective federation.

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

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

References

  1. Berger, S., Schrefl, M.: From federated databases to a federated data warehouse system. In: Proceedings of the 41st Annual Hawaii International Conference on System Sciences, HICSS 2008, pp. 394–404 (2008)

    Google Scholar 

  2. Dong, X.L., Berti-Equille, L., Srivastava, D.: Data fusion: resolving conflicts from multiple sources. In: Wang, J., Xiong, H., Ishikawa, Y., Xu, J., Zhou, J. (eds.) WAIM 2013. LNCS, vol. 7923, pp. 64–76. Springer, Heidelberg (2013)

    Chapter  Google Scholar 

  3. Fan, W., Lu, H., Madnick, S.E., Cheung, D.: Discovering and reconciling value conflicts for numerical data integration. Inf. Syst. 26(8), 635–656 (2001)

    Article  MATH  Google Scholar 

  4. Jindal, R., Acharya, A.: Federated data warehouse architecture. White paper, Wipro Technologies (2003)

    Google Scholar 

  5. Kern, R., Ryk, K., Nguyen, N.T.: A framework for building logical schema and query decomposition in data warehouse federations. In: Jedrzejowicz, P., Nguyen, N.T., Hoang, K. (eds.) ICCCI 2011, Part I. LNCS, vol. 6922, pp. 612–622. Springer, Heidelberg (2011)

    Google Scholar 

  6. Kern, R., Stolarczyk, T., Nguyen, N.T.: A formal framework for query decomposition and knowledge integration in data warehouse federations. Expert Syst. Appl. 40(7), 2592–2606 (2013)

    Article  Google Scholar 

  7. Kern, R., Dobrowolski, G., Nguyen, N.T.: A method for response integration in federated data warehouses. In: Camacho, D., Kim, S.-W., Trawiński, B. (eds.) New Trends in Computational Collective Intelligence. Studies in Computational Intelligence, vol. 572, pp. 63–73. Springer, Switzerland (2015)

    Google Scholar 

  8. Lenzerini, M.: Data integration: a theoretical perspective. In: Proceedings of the Twentyfirst ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, PODS 2002, pp. 233–246 (2002)

    Google Scholar 

  9. Motro, A., Anokhin, P.: Fusionplex: resolution of data inconsistencies in the integration of heterogeneous information sources. Inf. Fusion 7(2), 176–196 (2006)

    Article  Google Scholar 

  10. Nguyen, N.T.: Advanced Methods for Inconsistent Knowledge Management. Advanced Information and Knowledge Processing. Springer, New York (2007)

    Google Scholar 

  11. Chau, V.T.N., Nguyen Hua Phung, V., Tran, T.N.: Making kernel-based vector quantization robust and effective for incomplete educational data clustering. Vietnam J. Comput. Sci. 3(2), 93–102 (2016)

    Article  Google Scholar 

  12. Waddington, R.: An Architected Approach to Integrated Information. White paper, Kalido (2004)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institute of Informatics, Wroclaw University of Technology, Wybrzeze Wyspianskiego 27, 50-370, Wroclaw, Poland

    Rafał Kern

Authors
  1. Rafał Kern
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Rafał Kern .

Editor information

Editors and Affiliations

  1. Wrocław University of Technology, Wrocław, Poland

    Ngoc-Thanh Nguyen

  2. Aristotle University of Thessaloniki, Thessaloniki, Greece

    Lazaros Iliadis

  3. Department of Forestry and Management, Democritus University of Thrace, Orestiada, Thrace, Greece

    Yannis Manolopoulos

  4. Wrocław University of Technology, Wrocław, Poland

    Bogdan Trawiński

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this paper

Cite this paper

Kern, R. (2016). Data Warehouses Federation as a Single Data Warehouse. In: Nguyen, NT., Iliadis, L., Manolopoulos, Y., Trawiński, B. (eds) Computational Collective Intelligence. ICCCI 2016. Lecture Notes in Computer Science(), vol 9875. Springer, Cham. https://doi.org/10.1007/978-3-319-45243-2_33

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-45243-2_33

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-45242-5

  • Online ISBN: 978-3-319-45243-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics