Towards Integrated Data Analytics: Time Series Forecasting in DBMS

• Published in: Datenbank-Spektrum : Zeitschrift für Datenbanktechnologie : Organ der Fachgruppe Datenbanken der Gesellschaft für Informatik e.V 2013-03, Vol.13 (1), p.45-53
• Main Authors: Fischer, Ulrike, Dannecker, Lars, Siksnys, Laurynas, Rosenthal, Frank, Boehm, Matthias, Lehner, Wolfgang
• Format: Article
• Language: English
• Subjects: Computer Science; Computer Systems Organization and Communication Networks; Data Mining and Knowledge Discovery; Data Structures and Information Theory; Database Management; Fachbeitrag; Information Storage and Retrieval; IT in Business
• ISSN: 1618-2162; 1610-1995
• DOI: 10.1007/s13222-012-0108-4

Integrating sophisticated statistical methods into database management systems is gaining more and more attention in research and industry in order to be able to cope with increasing data volume and increasing complexity of the analytical algorithms. One important statistical method is time series forecasting, which is crucial for decision making processes in many domains. The deep integration of time series forecasting offers additional advanced functionalities within a DBMS. More importantly, however, it allows for optimizations that improve the efficiency, consistency, and transparency of the overall forecasting process. To enable efficient integrated forecasting, we propose to enhance the traditional 3-layer ANSI/SPARC architecture of a DBMS with forecasting functionalities. This article gives a general overview of our proposed enhancements and presents how forecast queries can be processed using an example from the energy data management domain. We conclude with open research topics and challenges that arise in this area.