Answering Queries Using Views (Synthesis Lectures on Data Management)
暫譯: 使用視圖回答查詢(數據管理綜合講座)
Foto Afrati, Rada Chirkova
- 出版商: Morgan & Claypool
- 出版日期: 2017-12-04
- 售價: $4,170
- 貴賓價: 9.5 折 $3,962
- 語言: 英文
- 頁數: 235
- 裝訂: Hardcover
- ISBN: 168173270X
- ISBN-13: 9781681732701
海外代購書籍(需單獨結帳)
相關主題
商品描述
The topic of using views to answer queries has been popular for a few decades now, as it cuts across domains such as query optimization, information integration, data warehousing, website design, and, recently, database-as-a-service and data placement in cloud systems. This book assembles foundational work on answering queries using views in a self-contained manner, with an effort to choose material that constitutes the backbone of the research. It presents efficient algorithms and covers the following problems: query containment; rewriting queries using views in various logical languages; equivalent rewritings and maximally contained rewritings; and computing certain answers in the data-integration and data-exchange settings. Query languages that are considered are fragments of SQL, in particular, select-project-join queries, also called conjunctive queries (with or without arithmetic comparisons or negation), and aggregate SQL queries.
商品描述(中文翻譯)
使用視圖來回答查詢的主題在過去幾十年中一直受到關注,因為它涉及查詢優化、資訊整合、資料倉儲、網站設計,以及最近的資料庫即服務(database-as-a-service)和雲端系統中的資料放置等領域。本書匯集了使用視圖回答查詢的基礎性研究,努力選擇構成該研究主幹的材料。它呈現了高效的演算法,並涵蓋以下問題:查詢包含性(query containment);使用各種邏輯語言重寫查詢的技術;等價重寫和最大包含重寫;以及在資料整合和資料交換環境中計算確定性答案。考慮的查詢語言是 SQL 的片段,特別是選擇-投影-連接查詢(select-project-join queries),也稱為合取查詢(conjunctive queries,無論是否包含算術比較或否定),以及聚合 SQL 查詢。