Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 16 6 Older Entries

Displaying posts with tag: sakila (reset)

Rediscovering the roots.
+4 Vote Up -0Vote Down

Do you ever stop and think? It happens to me all the time, random subjects kick in and I end up searching (aka googling) and today I wondered … Why is MySQLs logo a dolphin? Shame on me it took me so long to ask the question but as the saying goes, better late than never.

As per MySQLs own article (http://www.mysql.com/news-and-events/generate-article.php?id=77" target="_blank):
“We’ve been discussing a new logo for at least a year”, says main developer and MySQL AB founder Michael “Monty” Widenius. “I am personally concerned about the survival of endangered species, and I liked the idea of the dolphin as soon as it came up. It combines great symbol value with a powerful, modern design.”

After a while the name was chosen out of 6357 suggestions by the community and that is how Sakila the dolphin came to be :) …. and we lived happily ever after (or at least hope to!)

Back to blogging....
+7 Vote Up -0Vote Down
It has been a while since I posted on my blog - in fact, I believe this is the first time ever that more than one month passed between posts since I started blogging. There are a couple of reasons for the lag:

  • Matt Casters, Jos van Dongen and me have spent a lot of time finalizing our forthcoming book, Pentaho Kettle Solutions (Wiley, ISBN: 978-0-470-63517-9). The book is currently being produced, and should be available according to schedule in early September 2010. If you're interested, you might like to read

  [Read more...]
TOTD #122: Creating a JPA Persistence Unit using NetBeans 6.8
Employee +0 Vote Up -0Vote Down

Taking TOTD #121 forward, this blog explains how to create a JPA Persistence Unit for a MySQL sample database and package it as a library. This JAR file can then be easily included in other web applications.

Lets get started!

  • Configure GlassFish for using the MySQL sample database (sakila) as described in TOTD #121.
  • Add the GlassFish instance in NetBeans IDE using "Services" panel.
  • Create JPA entities using NetBeans IDE.
  • Create a Java class library:



  •   [Read more...]
    TOTD #122: Creating a JPA Persistence Unit using NetBeans 6.8
    Employee +0 Vote Up -0Vote Down

    Taking TOTD #121 forward, this blog explains how to create a JPA Persistence Unit for a MySQL sample database and package it as a library. This JAR file can then be easily included in other web applications.

    Lets get started!

  • Configure GlassFish for using the MySQL sample database (sakila) as described in TOTD #121.
  • Add the GlassFish instance in NetBeans IDE using "Services" panel.
  • Create JPA entities using NetBeans IDE.
  • Create a Java class library:



  •   [Read more...]
    TOTD #122: Creating a JPA Persistence Unit using NetBeans 6.8
    Employee +0 Vote Up -0Vote Down

    Taking TOTD #121 forward, this blog explains how to create a JPA Persistence Unit for a MySQL sample database and package it as a library. This JAR file can then be easily included in other web applications.

    Lets get started!

  • Configure GlassFish for using the MySQL sample database (sakila) as described in TOTD #121.
  • Add the GlassFish instance in NetBeans IDE using "Services" panel.
  • Create JPA entities using NetBeans IDE.
  • Create a Java class library:



  •   [Read more...]
    TOTD #121: JDBC resource for MySQL and Oracle sample database in GlassFish v3
    Employee +0 Vote Up -0Vote Down

    This blog clearly explains how to configure the MySQL sample database (sakila) with GlassFish. Even though the instructions use a specific database but should work for other databases (such as Oracle, JavaDB, PostgreSQL, and others) as well. The second half of the blog provide specific syntax for the Oracle sample database.

  • Download sakila sample database and unzip the archive.
  • Install the database as described here - basically load and run "sakila-schema.sql" and "sakila-data.sql" extracted from the archive.
  • Create a new MySQL user account using MySQL CLI Admin and assign the privileges
  •   [Read more...]
    TOTD #121: JDBC resource for MySQL and Oracle sample database in GlassFish v3
    Employee +0 Vote Up -0Vote Down

    This blog clearly explains how to configure the MySQL sample database (sakila) with GlassFish. Even though the instructions use a specific database but should work for other databases (such as Oracle, JavaDB, PostgreSQL, and others) as well. The second half of the blog provide specific syntax for the Oracle sample database.

  • Download sakila sample database and unzip the archive.
  • Install the database as described here - basically load and run "sakila-schema.sql" and "sakila-data.sql" extracted from the archive.
  • Create a new MySQL user account using MySQL CLI Admin and assign the privileges
  •   [Read more...]
    TOTD #121: JDBC resource for MySQL and Oracle sample database in GlassFish v3
    Employee +0 Vote Up -0Vote Down

    This blog clearly explains how to configure the MySQL sample database (sakila) with GlassFish. Even though the instructions use a specific database but should work for other databases (such as Oracle, JavaDB, PostgreSQL, and others) as well. The second half of the blog provide specific syntax for the Oracle sample database.

  • Download sakila sample database and unzip the archive.
  • Install the database as described here - basically load and run "sakila-schema.sql" and "sakila-data.sql" extracted from the archive.
  • Create a new MySQL user account using MySQL CLI Admin and assign the privileges
  •   [Read more...]
    MySQL University: Starring Sakila - A Data Warehouse Mini-Tutorial
    Employee +0 Vote Up -0Vote Down

    This Thursday (July 2nd, 13:00 UTC), Roland Bouman will will take the Sakila sample database and explain how to design and load a data warehouse for it, and how to use that to create those reports and charts that make managers smile. Along the way, he'll explain often uttered terms and concepts such as dimensional model, denormalization, star schema, OLAP, data staging, business intelligence, ETL and data integration. Roland's session is titled Starring Sakila - A Data Warehouse Mini-Tutorial.

    For MySQL University sessions, point your browser

      [Read more...]
    MySQL University: Starring Sakila - A Data Warehouse Mini-Tutorial
    Employee +0 Vote Up -0Vote Down

    This Thursday (July 2nd, 13:00 UTC), Roland Bouman will will take the Sakila sample database and explain how to design and load a data warehouse for it, and how to use that to create those reports and charts that make managers smile. Along the way, he'll explain often uttered terms and concepts such as dimensional model, denormalization, star schema, OLAP, data staging, business intelligence, ETL and data integration. Roland's session is titled Starring Sakila - A Data Warehouse Mini-Tutorial.

    For MySQL University sessions, point your browser

      [Read more...]
    Showing entries 1 to 10 of 16 6 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.