I am doing an undergrad final project, and need to justify my choice of MySQL for the database element of my project. Truth is, it's the only one I can really use, and hence I went for it.
我正在做一个本科最终项目，需要证明我选择MySQL作为我项目的数据库元素。事实是，它是我唯一可以真正使用的，因此我去了它。
What other database systems could I have used? Any advantages and disadvantages of these over MySQL?
我可以使用哪些其他数据库系统？ MySQL的这些优点和缺点是什么？
5 个解决方案
#1
17
In fact, you can use every database which is accessible through a JDBC driver. Almost all self-respected RDBMS vendors provides a fullworthy JDBC driver for download at their homepage. Just Google "[vendorname] jdbc driver download" to find it. Here's an overview:
实际上，您可以使用可通过JDBC驱动程序访问的每个数据库。几乎所有备受推崇的RDBMS供应商都在其主页上提供了一个完整的JDBC驱动程序供下载。只需Google“[vendorname] jdbc驱动程序下载”即可找到它。这是一个概述：
- MySQL JDBC driver
- MySQL JDBC驱动程序
- PostgreSQL JDBC driver (note: older versions doesn't support generated keys).
- PostgreSQL JDBC驱动程序（注意：旧版本不支持生成的密钥）。
- Oracle JDBC driver (note: older versions doesn't support generated keys).
- Oracle JDBC驱动程序（注意：旧版本不支持生成的密钥）。
- MSSQL JDBC driver (or performancewise better, the jTDS JDBC driver)
- MSSQL JDBC驱动程序（或性能更好，jTDS JDBC驱动程序）
- DB2 JDBC driver is hard to find in IBM's online forest, but it's usually already included in the
/javafolder of the DB2 installation. - DB2 JDBC驱动程序很难在IBM的在线林中找到，但它通常已经包含在DB2安装的/ java文件夹中。
This way you can use the JDBC API transparently to access either of the databases.
这样，您可以透明地使用JDBC API来访问任一数据库。
As to which database to choose, just look at the features, robustness, performance, etc the RDBMS provides and the budget you have -if it isn't freeware. I myself tend to prefer PostgreSQL.
至于选择哪个数据库，只需查看RDBMS提供的功能，健壮性，性能等以及您拥有的预算 - 如果它不是免费软件。我自己倾向于喜欢PostgreSQL。
Instead of a fullfledged database server, you can also consider an embedded Javabased database, such as
Sun
Oracle JavaDB, Apache Derby, HSQLDB or SQLite, each which are of course accessible through the JDBC API the usual way.
您也可以考虑使用嵌入式Javabased数据库，例如Sun Oracle JavaDB，Apache Derby，HSQLDB或SQLite，而不是完整的数据库服务器，每个数据库都可以通过JDBC API以常规方式访问。
#2
3
You can use any relational database that has a JDBC driver. These would include PostgreSQL, Hypersonic SQL, MySQL, SQLLite on the free side and Oracle, MS SQL Server, and others on the paid side.
您可以使用具有JDBC驱动程序的任何关系数据库。这些将包括免费的PostgreSQL，Hypersonic SQL，MySQL，SQLLite以及付费方面的Oracle，MS SQL Server和其他方面。
The biggest advantage accrued to MySQL in your case is that it's free and you know it. That's enough to make it suitable for what you want to accomplish.
在你的情况下，MySQL的最大优势是它是免费的，你知道它。这足以使其适合您想要完成的任务。
#3
2
You could have used pretty much ANY database. MSSQL, SQLite, Postgre, Oracle or [put your choice here]
您可以使用几乎任何数据库。 MSSQL，SQLite，Postgre，Oracle或[在此处选择]
There's a driver for pretty much any database to integrate with Java. This is a great place to find out all the DB's java support, as well as how to integrate
几乎所有数据库都有与Java集成的驱动程序。这是查找所有DB的java支持以及如何集成的好地方
Hope this helps
希望这可以帮助
#4
1
Have a look at the list of vendors who have endorsed the JDBC API maintained by Sun. Also see the list of third-party JDBC technology-enabled drivers which are currently shipping.
查看已经认可Sun维护的JDBC API的供应商列表。另请参阅当前发运的第三方支持JDBC技术的驱动程序列表。
#5
1
You mentioned MySQL and database. For the case you are free to usa a non RDBMS you can check db4o.
你提到了MySQL和数据库。对于您可以*发布非RDBMS的情况，您可以检查db4o。
Advantage: pure OO/Java persistence.
优点：纯OO / Java持久性。
#1
17
In fact, you can use every database which is accessible through a JDBC driver. Almost all self-respected RDBMS vendors provides a fullworthy JDBC driver for download at their homepage. Just Google "[vendorname] jdbc driver download" to find it. Here's an overview:
实际上，您可以使用可通过JDBC驱动程序访问的每个数据库。几乎所有备受推崇的RDBMS供应商都在其主页上提供了一个完整的JDBC驱动程序供下载。只需Google“[vendorname] jdbc驱动程序下载”即可找到它。这是一个概述：
- MySQL JDBC driver
- MySQL JDBC驱动程序
- PostgreSQL JDBC driver (note: older versions doesn't support generated keys).
- PostgreSQL JDBC驱动程序（注意：旧版本不支持生成的密钥）。
- Oracle JDBC driver (note: older versions doesn't support generated keys).
- Oracle JDBC驱动程序（注意：旧版本不支持生成的密钥）。
- MSSQL JDBC driver (or performancewise better, the jTDS JDBC driver)
- MSSQL JDBC驱动程序（或性能更好，jTDS JDBC驱动程序）
- DB2 JDBC driver is hard to find in IBM's online forest, but it's usually already included in the
/javafolder of the DB2 installation. - DB2 JDBC驱动程序很难在IBM的在线林中找到，但它通常已经包含在DB2安装的/ java文件夹中。
This way you can use the JDBC API transparently to access either of the databases.
这样，您可以透明地使用JDBC API来访问任一数据库。
As to which database to choose, just look at the features, robustness, performance, etc the RDBMS provides and the budget you have -if it isn't freeware. I myself tend to prefer PostgreSQL.
至于选择哪个数据库，只需查看RDBMS提供的功能，健壮性，性能等以及您拥有的预算 - 如果它不是免费软件。我自己倾向于喜欢PostgreSQL。
Instead of a fullfledged database server, you can also consider an embedded Javabased database, such as
Sun
Oracle JavaDB, Apache Derby, HSQLDB or SQLite, each which are of course accessible through the JDBC API the usual way.
您也可以考虑使用嵌入式Javabased数据库，例如Sun Oracle JavaDB，Apache Derby，HSQLDB或SQLite，而不是完整的数据库服务器，每个数据库都可以通过JDBC API以常规方式访问。
#2
3
You can use any relational database that has a JDBC driver. These would include PostgreSQL, Hypersonic SQL, MySQL, SQLLite on the free side and Oracle, MS SQL Server, and others on the paid side.
您可以使用具有JDBC驱动程序的任何关系数据库。这些将包括免费的PostgreSQL，Hypersonic SQL，MySQL，SQLLite以及付费方面的Oracle，MS SQL Server和其他方面。
The biggest advantage accrued to MySQL in your case is that it's free and you know it. That's enough to make it suitable for what you want to accomplish.
在你的情况下，MySQL的最大优势是它是免费的，你知道它。这足以使其适合您想要完成的任务。
#3
2
You could have used pretty much ANY database. MSSQL, SQLite, Postgre, Oracle or [put your choice here]
您可以使用几乎任何数据库。 MSSQL，SQLite，Postgre，Oracle或[在此处选择]
There's a driver for pretty much any database to integrate with Java. This is a great place to find out all the DB's java support, as well as how to integrate
几乎所有数据库都有与Java集成的驱动程序。这是查找所有DB的java支持以及如何集成的好地方
Hope this helps
希望这可以帮助
#4
1
Have a look at the list of vendors who have endorsed the JDBC API maintained by Sun. Also see the list of third-party JDBC technology-enabled drivers which are currently shipping.
查看已经认可Sun维护的JDBC API的供应商列表。另请参阅当前发运的第三方支持JDBC技术的驱动程序列表。
#5
1
You mentioned MySQL and database. For the case you are free to usa a non RDBMS you can check db4o.
你提到了MySQL和数据库。对于您可以*发布非RDBMS的情况，您可以检查db4o。
Advantage: pure OO/Java persistence.
优点：纯OO / Java持久性。