Modern Database Management, 12th Edition By Jeffrey Hoffer, Ramesh Venkataraman, Heikki Topi
eBook[PDF]

Modern Database Management, 12th Edition By Jeffrey Hoffer, Ramesh Venkataraman, Heikki Topi

$25.00
✓ Secure checkout
✓ Instant digital download
✓ PDF document

Document details

Pages
696
File size
20.14 MB
Format
Digital PDF
Category
eBook[PDF]
About this ebook
The textbook Modern Database Management, 12th Edition, written by Jeffrey Hoffer, Ramesh Venkataraman, and Heikki Topi, offers a comprehensive look at database development. The book balances traditional relational core concepts with modern enterprise trends like Big Data and cloud architectures. [1]
The detailed breakdown of topics covered, organized by the textbook's structure, includes:
Part I: The Context of Database Management
  • Chapter 1: The Database Environment and Development Process
    • Basic definitions of data versus information and metadata.
    • Traditional file-processing systems and their disadvantages.
    • The database approach: advantages, risks, and costs.
    • The Systems Development Life Cycle (SDLC) and its relationship to database development. [1, 2]
Part II: Database Analysis and Logical Design
  • Chapters 2–4: Modeling, Enhanced E-R, and Logical Design
    • Focuses on conceptual data modeling, Entity-Relationship (E-R) fundamentals, and business rules.
    • Covers advanced modeling with subtypes/supertypes using the Enhanced E-R model.
    • Explores logical design, schema transformation, relational integrity constraints (primary/foreign keys), and data normalization principles (1NF through 3NF). [1, 2, 3, 4, 5]
Part III: Database Implementation and Use
  • Chapters 5–8: SQL, Applications, and Physical Design
    • Introduces SQL via Data Definition Language (DDL) and Data Manipulation Language (DML), progressing to advanced queries (joins), triggers, and views.
    • Examines database applications in client-server/web environments and physical database design concepts such as indexing, file organization, and performance optimization. [1, 2, 3, 4]
Part IV: Advanced Database Topics
  • Chapters 9–12: Data Warehousing, Big Data, Analytics, and Administration
    • Covers data warehousing architecture, ETL, and dimensional modeling.
    • Explores Big Data characteristics, Hadoop, MapReduce, and NoSQL variants.
    • Discusses analytics and Business Intelligence (BI) visualization concepts.
    • Details database administration, security, backup/recovery, and data quality assurance. [1, 2, 3, 4, 5]
Online Chapters & Appendices
  • Chapters 13–14 & Appendices: Addresses distributed databases, concurrency control, object-oriented data modeling, and advanced normalization like BCNF. [1, 2]

File included

PDF
tmpphpXTAohQ 20.14 MB

Topics

978-0133544619 analytics and Business Intelligence (BI) visualization concepts Big Data characteristics Hadoop MapReduce and NoSQL variants Data Manipulation Language (DML) progressing to advanced queries (joins) triggers and views data modeling Entity-Relationship (E-R) fundamentals and business rules data normalization principles (1NF through 3NF) data warehousing architecture ETL and dimensional modeling Data Warehousing Big Data Analytics and Administration database administration security backup/recovery and data quality assurance Database Analysis and Logical Design database applications in client-server/web environments and physical database design concepts Database Implementation and Use distributed databases concurrency control indexing file organization and performance optimization logical design schema transformation relational integrity constraints (primary/foreign keys) Modeling Enhanced E-R and Logical Design Modern Database Management object-oriented data modeling and advanced normalization like BCNF SQL Applications and Physical Design SQL via Data Definition Language (DDL) The Context of Database Management The Database Environment and Development Process The Systems Development Life Cycle (SDLC) and its relationship to database development Traditional file-processing systems and their disadvantages
Related ebooks