首页 > 其他分享 >论文笔记:Optimizing Queries Using Materialized Views: A Practical, Scalable Solution

论文笔记:Optimizing Queries Using Materialized Views: A Practical, Scalable Solution

时间:2023-03-15 21:14:07浏览次数:64  
标签:Optimizing Views Materialized Scalable 视图 物化 Using

论文笔记:Optimizing Queries Using Materialized Views: A Practical, Scalable Solution

微软 SQL Server 关于优化器如何利用物化视图来改写查询的论文。它主要处理 SPJG 类型的物化视图与查询匹配,当查询 Query 可以通过在某个物化视图加上一些补偿操作(加filter, group by,甚至join)实现等价时,就可以改写成物化视图。

Abstract

Introduction

Defining the problem

Computing a query expression from a view

Fast filtering of views

Experimental results

词汇

scalabl 计算机、网络、软件等)可扩展的,可升级的

Reference

标签:Optimizing,Views,Materialized,Scalable,视图,物化,Using
From: https://www.cnblogs.com/qwerty-ll/p/17220024.html

相关文章