Solved

Database Design for a data extensive application

Posted on 2007-11-15
5
239 Views
Last Modified: 2013-11-12
Hi Experts,

We are designing a data extensive application. There would approximately one thousand customers for which we'll be entering data on daily basis.

All the data entry would be done in-house i.e. customer won't be entering the data themselves. Customers would be allowed to generate reports on the data entered. Reports being generated for one customer may be using data from all one thousand customers. The guesstimate for the daily data is around 10MB for all thousand customers.

Here is how we are planning to setup the environment:

We are planning to setup two different databases on two different machines, one for transactional data and other for reporting purpose. All the customers will be using the database daily for reporting. We'll be using a service that will fetch the data from transactional database, compile it, and dump into the reporting database.

I need feedback on the following:

1. Any comments/suggestion on above design.
2. Any other better idea for load balancing for the above situation.

Deployment environment would be: Window 2003 Server, MS SQL Server 2005.

Thanks,
Imran
0
Comment
Question by:imrancs
  • 2
  • 2
5 Comments
 
LVL 8

Expert Comment

by:digital_thoughts
ID: 20290443
From what you've said, I don't see a problem with the setup you are considering... Main thing to be concerned with is the actual database designs, make sure they are designed with 3rd normal form, normalized only when truly needed, also be sure they indexes are created for the queries that reports are generated from.
0
 
LVL 10

Author Comment

by:imrancs
ID: 20296494
digital_thoughts:

Thanks for your input.

Actually I am looking for possible options so I can chose better. There'll be heavy simultaneous hits on both databases. Therefore I want to design the things in such a way that they are scalable enough for the current scenario and for the future growth of data.

Thanks again.

Imran
0
 
LVL 8

Accepted Solution

by:
digital_thoughts earned 500 total points
ID: 20298413
Additional options would be setting up replication of the databases, then allows only a portion of your customers access a server, hince a sort of load balancing. Another option, but more expensive would be setting up a cluster. Since from the sound of it, most of your heavy activity will be read only querying, you have alot of options especially with replication, its when the customers need to modify that data as well, when things get more complex and expensive.
0
 
LVL 10

Author Comment

by:imrancs
ID: 20299232
digital_thoughts Thanks you for your input.

I would be waiting for more experts opinion.

Imran
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20311292
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

762 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now