International Journal of Computer Applications
On-Line Transaction Processing (OLTP) systems have been using the traditional relational database management system for many years. On-Line Analytical Processing (OLAP) system for analytical reporting is optimized to aggregate many records which involve more read operations. Hence to enhance the performance in OLAP systems various modeling options like star schema, extended star schema was implemented. But with the latest innovations in hardware technologies like availability of multi core dual processors, availability of 64 bit processors, decreasing cost of main memory and software technology innovations like in-memory computing, columnar storage and other with various other new features now there is less concern towards the performance degradation and performance optimization in a data warehouse system.