Database In Depth - Relational Theory for Practitioners
Author : C . J . Date
Size : 202
Press : Oreilly
About author:
_____________
He is a well known relational database authority, who also worked with EF Codd , relational database father.
He worked for IBM as core team member for the development of well known relational database products like DB2.
He also invented a new relational database product called Tutorial-d.he wrote so many books on relational database.
His one more book on the same topic is "Introduction to database Systems”. It is considered as academic book in so many universities.
Contents
________
Foreword
Preface
1. Introduction
2. Relations versus Types
3. Types and Relations
4. Relation variables
5. Relational Algebra
6. Integrity Constraints
7. Database design theory
8. What is relational model?
Appendix A: A little bit of logic
Appendix B: Suggestions for further reading
Index
Review
_______
This book is so short and precise on relational database. In this book, Date explains how a ideal relational database
Product should be?. He also clarifies all misconnections against the relational model.
He explains what an ideal database product should contain. He says every database product should implement all EF Codd rules.
He compares all database products features with mathematics like relation.
He says all database product operators like JOIN, UNION, UNION ALL, INTERSECT, PROJECTION AND SELECTION are similar to
Relational operators. And further to it, he says all properties of a mathematical relation like closure property,
Commutative and associative laws also apply to database products.
He even explains simple misconception like so many people think database and database management system, both are one and the same.
He explains both are different and should not be used interchangingly.his terminology is high level, clear and up to the situation.
This book is well organised.Date took simple database of only 3 tables and had explained everything with help of them.
he gave challenging questions for practice , after resolving them one can achieve significant improvement on this topic.
He says a simple query can be written in many ways. but one has to bother about the performance of the same.
He explains so many ways how to improve the performance of the queries.
He also explains database design and how to normalize the database very clearly.
Date explains all fundamental features of an ideal database product.
According to him so many database products do not have basic relational database features.
Other side is, his terminology in this book is very high level and hard to understand sometimes. He always tries to explain his own product Tutorial-d syntax. This is very redundant.
Surely this book is not for the beginners, who want to learn database product features,
If you got any hands on and interested to know about the database design then you should have this copy.
Tuesday, July 28, 2009
Monday, July 13, 2009
Sudoku the utterly addictive number-placing game --book1 review
Sudoku the utterly addictive number-placing game --book1
compiled by wayne gould
Contents
Introduction
Tips from compiler
Puzzles
Easy 1-4
Mild 5-30
Difficult 31-75
Fiendish 76-100
review
the times of India published 3 books of sudoku.this book is the first one of them.
book contains some useful tips to solve sudoku and it also contains 100 sudoku puzzles in
four levels namely Easy ,Mild ,Difficult and fiendish with solutions.
this is good book for the people who wants to learn sudoku and kill some time every day.
one can easily master the sudoku by solving these sudoku games one level after another.
i didnot find great tips and tricks from this book ,
still i feel this books is good one to kill the time by solving one sudoku every day.
compiled by wayne gould
Contents
Introduction
Tips from compiler
Puzzles
Easy 1-4
Mild 5-30
Difficult 31-75
Fiendish 76-100
review
the times of India published 3 books of sudoku.this book is the first one of them.
book contains some useful tips to solve sudoku and it also contains 100 sudoku puzzles in
four levels namely Easy ,Mild ,Difficult and fiendish with solutions.
this is good book for the people who wants to learn sudoku and kill some time every day.
one can easily master the sudoku by solving these sudoku games one level after another.
i didnot find great tips and tricks from this book ,
still i feel this books is good one to kill the time by solving one sudoku every day.
Subscribe to:
Posts (Atom)