Challenges in Workload Analyses for Column and Row Stores
Andreas Lübcke · Grundlagen von Datenbanken · 2010
Within the DWH domain, a new architecture known as column store is emerging especially to improve the performance of data analyses/aggregations. Column stores oer good results in performance benchmarks like TPC-H. In recent years, row stores dominate the data warehousing domain. We consider application elds for both architectures. We want to gure out and examine dierent application elds for row and column stores. To encourage our assumption, we perform a case study based on the TPC-H benchmark. To the best of our knowledge, there is no advisor for selection of storage architecture for a given application. We present an idea to overcome the workload analysis problems across dierent architectures in the DWH domain.