We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Distributed database disadvantages

evry2004
evry2004 asked
on
Medium Priority
2,083 Views
Last Modified: 2012-05-06
Distributed database disadvantages
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2010

Commented:
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...

Regards,

Patrick

Commented:
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.

Regards,

Jim
SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.