{"product_id":"9781449357801","title":"View Updating and Relational Theory: Solving the View Update Problem","description":"\u003cp\u003eViews are \u003ci\u003evirtual\u003c\/i\u003e tables. That means they should be updatable, just as \"real\" or base tables are. In fact, view updatability isn’t just desirable, it’s \u003ci\u003ecrucial\u003c\/i\u003e, 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.\u003c\/p\u003e\u003cp\u003eIn stark contrast to this conventional wisdom, this book shows how views, just like base tables, can \u003ci\u003ealways\u003c\/i\u003e be updated (so long as the updates don’t violate any integrity constraints). More generally, it shows how updating \u003ci\u003ealways\u003c\/i\u003e 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.\u003c\/p\u003e\u003cp\u003eThis book can:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eHelp database products improve in the future\u003c\/li\u003e\n\u003cli\u003eHelp with a \"roll your own\" implementation, absent such product improvements\u003c\/li\u003e\n\u003cli\u003eMake you aware of the crucial role of predicates and constraints\u003c\/li\u003e\n\u003cli\u003eShow you how relational products are really supposed to behave\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eAnyone with a professional interest in the relational model, relational technology, or database systems in general can benefit from this book.\u003c\/p\u003e","brand":"O'Reilly Media, Incorporated","offers":[{"title":"Default Title","offer_id":47124085899504,"sku":"9781449357801","price":31.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781449357801_p0.jpg?v=1763831164","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781449357801","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}