1 / 14

DATA INTEGRATION

DATA INTEGRATION. PENDAHULUAN. Agus Aan Jiwa Permana, S.Kom., M.Cs Singaraja - 2013. POKOK BAHASAN (3 SKS). Konsep Basis Data Sistem Basisdata (DBMS) Lingkungan Basisdata Relational Basisdata Normalisasi ERD Pengembangan Basisdata Aplikasi Basisdata : Studi Kasus

teva
Download Presentation

DATA INTEGRATION

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DATA INTEGRATION PENDAHULUAN Agus Aan Jiwa Permana, S.Kom., M.Cs Singaraja - 2013

  2. POKOK BAHASAN (3 SKS) • Konsep Basis Data • Sistem Basisdata (DBMS) • Lingkungan Basisdata • Relational Basisdata • Normalisasi • ERD • Pengembangan Basisdata • Aplikasi Basisdata : Studi Kasus • Konsep Dasar DW/DM dan bussiness intelligence • Konsep OLAP (online analytical processing) • Konsep ETL (Extraction, Transformation, and Loading) • Hybrid Approach • Operational Bussiness • Aplikasi DM

  3. Konsep Basis Data • Data & Informasi • SIM • Peran dan Pengertian Basisdata • Kriteria basisdata • Tujuan

  4. Sistem Basisdata (DBMS) • Pengertian • Komponen • Abstraksi • Bahasa basis data • Penggunaan

  5. Lingkungan Basisdata • Kekangan dalam basis data • Arsitektur sistem basis data • Kamus data (data dictionary) • Model-model data

  6. Relational Basisdata • Komponen Relasi • Entitas • Variasi Entitas • Kardinalitas • Modalitas

  7. Normalisasi • Tujuan normalisasi • Penyimpangan dalam modifikasi • Keharusan menghilangkan masalah-masalah akibat ketergantungan • Efek-efek normalisasi • Atribut tabel • Domain dan tipe data • Bentuk-bentuk normal • Contoh kasus

  8. ERD • Pemodelan perangkat lunak • Pengertian ERD • Komponen ERD • S/W untuk pemodelan • Tahap Perancangan ERD • Tugas dan Kasus

  9. Konsep Dasar DW/DM dan bussiness intelligence • Konsep DM • Konsep DW • Konsep Bussines Intelligence

  10. Konsep OLAP & ETL • Konsep OLAP • Konsep ETL • Life cycle of data mining • Komparasi OLAP dg DM

  11. Hybrid Approach • Teknik pendekatan hybrid • Operational reporting • Operational performance management • Decision Automation

  12. Operational Bussiness • Batasan operational environment • Konsep business consideration • Konsep technology consideration • Data management service component

  13. Aplikasi DM • Teknik implementasi DM • Konsep dan terapan association rule untuk merancang decision tree dan algoritma klasifikasi

  14. Komponen Penilaian Akhir • Tugas : 15% • Quiz : 5% • UTS : 25% • UAS : 40% • Keaktifan : 15% Total : 100% • Note : Minimal kehadiran 75% (12 kali hadir) • Project • Buku : Sistem Basisdata - Edhy Sutanta Database Systems Concepts - Korth and Silberschatz

More Related