Sahar
asked on
what hardware do I need to store huge databases?
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
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
Do you want information only on a file server, or for a system to process these database requests? If you're just wanting to serve files, any current "standard" server system will do from IBM, Compaq, etc...specify that you need a fast RAID array with capacity that you will need to determine based on the size of the Word documents being created. More space can be added with a fibre-channel SCSI implementation. This may be overkill of course, it depends on the concurrent workload expected.
I'm sure plenty of other suggestions will come in with more advice, that's just my part (given a somewhat limited understanding of high-end server hardware).
-d
I'm sure plenty of other suggestions will come in with more advice, that's just my part (given a somewhat limited understanding of high-end server hardware).
-d
We need some numbers here.
define Huge ?
1 terabyte, 1 petabyte ?
You need to know the present size of the file servers as a start, and the rate of growth.
You may need a high end EMC staorage or IBM, or a smaler Compaq RAID.
What will you be using for backup ?!!
I hope this helps !
define Huge ?
1 terabyte, 1 petabyte ?
You need to know the present size of the file servers as a start, and the rate of growth.
You may need a high end EMC staorage or IBM, or a smaler Compaq RAID.
What will you be using for backup ?!!
I hope this helps !
I don't mean to disparage any of the comments already given, but I think this is a foolish question to be asking here.
You are looking at solutions to a problem that may cost from 10's of thousands to several hundred thousand US$ to solve and it may be called upon to reliably handle many millions of US$ worth of data.
Can you really afford to take advice you get here?
If you really have nobody in your company who is experienced in this area, I'd suggest you locate and hire an EXPERIENCED consulting organization that has a proven track record in designing and implementing high performance/high capacity enterprise storage and database systems.
If you choose poorly yourself, your company will almost certainly suffer greatly and you personally, if you survive, will certainly suffer professionally.
You are looking at solutions to a problem that may cost from 10's of thousands to several hundred thousand US$ to solve and it may be called upon to reliably handle many millions of US$ worth of data.
Can you really afford to take advice you get here?
If you really have nobody in your company who is experienced in this area, I'd suggest you locate and hire an EXPERIENCED consulting organization that has a proven track record in designing and implementing high performance/high capacity enterprise storage and database systems.
If you choose poorly yourself, your company will almost certainly suffer greatly and you personally, if you survive, will certainly suffer professionally.
Yeah I got to agree with jhance. I think you need a consultant that can come in and sit down with you and go over point by point what is needed, the costs involved and the equipment needed. This will require a lot of interaction between you and the consultant that you can't get here at EE. To many variables involved and to many questions needing be asked and reasked to cover as many scenarios as possible.
Plus if something doesn't work out like you think it should you have no recourse with EE. The advice you take and implement from EE is entirely at your own risk. I don't think it would be worth that kind of risk for what it is you are asking. Spend the money and get it right because it is something you are going to have to live with once it is put into action. :>)
The Crazy One
Plus if something doesn't work out like you think it should you have no recourse with EE. The advice you take and implement from EE is entirely at your own risk. I don't think it would be worth that kind of risk for what it is you are asking. Spend the money and get it right because it is something you are going to have to live with once it is put into action. :>)
The Crazy One
Maybe they were hoping for some free "SHAREWARE" program to manage their business on. :-0 Might as well.
Will be good to know what is this company with 18 dep's that stores all its data in paradox tables and MSword files.May be it is not too late to sell my shares from it (if i has ... :-)))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you all for your comments and help.
for jhance: I was just asking for an advice from persons who are experts in this field ,but unforunately I surprised that I found you valuing my questions as a foolish one ,anyhow if the person didnot ask he will never know.
btw thanks for your advice to hire an EXPERIENCED consulting .
for jhance: I was just asking for an advice from persons who are experts in this field ,but unforunately I surprised that I found you valuing my questions as a foolish one ,anyhow if the person didnot ask he will never know.
btw thanks for your advice to hire an EXPERIENCED consulting .
sahar, I think jhance didn't mean you were personally foolish in general; he was just being blunt about this being an inappropriate forum for serious business computing infrastructure questions. There is no need for you to go away angry.
This is one type that should work.