Manajemen Data Berdasarkan Komputer dengan Sistem Database LOGO
Manajemen Data Berdasarkan Komputer dengan Sistem Database LOGO
Pendekatan Manajemen Data Dengan Komputer v. Pendepatan berorintasi file Memusatkan perhatian pada aplikasi individual v. Pendekatan database memusatkan pada penyimpanan data terpadu yang dibutuhkan oleh semua aplikasi. LOGO
Kelemahan Pendekatan Orientasi File v. Kelebihan Data v. Inkonsistensi v. Ketidakmampuan mengakses banyak data v. Ketidakluwesan LOGO
The Database Approach to Data Storage v. A Database is a set of computer files that minimizes data redundancy and is accessed by one or more application programs for data processing v. 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 v Data Independence - the separation of the data from the various application programs and other accesses by users v Data Standardization - data elements within a database have standard definitions, thus stored data are compatible with every application program that accesses the data v 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 v. Data Integration - data sets integrate the data, which enables all affected data sets to be updated simultaneously v. 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 v. 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 v. Manfaat § Berkurangnya Kelebihan Data § Meningkatnya Keluwesan Untuk Memenuhi Permintaan yang Berubah § Meningkatnya Aksesabilitas Data v. Kekurangan § Mahal § Awal yang Lambat § Peka LOGO
Model Data Logic Data Base Gudang Penyimpanan Data Struktur Data (Data Logic) LOGO
Data Logic TREE MODEL v Hanya memiliki Satu Buluh Dasar v Hubungan yang simple A B C D E LOGO
NETWORKING MODEL A B C D E G q Lebih dari satu buluh dasar q 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) v. A Database Management System (DBMS) is a computer program that enables users to create, modify, and utilize database information efficiently v Fuctionality : § Data Creation § Data Maintenance § Data Calling LOGO
Program-Data Independence Application Program A Database Management System Database Application Program B LOGO
DBMS Component v. Data Base Control System (DBCS) § Control the various component od the DBMS § Controling on: • Data Storage • Data Calling v. Data Definition Language (DDL) § Logical structure of the data base § Defines the data item LOGO
DBMS Component (Cont’) v. Data Manipulation Language Frase command in the program to : § Saving File § Manipulation File § Call Out File LOGO
v. Query Language § Special Comment § interactive v. Report Generator § Design Report § Specification v. Another component § Modul LOGO
Pertimbangan Rancangan Data Base v. SKEMA DATA BASE § Model Konseptual § Flowchart v. RANCANGAN DBMS § Pemilihan model data logic § Implementasi skema dengan DDL § Masukan info data sesuai skema dan aplikasi yang akan digunakan dengan DML LOGO
- Slides: 17