Powerful database systems running on all platforms from PCs to mainframes are vital for the success of modern companies and institutions. This book will enable users to design database systems that are flexible and efficient, following a proven methodology for both logical and physical database design.
Highlights of the book include * A step-by-step methodology for logical database design, integrating the Entity Relationship Model with normalization, and showing how to map this on to a physical implementation * A realistic case study integrated throughout the book, illustrating all stages in the development process * Extensive treatment of formal and de facto standards, including SQL, QBE and the ODMG standard for object databases * A clear introduction to implementation and management aspects, including concurrency and recovery control, security and integrity * Comprehensive chapters on distributed and object-oriented databases, including a preview of SQL3 The practical, hands-on approach will benefit students in computing, information systems, engineering and business, while its industrial-strength methodology can be followed by systems analysts/designers, systems or application programmers, and database adm inistrators. All three authors have experience of database design in industry, and now apply this in their teaching and research at the University of Paisley in Scotland.
Thomas Connolly has significant industrial experience and was a designer of RAPPORT, the world's first commercial portable DBMS, and of the LIFESPAN configuration management tool -- a winner of the British Design Award. Carolyn Begg specializes in the application of database systems in the medical domain, while Anne Strachan focuses on problems associated with large diverse data sets in organizations. 0201422778B04062001
Database Systems' practical, hands-on approach makes it uniquely suited to providing a strong foundation in good database design practice. A clear introduction to design, implementation and management issues, as well as an extensive treatment of database language and standards, make this book an indispensable complete reference for database students and professionals alike. 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 contributed to the success of previous editions.
A realistic case study integrated throughout the book enables complex subjects to be explained in the context of one understandable example, while three additional case studies allow readers to work through examples by themselves. Clearly stated chapter objectives and summaries guide the reader, highlighted key definitions and numerous worked examples illustrate the concepts, and review questions and exercises reinforce the material covered in each chapter.
- 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 SQL in three tutorial-style chapters.
- Comprehensive treatment of distributed, object-oriented, and object-relational DBMSs.
- Comprehensive introduction to data warehousing, OLAP, and data mining.
- Extensive treatment of the Web as an emerging platform for database applications with many code samples for accessing databases from the Web including JDBC, SQLJ, ASP, JSP, and Oracle's PSP.
New! For the third edition
-- Dieser Text bezieht sich auf eine vergriffene oder nicht verfügbare Ausgabe dieses Titels.
- Use of UML notation for ER diagrams.
- New chapter on the relational algebra and relational calculus.
- New chapter on fact-finding techniques as a step prior to the start of the database design methodology.
- New chapter on Access and Oracle DBMSs, illustrating the difference between the two systems.
- New chapter on semistructured data, its relationship to XML, and query languages for XML.
- New chapter of data warehouse design using dimensionality modeling.
- Introduction of color to highlight the text and improve navigation through the book.
- Additional Web resources at www.booksites.net/connolly, such as prototype implementations of the case studies, and lab notes for Access.