Distributed database disadvantages

Posted on 2009-02-16
Medium Priority
Last Modified: 2012-05-06
Distributed database disadvantages
Question by:evry2004
LVL 93

Expert Comment

by:Patrick Matthews
ID: 23652545
Hello evry2004,

1) You will get a much better response from the Experts if you actually ask a question

2) Dropping broad-based, general topics like this smacks of "homework" or an academic assignment of some sort...


LVL 18

Expert Comment

ID: 23652597
In addition to asking a real question you'd get better results posting in at least two zones, and you are allowed to post in as many as three zones.


LVL 57

Accepted Solution

Raja Jegan R earned 2000 total points
ID: 23659362
You will have the following disadvantages:

1. Performance impact will be very huge if you combine multiple databases in a query / statement.
2. Sorting, Merging and Aggregations of the result set will be a problem.
3. Complexity  extra work must be done by the DBAs to ensure that the distributed nature of the system is transparent. Extra work must also be done to maintain multiple disparate systems, instead of one big one. Extra database design work must also be done to account for the disconnected nature of the database  for example, joins become prohibitively expensive when performed across multiple systems.
4. Less Security  remote database fragments must be secured, and they are not centralized so the remote sites must be secured as well. The infrastructure must also be secured (e.g., by encrypting the network links between remote sites).
5. Data Integrity -- Require much of network resources
6. Complex Database design

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question