sheeri's blog

Real Time Data Warehousing Presentation

At the March Boston MySQL User Group meeting, Jacob Nikom of MIT's Lincoln Laboratory presented "Optimizing Concurrent Storage and Retrieval Operations for Real-Time Surveillance Applications." In the middle of the talk, Jacob said he sometimes calls what he did in this application as "real-time data warehousing", which was so accurate I decided to give that title to this blog post.

The slides can be downloaded in PDF format (1.3 Mb) at http://www.technocation.org/files/doc/Concurrent_database_performance_02.pdf.

Video: Partitioning in MySQL 5.1

At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning.

The slides are available at http://www.technocation.org/files/doc/2009_01_Partitioning.pdf. The video is embedded at the bottom of this post, and is also available at youtube at http://www.youtube.com/watch?v=zvN9XI-FraI.

New in MySQL 5.1: The Presentation

What's new, in a nutshell: http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html.

Release notes: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html (In the video, it's the page entitled "Changes in release 5.1.x").

And yes, very early on (at about 2 minutes in) I talk about my take on Monty's controversial post at http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html

OpenSQLCamp Video: How SQL Database Engines Work

Dr. Richard Hipp, creator of SQLite, presents "How SQL Database Engines Work" at OpenSQLCamp 2008.

The description:
To many programmers, SQL RDBMSes are a magical black box. A talk can help clear up a lot of the mystery. SQL users tend to make better use of the language once they have a rough idea of what is going on beneath the covers.

http://www.yo

Moving Application Logic Into the Database by Bruce Momjian

Bruce Momjian talks about general strategies for moving application logic into databases, mostly why to do it and why to not do it. This talk is mostly DB agnostic. Note that the slides have a title of "Processing Data Inside PostgreSQL". The slides can be found at http://www.slideshare.net/EnterpriseDB/data-processing-inside-postgresql.

How to Stop Hating MySQL

At LISA 2008, I gave a presentation entitled "How to Stop Hating MySQL: Fixing Common Mistakes and Myths".

The presentation slides can be downloaded as a PDF at:

http://technocation.org/files/doc/stophatingmysql.pdf

View the video online at http://www.youtube.com/watch?v=DylLYQlzuKo (or watch it at the bottom of this page).

Here are some notes and links I referred to:

Technocation, Inc containing free videos, a MySQL podcast (currently on hiatus) and blog posts about MySQL.

OSCon 2008 Video: Open Voices (Legal Panel)

"Open Voices" was a legal panel consisting of Jim Zemlin of The Linux Foundation, Keith Bergelt of the Open Invention Network, Karen Sandler of the Software Freedom Law Center and Phil Robb of Hewlett Packard (FOSS Bazaar project).

OSCon 2008 Video: history.forward()

history.forward()
Sam Ramji, Senior Director of Platform Strategy at Microsoft presents a keynote entitled "history.forward()". From the official conference description:

Over the past ten years, open source has fundamentally changed the way developers learn, communicate and code together. Over the past three years, Microsoft has made significant strides towards more fully participating in open source communities. This talk will discuss community participation and new ways in which Microsoft is architecting to contribute over the next ten years of open source development.

OSCon 2008 Video: State of ... Lightning Talks

"The State of" Lightning talks, moderated by Josh Berkus, is always a great highlight.
OSCon 2008's speakers and projects included:

  • Alan Kasindorf: Memcached
  • Glynn Foster: OpenSolaris
  • OSI: Danese Cooper
  • MySQL: Monty Widenius
  • PostgreSQL: Bruce Momjian
  • GNOME: Dave Neary
  • Gentoo: Donnie Berkholz
  • OpenOffice.org: Louis Suarez-Potts
  • Jabber: Peter Saint-Andre
  • Mozdev: Brian King
  • OpenID: Scott Kveton
  • Open Scrum: James Dixon
  • Talking Book Project: Cliff Schmidt

OSCon 2008 Video: Cloud Computing with Persistent Data

Jean-Paul Bauer of KnowledgeTree presents "Cloud Computing with Persistent Data: Pushing the Envelope of Amazon Web Services" at OSCon 2008. From the official conference description:

KnowledgeTreeLive is a novel SaaS document management application built using the Amazon’s Elastic Compute Cloud, Amazon’s Simple Storage Service and rPath’s Virtual Appliance technologies. KnowledgeTreeLive leverages the popular open source KnowledgeTree application. The combination of cloud computing, virtual appliances, and other open source technologies allowed for the speedy implementation of the on-demand offering, without requiring significant changes to the KnowledgeTree architecture and in a very cost and resource effective manner.

Pages