• Post Reply Bookmark Topic Watch Topic
  • New Topic

new to database question  RSS feed

 
Yuan Ye
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, everyone. I am quite new to database programming, I don't know which database system should I choose to practice and which one is most marketable used. There exits several choices as: Oracle, mySQL, MS SQL Server (is it also syBase?), MS Access and DB2. Could someone give me some advice or just tell me about the difference of these systems. Thanks in advance.
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The products you mentioned are the most commonly used in commercial projects, I believe. However, for learning purposes I would go with MySQL because it's freely available, lightweight (you don't need to buy 2GB RAM to run), and has the most important features in place.
The biggest differences among relational database products are (not in any particular order):
- price
- tools (GUI vs. command-line, reporting tools, etc.)
- performance
- enterprise features (clustering, replication, etc.)
- standards compliancy (e.g. SQL-92 datatypes)
- weight (how much h/w do you need to run a private development environment)
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!