Database Systems : A Practical Approach to Design, Implementation and Management

0.0

This book places a strong emphasis on good design practice, allowing students to master design methodology in an accessible, step-by-step fashion. 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. The book is designed to be used in database courses for technical and non-technical students. For Sale in Indian subcontinent only Features Uses UML notation for ER diagrams. 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 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, ISP, and Oracle's PSP. Table Of Contents PART I: BACKGROUND. 1.Introduction to Databases. 2. Database Environment. PART II: THE RELATIONAL MODEL AND LANGUAGES. 3. The relational model. 4. Relational algebra and relational calculus. 5. SQL: data manipulation. 6. SQL: data definition. 7. Query-By-Example (QBE). 8. Commercial DBMSs: Access and Oracle. PART III: DATABASE ANALYSIS AND DESIGN TECHNIQUES. 9. Database planning, design and administration. 10. Fact-finding techniques. 11. Entity-relationship modeling. 12. Enhanced entity-relationship modeling. 13. Normalization. 14. Advanced normalization. PART IV: METHODOLOGY. 15.Methodology - conceptual database design. 16. Methodology - logical database design for relational model. 17. Methodology - physical database design for relational databases. 18. Methodology - monitoring and tuning the operational system. PART V: SELECTED DATABASE ISSUES. 19. Security. 20. Transaction management. 21. Query processing. 22. Programming SQL. PART VI: DISTRIBUTED DBMSs AND REPLICATION. 23. Distributed DBMSs - concepts and design. 24. Distributed DBMSs - advanced concepts. 25. Replication and mobile databases. PART VII: OBJECT DBMSs. 26. Introduction to Object DBMSs. 27. Object-oriented DBMSs - concepts and design. 28. Object-oriented DBMSs - standards and languages. 29. Object-relational DBMSs. PART VIII: WEB AND DBMSs. 30. Web technology and DBMSs. 31. Semistructured data and XML. PART IX: BUSINESS INTELLIGENCE (OR DECISION SUPPORT). 32. Data warehousing concepts. 33. Data warehousing design. 34. OLAP. 35. Data mining. APPENDICES.