The Semantic Spreadsheet

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

doi:10.1109/ICECCS51672.2020.00027

The Semantic Spreadsheet

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

University of Auckland

Research output: Chapter or section in a book/report/conference proceeding › Chapter in a published conference proceeding

1 Citation (SciVal)

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 language	English
Title of host publication	Proceedings - 2020 25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020
Editors	Yi Li, Alan Liew
Publisher	IEEE
Pages	171-176
Number of pages	6
ISBN (Electronic)	9781728185583
DOIs	https://doi.org/10.1109/ICECCS51672.2020.00027
Publication status	Published - Oct 2020
Event	25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020 - Singapore, Singapore Duration: 4 Mar 2021 → 6 Mar 2021

Publication series

Name	Proceedings of the IEEE International Conference on Engineering of Complex Computer Systems, ICECCS
Volume	2020-October

Conference

Conference	25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020
Country/Territory	Singapore
City	Singapore
Period	4/03/21 → 6/03/21

Keywords

Data processing
Data systems
Spreadsheet programs

ASJC Scopus subject areas

Hardware and Architecture
Computer Networks and Communications

Access to Document

10.1109/ICECCS51672.2020.00027

Cite this

Farokhi, B., Dost, K., Weber, G., Sun, J., & Lutteroth, C. (2020). The Semantic Spreadsheet. In Y. Li, & A. Liew (Eds.), Proceedings - 2020 25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020 (pp. 171-176). Article 9376181 (Proceedings of the IEEE International Conference on Engineering of Complex Computer Systems, ICECCS; Vol. 2020-October). IEEE. https://doi.org/10.1109/ICECCS51672.2020.00027

The Semantic Spreadsheet. / Farokhi, Behzad; Dost, Katharina; Weber, Gerald et al.
Proceedings - 2020 25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020. ed. / Yi Li; Alan Liew. IEEE, 2020. p. 171-176 9376181 (Proceedings of the IEEE International Conference on Engineering of Complex Computer Systems, ICECCS; Vol. 2020-October).

Research output: Chapter or section in a book/report/conference proceeding › Chapter in a published conference proceeding

Farokhi, B, Dost, K, Weber, G, Sun, J & Lutteroth, C 2020, The Semantic Spreadsheet. in Y Li & A Liew (eds), Proceedings - 2020 25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020., 9376181, Proceedings of the IEEE International Conference on Engineering of Complex Computer Systems, ICECCS, vol. 2020-October, IEEE, pp. 171-176, 25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020, Singapore, Singapore, 4/03/21. https://doi.org/10.1109/ICECCS51672.2020.00027

Farokhi B, Dost K, Weber G, Sun J, Lutteroth C. The Semantic Spreadsheet. In Li Y, Liew A, editors, Proceedings - 2020 25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020. IEEE. 2020. p. 171-176. 9376181. (Proceedings of the IEEE International Conference on Engineering of Complex Computer Systems, ICECCS). doi: 10.1109/ICECCS51672.2020.00027

@inproceedings{d266bc509a8e47bca5da09234954b59a,

title = "The Semantic Spreadsheet",

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. ",

keywords = "Data processing, Data systems, Spreadsheet programs",

author = "Behzad Farokhi and Katharina Dost and Gerald Weber and Jing Sun and Christof Lutteroth",

year = "2020",

month = oct,

doi = "10.1109/ICECCS51672.2020.00027",

language = "English",

series = "Proceedings of the IEEE International Conference on Engineering of Complex Computer Systems, ICECCS",

publisher = "IEEE",

pages = "171--176",

editor = "Yi Li and Alan Liew",

booktitle = "Proceedings - 2020 25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020",

address = "USA United States",

note = "25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020 ; Conference date: 04-03-2021 Through 06-03-2021",

}

TY - GEN

T1 - The Semantic Spreadsheet

AU - Farokhi, Behzad

AU - Dost, Katharina

AU - Weber, Gerald

AU - Sun, Jing

AU - Lutteroth, Christof

PY - 2020/10

Y1 - 2020/10

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

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

KW - Data processing

KW - Data systems

KW - Spreadsheet programs

UR - http://www.scopus.com/inward/record.url?scp=85103505711&partnerID=8YFLogxK

U2 - 10.1109/ICECCS51672.2020.00027

DO - 10.1109/ICECCS51672.2020.00027

M3 - Chapter in a published conference proceeding

AN - SCOPUS:85103505711

T3 - Proceedings of the IEEE International Conference on Engineering of Complex Computer Systems, ICECCS

SP - 171

EP - 176

BT - Proceedings - 2020 25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020

A2 - Li, Yi

A2 - Liew, Alan

PB - IEEE

T2 - 25th International Conference on Engineering of Complex Computer Systems, ICECCS 2020

Y2 - 4 March 2021 through 6 March 2021

ER -

The Semantic Spreadsheet

Abstract

Publication series

Conference

Keywords

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Centre for the Analysis of Motion, Entertainment Research and Applications (CAMERA) - 2.0

Centre for the Analysis of Motion, Entertainment Research and Applications (CAMERA)

Cite this

The Semantic Spreadsheet

Abstract

Publication series

Conference

Keywords

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Projects

Centre for the Analysis of Motion, Entertainment Research and Applications (CAMERA) - 2.0

Centre for the Analysis of Motion, Entertainment Research and Applications (CAMERA)

Cite this