Principles of Database Management : The Practical Guide to Storing, Managing and Analyzing Big and Small Data (Hardcover)

Preface; Part I. Databases and Database Design: 1. Fundamental concepts of database management; 2. Architecture and categorization of DBMSs; 3. Conceptual data modeling using the (E)ER model and UML class diagram; 4. Organizational aspects of data management; Part II. Types of Database Systems: 5. Legacy databases; 6. Relational databases: the relational model; 7. Relational databases: structured query language (SQL); 8. Object oriented databases and object persistence; 9. Extended relational databases; 10. XML databases; 11. NoSQL databases; Part III. Physical Data Storage, Transaction Management, and Database Access: 12. Physical file organization and indexing; 13. Physical database organization; 14. Basics of transaction management; 15. Accessing databases and database APIs; 16. Data distribution and distributed transaction management; Part IV. Data Warehousing, Data Governance and (Big) Data Analytics: 17. Data warehousing and business intelligence; 18. Data integration, data quality and data governance; 19. Big data; 20. Analytics; Appendix A. Cases and questions; Appendix B. Using the online environment; Appendix C. Answer key to select review questions; Glossary; Index.