Interactive, Flexible, and Generic What-If Analyses Using In-Memory Column Stores

One well established method of measuring the success of companies are key performance indicators, whose inter-dependencies can be represented by mathematical models, such as value driver trees. While such models have commonly agreed semantics, they lack the right tool support for business simulations, because a flexible implementation that supports multi-dimensional and hierarchical structures on large data sets is complex and computationally challenging. However, in-memory column stores as the backbone of enterprise applications provide incredible performance that enables to calculate flexible simulation scenarios interactively even on large sets of enterprise data.

[1]  Alexander Zeier,et al.  HYRISE - A Main Memory Hybrid Storage Engine , 2010, Proc. VLDB Endow..

[2]  Pradeep Dubey,et al.  Fast Updates on Read-Optimized Databases Using Multi-Core CPUs , 2011, Proc. VLDB Endow..

[3]  Yannis Sismanis,et al.  Dwarf: shrinking the PetaCube , 2002, SIGMOD '02.

[4]  Hasso Plattner,et al.  Workload-aware aggregate maintenance in columnar in-memory databases , 2013, 2013 IEEE International Conference on Big Data.

[5]  Hamid Pirahesh,et al.  Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals , 1996, Data Mining and Knowledge Discovery.

[6]  Matteo Golfarelli,et al.  UML-Based Modeling for What-If Analysis , 2008, DaWaK.

[7]  Wolfgang Lehner,et al.  SAP HANA database: data management for modern business applications , 2012, SGMD.

[8]  Abhinav Gupta,et al.  Spreadsheets in RDBMS for OLAP , 2003, SIGMOD '03.

[9]  Jeffrey D. Ullman,et al.  Implementing data cubes efficiently , 1996, SIGMOD '96.

[10]  Hasso Plattner,et al.  A common database approach for OLTP and OLAP using an in-memory column database , 2009, SIGMOD Conference.

[11]  Nick Roussopoulos,et al.  Cubetree: organization of and bulk incremental updates on the data cube , 1997, SIGMOD '97.

[12]  Hasso Plattner,et al.  The Impact of Columnar In-Memory Databases on Enterprise Systems , 2014, Proc. VLDB Endow..

[13]  Inderpal Singh Mumick,et al.  Maintenance of data cubes and summary tables in a warehouse , 1997, SIGMOD '97.

[14]  Hasso Plattner,et al.  Aggregates Caching in Columnar In-Memory Databases , 2013, IMDM@VLDB.

[15]  Venky Harinarayan,et al.  Implementing Data Cubes E ciently , 1996 .

[16]  Alfred D. Chandler,et al.  Pierre S. Du Pont and the Making of the Modern Corporation , 1971 .

[17]  Lei Sheng,et al.  Query By Excel , 2005, VLDB.

[18]  Matteo Golfarelli,et al.  Designing what-if analysis: towards a methodology , 2006, DOLAP '06.