×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Can I get some Database recommendations?
3

Can I get some Database recommendations?

Can I get some Database recommendations?

(OP)
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

RE: Can I get some Database recommendations?

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

Sue Sloan

RE: Can I get some Database recommendations?

(OP)
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

RE: Can I get some Database recommendations?

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

RE: Can I get some Database recommendations?

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

RE: Can I get some Database recommendations?

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 ).

---

RE: Can I get some Database recommendations?

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.

---

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close