Elvis C. Foster, Shripad V. Godbole

Database Systems (eBook, ePUB)

A Pragmatic Approach, 3rd edition

• Format: ePub

Produktbeschreibung

This book provides a concise but comprehensive guide to the disciplines of database design, construction, implementation, and management. Based on the authors' professional experience in the software engineering and IT industries before making a career switch to academia, the text stresses sound database design as a necessary precursor to successful development and administration of database systems. The discipline of database systems design and management is discussed within the context of the bigger picture of software engineering. Students are led to understand from the outset of the text that a database is a critical component of a software infrastructure, and that proper database design and management is integral to the success of a software system. Additionally, students are led to appreciate the huge value of a properly designed database to the success of a business enterprise.

The text was written for three target audiences. It is suited for undergraduate students of computer science and related disciplines who are pursuing a course in database systems, graduate students who are pursuing an introductory course to database, and practicing software engineers and information technology (IT) professionals who need a quick reference on database design.

Database Systems: A Pragmatic Approach, 3rd Edition discusses concepts, principles, design, implementation, and management issues related to database systems. Each chapter is organized into brief, reader-friendly, conversational sections with itemization of salient points to be remembered. This pragmatic approach includes adequate treatment of database theory and practice based on strategies that have been tested, proven, and refined over several years. Features of the third edition include:

• Short paragraphs that express the salient aspects of each subject
• Bullet points itemizing important points for easy memorization
• Fully revised and updated diagrams and figures to illustrate concepts to enhance the student's understanding
• Real-world examples
• Original methodologies applicable to database design
• Step-by-step, student-friendly guidelines for solving generic database systems problems
• Opening chapter overviews and concluding chapter summaries
• Discussion of DBMS alternatives such as the Entity-Attributes-Value model, NoSQL databases, database-supporting frameworks, and other burgeoning database technologies
• A chapter with sample assignment questions and case studies

This textbook may be used as a one-semester or two-semester course in database systems, augmented by a DBMS (preferably Oracle). After its usage, students will come away with a firm grasp of the design, development, implementation, and management of a database system.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: Taylor & Francis
• Seitenzahl: 622
• Erscheinungstermin: 26. September 2022
• Englisch
• ISBN-13: 9781000562125
• Artikelnr.: 64305931

Autorenporträt

Elvis C. Foster is a Professor of Computer Science at Keene State College. 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 software engineering and database systems) from University of the West Indies, Mona Jamaica. His research interests include the development as well as evaluation of management support systems for contemporary organizations.

Shripad V. Godbole is an independent database administrator and consultant with more than 20 years of experience in diverse business environments, information infrastructure planning, diagnostics, and administration. He is also the Vice President for Technology Management at State Street Global Advisors, Boston. 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.

Inhaltsangabe

Preface. Acknowledgment. Section A PRELIMINARY TOPICS. 1 Introduction to
Database Systems. 2 The Database System Environment. Section B THE
RELATIONAL DATABASE MODEL. 3 Introducing the Relational Model. 4 Integrity
Rules and Normalization. 5 Database Modeling and Design. 6 Database User
Interface Design. 7 Relational Algebra. 8 Relational Calculus. 9 Reflective
Look at the Relational Database Model. Section C THE STRUCTURED QUERY
LANGUAGE. 10 Overview of SQL. 11 SQL Data Definition Statements. 12 SQL
Data Manipulation Statements. 13 Logical Views and System Security. 14 The
System Catalog. 15 Some Limitations of SQL. Section D ADVANCED TOPICS. 16
Database Administration. 17 Distributed Database Systems. 18 Object
Databases. 19 Data Warehousing. 20 Web-Accessible Databases. 21 Using
Database Systems to Anchor Management Support Systems. Section E OVERVIEW
OF SELECTED DBMS SUITES AND TECHNOLOGIES. 22 Overview of Oracle. 23
Overview of Db2. 24 Overview of MySQL. 25 Overview of Microsoft SQL Server.
26 Other Emerging Database Methodologies. Section F APPENDICES. Appendix 1:
Review of Trees. Appendix 2: Review of Hashing. Appendix 3: Review of
Information-Gathering Techniques. Appendix 4: BNF Syntax for Selected SQL
Statements. Appendix 5: Sample Exercises and Examination Questions. Index.

---

Part I: Preliminary Topics

1. Introduction to Database Systems

2. The Database System Environment

Part II: The Relational Database Model

3. The Relational Model

4. Integrity Rules and Normalization

5. Database Modeling and Design

6. Database User Interface Design

7. Relational Algebra

8. Relational Calculus

9. Relational System a Closer Look

Part III: Structured Query Language

10. Overview of SQL

11. SQL Definition Statements

12. SQL Data Manipulation Statements

13. Logical Views and Security

14. The System Catalog

15. Some Limitations of SQL

Part IV: Some Commonly Used DBMS Suites

16. Overview of Oracle

17. Overview of DB2

18. Overview of Microsoft SQL Server

19. Overview of Gupta Team Developer and MySQL

20. Overview of Borland Delphi

Part V: Advanced Topics

21. Database Administration

22. Distributed Database Systems

23. Object Databases

24. Data Warehousing and Information Extraction

25. Web-Accessible Databases

Part VI: Final Preparations

26. Sample Exercises and Examination Questions

Part VII: Appendices

A. Review of Trees

B. Review of Hashing

C. Review of Information Gathering Techniques