📊 Data Modelling
📚 Daftar Referensi & Sumber

DAFTAR REFERENSI LENGKAP DAN SUMBER BELAJAR

MATA KULIAH DATA MODELLING

Program Studi Sains Data - UIN K.H. Abdurrahman Wahid Pekalongan

1. BUKU TEKS UTAMA (WAJIB)

1.1 Fundamentals of Database Systems

  • Penulis: Ramez Elmasri & Shamkant B. Navathe
  • Edisi: 7th Edition (2015)
  • Penerbit: Pearson
  • ISBN: 978-0133970777
  • Halaman: ~1,280 halaman
  • Tingkat: Undergraduate/Graduate
  • Harga: ~$200 (baru), ~$50-100 (bekas)

Deskripsi: Buku referensi klasik dan komprehensif untuk database systems. Mencakup data modelling (conceptual, logical, physical), normalization, ER diagrams, dan implementasi database.

Chapter Penting untuk MK ini:

  • Chapter 1-2: Introduction to Databases
  • Chapter 3: Data Modeling Using the Entity-Relationship Model
  • Chapter 9: Relational Database Design by ER- and EER-to-Relational Mapping
  • Chapter 14-15: Functional Dependencies and Normalization
  • Chapter 17-18: Physical Database Design
  • Chapter 29: Data Warehousing and Data Mining (Introduction)

Kelebihan:

  • Comprehensive dan detail
  • Banyak contoh dan latihan
  • Academic standard (digunakan di universitas top dunia)
  • Mencakup teori dan praktek

Kekurangan:

  • Sangat tebal dan detail (bisa overwhelming untuk pemula)
  • Kurang fokus pada dimensional modelling
  • Harga relatif mahal

Link:

1.2 The Data Warehouse Toolkit

  • Penulis: Ralph Kimball & Margy Ross
  • Judul Lengkap: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
  • Edisi: 3rd Edition (2013)
  • Penerbit: Wiley
  • ISBN: 978-1118530801
  • Halaman: ~600 halaman
  • Tingkat: Intermediate to Advanced
  • Harga: ~$50-70

Deskripsi: "Bible" dari dimensional modelling. Authored by Ralph Kimball, pioneer dalam data warehousing. Fokus pada star schema, snowflake schema, slowly changing dimensions, dan best practices untuk data warehouse design.

Chapter Penting:

  • Chapter 1-3: Dimensional Modeling Fundamentals
  • Chapter 4: Retail Sales (Star Schema Example)
  • Chapter 5: Procurement (Advanced Techniques)
  • Chapter 7: Accounting
  • Chapter 13: Healthcare
  • Chapter 19: Kimball Lifecycle

Kelebihan:

  • THE authority on dimensional modelling
  • Industry best practices
  • Many real-world case studies
  • Practical and actionable
  • Explains "why" not just "how"

Kekurangan:

  • Kurang fokus pada conceptual modelling (ER diagram)
  • Tidak mencakup NoSQL atau big data technologies
  • Beberapa contoh sudah sedikit dated

Link:

1.3 Data Modeling Made Simple

  • Penulis: Steve Hoberman
  • Edisi: 2nd Edition (2009)
  • Penerbit: Technics Publications
  • ISBN: 978-0977140060
  • Halaman: ~360 halaman
  • Tingkat: Beginner to Intermediate
  • Harga: ~$40-60

Deskripsi: Buku yang sangat praktis dan mudah dipahami untuk data modelling. Cocok untuk mahasiswa yang baru belajar. Banyak diagram, checklist, dan template.

Chapter Penting:

  • Chapter 1-2: What is Data Modeling?
  • Chapter 3-4: Conceptual Data Modeling
  • Chapter 5-7: Logical Data Modeling
  • Chapter 8: Physical Data Modeling
  • Chapter 9: Data Model Scorecard
  • Chapter 11: Dimensional Data Modeling

Kelebihan:

  • Very beginner-friendly
  • Many visual examples
  • Practical checklists and templates
  • Clear explanations
  • Not too theoretical

Kekurangan:

  • Kurang mendalam untuk advanced topics
  • Tidak banyak mathematical proofs (untuk yang suka teori formal)

Link:

2. BUKU PENDUKUNG (SANGAT DIREKOMENDASIKAN)

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

  • Penulis: Thomas Connolly & Carolyn Begg
  • Edisi: 6th Edition (2014)
  • Penerbit: Pearson
  • ISBN: 978-0132943260
  • Halaman: ~1,440 halaman

Deskripsi: Alternatif yang baik untuk Elmasri & Navathe. Lebih praktis dengan banyak contoh implementasi. Mencakup database design, SQL, dan database administration.

Chapter Penting:

  • Part 3: Database Analysis and Design
  • Chapter 11-12: Entity-Relationship Modeling
  • Chapter 13-14: Enhanced ER and Normalization
  • Chapter 17: Methodology - Physical Database Design

Link:

2.2 Data Modeling Essentials

  • Penulis: Graeme Simsion & Graham Witt
  • Edisi: 3rd Edition (2004)
  • Penerbit: Morgan Kaufmann
  • ISBN: 978-0126445510
  • Halaman: ~550 halaman

Deskripsi: Fokus pada business-driven data modelling. Menekankan komunikasi dengan stakeholders dan understanding business requirements.

Kelebihan:

  • Business perspective
  • Good coverage of conceptual modeling
  • Pattern-based approach
  • Many real-world examples

Link:

2.3 Data Driven: Profiting from Your Most Important Business Asset

  • Penulis: Thomas C. Redman
  • Penerbit: Harvard Business School Press (2008)
  • ISBN: 978-1422119129
  • Halaman: ~257 halaman

Deskripsi: Fokus pada data quality dan data governance. Bukan buku teknis, tapi penting untuk understanding WHY data modeling matters.

Topik:

  • Cost of poor data quality
  • Data governance
  • Building data-driven culture
  • Data as strategic asset

Link:

2.4 Database Design and Relational Theory: Normal Forms and All That Jazz

  • Penulis: C.J. Date
  • Edisi: 2nd Edition (2019)
  • Penerbit: Apress
  • ISBN: 978-1484255391
  • Halaman: ~472 halaman

Deskripsi: Untuk yang ingin deep dive ke teori normalisasi. Sangat theoretical tapi rigorous.

Kelebihan:

  • Mathematical rigor
  • Complete coverage of normal forms
  • Theoretical foundation

Kekurangan:

  • Very theoretical (not for beginners)
  • Less practical examples

Link:

3. REFERENSI ONLINE DAN ARTIKEL

3.1 Kimball Group Website

Deskripsi: Website resmi Kimball Group dengan ratusan artikel tentang dimensional modelling, ETL, data warehousing. Must-read untuk siapa saja yang belajar data warehouse.

Section Penting:

  • Design Tips (100+ articles)
  • Kimball Techniques
  • Case Studies by Industry
  • Slowly Changing Dimensions
  • Surrogate Keys

Best Articles:

  1. "Fundamental Concepts Surrounding Dimensional Modeling"
  2. "Build a Better Data Warehouse: The Kimball Lifecycle"
  3. "Slowly Changing Dimensions"
  4. "Fundamental Concepts of Dimensional Modeling"

3.2 IBM Data Modeling Documentation

Deskripsi: IBM's comprehensive guide to data modeling. Includes tools documentation (IBM InfoSphere Data Architect), best practices, and tutorials.

Topik:

  • Logical data modeling
  • Physical data modeling
  • Data model transformation
  • Data model comparison
  • Data model governance

3.3 Oracle Database Data Modeling Guide

Deskripsi: Oracle's official documentation on database design and data modeling. Includes SQL Developer Data Modeler documentation.

Topik:

  • Entity-relationship modeling
  • Relational modeling
  • Physical design
  • Data types
  • Constraints and indexes

3.4 Lucidchart ERD Tutorials

Deskripsi: Excellent visual guides and tutorials for creating ER diagrams. Includes symbols, notations (Chen, Crow's Foot, UML), and best practices.

Resources:

  • ER diagram symbols and notation
  • How to draw an ER diagram
  • ER diagram examples
  • Database design tutorial
  • ER diagram templates

3.5 Draw.io / Diagrams.net

Deskripsi: Free, open-source diagramming tool. Excellent for creating ERDs. Web-based or desktop app.

Features:

  • ER diagram shapes
  • Database notation libraries
  • Export to PNG, PDF, SVG
  • Integration dengan Google Drive, OneDrive
  • Collaboration

4. TOOLS DAN SOFTWARE

4.1 MySQL Workbench

Features:

  • Visual database design
  • ERD creation
  • Forward engineering (ERD → SQL DDL)
  • Reverse engineering (Database → ERD)
  • SQL development
  • Database administration

Tutorial:

4.2 ERDPlus

Features:

  • Simple, clean interface
  • ER diagram creation
  • Relational schema
  • Convert ER to relational
  • Export to SQL
  • Collaboration (dengan account)

Kelebihan:

  • Very easy to use
  • No installation needed
  • Educational focus
  • Free

4.3 dbdiagram.io

Features:

  • Code-to-diagram (define schema in code)
  • Auto layout
  • Export to SQL, PDF, PNG
  • Collaboration

Kelebihan:

  • Fast and simple
  • Good for quick prototyping
  • Version control friendly (text-based)

4.4 Microsoft Visio

Features:

  • Professional diagramming
  • ER diagram templates
  • Database notation
  • Integration dengan Office
  • Extensive shape libraries

Kelebihan:

  • Very professional output
  • Rich feature set
  • Integration dengan Microsoft ecosystem

Kekurangan:

  • Expensive
  • Windows only
  • Overkill untuk simple ERDs

4.5 PostgreSQL

Deskripsi: Advanced open-source relational database. Excellent untuk pembelajaran dan production use.

Kelebihan:

  • Free and open source
  • Advanced features
  • Excellent documentation
  • Active community
  • Standards compliant

Tutorial:

4.6 SQLiteStudio

Deskripsi: Lightweight database tool. Good untuk pembelajaran dan prototyping.

Kelebihan:

  • Very lightweight
  • No server needed
  • Easy to use
  • Portable

5. VIDEO TUTORIALS DAN ONLINE COURSES

5.1 YouTube Channels

freeCodeCamp.org

  • Database Design Course (4+ hours): Complete tutorial from basics to advanced
  • URL: Search "Database Design freeCodeCamp" di YouTube

Lucidchart

The TechCave

  • Database Design and Modeling
  • Normalization tutorials

Socratica

  • SQL Tutorials
  • Relational Database Design

5.2 Online Learning Platforms

Coursera

edX

Udemy

LinkedIn Learning

6. ACADEMIC PAPERS DAN JOURNALS

6.1 Foundational Papers

E.F. Codd - "A Relational Model of Data for Large Shared Data Banks" (1970)

  • Seminal paper yang memperkenalkan relational model
  • Communications of the ACM
  • Must-read untuk understanding theoretical foundation

Peter Chen - "The Entity-Relationship Model—Toward a Unified View of Data" (1976)

  • Original ER model paper
  • ACM Transactions on Database Systems
  • Historical importance

6.2 Journals

ACM Transactions on Database Systems (TODS)

IEEE Transactions on Knowledge and Data Engineering (TKDE)

The VLDB Journal

7. KOMUNITAS DAN FORUM

7.1 Stack Overflow

7.2 Database Administrators Stack Exchange

7.3 Reddit Communities

7.4 LinkedIn Groups

  • Data Modeling Zone
  • Data Warehouse Professionals
  • Database Administrators (DBA)

8. TOOLS TAMBAHAN UNTUK DATA SCIENCE INTEGRATION

8.1 Apache Superset

8.2 dbt (data build tool)

8.3 Great Expectations

9. TEMPLATE DAN CONTOH

9.1 ERD Templates

9.2 Sample Databases

  • Sakila Database (MySQL sample):

  • Northwind Database (Microsoft sample):

    • Trading company
    • Classic example
    • Available for multiple DBMS

  • AdventureWorks (Microsoft):

    • Manufacturing company
    • Complex, realistic schema
    • Good for learning advanced concepts

10. CHEAT SHEETS DAN QUICK REFERENCES

10.1 SQL Cheat Sheets

10.2 Normalization Cheat Sheet

  • Normal Forms Quick Reference (many available via Google)
  • Functional Dependency Rules

10.3 ERD Notation Reference

11. REKOMENDASI READING PATH UNTUK MAHASISWA

Untuk Pemula (Minggu 1-4):

  1. Hoberman - "Data Modeling Made Simple" Chapter 1-4
  2. Draw.io Getting Started Tutorial — https://www.diagrams.net/doc (opens in a new tab)
  3. YouTube: freeCodeCamp Database Design Course (first 2 hours)
  4. Opsional: Lucidchart ERD Tutorials di YouTube (kualitas baik untuk pemahaman visual)

Untuk Conceptual & Logical Modeling (Minggu 5-8):

  1. Elmasri & Navathe Chapter 3 (ER Model)
  2. Elmasri & Navathe Chapter 9 (ER to Relational Mapping)
  3. Elmasri & Navathe Chapter 14-15 (Normalization)
  4. Hoberman Chapter 5-7

Untuk Physical Modeling (Minggu 9-10):

  1. Elmasri & Navathe Chapter 17-18
  2. MySQL Documentation: Data Types
  3. Connolly & Begg Chapter 17

Untuk Dimensional Modeling (Minggu 11-14):

  1. Kimball & Ross Chapter 1-4 (MUST READ)
  2. Kimball Group Articles (online)
  3. Hoberman Chapter 11
  4. Kimball & Ross - selected case studies based on interest

Untuk Integration dengan Data Science (Minggu 14):

  1. Redman - "Data Driven" (selected chapters)
  2. Kimball & Ross Chapter 18-19 (ETL, Lifecycle)

12. TIPS UNTUK MENCARI REFERENSI LEBIH LANJUT

Google Scholar

ResearchGate

arXiv

Library Genesis (untuk textbook)

  • Catatan: Gray area secara legal, tapi banyak digunakan mahasiswa
  • Alternatif Legal: Cek perpustakaan universitas, Google Books preview

13. SUMBER BAHASA INDONESIA

13.1 Buku Bahasa Indonesia

  • "Basis Data" oleh Abdul Kadir
  • "Sistem Basis Data" oleh Fathansyah
  • Tersedia di toko buku lokal (Gramedia, dll)

13.2 Tutorial dan Blog Indonesia

  • Cari di Google: "tutorial ERD bahasa indonesia", "normalisasi database"
  • Medium: Many Indonesian writers
  • YouTube Indonesia: Cari "database design indonesia"

CATATAN PENTING

Hak Cipta dan Etika Akademik

  • Selalu gunakan referensi secara legal
  • Cite sources dengan benar
  • Untuk textbook mahal, cek perpustakaan universitas atau interlibrary loan
  • Many older editions available cheaper dan masih sangat relevan

Staying Updated

  • Database field evolves, but fundamentals stay same
  • Follow Kimball Group, Oracle, IBM blogs untuk updates
  • Join LinkedIn groups dan follow thought leaders

Recommendation untuk Dosen

  • Purchase 3 main textbooks untuk perpustakaan program studi:
    1. Elmasri & Navathe (latest edition)
    2. Kimball & Ross
    3. Hoberman
  • Subscribe to 1-2 online learning platforms for course use
  • Encourage students to use free resources (Kimball website, YouTube, etc)

End of Reference List

Compiled by: Mohammad Reza Maulana, M.Kom Program Studi Sains Data UIN K.H. Abdurrahman Wahid Pekalongan February 2026

📜 RPS (Rencana Pembelajaran Semester)Pertemuan 1: Kontrak Kuliah & Pengantar Data Modelling