As mentioned in previous article, the database connectivity standard in Java is called JDBC that is an application programming interface (API) for the programming language Java, which defines how a client may access a database.
You can use any relational database that has a JDBC driver. These would include PostgreSQL, MySQL (for small, mid and big applications) , Oracle (for very big applications ), SQLLite, MS SQL Server, Sybase, DB2, H2, Apache Derby, Mongo and Cassandra .
- MySQL is an open-source RDBMS, owned by Oracle. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter and “SQL”, the abbreviation for Structured Query Language. It operates on Intel hardware only (contrary to Oracle which is available for almost any platform) and doesn’t come with any development tools.
Apache is an open source initiative producing various webservers, often combined with PHP and MySQL.
SQL is the acronym for Structured Query Language, which is used to retrieve data from a RDBMS. However, most vendors have their own dialect. the SQL in MySQL is incompatible with the SQL in Oracle RDBMS.
- Oracle is the company which made the first commercially available RDBMS, way back in 1979. The current version of this RDBMS, which is geared at corporate environments, is 12c. It comes with a webserver and a web-development environment, inside the database, called Apex. It integrates many products it bought in their Fusion Middleware architecture. Oracle acquired Sun and by consequence owns Java and Solaris and is now also selling hardware and database specific hardware called Exadata.
You should use Oracle if…
- You require flexibility in terms of transaction control
- You plan to host a large database
- You require a high degree of scalability
- You want your database to be platform-independent
You should use MySQL if…
- You aren’t going to scale to any large degree
- You’re planning to create a read-only web app or a website
- You require a high degree of replication
- Your project only requires simple queries, and has a low concurrency