110 likes | 219 Views
Session - 3 DISTRIBUTED DATABASE AND COMPUTER NETWORK. Matakuliah : M0184 / Pengolahan Data Distribusi Tahun : 2005 Versi :. OBJECTIVES. DATABASE AND DBMS TERMINOLOGY THE MEANING OF DISTRIBUTED DATABASE COMPUTER NETWORK TECHNOLOGY. DATABASE TECHNOLOGY. DATA AS A SOURCE
E N D
Session - 3DISTRIBUTED DATABASE ANDCOMPUTER NETWORK Matakuliah : M0184 / Pengolahan Data Distribusi Tahun : 2005 Versi :
OBJECTIVES • DATABASE AND DBMS TERMINOLOGY • THE MEANING OF DISTRIBUTED DATABASE • COMPUTER NETWORK TECHNOLOGY
DATABASE TECHNOLOGY • DATA AS A SOURCE • DBMS ARCHITECTURE • COMPONENT OF DBMS • RELATIONAL,HIERARCHICAL AND NETWORK DBMS • DATABASE DESIGN AND NORMALIZATION • QUERY LANGUANGE DML AND DDL
DBMS FUNCTION • MAINTENANCE OF PHYSYCAL DATA STRUCTURES • LANGUAGE FOR STORAGE RETRIEVAL AND UPDATE DATA • FACILITIES FOR ENSURING DATA INTEGRITY AND SECURITY • SUPPORT FOR MULTI-USER ACCESS • BACKUP AND RECOVERY • MAINTENANCE META DATA • DATA INDEPENDENCE • TOOLS FOR DATABASE ADMINISTRATOR
DISTRIBUTED DATABASE DISTRIBUTED DATABASE (DDB) IS A COLLECTION OF MULTIPLE, LOGICAL INTERRELATES DATABASE DISTRIBUTED OVER COMPUTER NETWORK DISTRIBUTED DATABASE MANAGEMENT SYSTEM (DDBMS) IS THE SOFTWARE THAT MANAGES THE DDB AND PROVIDES ACCESS MECHANISM THAT MAKE DISTRIBUTION TRANSPARENT FOR THE USER
DISTRIBUTED DATABASE CONT’D ADVANTAGE OF DDBS (DISTRIBUTED DATABASE SYSTEM) • IMPROVED PERFORMANCE, RELIABILITY AND AVAILABILITY THROUGH DISTRIBUTED PROCESSING • ECONOMICS, EXPANDABILITY, SHAREABILITY • LOCAL AUTONOMY (OF THE SITE THAT PARTICIPATE)
DISTRIBUTED DATABASE CONT’D DISADVANTAGE OF DDBS • COMPLEXITY OF DESIGN • DISTRIBUTION OF CONTROL • DATA INTEGRITY
COMPUTER NETWORK NETWORK TOPOLOGY • RING • STAR • BUS • TREE • FULLY INTERCONNECTED
COMPUTER NETWORK CONT’D STAR RING
COMPUTER NETWORK CONT’D TREE INTERCONNECTED