This book places a strong emphasis on good design practice, allowing readers to master design methodology in an accessible, step-by-step fashion. In this book, database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodology working in practice. Extensive treatment of the Web as an emerging platform for database applications is covered alongside many code samples for accessing databases from the Web including JDBC, SQLJ, ASP, ISP, and Oracle's PSP. A thorough update of later chapters covering object-oriented databases, Web databases, XML, data warehousing, data mining is included in this new edition. A clear introduction to design implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable, complete reference for database professionals.
Over 200,000 people have been grounded in good database design practice by reading Database Systems. The new edition of this bestseller brings it up to date with the latest developments in database technology and builds on the clear, accessible approach that has contributed to the success of previous editions.
A clear introduction to design, implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable complete reference for database students and professionals alike
Features
- Complex subjects are clearly explained using running case studies throughout the book.
- Database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described with an example of how it works in practice.
- SQL is comprehensively covered in three tutorial-style chapters.
- Distributed, object-oriented, and object-relational DBMSs are fully discussed.
Check out the web site at www.booksites.net/connbegg, for full implementations of the case studies, lab guides for Access and Oracle, and additional student support.
New! For the fourth edition
- Extended treatment of XML, OLAP and data mining.
- Coverage of updated standards including SQL:2003, W3C (XPath and
XQuery), and OMG.
- Now covers Oracle9i and Microsoft Office Access 2003.
Both Thomas Connolly and Carolyn Begg have experience of database design in industry, and now apply this in their teaching and research at the University of Paisley in Scotland.
This book comes with a free six-month subscription to Database Place, an online tutorial that helps readers master the key concepts of database systems. Log on at www.aw.com/databaseplace.