Can I get some Database recommendations? 3

[jwarmuth]

Good day,

Our company is thinking of creating a rather extensive database that will be accessed via the web for entering and searching large amounts of data. More specifically an online trouble ticket system with a knowledge base of resolutions that will keep track of all client info and products purchased.

Databases aren't my area of expertise so I'm hoping you all could give me your thoughts on the following database options. After we are confident we have made the right choice for our needs I'll be hiring someone to programm the appropriate database for us.

1)Oracle
2)MySQL
3)MS SQL
4)Any others I missed but are good as well

We would like to keep costs low, and security is a primary concern, even though we will have security on the web server. It has to be fast at returning queries and robust enough to grow very, very large. I honestly expect it to grow to about 10+GBs in the first two years, and even faster after that. Thank you for your help. Jeff Warmuth
MCSE, CNE

 

[suesloan]

Don't overlook IBM's DB2 and Lotus Notes as possiblilities!

Sue Sloan

 

[svanels]

Borland's Interbase at

http://www.borland.com/interbase/

and

http://www.borland.com/interbase/tech_specs.html

If you want to keep the costs low, stay away from Oracle. S. van Els
SAvanEls@cq-link.sr

 

[jwarmuth]

What about MySQL? I've heard good things about it, and the cost is NIL since it's free.

But not everything is as good as it seems! Any thoughts on that? Jeff Warmuth
MCSE, CNE
ICQ 129152989

 

[svanels]

Nothing is free, only the air you breathe.
You have to spend some money for at least buying a book to master it. Interbase is also free (open source) at least for a few connections. If you need lets say 500 concurrent users , or an open internet connection, they will charge you money for it. S. van Els
SAvanEls@cq-link.sr

 

[sfvb]

Here is a good article that compares the major databases.

http://www.pcmag.com/article/0,2997,s=1732&a=23362,00.asp

 

[svanels]

svfb that is a very good link!! although they forgot Interbase. This article entered my favorites. It enforces my statement that nothing is free.

Regards S. van Els
SAvanEls@cq-link.sr

 

[tdatgod]

Hi,


Here is what a leading analyst firm says about Data warehousing

http://www.gartner.com/gc/webletter/ncr/article2/article2.html.

However they probably consider a warehouse in the 500 to 3,000 Gig range.

10 Gig really a small database so you might be better off woth one of the smaller products like sql server or My SQL.

Both Oracle or Teradata are probably a little expensive for a Database of that size. Oracle typically handle databse in to 100 - 500 GIg range and Teradata ranges from 100 gig to 100,000 Gig ( 100 TeraBytes ).

---

 

[tdatgod]

Hi,
Although now that I think about it, since you are talking about on Windows if you would like a FREE copy of Teradata you can order it at

http://www.teradata.com/dwdemo

This is a fully functional copy of teradata with most of our client utilities bundled in. The only limitiation is the maximum size of the database allowed is 1 GIG and that you agree not to use it in a production environment.

It comes with sample database and applications ( ODBC , JDBC and CLI connections ) , which you can chose to load or not. All the samples come with the source code.

You can delete the sample database if you need more space for your own tables.

---