Management Information Systems 8e Chapter 7 Managing Data

  • Slides: 39
Download presentation
Management Information Systems 8/e Chapter 7 Managing Data Resources Pertemuan 3 Mengelola Data 7.

Management Information Systems 8/e Chapter 7 Managing Data Resources Pertemuan 3 Mengelola Data 7. 1 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources TUJUAN • Membahas tipe 2

Management Information Systems 8/e Chapter 7 Managing Data Resources TUJUAN • Membahas tipe 2 basisdata dari suatu model basisdata • Lingkungan database yang dibutuhkan oleh organisasi • Teknologi dan peralatan yang dapat membuat basisdata makin dapat diakses 7. 2 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources MENGORGANISASI DATA PADA LINGKUNGAN FILE

Management Information Systems 8/e Chapter 7 Managing Data Resources MENGORGANISASI DATA PADA LINGKUNGAN FILE DATA TRADISIONAL Konsep dan pengertian Organisasi File 7. 3 • Bit: satuan data terkecil; binary digit (0, 1) • Byte: Sekelompok bit yang menyatakan • Field: Sekelompok kata-kata atau sebuah karakter bilangan © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources ORGANIZING DATA IN A TRADITIONAL

Management Information Systems 8/e Chapter 7 Managing Data Resources ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT Konsep dan Pengertian Organisasi File • • • 7. 4 Record: Sekelompok field yang berhubungan File: Sekelompok record dengan tipe yang sama Database: Sekelompok file yang berhubungan © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources ORGANIZING DATA IN A TRADITIONAL

Management Information Systems 8/e Chapter 7 Managing Data Resources ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT Data Hierarchy in a Computer System 7. 5 Figure 7 -1 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources ORGANIZING DATA IN A TRADITIONAL

Management Information Systems 8/e Chapter 7 Managing Data Resources ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT File Organization Terms and Concepts 7. 6 • Entity: Orang, tempat, benda, atau • Attribute: Gambaran tentang entity • Key field: field khusus yang digunakan kejadian tentang informasi yang sedang ditangani tertentu untuk mengambil, mengganti, dan mengurutkan record © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources ORGANIZING DATA IN A TRADITIONAL

Management Information Systems 8/e Chapter 7 Managing Data Resources ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT Entitities and Attributes Figure 7 -2 7. 7 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Database Management System (DBMS) • Membangun dan mengelola basisdata • Mengurangi perintah untuk mendefinisikan data • Bertindak sebagai antarmuka antara program aplikasi dengan file data secara fisik • Memisahkan penglihatan data secara fisik dan logika 7. 8 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Lingkungan basisdata yang baru 7. 9 Figure 7 -4 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Types of Databases • Relational DBMS • Hierarchical and Network DBMS • Object-Oriented Databases 7. 10 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Relational DBMS • Menyatakan data sebagai tabel dua dimensi yang disebut relasi • Menghubungkan data antar tabel berdasarkan elemen data yang sama • Contoh: DB 2, Oracle, MS SQL Server, Access 7. 11 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Relational Data Model 7. 12 Figure 7 -6 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Three Basic Operations in a Relational Database • Select: memilih bagian baris yang sesuai dengan kriteria yang ditentukan • Join: Menggabung tabel-tabel yang berrelasi untuk memberikan informasi pada pengguna • Project: User dapat membentuk tabel baru yang berisi informasi 2 yang relevan 7. 13 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Three Basic Operations in a Relational Database 7. 14 Figure 7 -7 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Hierarchical and Network DBMS Hierarchical DBMS • Mengorganisasi data dengan struktur yang mirip pohon • Mendukung relasi satu-ke-banyak dan indukanak • Biasa digunakan dalam sistem yang besar secara turun-temurun 7. 15 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Hierarchical DBMS Figure 7 -8 7. 16 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Object-Oriented Databases • Object-oriented DBMS: Menyimpan data dan prosedur sebagai obyek yang dapat dipanggil dan digunakan bersama secara otomatis • Object-relational DBMS: Mampu digunakan untuk OO DBMS maupun RDBMS 7. 17 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Querying Databases: Elements of SQL Basic SQL Commands • SELECT: Menyatakan kolom • FROM: menyebut tabel atau view • WHERE: menyatakan kondisi 7. 18 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Hasil Penggunaan Perintah SELECT 7. 19 Figure 7 -10 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT C Hasil Pemilihan dengan kondisi Figure 7 -11 7. 20 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA

Management Information Systems 8/e Chapter 7 Managing Data Resources THE DATABASE APPROACH TO DATA MANAGEMENT Proyeksi dari penggabungan tabel PART dan SUPPLIER Figure 7 -12 7. 21 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Merancang

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Merancang Basisdata • Perancangan secara konsep: Pembuatan model basisdata berdasarkan pada kebutuhan • Perancangan secara fisik: Gambaran secara detil kebutuhan 2 untuk sistem informasi 7. 22 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Designing

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Designing Databases • Entity-relationship diagram: Metode untuk menggambarkan basisdata dilihat dari hubungan antar entitas • Normalization: Proses pembuatan struktur basisdata yang kecil tetapi stabil yang diturunkan dari sekelompok data yang kompleks 7. 23 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Figure

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Figure 7 -13 7. 24 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Figure

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Figure 7 -14 7. 25 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT An

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT An Normalized Relation of ORDER Figure 7 -15 7. 26 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Distributing

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Distributing Databases Basisdata terpusat (Centralized database) • digunakan oleh prosesor tunggal atau prosesor ganda dalam suatu jaringan client/server 7. 27 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Distributing

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Distributing Databases Basisdata Terdistribusi (Distributed database) • Disimpan pada beberapa lokasi secara fisik • Basisdata terpisah • Terjadi basisdata ganda 7. 28 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Distributed

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Distributed Databases Figure 7 -16 7. 29 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Management

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Management Requirements for Database Systems Kunci dalam lingkungan basisdata : • Administrasi data • Metodologi perencanaan dan pemodelan data • Manajemen dan teknologi basis data • Pengguna (Users) 7. 30 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Management

Management Information Systems 8/e Chapter 7 Managing Data Resources CREATING A DATABASE ENVIRONMENT Management Requirements for Database Systems 7. 31 Figure 7 -17 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Data Warehousing and

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Data Warehousing and Datamining Gudang data (Data warehouse) • Mendukung proses pelaporan dan pencarian data • Menyimpan data saat ini dan masa lalu • Mengkonsolidasi antara analisis dan pembuatan keputusan 7. 32 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Komponen 2 gudang

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Komponen 2 gudang data Figure 7 -19 7. 33 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Data Warehousing and

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Data Warehousing and Datamining Penggalian data (Datamining) • Alat untuk menganalisis pusat data yang sangat besar • Mencari pola yang tersembunyi dan membentuk aturan untuk memprediksi tren 7. 34 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Benefits of Data

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Benefits of Data Warehouses • Memperbaiki dan membuat data menjadi mudah diakses • Mampu digunakan untuk memodelkan data 7. 35 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Databases and the

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Databases and the Web Basisdata hipermedia • Mengorganisasi data sebagai jaringan titik 2 • Menghubungkan titik 2 dalam suatu pola yang ditentukan oleh pengguna • Mendukung teks, grafik, suara, video dan program 7. 36 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS A Hypermedia Database

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS A Hypermedia Database 7. 37 Figure 7 -20 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Databases and the

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Databases and the Web Database server • Komputer dalam lingkungan client/server yang menjalankan DBMS untuk memproses perintah 2 SQL dan melakukan tugas manajemen data Application server • Perangkat lunak yang mengontrol semua operasi aplikasi 7. 38 © 2004 by Prentice Hall

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Menghubungkan basisdata Internal

Management Information Systems 8/e Chapter 7 Managing Data Resources DATABASE TRENDS Menghubungkan basisdata Internal dengan WEB Figure 7 -21 7. 39 © 2004 by Prentice Hall