Transcript Manajemen Data Berdasarkan Komputer dengan Sistem Database LOGO Pendekatan Manajemen Data Dengan Komputer Pendepatan berorintasi file Memusatkan perhatian pada aplikasi individual Pendekatan database memusatkan pada penyimpanan data terpadu yang dibutuhkan oleh.

Manajemen Data
Berdasarkan Komputer
dengan Sistem Database
LOGO
Pendekatan
Manajemen Data
Dengan Komputer
Pendepatan berorintasi file
Memusatkan perhatian pada aplikasi
individual
Pendekatan database
memusatkan pada penyimpanan data
terpadu yang dibutuhkan oleh semua
aplikasi.
LOGO
Kelemahan
Pendekatan
Orientasi File
Kelebihan Data
Inkonsistensi
Ketidakmampuan mengakses
banyak data
Ketidakluwesan
LOGO
The Database Approach to Data
Storage
A Database is a set of computer files that
minimizes data redundancy and is accessed by
one or more application programs for data
processing
The database approach to data storage applies
whenever a database is established to serve two
or more applications, organizational units, or
types of users
LOGO
Characteristics of
the Database
Approach
Data Independence - the separation of the data
from the various application programs and other
accesses by users
Data Standardization - data elements within a
database have standard definitions, thus stored
data are compatible with every application
program that accesses the data
One-Time Data Entry and Storage - individual
data values are entered into the database only
once; consequently, redundancy is reduced and
inconsistencies between data elements are
eliminated
LOGO
Characteristics of
the Database
Approach
Data Integration - data sets integrate the data,
which enables all affected data sets to be updated
simultaneously
Shared Data Ownership - all data within a
database are owned in common by the users. The
portion of the database that is of interest to each user
is known as the sub-schema
Centralized Data Management - the database
management system stands guard over the database
and presents the logical view to users and
application programs
LOGO
Manfaat &
Kekurangan
Pendekatan Database
Manfaat
 Berkurangnya Kelebihan Data
 Meningkatnya Keluwesan Untuk Memenuhi
Permintaan yang Berubah
 Meningkatnya Aksesabilitas Data
Kekurangan
 Mahal
 Awal yang Lambat
 Peka
LOGO
Model Data Logic
Data Base
Gudang Penyimpanan Data
Struktur Data (Data Logic)
LOGO
Data Logic
TREE MODEL
 Hanya memiliki Satu Buluh
Dasar
 Hubungan yang simple
A
B
C
D
E
LOGO
NETWORKING MODEL
A
B
C
D
E
G
 Lebih dari satu
buluh dasar
 Lebih kompleks
F
H
I
LOGO
RELATION MODEL
A
W
C
B
X
Y
Independen,
dan tidak
tergantung
satu sama lain
Z
LOGO
Database Management
System (DBMS)
A Database Management System (DBMS) is
a computer program that enables users to
create, modify, and utilize database
information efficiently
Fuctionality :
 Data Creation
 Data Maintenance
 Data Calling
LOGO
Program-Data Independence
Application
Program A
Database
Management
System
Database
Application
Program B
LOGO
DBMS Component
Data Base Control System (DBCS)
 Control the various component od the DBMS
 Controling on:
• Data Storage
• Data Calling
Data Definition Language (DDL)
 Logical structure of the data base
 Defines the data item
LOGO
DBMS Component
(Cont’)
Data Manipulation Language
Frase command in the program to :
 Saving File
 Manipulation File
 Call Out File
LOGO
Query Language
 Special Comment
 interactive
Report Generator
 Design Report
 Specification
Another component
 Modul
LOGO
Pertimbangan Rancangan
Data Base
SKEMA DATA BASE
 Model Konseptual
 Flowchart
RANCANGAN DBMS
 Pemilihan model data logic
 Implementasi skema dengan DDL
 Masukan info data sesuai skema dan aplikasi
yang akan digunakan dengan DML
LOGO