FunSETL–Functional Reporting for ERP Systems
Research output: Chapter in Book/Report/Conference proceeding › Article in proceedings › Research › peer-review
Standard
FunSETL–Functional Reporting for ERP Systems. / Nissen, Michael Nebel; Larsen, Ken Friis.
Draft Proceedings of The Ninth Symposium on Trends in Functional Programming (TFP): Technical Report ICIS-R08007, Radboud University Nijmegen. ed. / Peter Achten; Pieter Koopman; Marco T. Morazán. 2008. p. 1-16.Research output: Chapter in Book/Report/Conference proceeding › Article in proceedings › Research › peer-review
Harvard
APA
Vancouver
Author
Bibtex
}
RIS
TY - GEN
T1 - FunSETL–Functional Reporting for ERP Systems
AU - Nissen, Michael Nebel
AU - Larsen, Ken Friis
N1 - Conference code: 9
PY - 2008
Y1 - 2008
N2 - One of the essential features of enterprise resource planning systems is the ability to provide the users and decision makers with reports on how the enterprise is running, and to enable the enterprise to provide the authorities the required legal reports. By their nature these reports needs to operate on large amounts of data and the decision makers need the reports in a timely manner. To achieve acceptable performance of the programs that generates these reports, the data, the full transaction log, the programs operates on is kept in denormalized form. What we propose instead is to write the programs as they are operating on the full amount of data and then use automatic incrementalization for achieving acceptable performance. To study whether automatic incrementalization is practically feasible we introduce the reporting language FunSETL, which is a restricted ML dialect, a compiler for FunSETL that can perform automatic incrementalization, and we have collected a small suite of reporting programs written in FunSETL containing a real life report. We show that using incrementalization on our suite we obtain an asymptotic improvement of a linear factor in the running time compared to the non-incrementalized original programs.
AB - One of the essential features of enterprise resource planning systems is the ability to provide the users and decision makers with reports on how the enterprise is running, and to enable the enterprise to provide the authorities the required legal reports. By their nature these reports needs to operate on large amounts of data and the decision makers need the reports in a timely manner. To achieve acceptable performance of the programs that generates these reports, the data, the full transaction log, the programs operates on is kept in denormalized form. What we propose instead is to write the programs as they are operating on the full amount of data and then use automatic incrementalization for achieving acceptable performance. To study whether automatic incrementalization is practically feasible we introduce the reporting language FunSETL, which is a restricted ML dialect, a compiler for FunSETL that can perform automatic incrementalization, and we have collected a small suite of reporting programs written in FunSETL containing a real life report. We show that using incrementalization on our suite we obtain an asymptotic improvement of a linear factor in the running time compared to the non-incrementalized original programs.
M3 - Article in proceedings
SP - 1
EP - 16
BT - Draft Proceedings of The Ninth Symposium on Trends in Functional Programming (TFP)
A2 - Achten, Peter
A2 - Koopman, Pieter
A2 - Morazán, Marco T.
Y2 - 28 June 0208 through 26 May 2008
ER -
ID: 9293234