Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

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

  • Are there appropriate tools and approaches?
  • How to include stereotypes for (horizontal) fragments?
share|improve this question
Oftentimes the function or business logic drives the design model. What are you trying to achieve? – MarlonRibunal May 17 '12 at 1:21
I just need a model for my project. I have to show the databases and how the are linked together. – user1170330 May 17 '12 at 11:58
In the current state, this question is too broad. Could you provide more details on what you are doing, and perhaps what you have found so far in your research? – Derek Downey May 17 '12 at 13:41
I have found these 2 models so far: train-srv.manipalu.com/wpress/wp-content/uploads/2009/09/… and docs.oracle.com/cd/B19306_01/server.102/b14231/img/admin046.gif. I think, this is the way, I should do that. But unfortunately I still don't understand, what (horizontal) fragments are and how to implement them in the model. – user1170330 May 17 '12 at 16:10

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, see the FAQ.

1 Answer

up vote 3 down vote

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.

Update:

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

share|improve this answer
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
+1 for the edit – JNK♦ May 17 '12 at 18:58
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.