MySQL Conference – Opening Keynote with Marton Mickos

It’s an early start this morning at 8:20am at MySQL Conference 2007 with CEO Mårten Mickos keynote talk Welcome and State of MySQL AB.

Here are some of the key points that impressed on me.

**“The Participatory & Disruptive spirit of the Dolphin.”**.

Open Source disrupts inefficient models and produces new wealth.

Architecture of Participation.

  • GPL and FOSS licenses
  • Google
  • del.ico.us

MySQL Architecture of Participation
You have the forge, the planet, community contributer program and many more.

Production of Amateurs

  • You Tube
  • Second Life
  • Wikipedia

Some really great Quotes:

“Fail often to succeed soon.” IDEO company slogan

“Noah’s Ark was built by amateurs, but the Titanic by professionals.”

Innovation Happens Here

MySQL Monitoring & Advisory Service

In his presentation of MySQL Network Enterprise Dashboard, If you were quick you would have noticed the MySQL Version 6.0.0-alpha-pb518.log

Leading Applications

  • Open Source ISVs
  • Web
  • Web 2.0
  • On-Demand
  • Hosting
  • Telco & VOIP
  • Security
  • Enterptise 2.0
  • Hub & Spoke

We want to be known as The Online Database.

Drawn to the Lamp

  • Microsoft
  • Oracle
  • IBM
  • Sun
  • HP
  • Dell
  • Unisys

They all have an Open Source strategy, the develop open source products, they use and partner with MySQL.

He also mentioned MySQL Enterprise Connection Alliance – MECA.

Global Distributed Organization

  • 70% work from home
  • 100 major locations in nearly 30 different countries.
  • There is a great focus on culture – global culture.

Disruptive Businesses

  • A smarter way to produce the goods

  • A smarter way to distribute them

  • Serve the underserved

  • Keep it simple

  • Innovate with technology to give customers more convenience

  • Make money

  • Gartner: 66% of enterprises are deploying MySQL or planning to

  • 750,000 newsletter subscribers

  • MySQL installed in over 11 million installations

Going Forward

  • Scalability
  • Availability
  • Manageability
MySQL – The best online database in the world.
Tagged with: Databases General MySQL MySQL Conference &Amp; Expo 2007

Producing IQR and Outlier statistics with SQL

The interquartile range (IQR) measures the spread of the middle 50% of a distribution — the distance between the first quartile (Q1) and the third quartile (Q3). Combined with Tukey’s 1.

Producing Mode statistics with SQL

The mode is the value or values that appear most frequently in a dataset. Unlike the mean or median, it applies naturally to categorical and ordinal data — star ratings, product codes, survey responses — and reveals what is most common, not what is average.

Extending MySQL Capabilies with UDFs, Plugins and Components - Part 2

MySQL offers three different approaches to extending the SQL capabilities with the default product you download and install. These are: User Defined Function (UDF) MySQL Manual MySQL Plugin MySQL Manual MySQL Component MySQL Manual In my prior post I provided a new uuidv function that accepted a numeric argument to return a string of the version of UUID specified.