在电信服务管理的大型数据存储中使用物化视图的实践经验

Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130) Pub Date : 1998-08-26 DOI:10.1109/DEXA.1998.707509

Wijnand Derks, W. Jonker

{"title":"在电信服务管理的大型数据存储中使用物化视图的实践经验","authors":"Wijnand Derks, W. Jonker","doi":"10.1109/DEXA.1998.707509","DOIUrl":null,"url":null,"abstract":"This paper presents our enhancements to the work of Harinarayan (1996) on the use of materialized views for query execution speed-up. The enhancements were developed when trying to apply the basic approach in a real-life situation on a very large data store with a complex multidimensional model of 18 million views. Our contributions are an extension of the basic model, the development of an efficient implementation, and a heuristic for view size estimation. In addition, we experimented with different cost functions and validated our enhancements in actual experiments. The paper shows that the approach of Harinarayan (augmented with our enhancements) is applicable in practical situations with large view lattices.","PeriodicalId":194923,"journal":{"name":"Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130)","volume":"17 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1998-08-26","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"2","resultStr":"{\"title\":\"Practical experiences with materialized views in a very large data store for telecommunication service management\",\"authors\":\"Wijnand Derks, W. Jonker\",\"doi\":\"10.1109/DEXA.1998.707509\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"This paper presents our enhancements to the work of Harinarayan (1996) on the use of materialized views for query execution speed-up. The enhancements were developed when trying to apply the basic approach in a real-life situation on a very large data store with a complex multidimensional model of 18 million views. Our contributions are an extension of the basic model, the development of an efficient implementation, and a heuristic for view size estimation. In addition, we experimented with different cost functions and validated our enhancements in actual experiments. The paper shows that the approach of Harinarayan (augmented with our enhancements) is applicable in practical situations with large view lattices.\",\"PeriodicalId\":194923,\"journal\":{\"name\":\"Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130)\",\"volume\":\"17 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"1998-08-26\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"2\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/DEXA.1998.707509\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/DEXA.1998.707509","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 2

摘要

本文介绍了我们对Harinarayan(1996)关于使用物化视图来加快查询执行速度的工作的改进。这些增强是在尝试将基本方法应用于具有1800万视图的复杂多维模型的大型数据存储的实际情况时开发的。我们的贡献是基本模型的扩展，高效实现的开发，以及视图大小估计的启发式。此外，我们还对不同的成本函数进行了实验，并在实际实验中验证了我们的改进。本文证明了Harinarayan方法(经过我们的增强)适用于具有大视图格的实际情况。

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

查看原文本刊更多论文

Practical experiences with materialized views in a very large data store for telecommunication service management

This paper presents our enhancements to the work of Harinarayan (1996) on the use of materialized views for query execution speed-up. The enhancements were developed when trying to apply the basic approach in a real-life situation on a very large data store with a complex multidimensional model of 18 million views. Our contributions are an extension of the basic model, the development of an efficient implementation, and a heuristic for view size estimation. In addition, we experimented with different cost functions and validated our enhancements in actual experiments. The paper shows that the approach of Harinarayan (augmented with our enhancements) is applicable in practical situations with large view lattices.

求助全文

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

来源期刊

Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130)

自引率

0.00%

发文量