Automating Data Mart Construction from Semi-structured Data Sources. (15th June 2018)

• Record Type: Journal Article
• Authors: Scriney, Michael; McCarthy, Suzanne; McCarren, Andrew; Cappellari, Paolo; Roantree, Mark
• Is Part Of: Computer journal. Volume 62:Number 3(2019)
• Page Start: 394
• Page End: 413
• Publication Date: 2018-06-15
• Subjects: data model transformation -- semi-structured data -- ETL -- data marts; Computers -- Periodicals; 005.1
• DOI: 10.1093/comjnl/bxy064
• Languages: English
• ISSNs: 0010-4620

Abstract

Abstract: The global food and agricultural industry has a total market value of USD 8 trillion in 2016, and decision makers in the Agri sector require appropriate tools and up-to-date information to make predictions across a range of products and areas. Traditionally, these requirements are met with information processed into a data warehouse and data marts constructed for analyses. Increasingly however, data are coming from outside the enterprise and often in unprocessed forms. As these sources are outside the control of companies, they are prone to change and new sources may appear. In these cases, the process of accommodating these sources can be costly and very time consuming. To automate this process, what is required is a sufficiently robust extract–transform–load process; external sources are mapped to some form of ontology, and an integration process to merge the specific data sources. In this paper, we present an approach to automating the integration of data sources in an Agri environment, where new sources are examined before an attempt to merge them with existing data marts. Our validation uses a case study of real world Agri data to demonstrate the robustness of our approach and the efficiency of materializing data marts.