b belajar.myudak

Manajemen Basis Data

Database Management · Data & Basis Data · 3 sks wajib · MIK1624403 (2020: PAIK6403)

Prasyarat Basis Data Membuka Data Besar

Materi

Folder Drive ↗

Sebelum UTS 8

  1. 1.1 Stored Procedure Formula ↗
  2. 1.2 SQL Integrity Guardians ↗
  3. 2 Database Automation Catatan ↗
  4. 3 DBMS Storage Architecture ↗
  5. 4 Database Indexing Essentials ↗
  6. 5 Modern Database Security ↗
  7. 6.1 SQL Engine Blueprints ↗
  8. 6.2 PEMROSESAN QUERY ↗

Sesudah UTS 10

  1. 8.1 ISAM B+Tree ↗
  2. 8.2 Algorithm insert B+ tree ↗
  3. 8.3 Proc delete ↗
  4. 9.1 Hash Index ↗
  5. 9.2 Transaction ↗
  6. 11.1 Serializability Catatan ↗
  7. 11.2 Concurrency Control ↗
  8. 12.1 Concurrency Control ↗
  9. 12.2 Concurrency Control B+Tree ↗
  10. 12.3 DEADLOCK ↗

Lainnya Buku Sumber ↗Tugas Besar ↗Soal Ujian ↗

Catatan

  1. 1 Serializability dan graf konflik Bangun precedence graph untuk menilai apakah jadwal bisa diserialkan. ▶ visual
  2. 2 Constraint, trigger, dan perubahan data Pilih mekanisme untuk menjaga aturan data dan mencatat perubahan baris. ▶ visual

UTS & UAS

ada pembahasan

UTS

2026 2025

UAS

2026 2025

Silabus

  1. 1 DBMS
  2. 2 Store Procedure, Constraints, Assertion, Trigger
  3. 3 Storing data
  4. 4 File Organization dan Index
  5. 5 Tree Structure Indexing
  6. 6 Hash Based Indexing
  7. 7 Evaluasi Query, Query Optimizer
  8. 8 Database Security, Access Control
  9. 9 Transaction Management, Schedules
  10. 10 Concurrency Control, Lock Management, Serializability, Deadlock
  11. 11 Crash Recovery, ARIES
  12. 12 Advance Topic : Paralel and Distributed Database, Internet Database

Sumber: Silabus Informatika 2020 (PAIK6403).

Referensi

  • Ramakhrisnan, Raghu & Gehrke, Johanes. Database Management System , 3rd edition. McGraw Hill. 2013
  • Silberschat, Abraham; Korth, F Henry; Sudharsan S, Database System Concepts, 7th edition, McGraw Hill, 2020
  • Domdouzis, Konstantinos; Lake, Peter; Crowther, Paul; Concise Guide to Database, 2nd edition, Springer, 2021
  • Elmashri; Navathe; Fundamentals of Database System, 7th edition, Pearson, 2016
  • Oracle Database Design
  • Oracle Database Programming with SQL