SpringerLink
Log in

The Analytical Object Model as a Base of Heterogeneous Data Integration

  • Conference paper
  • First Online:
Perspectives of System Informatics (PSI 2019)

Part of the book series: Lecture Notes in Computer Science ((LNTCS,volume 11964))

  • 301 Accesses

Abstract

When viewed the issue of analytical integration of heterogeneous data without warehouse building the unified model of diverse data sources has to be suggested. The desired model has to take into account analytical features of original file formats, to provide a construction of the integral analytical model and to attend to unlimited user data queries. This paper proposes the analytical object model in terms of a formal specification as the unified model and presents the map** of an XSD schema and a relational database to this model. The model has been applied to analyze the All-Russia website of procurement that uses XML and The Local System of procurement that uses relation DB. The model instances obtained for each format are partly represented in this paper in the form of JSON.

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
EUR 32.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 (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (Canada)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (Canada)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free ship** worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

References

  1. Ibragimov, D., Hose, K., Pedersen, T.B., Zimányi, E.: Towards exploratory OLAP over linked open data – a case study. In: Castellanos, M., Dayal, U., Pedersen, T.B., Tatbul, N. (eds.) BIRTE 2013-2014. LNBIP, vol. 206, pp. 114–132. Springer, Heidelberg (2015). https://doi.org/10.1007/978-3-662-46839-5_8

    Chapter  Google Scholar 

  2. Abelló, A., et al.: Fusion cubes: towards self-service business intelligence. Int. J. Data Warehous. Min. 9, 66–88 (2013)

    Article  Google Scholar 

  3. Löser, A., Hueske, F., Markl, V.: Situational business intelligence. In: Castellanos, M., Dayal, U., Sellis, T. (eds.) BIRTE 2008. LNBIP, vol. 27, pp. 1–11. Springer, Heidelberg (2009). https://doi.org/10.1007/978-3-642-03422-0_1

    Chapter  Google Scholar 

  4. Gallinucci, E., Golfarelli, M., Rizzi, S., Abelló, A., Romero, O.: Interactive multidimensional modeling of linked data for exploratory OLAP. Inf. Syst. 77, 86–104 (2018)

    Article  Google Scholar 

  5. Alpar, P., Schulz, M.: Self-Service business intelligence. Bus. Inf. Syst. Eng. 58, 151–155 (2016)

    Article  Google Scholar 

  6. Chen, H., Chiang, R.H., Storey, V.C.: Business intelligence and analytics: from big data to big impact. MIS Q. 36, 1165–1188 (2012)

    Article  Google Scholar 

  7. Singh, R., Yoon, V.Y., Redmond, R.T.: Integrating data mining and on-line analytical processing for intelligent decision systems. J. Decis. Syst. 11, 185–204 (2002)

    Article  Google Scholar 

  8. Baranović, M., Kalpić, D., Brkić, L.: Application of semantic and structural similarity for schema reuse in conceptual database design. In: Proceedings 6th WSEAS European Computing Conference (ECC 2012), pp. 368–373 (2012)

    Google Scholar 

  9. Cuzzocrea, A., Bellatreche, L., Song, I.-Y.: Data warehousing and OLAP over big data: current challenges and future research directions. In: Proceedings of the Sixteenth International Workshop on Data Warehousing and OLAP - DOLAP 2013, pp. 67–70 (2013)

    Google Scholar 

  10. Pe, J.M., Rafael, B., Aramburu, M.J., Pederson, T.B.: Integrating data warehouses with web data: a survey. IEEE Trans. Knowl. Data Eng. 20, 940–955 (2008)

    Article  Google Scholar 

  11. Salem, R., Boussaïd, O., Darmont, J.: Active XML-based web data integration. Inf. Syst. Front. 15, 371–398 (2013)

    Article  Google Scholar 

  12. Varga, J., Romero, O., Pedersen, T.B., Thomsen, C.: Analytical metadata modeling for next generation BI systems. J. Syst. Softw. 144, 240–254 (2018)

    Article  Google Scholar 

  13. Rizzi, S., Gallinucci, E., Golfarelli, M., Romero, O., Abelló, A.: Towards exploratory OLAP on linked data. In: In: 24th Italian Symposium on Advanced Database Systems, SEBD 2016, pp. 86–93 (2016)

    Google Scholar 

  14. Benedikt, M., Cuenca Grau, B., Kostylev, E.V.: Logical foundations of information disclosure in ontology-based data integration. Artif. Intell. 262, 52–95 (2018)

    Article  MathSciNet  Google Scholar 

  15. Doan, A.H., Alon, H., Zachary, I.: Principles of Data Integration. Elsevier, Amsterdam (2012)

    Google Scholar 

  16. Luján-Mora, S., Vassiliadis, P., Trujillo, J.: Data map** diagrams for data warehouse design with UML. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, T.-W. (eds.) ER 2004. LNCS, vol. 3288, pp. 191–204. Springer, Heidelberg (2004). https://doi.org/10.1007/978-3-540-30464-7_16

    Chapter  Google Scholar 

  17. Kimball, R., Ross, M.: The Data Warehouse Toolkit, The Definitive Guide to Dimensional Modeling. Wiley, Hoboken (2013)

    Google Scholar 

  18. OMG, Object Management Group: Object Management Group, Model Driven Architecture (MDA), pp. 1–15. OMG Doc. ormsc/2014-06-01. 2.0 (2014)

    Google Scholar 

  19. Korobko, A.V., Penkova, T.G.: On-line analytical processing based on formal concept analysis. Procedia Comput. Sci. 1, 2311–2317 (2010)

    Article  Google Scholar 

  20. Federal State Statistics Service. http://www.gks.ru/wps/wcm/connect/rosstat_main/rosstat/ru/statistics/accounts/

  21. Central Bank of Russia for financial market indicators. http://www.cbr.ru/development/DWS/

  22. Federal Tax Service for open governmental data. https://www.nalog.ru/opendata/

  23. Listing of Open Access Databases - LOADB. http://www.loadb.org/Control.do?_brse

Download references

Author information

Authors and Affiliations

  1. Institute of Computational Modeling of the SB RAS, Krasnoyarsk, Russia

    Anna Korobko & Anna Metus

Authors
  1. Anna Korobko
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Anna Metus
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Anna Korobko .

Editor information

Editors and Affiliations

  1. Microsoft Research, Redmond, WA, USA

    Nikolaj Bjørner

  2. AP Ershov Institute of Informatics Systems, Novosibirsk, Russia

    Irina Virbitskaite

  3. School of Computer Science, University of Manchester, Manchester, UK

    Andrei Voronkov

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Korobko, A., Metus, A. (2019). The Analytical Object Model as a Base of Heterogeneous Data Integration. In: Bjørner, N., Virbitskaite, I., Voronkov, A. (eds) Perspectives of System Informatics. PSI 2019. Lecture Notes in Computer Science(), vol 11964. Springer, Cham. https://doi.org/10.1007/978-3-030-37487-7_9

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-37487-7_9

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-37486-0

  • Online ISBN: 978-3-030-37487-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation