Ebook Download View Updating and Relational Theory (Theory in Practice), by C. J. Date
When some people considering you while checking out View Updating And Relational Theory (Theory In Practice), By C. J. Date, you might really feel so honored. However, instead of other individuals feels you have to instil in yourself that you are reading View Updating And Relational Theory (Theory In Practice), By C. J. Date not because of that factors. Reading this View Updating And Relational Theory (Theory In Practice), By C. J. Date will provide you more than people appreciate. It will certainly overview of understand more than individuals staring at you. Even now, there are lots of sources to learning, reviewing a book View Updating And Relational Theory (Theory In Practice), By C. J. Date still comes to be the front runner as a wonderful way.
View Updating and Relational Theory (Theory in Practice), by C. J. Date
Ebook Download View Updating and Relational Theory (Theory in Practice), by C. J. Date
View Updating And Relational Theory (Theory In Practice), By C. J. Date Actually, book is actually a window to the globe. Also lots of people might not such as reviewing books; guides will always offer the exact information concerning truth, fiction, encounter, journey, politic, religion, as well as much more. We are right here an internet site that provides compilations of books more than the book shop. Why? We give you lots of varieties of link to get the book View Updating And Relational Theory (Theory In Practice), By C. J. Date On is as you need this View Updating And Relational Theory (Theory In Practice), By C. J. Date You could discover this publication effortlessly here.
When some people taking a look at you while checking out View Updating And Relational Theory (Theory In Practice), By C. J. Date, you might really feel so happy. Yet, as opposed to other individuals feels you need to instil in on your own that you are reading View Updating And Relational Theory (Theory In Practice), By C. J. Date not due to that reasons. Reading this View Updating And Relational Theory (Theory In Practice), By C. J. Date will provide you more than individuals appreciate. It will guide to recognize more than individuals looking at you. Already, there are many resources to knowing, checking out a book View Updating And Relational Theory (Theory In Practice), By C. J. Date still ends up being the front runner as a great way.
Why should be reading View Updating And Relational Theory (Theory In Practice), By C. J. Date Once again, it will certainly depend on exactly how you feel and also think of it. It is surely that a person of the benefit to take when reading this View Updating And Relational Theory (Theory In Practice), By C. J. Date; you can take more lessons straight. Also you have actually not undertaken it in your life; you can obtain the encounter by checking out View Updating And Relational Theory (Theory In Practice), By C. J. Date And also now, we will certainly present you with the on the internet book View Updating And Relational Theory (Theory In Practice), By C. J. Date in this web site.
What type of book View Updating And Relational Theory (Theory In Practice), By C. J. Date you will prefer to? Currently, you will not take the published publication. It is your time to get soft file book View Updating And Relational Theory (Theory In Practice), By C. J. Date rather the printed files. You can enjoy this soft data View Updating And Relational Theory (Theory In Practice), By C. J. Date in at any time you expect. Even it remains in expected location as the various other do, you could check out the book View Updating And Relational Theory (Theory In Practice), By C. J. Date in your gadget. Or if you want more, you can read on your computer or laptop computer to obtain complete display leading. Juts locate it here by downloading and install the soft data View Updating And Relational Theory (Theory In Practice), By C. J. Date in web link web page.
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.
- Sales Rank: #2169297 in eBooks
- Published on: 2012-12-20
- Released on: 2012-12-20
- Format: Kindle eBook
Amazon.com Review
Q&A with C.J. Date, author of "View Updating and Relational Theory"
Q. Why did you write this book?
A. View updating has long been regarded as one of the great unsolved problems in the database world. It’s also something I’ve been interested in for just about as long as I can remember! In fact, my very first two published papers (done jointly with a colleague at the time, Paul Hopewell), which appeared in 1971, had to do with view updating. Now I think I have something useful and constructive to say regarding how to solve this problem.
Q. So what exactly is the problem?
A. Well, perhaps I should first say what views are. As you know, databases are made up of tables. And there are two main kinds of tables-- base tables, which are the “real” ones in a sense, and views, which are “virtual” tables, defined in terms of the real ones. For example, a personnel database might have two base tables, EMP and DEPT, containing information about employees and departments, respectively. Now imagine some specific user of that database who happens to be interested only in employees who are programmers and who work in a department located in Silicon Valley. We can make life easier for that user by defining a view over EMP and DEPT, derived by (a) joining EMP and DEPT together and then (b) discarding everything from that join that doesn’t concern Silicon Valley programmers. As far as that user is concerned, that view is the database-- he or she can operate on that view exactly as if it were a base table. At least, that’s the idea. So that’s what views are-- virtual tables that the user thinks are real ones.
But since views are virtual, in a sense they don’t exist! (You know the definition of “virtual”: You can see it but it isn’t there. It’s the opposite of “transparent,” which means it’s there but you can’t see it. But I digress.) So when the user performs some operation on a view, what the system has to do is convert that operation into operations on the real tables (that is, the base tables) in terms of which that view is defined. Now, it turns out that this conversion process is comparatively straightforward in the case of retrieval operations-- it works 100 percent of the time. But update operations are much harder! In fact, many people have thought for a long time that the problem of converting update operations properly is, in the final analysis, unsolvable-- that is, certain updates on certain views just can’t be done at all.
Q. But you don’t agree with that position-- right?
A. Right! Numerous and varied approaches to the view update problem have been investigated over the past 40 years or so, but those approaches-- at least, the ones I’m familiar with-- just didn’t solve the problem. That is, they showed how some views could be updated, but there were always others that couldn’t be. By contrast, what I’m proposing (and here let me give credit to my friend David McGoveran, who’s been working with me on this issue for several years and whose ideas have heavily influenced my thinking on this topic) in effect allows all updates on all views. Let me immediately add that it’s true that those updates will sometimes fail, of course-- to be specific, they’ll fail if they violate some integrity constraint-- but that’s true for updates on base tables as well.
Q. So why is the ability to update views important?
A. Because without it, we have to give up on the goal of data independence-- a goal that, as a matter of fact, was one of Ted Codd’s primary motivations for introducing the relational model in the first place, back in 1969. By the way, I’m assuming here that you do know what data independence is. If you don’t, then please read the book!
Q. Any last points you’d like to make?
A. Yes. I said my scheme “allows all updates on all views.” That’s true, but let me say also that some people will probably find parts of what I’m proposing a little controversial. In this connection, I’ve tried to be as honest as I can and point out in the book those aspects of my proposals where there might well be some debate. So I don’t claim that what I have to say is the last word on the subject. Rather, what I’ve tried to do is make a step forward-- I’d like to think, a big step forward-- and move the debate up to another level, as it were. But I’m certainly open to constructive suggestions regarding possible improvements to what I propose.
About the Author
C.J. Date has a stature that is unique within the database industry. C.J. is a prolific writer, and is well-known for his best-selling textbook: An Introduction to Database Systems (Addison Wesley). C.J. is an exceptionally clear-thinking writer who can lay out principles and theory in a way easily understood by his audience.
Most helpful customer reviews
See all customer reviews...View Updating and Relational Theory (Theory in Practice), by C. J. Date PDF
View Updating and Relational Theory (Theory in Practice), by C. J. Date EPub
View Updating and Relational Theory (Theory in Practice), by C. J. Date Doc
View Updating and Relational Theory (Theory in Practice), by C. J. Date iBooks
View Updating and Relational Theory (Theory in Practice), by C. J. Date rtf
View Updating and Relational Theory (Theory in Practice), by C. J. Date Mobipocket
View Updating and Relational Theory (Theory in Practice), by C. J. Date Kindle
Tidak ada komentar:
Posting Komentar