F 2DB: The flash-forward database system

Research output: Contribution to book/Conference proceedings/Anthology/ReportConference contributionContributedpeer-review

Contributors

Abstract

Forecasts are important to decision-making and risk assessment in many domains. Since current database systems do not provide integrated support for forecasting, it is usually done outside the database system by specially trained experts using forecast models. However, integrating model-based forecasting as a first-class citizen inside a DBMS speeds up the forecasting process by avoiding exporting the data and by applying database-related optimizations like reusing created forecast models. It especially allows subsequent processing of forecast results inside the database. In this demo, we present our prototype F2DB based on PostgreSQL, which allows for transparent processing of forecast queries. Our system automatically takes care of model maintenance when the underlying dataset changes. In addition, we offer optimizations to save maintenance costs and increase accuracy by using derivation schemes for multidimensional data. Our approach reduces the required expert knowledge by enabling arbitrary users to apply forecasting in a declarative way.

Details

Original languageEnglish
Title of host publication2012 IEEE 28th International Conference on Data Engineering
PublisherIEEE
Pages1245-1248
Number of pages4
ISBN (electronic)978-0-7695-4747-3
ISBN (print)978-1-4673-0042-1
Publication statusPublished - 2012
Peer-reviewedYes

Publication series

Series International Conference on Data Engineering (ICDE)
ISSN1084-4627

Conference

TitleIEEE 28th International Conference on Data Engineering, ICDE 2012
Duration1 - 5 April 2012
CityArlington, VA
CountryUnited States of America

External IDs

ORCID /0000-0001-8107-2775/work/199215568

Keywords

Research priority areas of TU Dresden

DFG Classification of Subject Areas according to Review Boards

Subject groups, research areas, subject areas according to Destatis