Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old September 24th, 2004, 01:48 AM
noami noami is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 2 noami User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question Large Scale Database issues

Hi,

We are designing a large-scale database application. The current one will
receive information from many inputs constantly.

We expect it to grow in one year to 60GB (on average of 4-5GB/Mo).

The database then (after one year) will have a cleaning procedure that will delete information and the size of the
database will not increase in such a way.

Here are a few questions:
1. What are the guide lines to design and implement such a database? Where can I find information on the web
on such cases?
2. From database creation point of view - should we use a few files that will create the database or should we use
only one ? If we use a few files, what happends to clustered indexes? Where can I find more reading material?
3. The database has the management tables of the application and the data tables. On data table will hold most of
the information in that database. Do you think I need to divide te table? if so, how do we do it?
how do you build efficient queries? How do you manage the data in the separate tables? How do you manage indexes?
and again where can I find material on this?

TIA!!

Noam

Reply With Quote
  #2  
Old September 24th, 2004, 03:27 AM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
 
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 21 h 32 m 23 sec
Reputation Power: 180
If you are referring to a MS SQL Server dbms, try the Books Online that come with the code and are also available online at http://msdn.microsoft.com/library
__________________
======
Doug G
======
I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain

Reply With Quote
  #3  
Old September 24th, 2004, 03:34 AM
noami noami is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 2 noami User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally Posted by Doug G
If you are referring to a MS SQL Server dbms, try the Books Online that come with the code and are also available online at http://msdn.microsoft.com/library

Thanks Doug G, but the issue is not the books - its the common practices.
Thanks for the fast reply.

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft SQL Server > Large Scale Database issues


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway