SAKILA DEMO DATABASE FREE COMMUNITY EDITION

Sakila Demo Database Free Community Edition

Like Oracle and Microsoft’s flagship RDBMS, MySQL Server comes in at least four flavors, ranging from the free Community Edition, demonstrated here, to a full-featured, enterprise-level Cluster Carrier Grade Edition. In fact, MySQL is the world’s most popular open source database software, according to Oracle.MySQL is available on over 20 platforms and operating systems including Linux, Unix, Mac and Windows, according to the MySQL website. However, there are several excellent alternative relational databases, including MySQL. The section below outlines the SQL queries to create test tables and demo data.When implementing a Relational Database Management System ( RDBMS), many enterprise software developers tend to favor Oracle 11g or Microsoft SQL Server relational databases, depending on their technology stack. The Sakila sample database was created for the purposes of tutorials.

MySQL is supported by many popular IDE’s, including MySQL’s own RDBMS IDE, MySQL Workbench. NET development, as well as other languages. MySQL provides JDBC, ODBC.

Installation and ConfigurationIf you’ve worked with Microsoft SQL Server or particularly Oracle 11g, you’ll have a minimal learning curve with MySQL. The RESTful web services, part of a Java Web Application, will be deployed to GlassFish, where they are accessed with HTTP methods and tested. The class library will be referenced by the RESTful web services. We will separate the JPA entities into a Java Class Library. We will then build RESTful web services, EJB classes, which communicate with MySQL through the entities.

I will host the project on Oracle’s GlassFish Open Source Application Server 3.1.2.2, running on Ubuntu. I will be using the latest Linux version of NetBeans IDE 7.3 to develop the demonstration project. All links are included at the end of this post.For reference when following this post, I have installed MySQL Server 5.5.x on 64-bit Ubuntu 12.10 LTS, running within a Windows version of Oracle VM VirtualBox. To get the latest software and installation and configuration recommendations, I prefer to download and install them myself from the MySQL web site. If on Linux, you could use the command line, or a native application management application, like Synaptic Package Manager, to perform most of the installations. Start by downloading and installing the latest versions of MySQL Server, MySQL Workbench, MySQL JDBC Connector/J Driver, and MySQL Sakila sample database.