1 / 58

KULIAH MANAJEMEN BASIS DATA

KULIAH MANAJEMEN BASIS DATA. PROF. DR. IR. H. IMAN SUDIRMAN, DEA. Tujuan :. Memahami konsep dan teori dalam manajemen basis data Memberikan kemampuan dalam mengelola dan merancang basis data. Out line kuliah. Pendahuluan Sistem file Organisasi data base

deepak
Download Presentation

KULIAH MANAJEMEN BASIS DATA

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. KULIAH MANAJEMEN BASIS DATA PROF. DR. IR. H. IMAN SUDIRMAN, DEA

  2. Tujuan : • Memahamikonsepdanteoridalammanajemen basis data • Memberikankemampuandalammengeloladanmerancang basis data

  3. Out line kuliah • Pendahuluan • Sistem file • Organisasi data base • Data base dansisteminformasi • Normalisasi • Entity relationship diagram • Penerapanmanajemen data base

  4. Literatur : • Data base design (James martin) • Manegement information system ( Mcleod) • Analysis and system design ( Whitten )

  5. Data base : kumpulansistemstruktur data base : • Data • Field • Record • file

  6. Karakteristikpadasistem file : • Pemogrammankompleksdan extensive • Organisasi file sulit • Proteksisulit • Perubahan file merubah program • Redudansitinggi

  7. Sistem basis data • Memperhatikanrelasi data • Mengurangiinkosistensi data • Mengurangiduplikasi/ reduksi data • Mengurangiketergantungan program danstruktur data • DBMS menyimpan data strukturdanrelasi

  8. Sistem basis data

  9. Sistem basis data

  10. Sistembasis data • The Database System Components • Hardware • Computer • Peripherals • Software • Operating systems software • DBMS software • Applications programs and utilities software

  11. Komponenmanajemen basis data : • People • Systems administrators: • Database administrators • Database designers • Systems analysts and programmers • End users • Procedures • Data

  12. Tipesistem basis data : • Number of Users • Single-user • Multi-user • Scope • Desktop (Single user) • Workgroup (Used by a department, nbr of users < 50) • Enterprise (Used by the entire organization, users in 100s)

  13. Location • Centralized (Database located in a single site) • Distributed (Database distributed across multiple sites) • Use • Transactional (aka Production) • Data integrity, consistency and operational efficiency are important • Decision support • Historical, aggregated data • Used for managerial decision making • Data warehouse • Used for decision support

  14. Fungsi DBMS : • Data Dictionary Management • Data Storage Management • Data Transformation and Management • Security Management • Multi-User Access Control • Backup and Recovery Management • Data Integrity Management • Database Access Languages & Application Programming Interfaces • Database Communication Interfaces

  15. Tigajenishubungandalam model database conceptual : • One- to- many relationship • Many- to- many relationship • One-to- one relationship

  16. Jenis model implementasi database : • Hierarchical • Network • Relational • Object oriented

  17. Hierachical model

  18. Keuntungan : • Data independent • Mengurangibesarnyausahapembuatan program • Integrity tinggi ( anakhanyapunyasatuorangtua ) • Hubungandominan one-to- many yang banyakdigunakandalambisnis

  19. Kerugian : • Hanyaberlakuuntuk one- to-many relationship • Membutuhkan program yang kompleks

  20. Network model : Relasiantara record dapatberupajaringan . Contoh : COMISSION SET SALES SET PAYMENT SET INVENTORY SET LINE SET SALESREP COSTUMER INVOICE PAYMENT PRODUCT INV_LINE

  21. Keuntungan : • Mudahdiimplementasikanuntukberbagairelasi • Integrity terjamin • Indepedensi data terjamin

  22. Kerugian : • Program kompleks • Perancangansulitkarenahubungandapatkompleks • Sulitmelakukanperubahan data base

  23. Relational database model

  24. Keuntungan : • Data independen • Mudahdirancangdandikelola • Tidakmembutuhkanusaha programming yang tinggi • Pleksibeldanmudahdalampencarian data

  25. Kerugian : • Membutuhkan DBMS tertentu • Memilikikecenderunganlebihlambatdalampencarian data

  26. Object oriented database model Objekadalah : entitas yang memilikisekumpulanatribut. Misal ; mahasiswamemilikiNama, NIP dansebagainya Objek yang memilikikesamaan /kemiripadikelompokandalamsebuahkelas Kelasmemilikihirarkidansebuahkelasmemilkiatribut yang diturunkandari super kelas

  27. Keuntungan : • Dapatdigunakanoleh program yang kompleksseperti CAD/CAM Kerugian : • Belumdistandarkan

  28. KonsepDasarPemodelan Data • Desaindatabase adalahart and science. • Data model adalahrepresentasisederhana, biasanyadalambentukgrafik, yang menggambarkanstruktur data dalamsuatusistemnyata; sertakarakteristik, relasi, batasan-batasan, dantransformasi data. • Desainerdatabase menggunakan model data sebagai tools komunikasiuntukmenfasilitasiinteraksiantardesigner, applications programmer, and end user. • Database yang baikadalahdasaruntuksuatuaplikasi yang baik.

  29. Model Data • Model Konseptual • Model konseptualmerepresentasikan view global dari data; enterprise-wide representation of data • Entity-Relationship (E-R) model paling banyakdigunakanuntuk model konseptual. • Model konseptual independent terhadap software (software independence) and hardware (hardware independence).

  30. Relationship dalam Database Relasional • E-R Diagram (ERD) • Kotaksebagairepresentasientitas. • Namaentitasdalamktabendadandenganhurufkapital. • Diamond untuk relationship(s) antaraentitas. • 1 is untukmenyatakansisi “1”/satudalamsuaturelasi. • M is untukmenyatakansisi “many”/banyakdalamsuaturelasi.

  31. Perancangan database denganmenggunakan ERD • Tentukankatagorientitas : Manusia, tempat, barang, konsepdan output • Penjabarankatagorimenjadientitas, misal : manusiadijabarkanmenjadidosen, mahasiswa, pegawai, tamu, suplierdsb • Perumusan data, misal : data dosen, nama, NIP, Tgllahir, unit kerjaDsb • Perumusanhubunganantarentitas a. one-to-one ( 1 1 ) b. one-to-many ( 1 M ) c. many-to-many ( M M)

  32. 5. Penggambaran ERD= entitasdenganhurupkapital= untukhubunganantarentitas

  33. Contoh :

More Related