I want to design a model for a distributed database solution.

  • Are there appropriate tools and approaches?
  • How to include stereotypes for (horizontal) fragments?

closed as not a real question by Derek Downey, jcolebrand May 17 '12 at 22:15

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. If this question can be reworded to fit the rules in the help center, please edit the question.


If you are looking for data models to start with, I'd recommend you take a look at: http://www.databaseanswers.org/data_models/index.htm

This is the most comprehensive list of data model examples that I found so far. In fact I have used some samples as starting point for some of my projects. These models won't show you how to take horizontal fragmentation into consideration, though.


You may consider these basic techniques for horizontal fragmentation*:

  • Range Partitioning: Each fragment is assigned a different value range
  • Value List: For each fragment a list of attribute values is given
  • Hash Values: Applying a hash function to tuples, each fragment is responsible for a given hash range

*Source - Distributed Database Systems: Fragmentation and Allocation by Katja Hose, Ralf Schenkel

  • Link only answers have limited utility (if the link dies then the answer is useless). Can you add a summary of the content here? – JNK May 17 '12 at 18:27
  • As user @DTest observed, the question is too broad. According to user1170330's comment, he seems to be looking for data models. To quote him exactly (see question comment), "I just need a model for my project. I have to show the databases and how the are linked together." The link I provided, as clearly stated in my second paragraph, will lead you to a page that shows you: "comprehensive list of data model examples". – MarlonRibunal May 17 '12 at 18:43
  • ...and as I said, if the link dies or changes then the answer has no merit. If the actual answer doesn't contain the answer, then it's not an answer ;) – JNK May 17 '12 at 18:53
  • The models in the first link are only ERD's (most of them at least). – MarlonRibunal May 17 '12 at 19:05

Not the answer you're looking for? Browse other questions tagged or ask your own question.