Database Systems (eBook)

A Pragmatic Approach

Elvis C. Foster, Shripad Godbole (Autoren)

eBook Download: PDF

2016 | 2nd ed.
XXXVIII, 604 Seiten
Apress (Verlag)
978-1-4842-1191-5 (ISBN)

Infos

This book provides a comprehensive, yet concise introduction to database systems, with special emphasis on the relational database model. The book discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. New in this second edition is updated SQL content covering the latest release of the Oracle Database Management System along with a reorganized sequence of the topics which is more useful for teaching. Also included are revised and additional illustrations, as well as a new chapter on using relational databases to anchor large, complex management support systems. There is also added reference content in the appendixes.

The book is based on lecture notes that have been tested and proven over several years, with outstanding results. It also exemplifies mastery of the technique of combining and balancing theory with practice, to give students their best chance at success.

The book discusses concepts, principles, design, implementation, and management issues of databases. Each chapter is organized systematically into brief, reader-friendly sections, with itemization of the important points to be remembered. It adopts a methodical and pragmatic approach to solving database systems problems. Diagrams and illustrations also sum up the salient points to enhance learning. Additionally, the book includes a number of Elvis Foster's original methodologies that add clarity and creativity to the database modeling and design experience, while making a novel contribution to the discipline. These features combine to make Database Systems: A Pragmatic Approach an excellent textbook for students and reader-friendly resource on database theory for the practitioner.

Elvis C. Foster is Associate Professor of Computer Science at Keene State College, New Hampshire. He holds a Bachelor of Science (BS.) in Computer Science and Electronics, as well as a Doctor of Philosophy (PhD) in Computer Science (specializing in strategic information systems and database systems) from University of the West Indies, Mona Jamaica. Dr. Foster has over 22 years of combined experience as a software engineer, information technology executive and consultant, and computer science educator.

---

Learn the concepts, principles, design, implementation, and management issues of databases. You will adopt a methodical and pragmatic approach to solving database systems problems. Database Systems: A Pragmatic Approach provides a comprehensive, yet concise introduction to database systems, with special emphasis on the relational database model. This book discusses the database as an essential component of a software system, as well as a valuable, mission-critical corporate resource. New in this second edition is updated SQL content covering the latest release of the Oracle Database Management System along with a reorganized sequence of the topics which is more useful for learning. Also included are revised and additional illustrations, as well as a new chapter on using relational databases to anchor large, complex management support systems. There is also added reference content in the appendixes. This book is based on lecture notesthat have been tested and proven over several years, with outstanding results. It combines a balance of theory with practice, to give you your best chance at success. Each chapter is organized systematically into brief sections, with itemization of the important points to be remembered. Additionally, the book includes a number of author Elvis Foster's original methodologies that add clarity and creativity to the database modeling and design experience.What You'll LearnUnderstand the relational model and the advantages it brings to software systemsDesign database schemas with integrity rules that ensure correctness of corporate dataQuery data using SQL in order to generate reports, charts, graphs, and other business resultsUnderstand what it means to be a database administrator, and why the profession is highly paidBuild and manage web-accessible databases in support of applications delivered via a browserBecome familiar with the common database brands, their similarities and differencesExplore special topics such as tree-based data, hashing for fast access, distributed and object databases, and moreWho This Book Is ForStudents who are studying database technology, who aspire to a career as a database administrator or designer, and practicing database administrators and developers desiring to strengthen their knowledge of database theory

Autor

Elvis C. Foster is Associate Professor of Computer Science at Keene State College, New Hampshire. He holds a Bachelor of Science (BS.) in Computer Science and Electronics, as well as a Doctor of Philosophy (PhD) in Computer Science (specializing in strategic information systems and database systems) from University of the West Indies, Mona Jamaica. Dr. Foster has over 22 years of combined experience as a software engineer, information technology executive and consultant, and computer science educator.Shripad V. Godbole is an independent database administrator/consultant with over 20 years of experience in diverse business environments, information infrastructure planning, diagnostics, and administration. His qualifications include Bachelor of Science (BS) in Physics, Bachelor of Computer Science (BCS), Master of Science (MS) in Physics with specialization in Electronics, all from Poona University in Pune, India. He is also an Oracle Certified Professional Database Administrator (OCPDBA), and holds a Master of Business Administration (MBA) in Technology Management from University of Phoenix. 

Inhalt

Part A: Preliminary Topics:1. Introduction to Database Systems2. The Database System EnvironmentPart B: The Relational Database Model3. The Relational Model4. Integrity Rules and Normalization5. Database Modeling and Design6. Database User Interface Design7. Relational Algebra8. Relational Calculus9. Reflective Look at the Relational Database ModelPart C: The Structured Query Language10. Overview of SQL11. SQL Data Definition Statements12. SQL Data Manipulation Statements13. Logical Views and System Security14. The System Catalog15. Some Limitations of SQLPart D: Advanced Topics16. Database Administration17. Distributed Database Systems18. Object Databases19. Data Warehousing20. Web-Accessible Databases21. Using Database Systems to Anchor Management Support SystemsPart E: Overview of Selected DBMS Suites22. Overview of Oracle23. Overview of DB224. Overview of MySQL25. Overview of Microsoft SQL ServerPart F: Appendices26. Appendix 1: Review of Trees27. Appendix 2: Review of Hashing28. Appendix 3: Review of Information Gathering Techniques29. Appendix 4: BNF Syntax for Selected SQL Statements 30. Appendix 5: Sample Exercises and Examination Questions

Produkt-Details

• Erscheint lt. Verlag: 7.11.2016
• Zusatzinfo: XXXVIII, 604 p. 296 illus., 291 illus. in color.
• Verlagsort: Berkeley
• Sprache: englisch
• Themenwelt: Mathematik / Informatik ► Informatik ► Datenbanken
• Schlagworte: Data Definition Language • Data Manipulation Language • DDL • DML • Integrity Rules • normalization • Object Databases • Relational algebra • Relational Calculus • relational model • SQL
• ISBN-10: 1-4842-1191-X / 148421191X
• ISBN-13: 978-1-4842-1191-5 / 9781484211915