MySQL AB took the wraps off the latest version of its database server
Monday, a product that now offers enterprise-grade capabilities such as
stored procedures to the open-source software.
Stored procedures are Structured Query Language (SQL)
statements that are compiled in the database so that they can be
across multiple applications.
Such features, which cater to complex enterprise resource planning
effectively enable MySQL to compete with Microsoft’s SQL Server, IBM’s
and Oracle’s Database products.
MySQL CEO Marten Mickos said stored procedures allow administrators to
some of the application logic over to the database server. The database
run the procedure on its own, reducing network traffic in enterprise
environments where speed and efficiency are paramount.
“There is no need to go to the client all of the time,” Mickos told
internetnews.com. “You can split the application logic on two
locations. There are some instances where you might need that and some
you don’t but we’re offering users that choice.”
MySQL has a penchant for making sure its database server versions are
“battle tested,” or floating in testing phases for months before
production-ready releases are rolled out to ensure a quality and
level Mickos equates to that of a car.
To wit, MySQL 5.0, which also includes improved portability and
is in the initial development, or “alpha” phase, which means developers
still add features to the current code. Subsequent beta and
gamma tests precede the final production release.
Mickos said one of the key goals of MySQL development is making sure
features don’t comprise database speed or performance because one of
things both opens-source users and business users like about the
that it “so simple and so fast.”
MySQL, the most popular open-source database with more than 4 million
installations, both complements and competes on some levels with
IBM, and Oracle, but it is often used in small businesses or
large enterprises where modest application data storage and retrieval
One of the reasons why many industry analysts find the Sweden-based
company intriguing is its dual licensing business model. This makes
software available free under the GPL license, while users may pay for
under a commercial license, which includes services.
Such flexibility is a breath of fresh air in the software world, which
often segregated into two camps: open-source or proprietary. Those
typified by the open Linux and Microsoft Windows operating systems.
A recent survey completed by Evans Data found that found that MySQL is
gaining traction. Microsoft SQL Server and Access usage has grown by
percent while MySQL usage has grown more than 30 percent in the last
according to the market researcher.
Another recent study conducted by software inspection concern Reasoning
found that MySQL code quality was six times better than that of
MySQL 5.0 alpha can be downloaded at the MySQL Web site.