DocumentCode :
2549397
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
fYear :
2007
fDate :
22-28 April 2007
Firstpage :
2
Lastpage :
2
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;
fLanguage :
English
Publisher :
ieee
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
Type :
conf
DOI :
10.1109/ICONS.2007.17
Filename :
4196304
Link To Document :
بازگشت