FunSETL–Functional Reporting for ERP Systems

Research output: Chapter in Book/Report/Conference proceedingArticle in proceedingsResearchpeer-review

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.
Original languageEnglish
Title of host publicationDraft Proceedings of The Ninth Symposium on Trends in Functional Programming (TFP) : Technical Report ICIS-R08007, Radboud University Nijmegen
EditorsPeter Achten, Pieter Koopman, Marco T. Morazán
Number of pages16
Publication date2008
Pages1-16
Publication statusPublished - 2008
EventThe Ninth Symposium on Trends in Functional Programming (TFP) - Nijmegen, Netherlands
Duration: 28 Jun 020826 May 2008
Conference number: 9

Conference

ConferenceThe Ninth Symposium on Trends in Functional Programming (TFP)
Nummer9
LandNetherlands
ByNijmegen
Periode28/06/020826/05/2008

ID: 9293234