Advanced Query Model Design Concept to Support Multi-Dimensional Data Analytics for Relational Database Management Systems (December 2016)

Industries use information for decision making to help process changers and business expansions. They use historical data to produce the required information. Preparation of information varies with the way of arranging, retrieving and processing data accurately. Decision support systems use many different approaches to design and data manipulation. Existing small to medium systems still use relational databases and basic query models as primary data analysis technique. But large scaled enterprise systems use different analytical, data warehousing and business intelligent systems rather than using databases due to the numerous RDBMS limitations. As described in (Ballard, et al., 1998, February) data warehousing concept evolve the easy access method of quality data in a structured store for decision making. Objective of this paper is to introduce an advanced database and query model design to support data analysis, business intelligence and data visualization over relational database management systems.