A Semantic Data Lake for Harmonizing Data from Cross-Platform Digital Workspaces using Ontology-Based Data Access.
Florian Schwade, Petra L. Schubert · Journal of the Association for Information Systems · 2020
Most organizations provide a portfolio of multiple applications from different vendors (with different data structures) for supporting computer-mediated collaboration among their employees. The heterogeneous format of the activity logs and the content data is challenging for the analysis of cross-platform collaboration and for comparing results from the different systems. To address these issues, we develop and demonstrate a prototype for a semantic data lake. Our prototype is based on Hadoop and ingests data from the source systems in near real-time. Ontology-based data access is implemented based on a mapping between an ontology and the ingested data. Thus, an analyst only needs to be familiar with the ontology and can use identical SPARQL queries to obtain the same information from the source systems. We demonstrate the ontology-database mapping and show how concepts from Web Science can solve practical problems in the Information Systems discipline, specifically for the area of Business Intelligence.