Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

single database or multiple database

single database or multiple database

single database or multiple database

I need some clarification to design the database of my project.Let me explain my project first.
This project has atleast 10 clients who are going to update the database.
Each client has 1 million records per year.Each client has similar kind of data and each client has nearly 10 tables.

I have decided to choose any of the three possible approaches for this DB  design

    1. Keeping a single table (with Client ID field)for all the clients(single table - single database)
    2. Keeping seperate table for each client in a single database (Multiple table - single database)
    3. Keeping separate database for each client (Multiple table - multiple database)

Let me know which is the best appraoach among the above three for my project.I am using SQL server 2000 as database server.Currently we have only one database server.In future, we may go for more than one database server.Even we can go for the federated database system.My query is mostly based on the client wise, but occasionally I need to query the data by combining the more than one client.
So please help me to find the best of above three approaches for the current situations which will give good performance now and the porting to federated database system can also be easily implemented in future.

Can any one help me?

Thanx in advance,

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close