Channels ▼
RSS

Database

Q&A: Open Database



Michael "Monty" Widenius was the creator of the MySQL database, and founder of Monty Program Ab. He recently spoke with Dr. Dobb's Jonathan Erickson

Dr. Dobb's: What's the Open Database Alliance?

Widenius: The Open Database Alliance is a vendor neutral consortium of vendors and individuals commercially supporting or delivering services around MariaDB and MySQL. Open Database Alliance partners will support each other's open source initiatives, and resell each other's services. This makes it possible for customers to get all services they require around their database issues through any vendor in the Alliance.

Dr. Dobb's: What's MariaDB?

Widenius: It's a community developed branch of MySQL with bug fixes and new features developed by the MariaDB community, of which Monty Program Ab is an active member. We will keep MariaDB in sync with MySQL development to ensure all bug fixes and features in MySQL also exists in MariaDB. At this time MariaDB 5.1 should be notable faster, have more features and have fewer bugs than the corresponding MySQL 5.1 release.

Dr. Dobb's: Is SQL adequate for 21st century computing?

Widenius: Yes. SQL will be around for a long time because it's a very expressive language that is very easy to embed in web-based applications. As long as people are developing web pages with programming languages like PHP, Perl, Ruby, and Java, SQL will have it's place.

Dr. Dobb's: What will the biggest change in data storage in five years?

Widenius: SSD (solid-state drive) memory will force a paradigm shift in how data is stored and accessed and a lot of old proven database algorithms have to be changed because there is no seek time anymore.

Dr. Dobb's: What's the most exciting development in DBMS technology today?

Widenius: On the software side, the usage of Memcached and Gearman to do inexpensive "cloud like" computing is of course interesting. We are also seeing dedicated inexpensive machines that provides Memcached interfaces which will notable speed up and simplify any setup that uses Memcached (which is a standard component for most busy web sites).

Dr. Dobb's: Will operating systems ultimately be successful in converting their filesystems into SQL-managed organizations of data?

Widenius: I think that is a stupid idea. Most data people store is not suitable really suitable for SQL. SQL will only notable slow things down when accessing things and will create a lot more fragmentation compared to modern file systems without providing anything really critical for the end user. Another problem is that SQL managed data is very bad of application that wants to have their own access to the part of the data (like another database server running on a SQL managed filesystem).


Related Reading


More Insights






Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

 
Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.
 

Video