| Author |
new to database question
|
Yuan Ye
Ranch Hand
Joined: Mar 05, 2003
Posts: 172
|
|
|
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
Joined: Jan 23, 2002
Posts: 11962
|
|
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)
|
Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
|
|
 |
|
|
subject: new to database question
|
|
|
0
