1 / 11

Session - 3 DISTRIBUTED DATABASE AND COMPUTER NETWORK

This session focuses on the fundamentals of distributed databases and their integration with computer network technology. Key objectives include understanding database and DBMS terminology, the significance of distributed databases, and the architecture of DBMS systems. We will delve into the advantages, such as enhanced performance, reliability, and scalability, while also addressing challenges like design complexity and data integrity. Additionally, this session covers computer network topologies, including ring, star, bus, and tree configurations. Gain insights into how distributed systems improve data management.

tannar
Télécharger la présentation

Session - 3 DISTRIBUTED DATABASE AND COMPUTER NETWORK

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. Session - 3DISTRIBUTED DATABASE ANDCOMPUTER NETWORK Matakuliah : M0184 / Pengolahan Data Distribusi Tahun : 2005 Versi :

  2. OBJECTIVES • DATABASE AND DBMS TERMINOLOGY • THE MEANING OF DISTRIBUTED DATABASE • COMPUTER NETWORK TECHNOLOGY

  3. 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

  4. COMPONENT OF DBMS

  5. 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

  6. 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

  7. 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)

  8. DISTRIBUTED DATABASE CONT’D DISADVANTAGE OF DDBS • COMPLEXITY OF DESIGN • DISTRIBUTION OF CONTROL • DATA INTEGRITY

  9. COMPUTER NETWORK NETWORK TOPOLOGY • RING • STAR • BUS • TREE • FULLY INTERCONNECTED

  10. COMPUTER NETWORK CONT’D STAR RING

  11. COMPUTER NETWORK CONT’D TREE INTERCONNECTED

More Related