The Bookpointindia

About the BookAbout the AuthorTable of Contents

This book provides a comprehensive coverage of database principles and practice. The author uses the open source database ‘MySQL’ for illustration. The standard database language for querying (interacting with) relational databases is SQL (structured query language). MySQL is the most popular “open source” database system with an installed base of over 5 million systems. It is very fast, multi-threaded, multi-user database which can be effectively used by teachers who want to teach concepts and practice, database users, programmers and computer scientists.

Narain Gehani is a world-renowned expert in databases, web technologies and software. Dr. Gehani has authored or coauthored several major software systems, including the Ode database, the concurrent C/C++ parallel programming language, and the Maps On Us website. He has authored and edited many books and has about 75 papers in computer science to his credit. Currently, Dr Gehani is the Chairman of Computer Science Department at the New Jersey Institute of Technology.

Preface / Acknowledgement / Databases / A “Real Example – The Everest Books Database / Relational Databases (With A My SQL Flavor) / Manipulating The Databases / Database Design / SQL / Transactions / Constraints / Triggers / Objects / Indexes / Views / Spatial Databases / Security / Logs & Recovery / Replication / Tuning / Appendix A: Codd’s Rules For Relational Databases / Appendix B: DATABASE APIS / Appendix C: Importing & Exporting Data / Bibliography / Glossary / Index