Cost-Based Oracle Fundamentals

Cost-Based Oracle Fundamentals
Average customer rating:

Jonathan is a tease... but it's a great book!

Invaluable Knowledge and Applicability

Another brilliant book by Jonathan Lewis

Excellent Book! Recommended!

How much of it is useful ???

Cost-Based Oracle Fundamentals
Jonathan Lewis
Manufacturer: Apress
ProductGroup: Book
Binding: Paperback

Software Development | Software Design, Testing & Engineering | Programming | Computers & Internet | Subjects | Books
Database Management Systems | Databases | Computers & Internet | Subjects | Books
General | Oracle | Databases | Computers & Internet | Subjects | Books
General | Databases | Computers & Internet | Subjects | Books
General | Software | Computers & Internet | Subjects | Books
Look Inside Computer Books | Trip | Specialty Stores | Books
Similar Items:

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)

Effective Oracle by Design (Osborne ORACLE Press Series)

Optimizing Oracle Performance

Oracle Insights: Tales of the Oak Table

Accessories:

Forecasting Oracle Performance

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions

ASIN: 1590596366

Book Description

The insights that Jonathan provides into the workings of the cost-based optimizer will make a DBA a better designer, and a Developer a better SQL coder. Both groups will become better troubleshooters.

— Thomas Kyte, VP (Public Sector), Oracle Corporation

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columns--and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong?

If you've suffered the frustration of watching the optimizer do something completely bizarre when the best execution plan is totally obvious, or spent hours or days trying to make the optimizer do what you want it to do, then this is the book you need. You'll come to know how the optimizer "thinks," understand why it makes mistakes, and recognize the data patterns that make it go awry. With this information at your fingertips, you will save an enormous amount of time on designing and trouble-shooting your SQL.

The cost-based optimizer is simply a piece of code that contains a model of how Oracle databases work. By applying this model to the statistics about your data, the optimizer tries to efficiently convert your query into an executable plan. Unfortunately, the model can't be perfect, your statistics can't be perfect, and the resulting execution plan may be far from perfect.

In Cost-Based Oracle Fundamentals, the first book in a series of three, Jonathan Lewis--one of the foremost authorities in this field--describes the most commonly used parts of the model, what the optimizer does with your statistics, and why things go wrong. With this information, you'll be in a position to fix entire problem areas, not just single SQL statements, by adjusting the model or creating more truthful statistics.

Customer Reviews:

Jonathan is a tease... but it's a great book!.......2007-08-24

Each quarter my team of DBA's has one book that we read and discuss in team meetings. This quarter, Cost-Based Oracle Fundamentals is it. This book is a wholly remarkable book for the moderate to advanced DBA. It is a deep dive into the Oracle optimizer, providing some wonderful insights into not only how it works, but why. It is not a book for the faint of hart, or those waiting breathlessly for retirement. It is a book for those who want to understand the CBO in more depth.

Within the book, Jonathan provides insights into how the CBO *should* work. He follows up often by demonstrating the maturing (or devolving as the case may be) of the CBO from version to version. Beyond his own experimentation and results, he leads the reader into the process that he has followed to come to understand the internals of the CBO, providing a road map allowing the reader to continue to explore the optimizer in future releases.

However, I must take Jonathan to task, for he is a nasty tease. This book was released about two years ago. In it, he leads us on with promises of forthcoming volumes 2 and 3, dangling the carrot out there for us to follow. Sadly, these volumes are yet to be seen. Jonathan! Quit running to and fro filling our heads with knowledge at various conferences and write those books man!

A caution for the new DBA or the cursory SQL developer, you may find this book overwhelming at first glance. For the new or even intermediate DBA, it might be hard to derive practical application of what Jonathan is teaching at first glance. Take your time with the material and the insight that you will gain will be invaluable.

Overall, if you want a book with meat, then this is the book for you. It will expand your mind and the way you look at the Oracle CBO.

Invaluable Knowledge and Applicability.......2006-11-28

This book gets a prized spot on my technical shelf. It is a challenging read, and has taken the most time of any book I have to get through, but it is quite good. The optimizer is such a core part of what makes Oracle worth the investment, that any DBA who does not understand it is doing a disservice to the company investing such capital into the product.

Lewis' use of proof through example is second to none, and leaves me feeling confident about the knowledge I've gained. His insights are not only theoretical, but quite applicable. I learned much about manipulating and using the DBMS_STATS package, about data model design and why data knowledge is so critical to the DBA.

My nervousness about hints and about upgrades was reinforced with concrete examples that have improved my test plans, upgrade methodologies and overall made me a more competent DBA. I've directly used this knowledge to support my clients in better ways than I would have before it, and that is well worth the price of admission and the time to get through such an in-depth work.

Thanks Jonathan!

Another brilliant book by Jonathan Lewis.......2006-10-18

This is the book that one definitely needs to read (and understand) in order to get an idea what the CBO is all about.

Jonathan's examples and presentation is excellent. Though the topic is quite intense, the book is quite pleasant to read. This book is a worthy follow up the classic "Practical Oracle8i".

As regards the usefulness of the book in real world scenarios, I can only say that if one wants to approach SQL tuning as a science, one needs to learn the CBO, and this book is essential.

This is volume 1 or 3. I will definitely be eagerly waiting for the next volumes.

Excellent Book! Recommended!.......2006-09-14

I bought the book "Cost-Based Oracle Fundamentals" and I found it extremely helpful and I've been recommending to other people - both DBA's and SQL writers. I've been pretty good at tuning problem SQL in the past mostly by knowing (or learning) the data and forcing the best plan using hints. But the row estimates/cost figures that the optimizer comes up with have always been a mystery to me. This book explains a lot of what I have been seeing. (The answer is 5%!)

The book is very well laid out and it meant to conceptually show how the optimizer makes decisions and how it can be mislead into making wrong decisions. It also spells out many situations where the optimizer is making a SWAG and indicates where you should pay attention to the explain plans and perhaps hint them so they run properly.

With the suggestions in the book, I have made great strides in fixing our database so that we get rational explain plans from the optimizer. However, we have so many queries based on SYSDATE calculations that I now realize that many of the row estimates (5%) are crap and that frequently this is what has been causing us issues. (I knew that the row estimates were the issue. I just never knew where the harebrained estimates actually came from. Now I can say, "Oh, 7 million. That's 5% of 152 million rows. The optimizer doesn't know how many rows you're bringing back for SYSDATE and SYSDATE-1, so it's using 5%")

Thanks to this book, I can now also show that half the time the CBO has been picking the right plan for the wrong reasons! Who says, "Two wrongs don't make a right?" They do sometimes. Now, as I untangle all this, I have to worry about Oracle suddenly selecting the wrong plan for only one wrong reason! But I've at least been able to explain why the performance of some SQL seems to periodically go haywire and then fix itself without any changes having been made to the SQL.

I have so many more answers and explanations now that when people see the yellow and black book on my desk, they ask me, "Is this the book?" I look forward to the next two volumes in the series.

How much of it is useful ???.......2006-07-08

I took two days and went through the book. Sounds more like
R&D book rather than something which I am going to use. If you want to learn good SQL tuning, stick with Guy Harrison - it is more practical.

Microsoft SQL Server(TM) 2000 Programming Step by Step (Dv-Dlt Fundamentals)

Average customer rating:

The gate for the beginner
Don't waste your money
Worthless
From an Access background
Glad I didn't buy it!

Microsoft SQL Server(TM) 2000 Programming Step by Step (Dv-Dlt Fundamentals)
Rebecca Riordan
Manufacturer: Microsoft Press
ProductGroup: Book
Binding: Paperback

Relational Databases | Databases | Computers & Internet | Subjects | Books

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

Databases | Software | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

General | Programming | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books

All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books

Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

SQL Server 2000 Programming by Example
Microsoft(r) SQL Server(tm) 2000 Analysis Services Step by Step
SQL Server 2000: A Beginner's Guide (Book/CD-ROM)
Professional SQL Server 2000 Programming (Programmer to Programmer)
SQL Server 2000: The Complete Reference

ASIN: 0735611424

Product Description

Microsoft provides its software solutions with user's guides that give the most complete information for Microsoft applications. Documentation sets describe both advantages and some basic features along with answers to the most frequently asked questions.

Customer Reviews:

The gate for the beginner.......2006-05-02

SQL Server, this is the topic that I think it is very hard for me to learn. But after I have try this book, it is really make really funny to learn SQL server. I learn a lot of basic things such as table, query, rule, user define function... from this book and now I could SQL Server to manage my own database. There are two advantage that I found in this book:

1. Each chapter is guide you from the basic and have many screen shoot for you to learn. You do not need to have any previous knowledge about SQL server. What you need is the basic task with windows operating system, such as shut down, restart, moving windows dialog box, resize windows dialog box, copy/cut or paste file...
2. The author use a very simple word to explain to the reader and very easy to follow each step.

Whether this book is design for the beginner, you will need to read additional book after you read this book. This book just give you a starting point only, if you want to master sql server 2000 you should try to find another resource which guide you deeply in this technology.

Don't waste your money.......2005-02-23

When I first started to read this book, I wanted to learn more about SQL, but this book failed. As the title says, it's pretty much just a bunch of step-by-step exercises and screen shots, but doesn't really get into too much detail, or give any reasons or explanation.

The only reason why I am writing a review now is that I now have something to compare this book against.

If you want a great book on SQL programming, I suggest you pick up "Profession SQL Server 2000 Programming" by Robert Vieira (Wrox Press), which is a great book even for novices.

IF you really want to buy this book, I have a copy that I'd be willing to let go for dirt cheap.

Worthless.......2003-11-07

If you want 600 pages of screen shots with virtually no explanation of the underlying concepts being presented, then this book is for you. I cannot believe this book would be useful to anyone trying to learn SQL programming. A complete waste of money and time.

From an Access background.......2003-01-23

I have had a lot of experience with Access but none with SQL server. This book told me everything I needed to get up and running quickly with SQL server. The presentation is very clear and readable. I also learned me a few new things about relational databases. Thanks Rebecca.

Glad I didn't buy it!.......2002-06-01

Having a reasonable background in Access, I thought this would be a good book to learn SQL Server. WRONG! About the only things she explains are the wizards - which I thought were supposed to be self-explanatory. I was about 200 pages into the book before I found something even remotely useful, and by then I had no patience left to finish the book. If you're really thinking about buying this book, save yourself some money... at least go to the book with a list of questions and try to answer them using just the book... I guess I should check out Andy Baron/Mary Chipman's book on Access/SQL Server/ADPs... This book would only be good for starting up the BBQ...

OCP Oracle9i Database: Fundamentals I Exam Guide

Average customer rating:

Mildly bad!!!!
Average book for OCP Fundamentals II
Decent OCP book
Oracle should rewrite this book
Blows

OCP Oracle9i Database: Fundamentals I Exam Guide
Jason Couchman , and Sudheer Marisetti
Manufacturer: McGraw-Hill Osborne Media
ProductGroup: Book
Binding: Hardcover

General | Certification Central | Computers & Internet | Subjects | Books

Relational Databases | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Programming | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books

Look Inside Reference Books | Trip | Specialty Stores | Books

All Amazon Upgrade | Amazon Upgrade | Stores | Books

Computers & Internet | Amazon Upgrade | Stores | Books

Professional & Technical | Amazon Upgrade | Stores | Books

Reference | Amazon Upgrade | Stores | Books

All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books

Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books

Professional | Qualifying Textbooks - Fall 2007 | Stores | Books

Reference | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

OCP Oracle9i Database: Fundamentals II Exam Guide
OCP Introduction to Oracle9i: SQL Exam Guide
OCP Oracle9i Database: Performance Tuning Exam Guide
OCP: Oracle9i DBA Fundamentals II Study Guide
OCA/OCP: Oracle9i DBA Fundamentals I Study Guide

ASIN: 0072195401

Book Description

Prepare to pass the OCP DBA Fundamentals I exam using this Oracle Press study guide. You’ll get complete coverage of all exam topics followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice exam questions in an adaptive format.

Customer Reviews:

Mildly bad!!!!.......2006-04-30

I read this book cover to cover..twice!!! The authors did a terrible job explaining the Architectural Components in depth. For any novice or beginner, how would you expect to get a grasp on storage structures(tablespaces,indexes,blocks) if you're getting a half ass instruction on what the main key components are? Their explaination of the buffer cache was no more that 10 lines of text. Nothing mentioned about the different structures within that cache. And the same goes for the other components.

And as the other reviewer indicated, its terribly organized.The index in the book is a total joke.

I think this is a great book for beginners who want to have a "general" understanding of Oracle,but if you want to conceptually understand the material and not blow $125, don't purchase this book.
Get Sybex. Its does exactly opposite of what this book does. It Covers just about everthing you need to understand as a junior dba and test taker.

Average book for OCP Fundamentals II.......2005-11-29

This book does not cover all the details for Fundamentals II. It is a good source for reference. The CD accompanied with the book has wrong answers for the questions. You may need to refer additional book(s), may be sybex one along with this one.

Decent OCP book.......2004-06-11

I used this book to prepare for my Exam 1z0-031 but not as main reference. I used it to supplement the Sybex Study guide. It has some errors but I would say it is a decent book to use as preparation tool. I liked the practice exam questions. I did not have to buy any sotware for my practice exam questions. Those already in this book helped me.
I give 3 stars and I will definitely recommend this book as supplement to the Sybex study guide if you are preparing for OCP exam Exam 1z0-031.

Oracle should rewrite this book.......2004-05-01

I used this Oracle Press book, the Sybex book, and the Self Test Software prep questions to pass the Oracle Fundamentals I exam.

This book has received justifiable bad press. I bought it anyway, as I did not want to risk missing any material that might be presented in the "official" Oracle exam guide. I'm sure you'll buy it for the same reason.

The Oracle Press book was difficult to read. The issues go beyond spelling errors and the many "Oracle 8I" references that should say "Oracle 9i". I can correct these errors myself. This book has serious editing issues that will impact your ability to understand the concepts presented. The author knows his stuff but the editor really dropped the ball. Oracle should take pity on certified hopefuls and rewrite it.

However, not all is lost. You can avoid getting mired down in Oracle's presentation by printing the exam objectives from the Oracle web site and focus your studies around this outline. Consider buying the Sybex book as an added guide. Pull details from both books using your exam ojective outline. The only exam objective I found to be missing from the Oracle Press book was on NLS. NLS is covered in the Sybex book.

Good luck!

Blows.......2004-01-20

This book blows. I read to book cover to cover and it misses alot of the key concepts covered on the exam. It dosen't go into enough detail in areas that need to be and goes into to much detail into subject such as utilities such as OEM. I don't even remember the book covering NLS topics. I suggest ordering a different prep book for this exam and buying STS software.

Schaum's Outline of Fundamentals of SQL Programming

Average customer rating:

for new DBAs

Schaum's Outline of Fundamentals of SQL Programming
Ramon Mata-Toledo , and Pauline Cushman
Manufacturer: McGraw-Hill
ProductGroup: Book
Binding: Paperback

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Programming | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Study Guides | Reference | Subjects | Books

All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books

Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books

Reference | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

Schaum's Outline of Fundamentals of Relational Databases
Schaum's Outline of Visual Basic
Schaum's Outline of Programming with Java
Schaum's Outline of Programming with C++
Schaum's Outline of Computer Networking

ASIN: 0071359532

Book Description

Standard SQL guarantees that no matter what the database implementation, the features of the language will be applicable across all platforms. Over 200 completely solved problems plus 200 supplementary problems reinforce students’ understanding and skills. Features the syntax used by the most important database developers, Oracle and Microsoft, to familiarize students with this common language. Includes labs and practice tests like those used in database certification exams.

Customer Reviews:

for new DBAs.......2005-01-01

Are you a new database administrator? Trying to be one? Or needing to pass a certification exam in one of the main proprietary databases, like Oracle, IBM's db2 or Microsoft SQL Server? And you need to prepare for that exam. Well, there are third party books devoted to each vendor's exam. You should probably get an appropriate one and study it carefully. But you can also improve your chances of passing any of those exams by tackling the problems in this book.

Mata-Toledo offers some 400 problems. With the answers to half of these in the book. He tests virtually the entire syntax of SQL; an industry standard. Everything from arithmetic functions to group functions to making complex queries, and more. Of course, it will take you time to go through these problems. But that is the point of the book, after all.

Also, the book is cheap compared to the other books that specialise in a given database vendor's exam.

Average customer rating:

Easy to read , well structured, great code extracts, accompaning CD is great!
Shockingly Good
SQL Learner
I enjoyed reading this book very much.
It Works

SQL Fundamentals
John J. Patrick
Manufacturer: Prentice Hall
ProductGroup: Book
Binding: Paperback

Relational Databases | Databases | Computers & Internet | Subjects | Books

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

Databases | Software | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books
Similar Items:

Oracle 10g: SQL
Oracle9i: SQL, with an Introduction to PL/SQL
70-284 MCSE Guide to Microsoft Exchange Server 2003 Administration
Applied Data Communications: A Business-Oriented Approach
Microsoft Office Access 2003, Illustrated Complete, CourseCard Edition (Illustrated Series)

ASIN: 0130960160

Amazon.com

SQL Fundamentals deserves praise because it documents the implementation of Structured Query Language (SQL) in Oracle databases and Access databases simultaneously. Readers find out how to do simple single-table queries, more complicated multitable queries, table creation, joins, unions, and calculations in both environments in a variety of circumstances. For those who've never worked with SQL before and plan to use one of the two covered platforms, this book will make a fine starting point, since it explains elementary SQL concepts too.

Here's the approach: Author John J. Patrick sets out a task--for example, writing a statement that yields a left outer join of two databases. Then he proceeds to accomplish the task in both Access and Oracle, presenting the platforms' respective SQL statements side by side. The differences between the two implementations of SQL are obvious, making it easy for someone familiar with one of the two environments to adapt to the other. The reader will also find the numbered and highlighted key passages, which include details on the facing page, very helpful.

Patrick, who based this book on a university course he teaches, knows the value of practical experience--he's loaded SQL Fundamentals with exercises in addition to the tasks he completes himself. He leaves most of these to the reader but provides solutions to some of the more interesting ones. Databases for the illustrations and exercises are included on the companion CD-ROM. --David Wall

Customer Reviews:

Easy to read , well structured, great code extracts, accompaning CD is great!.......2007-07-12

Originally bought the book for a class in school, and three years later, it is on my desk... the only one from my text books. It is easy to learn from the book and practice. It is very easy to read, one could actually read it for leisure. It has a MS Access DB with it in the CD, so you can easily follow what the author is doing, and practice it on your own. It has served as a good reference for me where I had to write code and needed a quick reference.
The index at the back is indepth. I like a book that would easily point me to something that I need, I dont want to search a whole chapter to find it, and he has done a great job on providing meaningful index. Have used it from my amature years in SQL to the more advanced years.
Would highly recommend it!

Shockingly Good.......2007-07-09

I bought this book for a SQL programming class I was taking over the summer and I was very surprised to find that it was very easy to read and understand. Being that it's a programming book I expected it to be really dry and a hard read but its not. I am very happy with the book and would suggest it to anyone wanting to teach themselves SQL. (I find it sad that the book taught me more than the instructor of the class. I should have just bought this book)

SQL Learner.......2007-05-30

I have just started using this book and so far I really think it has help me more than any other SQL book. I purchase this book to learn on my own because the universities use this book.

I enjoyed reading this book very much........2006-12-01

When I first skimmed through this book at my local Borders, I asked myself "Why wouldn't this guy write one book for Access SQL and one book for Oracle SQL?" After I sat down and actually read the book I realized that this wasn't as confusing as I had originally thought; the author was actually trying to show how SQL has standards, yet the products have their own variations. Remarkably, Mr Patrick does not write in a style that uses obscure references, witty axioms or generalizations. There are many query examples where he explains the desired results, then gives the SQL that could be used by mistake, and then proper SQL and explains why the original query was not correct. That is great to see that.
On page 32, Mr Patrick says "...most SQL books have you work with a database that is tame and contains no challenges. This book is different..."
I would recommend this book to anyone who would like to learn more about SQL in either Access or Oracle.

It Works.......2006-11-03

The content of the book is well laid out and easy to follow, but I thought it was too rudimentary for my purposes. There were, however, a lot of SQL code to copy and practice with.

I probably would not buy it again if I had the chance for 'do-overs'.

Oracle Database Foundations: Technology Fundamentals for IT Success

Average customer rating:

Oracle Database Foundations: Technology Fundamentals for IT Success
Bob Bryla
Manufacturer: Sybex
ProductGroup: Book
Binding: Paperback

Data Mining | Databases | Computers & Internet | Subjects | Books

Relational Databases | Databases | Computers & Internet | Subjects | Books

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books
ASIN: 0782143725

Book Description

The world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year. The purpose of the Foundations series is to identify these concepts and present them in a way that gives you the strongest possible starting point, no matter what your endeavor.

Oracle Database Foundations provides essential knowledge about installing, configuring, maintaining, and querying Oracle 9i and 10g databases. What you learn here will benefit you in the short term, as you acquire and practice your skills, and in the long term, as you use them. Topics covered include:

Basic relational database concepts
Reporting and querying using SQL*Plus and iSQL*Plus
Creating and maintaining a database
Managing user access and security
Understanding Oracle database functions
Using multiple tables in a query
Restricting, sorting, and grouping data
Optimizing database performance
Creating backups
Troubleshooting database errors

Average customer rating:

Course ILT: SQL Fundamentals
Course Technology
Manufacturer: Course Technology
ProductGroup: Book
Binding: Spiral-bound

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Operating Systems | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books
ASIN: 0619022906

Book Description

An affordable, easily scannable one-day training guide designed for use in instructor-led training courses.

An Extended Entity-Relationship Model: Fundamentals and Pragmatics (Lecture Notes in Computer Science)

Average customer rating:

An Extended Entity-Relationship Model: Fundamentals and Pragmatics (Lecture Notes in Computer Science)
Martin Gogolla
Manufacturer: Springer
ProductGroup: Book
Binding: Paperback

General | Databases | Computers & Internet | Subjects | Books

Book Description

This text presents a comprehensive introduction to an extended Entity-Relationship model both on a conceptual and on a formal, mathematical level. In addition to the primitives given by the data model the text introduces a language for the formulation of constraints in order to restrict database states to consistent ones. The text explains an implementation of the approach chosen in the logic programing language PROLOG and discusses in this context the computational power of the proposed calculus. The extended Entity-Relationship calculus is used to define the meaning of the relational query language SQL. A nice feature of the approach is that it becomes possible to prove language properties on a sound mathematical basis.

Average customer rating:

don't judge the book by its looks
read the first 5 chapters so far
The Bible for Database Systems
A confusion of purpose
Decent book

Fundamentals of Database Systems
Ramez Elmasri , and Shamkant B. Navathe
Manufacturer: Benjamin-Cummings Publishing Company, Subs of Addison Wesley Longman, Inc
ProductGroup: Book
Binding: Paperback

General | Databases | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books
Similar Items:

Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)
Oracle 9i Programming: A Primer
Operating System Concepts
Software Engineering: A Practitioner's Approach
Computer Networking: A Top-Down Approach Featuring the Internet (3rd Edition)

ASIN: 0805317538

Book Description

Responding to the requests of database professors nationwide,the leading textbook for the introductory database management course is being fully revised in time for the startof Fall 1999 classes. Fundamentals of Database Systems, Third Edition is updated to reflect the latest developments indatabase research and practice. It combines clear explanations of theory and real systems, broad coverage of modeling and design of databases, and excellent examples with up-to-date introductions to modern database technology.

Features of the Third Edition

Presents clear and complete discussion of the relational approach including modeling, design, and query languages

Reorganized material on data modeling to clearly separate entity relationship modeling, extended entity relationship modeling, and object-oriented modeling

NEW! Gives examples of real database systems - Oracle and Microsoft Access - in Ch. 10

NEW and EXPANDED! Provides coverage of the object-oriented and object relational approach to data management including ODMG and SQL3

NEW! Includes discussion of decision support applications of data warehousing and data mining, as well as emerging technologies of web databases, multimedia, and mobile databases

NEW! Covers advanced modeling in the areas of active, temporal, and spatial databases

NEW! Discusses current database application areas of GIS, genome, and digital libraries

Customer Reviews:

don't judge the book by its looks.......2007-01-13

it's a thick book but doesn't have much depth and the way they cover the material will put most to sleep. An expensive >$100 database book should be much better.

read the first 5 chapters so far.......2007-01-11

I bought this book for a graduate level database management course. It starts off with the very basics. Thankfully, my professor breezed through the first few chapters. Overall, the content is good and I would recommend it for anyone who wants to learn the theory behind database design and management.

The Bible for Database Systems.......2006-12-11

This is an excellent and thorough analysis of database processes involving transactions, concurrency control, security and covers relational tables, object-relational dbs as well as object oriented technology. There is a thorough overview of UML as well as ER design tools. It is a tough read and covers alot of material and is very theoretical but practical. Relational algebra and calculus are covered thoroughly. This is recommended for an advanced database course as it's coverage of SQL is coarse and cursory. Instead this book is intended more for a behind the scenes analysis of database technology. An excellent database course as a prerequisite for using this book would use Mannino's Database Design, Application, Development and Administration. Mannino's book has an excellent coverage of SQL and its applications.

A confusion of purpose.......2006-11-27

This 1100 page tome of a book is a case study in what happens when you try to be all things to all people. There's a good book on database theory in there somewhere (most of chapters 5,6,10,11,...), and there's a good book on database design and practice, and there's a good book on database implementation.

This book, though, is none of those good books. Instead, it is a gigantic bunch of unmotivated information that lacks any kind of focus or goal. It's impossible to read about database theory without being lectured about ER and EER diagrams or wading through "business" examples with employees and payroll systems. It's impossible to read about database design without encountering extreme formalism in the descriptions of the normal forms. The information needed for implementation is scattered so sparsely that one would be well-advised to find another book (preferably that weighs less than five pounds).

Decent book.......2006-11-11

This was a good book for what was required for the class I took.

Sql Fundamentals & Visio Essn Sys Analys (2nd Edition)

Average customer rating:

Sql Fundamentals & Visio Essn Sys Analys (2nd Edition)

Manufacturer: Prentice Hall PTR
ProductGroup: Book
Binding: Paperback

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books
ASIN: 0131456075

Books:

Books Index

Books Home

Recommended Books