The Semantic Spreadsheet

Behzad Farokhi, Katharina Dost, Gerald Weber, Jing Sun, Christof Lutteroth

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Spreadsheets are one of the most widely used data management tools. Although intuitive and easy to use, they suffer from a number of issues. Numerous publications indicate that most spreadsheets contain errors and that spreadsheet-based data shadow systems lead to problems such as the "spreadmart dilemma"creating inconsistent views on organizational data. In this paper, we describe "The Semantic Spreadsheet ", a new data model for a semantically accurate spreadsheet system. Unlike the existing data models, the described model is a presentation independent data model based on the Resource Description Framework (RDF) that avoids the spreadmart dilemma by providing a semantically sound data structure. We describe the set-theoretic and relational algebraic operations on the data model and show how it can improve data integrity.

Original languageEnglish
Title of host publicationProceedings - 2020 25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020
EditorsYi Li, Alan Liew
PublisherIEEE
Pages171-176
Number of pages6
ISBN (Electronic)9781728185583
DOIs
Publication statusPublished - Oct 2020
Event25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020 - Singapore, Singapore
Duration: 4 Mar 20216 Mar 2021

Publication series

NameProceedings of the IEEE International Conference on Engineering of Complex Computer Systems, ICECCS
Volume2020-October

Conference

Conference25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020
CountrySingapore
CitySingapore
Period4/03/216/03/21

Keywords

  • Data processing
  • Data systems
  • Spreadsheet programs

ASJC Scopus subject areas

  • Hardware and Architecture
  • Computer Networks and Communications

Cite this