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