You could put your verification ID in a comment Technical Book reviews: July 2009

Chitika

Tuesday, July 28, 2009

Database In Depth review

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.

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.