公共云中物化视图选择的代价模型
Cost Models for Selecting Materialized Views in Public Clouds
摘要：
数据仓库性能通常是通过物理数据结构（如索引或物化视图）来实现的。在这种情况下，成本模型可以帮助选择一组相关的性能优化结构。然而，选择在云中变得更加复杂。优化的标准实际上至少是二维的，货币成本平衡了整个查询响应时间。本文介绍了适合云计算的现收现付模式的新成本模型。基于这些成本模型，定义了一个优化问题，发现，在候选视图，那些要物化，以最大限度地减少使用和维护数据库在公共云中的总成本和总响应时间ofa给定的查询工作量。我们的实验表明，维护物化视图总是有利的，无论是在性能和成本方面。
英文摘要：
Data warehouse performance is usually achieved through physical data structures such as indexes or materialized views. In this context, cost models can help select a relevant set ofsuch performance optimization structures. Nevertheless, selection becomes more complex in the cloud. The criterion to optimize is indeed at least two-dimensional, with monetary cost balancing overall query response time. This paper introduces new cost models that fit into the pay-as-you-go paradigm of cloud computing. Based on these cost models, an optimization problem is defined to discover, among candidate views, those to be materialized to minimize both the overall cost of using and maintaining the database in a public cloud and the total response time ofa given query workload. We experimentally show that maintaining materialized views is always advantageous, both in terms of performance and cost.
机构、总结、中文摘要均由AI分析而来，可能存在错误，请以论文正文为准。
