Solved

what hardware needed to store huge databases?

Posted on 2001-08-06
7
229 Views
Last Modified: 2010-04-06
hello Sirs

I would like to ask about the hardware needed {Servers and their featurs......other H\W} for a filling System developed for a company that consist of 18 department which all have files that want to store, retrive,and Search from the database .
The system is written by delphi programming language and the tables are created using paradox ,the application is CGI (Common Gateway Interface).
The idea is that :to let those who are responsible from files in their department open the application through the net of the company.
Note:
 _The number of files are unlimited and increase continously
 _Most of the company files are writtem in MSword.
 

thanks in advance
Sahar Elsadig Elamin
0
Comment
Question by:Sahar
[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
7 Comments
 
LVL 17

Accepted Solution

by:
inthe earned 40 total points
ID: 6357412
hi,
just to mention msword files are quite big so you will need to work out an average size of the documents and approx how many documents are going to be made over say a year and * that together to see the bare minimum size harddisk you will need.
youll probably want to at least double the result then add the size of the operating system and software needed to run the db including your delphi app.
with harddisk sizes these days it shouldnt be a problem to stick at least a couple of 40-50g disks in a server..
0
 
LVL 5

Assisted Solution

by:heathprovost
heathprovost earned 40 total points
ID: 6357725
Just my humble opinion, but I dont think paradox is at all suited for such a demanding task.  If I understand correctly you are wanting to store ALOT of BIG files in BLOB fields inside of a database correct?  Paradox in my experience suffers for index corruption problems in even small litely used multiuser applications, and it is a pain to keep reparing things. And it is sssslllloooowwwwwww.  I would highly recommend going with a full blown DBMS such as Interbase, Oracle, or MSSQL to do this kind of heavy lifting.  As for hardware, I would say that would end up depending on the chosen DB.  Paradox can really only scale to a certain point both in maximum table size and memory use, so throwing big iron at it wont help a whole lot.  On the other hand the big DBMS's such as I mentioned LOVE having gobs and gobs of memory and big, fast hard drives...  If I were specking a system for this I would probably choose the following:

At least a 900Mhz processor, preferable 2 (if not on paradox, paradox wont get much benefit from a dually) Of course the faster the better...

Either an IDE Raid controller or a SCSI Raid controller - IDE is much, much cheaper, but is also a tad bit slower for this kind of stuff and the SCSI stuff is usually hot swapable so that is a plus.

Lots of memory, at least 512MB, preferable 1 Gig or more. With memory as cheap as it is now you might as well max the motherboard out... Again, if you stick with paradox I doubt any more than 512MB will do you any good.

at least 2 80 gig drives.  If you get 2 than set up a mirror using the raid controller.  If you go the scsi route it is much more cost effective to get 5 40gig drives and setup a RAID5 array.  Then replacement costs are not as high when you have a failure.

I would also recommend get 2 NIC cards that do load balancing so you can boost your network throughput as much as possible.  This is a pretty cheap way to get better network performance.

A system like this can be had for about 2k to 3k US dollars depending upon options chosen

Of course the above is strictly for the database server.  I would highly recommend putting the web server on a seperate box to maximize performance.  Running the web server on the same box as the DB isnt a good idea if the web site gets alot of use.  The two services will tend to fight with each other for memory bandwidth and cpu time.  The web server doesnt need to be much, just enough to handle the expected load, the DBMS will be doing most of the work if you code everything properly.  Of course if you are not expecting high utilization then putting them both on one box is an option.

Heath
0
 
LVL 15

Assisted Solution

by:simonet
simonet earned 40 total points
ID: 6357902
First of all, forget about Paradox. Paradox is simply for you to GET STARTED in LEARNING doing some DB programming. It's not at all suited for a full-blown professional application.

If you're gonna stick with Paradox, than ANYTING will do, as long as you have a HD large and fast enough to hold all the files you want and has a fast network.

Alex
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 2

Assisted Solution

by:FrodoBeggins
FrodoBeggins earned 40 total points
ID: 6358735
Yes, I agree PARADOX can't get the load. The same for using os like Windows 98. Just not done for server.

I suggest you the folowing:

Oracle or SQL Server (I prefer Oracle. it's more secure). IBM DB2 can make it too, but it costs more and it is slower than Oracle. SQL Server is esaier for administraton, Oracle is well-known world leader.

Use SCSI RAID controler. It may be more expensive, but my test server got 6 to 10 times (!) faster after is changed the configuration from (2 SCSI 80 IBM disks) to (4 SCSI 160 RAID 1+0 IBM discs) with no other config change.

OS: Windows NT or 2K - they all can handle te load. Use the latest servicepack. Linux can do it too.

Rgds,
Frodo
0
 
LVL 3

Assisted Solution

by:VSF
VSF earned 40 total points
ID: 6359047
Why not using INTERBASE it's free and can handle the task!

How many computers are attached to the network!?

VSF
<edited by PashaMod>
0
 
LVL 26

Expert Comment

by:Russell Libby
ID: 8741460
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Split points between inthe, heathprovost, simonet, FrodoBeggins, and VSF

Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Thank you,
Russell

EE Cleanup Volunteer
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses
Course of the Month7 days, 1 hour left to enroll

622 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