View Updating and Relational Theory (Paperback)
暫譯: 視圖更新與關聯理論 (平裝本)

C. J. Date

View Updating and Relational Theory (Paperback)

買這商品的人也買了...

商品描述

Views are virtual tables. That means they should be updatable, just as "real" or base tables are. In fact, view updatability isn’t just desirable, it’s crucial, for practical reasons as well as theoretical ones. But view updating has always been a controversial topic. Ever since the relational model first appeared, there has been widespread skepticism as to whether (in general) view updating is even possible.

In stark contrast to this conventional wisdom, this book shows how views, just like base tables, can always be updated (so long as the updates don’t violate any integrity constraints). More generally, it shows how updating always ought to work, regardless of whether the target is a base table or a view. The proposed scheme is 100% consistent with the relational model, but rather different from the way updating works in SQL products today.

This book can:

  • Help database products improve in the future
  • Help with a "roll your own" implementation, absent such product improvements
  • Make you aware of the crucial role of predicates and constraints
  • Show you how relational products are really supposed to behave

Anyone with a professional interest in the relational model, relational technology, or database systems in general can benefit from this book.

商品描述(中文翻譯)

視圖是虛擬表格。這意味著它們應該是可更新的，就像「真實」或基礎表格一樣。事實上，視圖的可更新性不僅是可取的，對於實際原因和理論原因來說，它是至關重要的。但是，視圖更新一直是一個有爭議的話題。自從關聯模型首次出現以來，對於視圖更新是否（一般而言）甚至可能的廣泛懷疑一直存在。

與這種傳統智慧形成鮮明對比的是，本書展示了視圖如何像基礎表格一樣，總是可以被更新（只要更新不違反任何完整性約束）。更一般地說，本書展示了更新總是應該如何運作，無論目標是基礎表格還是視圖。所提出的方案與關聯模型100%一致，但與當今SQL產品中的更新方式有相當大的不同。

本書可以：

- 幫助數據庫產品在未來改進
- 幫助實現「自製」的實作，若缺乏此類產品改進
- 讓您意識到謂詞和約束的關鍵角色
- 向您展示關聯產品實際應該如何運作

任何對關聯模型、關聯技術或數據庫系統有專業興趣的人都可以從本書中受益。

類似商品

最後瀏覽商品 (8)