Application-aware aggregations in a columnar in-memory database

摘要: The reunification of online transactional processing and analytical in one single database has been proposed recently as the advent columnar in-memory databases makes this both viable feasible. Compared to traditional row-based databases, resource-intensive operations such aggregation can now be executed with high performance. This emerged radical approach eliminating materialized aggregate tables calculate all aggregations on fly. paper contributes by investigating application data characteristics that have an influence performance databases. In particular, we examined Availability-to-Promise calculates if a desired order fulfilled requested date quantity. We implemented prototype incorporates our identified backed up findings relevant experiments real-life customer data.