Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 16

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...]
    Talking at FOSDEM (7-8 februari, MySQL Room)
    +0 Vote Up -0Vote Down
    Wohoo!

    I just got word that the proposals I submitted for FOSDEM are appoved! I was going to go to FOSDEM no matter what, and when I saw Lenz Grimmer's call for participation, I decided to give it a go.

    I'll be doing two talks:

    • MySQL Plugins - Learn about this exciting MySQL 5.1 feature

    • Starring Sakila - A datawarhousing and Business Intelligence mini-tutorial using the Sakila sample database


    Having the opportunity to do these talks adds to the fun, and I feel honored for being given the chance. Thank you!

    This year, Fosdem looks very promising for the MySQL









      [Read more...]
    "Starring Sakila": a Data Warehousing mini-tutorial at the MySQL UC 2009
    +0 Vote Up -0Vote Down
    Hi!

    Recently I wrote about how glad I was to see two of my proposals for the upcoming MySQL Conference approved.

    I am absolutely thrilled to see my third proposal has been approved as well: "Starring Sakila: data warehousing explained, illustrated and subtitled". I'm very proud to announce that I'm doing this talk together with Matt Casters, chief data integration of Pentaho and creator of the popular ETL/Data Integration suite Kettle (a.k.a Pentaho data integration).

    During this 45-minute





      [Read more...]
    The power of a good SQL naming convention
    +0 Vote Up -0Vote Down
    At my previous employer, one of the early decisions that had huge payoffs later was the SQL naming conventions. A good naming convention is more than just a nicety. It lets you write programs that don’t need to be told about the relationships among tables and columns. There are many ways to do this, [...]
    RESTful representation of "sakila" using GlassFish and NetBeans IDE
    Employee +0 Vote Up -0Vote Down

    "sakila" is the sample database shipped with MySQL (http://mysql.com) (pronounced as my ess-kew-ell). In the context of Sun Microsystems announcing the agreement to acquire MySQL, I'd like to dedicate this entry to show how this sample database can be exposed as a RESTful Web service endpoint and deployed on GlassFish using Jersey Tooling Plugin (0.4.1 with Jersey 0.4) in NetBeans IDE.

    Lets get started!

  • Install MySQL & the sample database
  •   [Read more...]
    Helping Dolphins Fly
    Employee +0 Vote Up -0Vote Down

    We announced big news today - our preliminary results for our fiscal second quarter, and as importantly, that we're acquiring MySQL AB (http://www.mysql.com).

    If you're interested in the financial details for the quarter, tune in to our conference call (see details on sun.com) today - we'll obviously have more to say as we release our formal results on January 24th.

    But the biggest news of the day is... we're putting a billion dollars behind the M in LAMP. If you're an industry insider, you'll know what that means - we're acquiring MySQL AB, the company behind MySQL, the world's most popular open source database.

    You'll recall I wrote about a customer event a few weeks ago, at which some of the world's most

      [Read more...]
    How to avoid an extra index scan in MySQL
    +0 Vote Up -0Vote Down

    Is your MySQL server doing an extra index scan on queries that need to check a key for matches or NULL? It's easy for this to happen accidentally, but it's also easy to fix, especially in MySQL 5.0 and up. Here's how.

    Showing entries 1 to 16

    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.