Research on enterprise spreadsheet model based-on semantic

Authors:
Chong-chong Zhao;Li-yong Zhao;Zhang Xiao-ming
Affiliations:
Information Engineering School, University of Science and Technology Beijing, Beijing, China;Information Engineering School, University of Science and Technology Beijing, Beijing, China;Information Engineering School, University of Science and Technology Beijing, Beijing, China
Venue:
FSKD'09 Proceedings of the 6th international conference on Fuzzy systems and knowledge discovery - Volume 7
Year:
2009

Citing 6
Cited 0

An experimental study of people creating spreadsheets

ACM Transactions on Information Systems (TOIS)
Spreadsheet analysis and design

Communications of the ACM
What we know about spreadsheet errors

Journal of End User Computing - End User Development
The role of spreadsheet knowledge in user-developed application success

Decision Support Systems
Number Crunching without Programming: The Evolution of Spreadsheet Usability

IEEE Annals of the History of Computing
Testing spreadsheet accuracy theory

Information and Software Technology

Quantified Score

Hi-index	0.00

Visualization

Abstract

This paper presents a semantic based enterprise spreadsheet model to improve the spreadsheet template modifiability, data presentation ability and domain applicability, and the principle is to uncouple data and structure by means of semantic. In this model, cell structure object encapsulates structural information and semantic of a cell, and data object encapsulates value and semantic. Thus there is an indirect relationship depends on semantic matching between the cell structure object and data object. Additionally, this model can satisfy domain requirements by customizations throughout the templates design. A spreadsheet system implemented on this model has been applied in an enterprise of petroleum domain and the results have proved the effectiveness.