Optimizing HBase table scheme for marketing strategy suggestion

Abstract

We propose a unique table schema to store business data for marketing strategy analysis. Marketing strategy analysis requires various business index such as floating population, store transactions to calculate its model, which are too detailed to analyze some specific customer clusters. These data of detailed unit may produce continuous database query in responsible for slow runtime performance. The performance of strategy analysis operation may be increased. By merging data records and modifying table schema that are suitable for model calculation.