Distributed Databses

• Distributed processing involves placing processing units at different locations and linking them via telecommunications equipment.
• A distributed database is a database in which data may be spread across several smaller databases connected via telecommunications devices.
• Distributed database is a single database in one location. All users and client applications connect directly to the DBMS and this means that the database is stored in only one location and everyone in the system is directly connected to it.
• Avantage
• Access if faster
• Processing is faster due to several sites spreading out the workload,
• New sites can be added quickly and easily
• Communication is improved,
• It is user friendly
• There is less danger of a single point failure
• It has process independence
• Disadvantage
• Managing and controlling is complex
• There is less security because data has so many different sites.
• Data integrity
• Data needs to be carefully partitioned to make the system as eddicinet as possible