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

Displaying posts with tag: Data warehousing (reset)

Easter Eggs for MySQL and Kettle
+3 Vote Up -0Vote Down

To whom it may concern,
A MySQL stored function to calculate easter day
I uploaded a MySQL forge snippet for the f_easter() function. You can use this function in MySQL statements to calculate easter sunday for any given year:


mysql> select f_easter(year(now()));
+-----------------------+
| f_easter(year(now())) |
+-----------------------+
| 2010-04-04 |
+-----------------------+
1 row in set (0.00 sec)


Anonymous Gregorian algorithm
To implement it, I simply …











  [Read more...]
Calpont opens up: InfiniDB Open Source Analytical Database (based on MySQL)
+9 Vote Up -0Vote Down

Open source business intelligence and data warehousing are on the rise!

If you kept up with the MySQL Performance Blog, you might have noticed a number of posts comparing the open source analytical …

  [Read more...]
EU Should Protect MySQL-based Special Purpose Database Vendors
+2 Vote Up -0Vote Down

In my recent post on the EU antitrust regulators' probe into the Oracle Sun merger I did not mention an important class of stakeholders: the MySQL-based special purpose database startups. By these I mean:


  [Read more...]
Starring Sakila: MySQL university recording, slides and materials available onMySQLForge
+0 Vote Up -0Vote Down

Hi!

Yesterday I had the honour of presenting my mini-bi/datawarehousing tutorial "Starring Sakila" for MySQL University. I did a modified version of the presentation I did together with Matt Casters at the MySQL user's conference 2009. The structure of the presentation is still largely the same, although I condensed various bits, and I added practical examples of setting up the ETL process and creating a Pentaho Analysis View (OLAP pivot table) on top of a Mondrian Cube.

The slides, session recording, and materials such as SQL …



  [Read more...]
Loading a dimension table with SCD1 and SCD2 attributes
+0 Vote Up -0Vote Down

Jos, my co-author for the "Building Pentaho Solutions" book just pointed me to a recent article by Jeff Prenevost entitled "The Problem with History".AbstractJeff's topic, loading a hybrid Type 1 / Type 2 slowly changing dimension table is related to …

  [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 …






  [Read more...]
Writing a Book: Building Pentaho Solutions
+0 Vote Up -0Vote Down

Ok - this has been stewing for some time now, and I think now is the right time to announce that I am working together with Jos van Dongen from Tholis Consulting to create a book for Wiley with the tentative title "Building Pentaho Solutions".

My personal aim is to make this book the primary point of reference for DBAs and Application Developers that are familiar with Open Source products like MySQL and PostgreSQL but have no prior BI skills, as well as …

  [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 …



  [Read more...]
Showing entries 1 to 8

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.