The Analytical Object Model as a Base of Heterogeneous Data Integration

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 mapping 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.

[1]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling , 2013 .

[2]  Alfredo Cuzzocrea,et al.  Data warehousing and OLAP over big data: current challenges and future research directions , 2013, DOLAP '13.

[3]  Ljiljana Brkic,et al.  Application of Semantic and Structural Similarity for Schema Reuse in Conceptual Database Design , 2012 .

[4]  Torben Bach Pedersen,et al.  Integrating Data Warehouses with Web Data: A Survey , 2008, IEEE Transactions on Knowledge and Data Engineering.

[5]  Panos Vassiliadis,et al.  Data Mapping Diagrams for Data Warehouse Design with UML , 2004, ER.

[6]  Anna V. Korobko,et al.  On-line analytical processing based on formal concept analysis , 2010, ICCS.

[7]  Alberto Abelló,et al.  Towards Exploratory OLAP on Linked Data , 2016, SEBD.

[8]  Torben Bach Pedersen,et al.  Analytical metadata modeling for next generation BI systems , 2018, J. Syst. Softw..

[9]  Paul Alpar,et al.  Self-Service Business Intelligence , 2016, Bus. Inf. Syst. Eng..

[10]  Volker Markl,et al.  Situational Business Intelligence , 2008, BIRTE.

[11]  Michael Benedikt,et al.  Logical foundations of information disclosure in ontology-based data integration , 2018, Artif. Intell..

[12]  Veda C. Storey,et al.  Business Intelligence and Analytics: From Big Data to Big Impact , 2012, MIS Q..

[13]  Gottfried Vossen,et al.  Towards Self-Service Business Intelligence , 2013 .

[14]  Omar Boussaïd,et al.  Active XML-based Web data integration , 2013, Inf. Syst. Frontiers.

[15]  Rahul Singh,et al.  Integrating Data Mining and On-line Analytical Processing for Intelligent Decision Systems , 2002, J. Decis. Syst..

[16]  Alberto Abelló,et al.  Interactive multidimensional modeling of linked data for exploratory OLAP , 2018, Inf. Syst..