Advanced Database Management System - Tutorials and Notes: Date's Tweleve Rules for Distributed Database Systems - Database (DBMS) Independence

Friday, 15 May 2015

Date's Tweleve Rules for Distributed Database Systems - Database (DBMS) Independence

Date's Tweleve Rules for Distributed Database Systems - Database [DBMS] Independence


DBMS independence

The system must support any vendor's database product. The DBMS instances at different sites all support the same interface - they do not necessarily all have to be copies of the same DBMS software. The ideal distributed system should be heterogeneous and should provide DBMS independence.
For example, if Ingres and Oracle both supported the official SQL standard, the Ingres site and the Oracle site might be able to talk to each other in a distributed database system. Pictorial representation of the same is given below.


Fig 1 - Distributed database with database independence (source: Prof. Sin Min Lee ppt from CJ Date book)








No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents