Title :
DB2 performance enhancements using Materialized Query Table for LUW
Author :
Satish, Shanmugam K. ; Saraswatipura, Mohan K. ; Shastry, Suma C.
Author_Institution :
India Software Lab., Bangalore
Abstract :
Performance of an application has become the need of the hour. There have been lots of challenges in achieving the desired rate of throughput in terms of application tuning and database tuning. Materialized query table (MQT) is one such efficient tool used in enhancing the performance of OLTP/OLAP applications. This presentation is targeted to bring out the importance of MQT and its associated technologies used in DB2 UDB, an IBM Database Product.
Keywords :
SQL; data mining; data warehouses; query processing; transaction processing; DB2 performance enhancement; LUW; OLAP; OLTP; SQL; application tuning; data warehouse; database tuning; materialized query table; Application software; Costs; Databases; Decision support systems; Query processing; Software performance; Statistics; Throughput; Warehousing;
Conference_Titel :
Systems, 2007. ICONS '07. Second International Conference on
Conference_Location :
Martinique
Print_ISBN :
0-7695-2807-4
Electronic_ISBN :
0-7695-2807-4
DOI :
10.1109/ICONS.2007.17