使用LUW物化查询表增强DB2性能

Second International Conference on Systems (ICONS'07) Pub Date : 2007-04-22 DOI:10.1109/ICONS.2007.17

S. Satish, M.K. Saraswatipura, S. Shastry

{"title":"使用LUW物化查询表增强DB2性能","authors":"S. Satish, M.K. Saraswatipura, S. Shastry","doi":"10.1109/ICONS.2007.17","DOIUrl":null,"url":null,"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.","PeriodicalId":355435,"journal":{"name":"Second International Conference on Systems (ICONS'07)","volume":"9 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2007-04-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"10","resultStr":"{\"title\":\"DB2 performance enhancements using Materialized Query Table for LUW\",\"authors\":\"S. Satish, M.K. Saraswatipura, S. Shastry\",\"doi\":\"10.1109/ICONS.2007.17\",\"DOIUrl\":null,\"url\":null,\"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.\",\"PeriodicalId\":355435,\"journal\":{\"name\":\"Second International Conference on Systems (ICONS'07)\",\"volume\":\"9 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2007-04-22\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"10\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Second International Conference on Systems (ICONS'07)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ICONS.2007.17\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Second International Conference on Systems (ICONS'07)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICONS.2007.17","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 10

摘要

应用程序的性能已成为当务之急。在应用程序调优和数据库调优方面，实现期望的吞吐量率存在许多挑战。物化查询表(MQT)就是用于增强OLTP/OLAP应用程序性能的一种有效工具。本演讲的目的是说明MQT及其在IBM数据库产品DB2 UDB中使用的相关技术的重要性。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

DB2 performance enhancements using Materialized Query Table for LUW

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.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

Second International Conference on Systems (ICONS'07)

自引率

0.00%

发文量