Solved

Database Design for a data extensive application

Posted on 2007-11-15
5
249 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

734 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