Database Systems: A Practical Approach to Design, Implementation and Management
Edition 3 ed
Publication Date 1 Jan 2002
OverviewThis practical, hands-on approach to database systems provides a strong foundation in good database design practice. It gives a clear introduction to design, implementation and management issues, as well as an extensive treatment of database languages and standards. The new edition of this text brings it up to date with the latest developments in database technology in 2001. 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. The book provides extensive treatment of SQL in three tutorial style chapters, and there is a comprehensive treatment of distributed, object-oriented, and object-relational DBMSs. Also included in the book is: a comprehensive introduction to data warehousing, OLAP, and data mining; 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; use of UML notation for ER diagrams; a chapter on the relational algebra and relational calculus; a chapter on fact-finding techniques as a step before where the methodology begins; a chapter on Access and Oracle DBMSs, illustrating the difference between the two systems; a chapter on semistructured data, its relationship to XML, and query languages for XML; a chapter on data warehouse design using dimensionality modelling; and an introduction of colour to highlight the text where necessary and improve navigation through the book. Additional Web resources for such tasks as the full implementation of the case studies, and lab notes for Access and Oracle can be found on the internet.