implementation, & Management 13th
Edition - Chapter 12
Distrubuted Database Management System (DDMS)
A DBMS that helps a database dispensed across several exceptional web sites;
it governs the storage and processing of logically related facts over interconnected laptop
systems wherein both data and processing functions are distributed
Factors of essential social and technological adjustments that affected the nature of the systems
and the facts they use: (five)
- Business operations became worldwide
- Customer needs and market needs favoring an on-call for transaction styl
- Rapid social and technological adjustments fueled through low-value
- Data geographical regions are converging inside the digital world extra often
- The creation of social media as a manner to attain new customers and open new markets
2 Database requirements:
1- Rapid advert hoc records get entry to
2- Distributed facts get right of entry to
Centralized Database Management Problems:
- Performance degradation
- High fees
- Reliability troubles
- Scalability issues
- Organizational rigidity
Distributed DMS Advantages:
- Data is placed near the web site of greatest demand
- Faster information get right of entry to
, - Faster facts processing
- Growth facilitation
- Improved communications
- Reduced operating expenses
- User-Friendly interface
- Less threat of unmarried-point failure
- Processor independence
Distributed DMS Disadvantages:
- Compexity of management and control
- Technological issue
- Security
- Lack of standards
- Increased garage and infrastructure requirements
- Increased education fee
- Higher prices
allotted processing
Sharing the logical processing of a database over 2/extra websites connected by using a
community
Uses only a single-site database however stocks the processing chores among several
websites
disbursed database
A logically related database that is stored in 2/extra physically indepenent sites
Sites are linked via a computer community
database fragment
A subset of a allotted database
Although the fragments may be stored at exceptional websites inside a computer community,
the set of all fragments is dealt with as a unmarried database
Fragments are placed at one-of-a-kind sites and can be replicated among diverse web sites
(Also see: horizontal fragmentation and vertical fragmentation)
Keep the subsequent factors in mind while working with dispensed databases and dispensed
processing: