Open-Source Database Technologies Flourish at LinuxWorld

By Lisa Vaas  |  Posted 2005-08-11

Open-Source Database Technologies Flourish at LinuxWorld

Microsoft can snipe all it wants at the TCO and security of open source, but a flood of database-, BI- and data-center-related news coming out of LinuxWorld means one thing: Linux has drilled so far down into overall IT frameworks that its simply another option on the short list.

Commercialization of open source is one trend evident at LinuxWorld Conference & Expo, and its being reflected big-time in database-centric offerings.

"Were seeing the notion that open-source products have a very, very viable business model and have established themselves as credible players," said Steve OGrady, an analyst at RedMonk.

"While they dont play in exactly the same markets and dont compete feature-to-feature with proprietary [solutions], theres a sizable market thats not interested in all the bells and whistles included with proprietary vendors."

Acceptance of the commercial open-source model is more evident than ever. The database is, and will always be, a critical component of the application stack, OGrady said. And as LinuxWorld shows, options for that stack are viable and vibrant.

MySQL AB had two whoppers this week. First, Dell Inc.s announcement on Monday that it would resell MySQLs open-source database, along with the other components of the LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack, is both an indication of the widening spread of the stack and of this enormously popular database.

Dell is shipping the LAMP stack with the PowerEdge 830 and PowerEdge 850 servers, both Intel chip-based servers.

OGrady said that such a big-volume play means that MySQL is going to get a crack at entering enterprises up and down the scale.

"Dell sells to folks up and down the stack, but there are a lot of businesses buying Dell on the price," he said. "Theyre buying cheap boxes because thats a smart use of their money."

MySQLs second big reseller score came with the announcement on Tuesday that Novell Inc. will offer subscriptions to the MySQL Network, a subscription offering that includes MySQL software; updates and upgrades; alerts and advisers; MySQLs online knowledgebase; and full, production-level technical support.

The companies say that this is the only accord of its kind between a Linux vendor and MySQL. Of course, many MySQL users already run on SuSE Linux.

But gaining access to Novells customer base, which numbers more than 50,000 users in 43 countries, is a giant leap for this small database company.

The broadening of what was already a close relationship between the two companies will only stand to drive open-source databases deeper into the enterprise, across a much larger spectrum of organizations.

Partnering with these two tech giants means that MySQL will be able to reach into accounts it might not have accessed on its own.

The reseller agreements will enable the database—and, potentially, the company that sells services around it—to push past alternatives.

And such alternatives are many: Microsoft Corp.s SQL Server is a viable database candidate in the SMB (small to midsize business) space, as is the companys ever-popular Access database.

A step up the ladder, companies with a few hundred or even thousand employees run things a little differently: They tend to get their stacks from local systems integrators that then manage the stacks.

On that level, open-source databases such as MySQL could be coming up against commercial databases that include the big three: IBMs DB2, SQL Server or Oracle.

Will Dell reselling be the final push to make an open-source database chomp at the heels of the database titans?

Stacey Quandt, an analyst with Quandt Analytics, said that such growing market opportunities for open-source solutions are "inevitable" and will put pressure on the proprietary vendors, but were still only talking about competition at the bottom rungs.

"The database-, BI- and data-center-specific offerings are interesting because they give users more choice and broaden the support for Linux," she said. "The challenge for established vendors is that as open-source alternatives gain maturity, this will place pressure from below on the likes of SAS, Cognos, Oracle and DB2."

MySQL has, indeed, appealed at the lower end, for use in running lightweight applications.

MySQL AB has long positioned its database as being a commodity—something you can plug in to do routine tasks, where the full-featured relational databases would be overkill.

But open-source databases as a whole have a lot more to offer than merely catering to that humble niche, as startup EnterpriseDB Corp. is eager to point out.

On Tuesday EnterpriseDB launched the final version of its flagship EnterpriseDB 2005 database, released in beta this spring.

The PostgreSQL-based database, which the company seeks to position as the enterprise-class database of choice, supports high-volume applications and update-intensive situations. It delivers Oracle compatibility and performance enhancements over its open-source base, PostgreSQL.

What does Oracle compatibility mean? Unlike MySQL, this open-source database purveyor seeks to do no less than unseat Oracle, the King Kong of databases in terms of features, functionality and cost.

Indeed, these are heady times when it comes to the increasingly rich ecosystem of both open-source enterprise applications and new Linux versions of enterprise applications.

Business Objects S.A., for one, on Tuesday released a Linux version of its XI platform, including both BusinessObjects XI and its Crystal Reports Server XI.

Already available for Windows and Unix, the XI platform combines query, reporting and analysis technology from Crystal Decisions Crystal Reporting, Crystal Enterprise and Crystal Analysis products with several pieces of Business Objects BI technology.

The XI products now will support Novells SuSE Linux Enterprise and Red Hat Inc.s Enterprise Linux—a decision Business Objects management says will help to drive adoption of Linux.

The support for Linux will be welcomed by Business Objects customers who are moving to that operating system. But what about those customers seeking open-source alternatives to their pricey enterprise applications?

James Thomas, director of product marketing for Business Objects, said that open-source alternatives are "on the radar" for some BI customers. Still, he said, enterprises are looking to big proprietary players for software, training, services, support and domain expertise.

"Having a good product is one thing," he said. "Being a provider of BI is quite another. Thats why customers continue to invest in top-tier vendors.

Next Page: Theres more XML in the future for open-source databases.

Theres More XML in

the Future for Open-Source Databases"> "Thats why you see open source do quite well in areas like application servers and Web servers, all on the infrastructure side. But you see few BI, CRM [customer relationship management] or ERP [enterprise resource management] open source," he said.

Some would like to change that. Thus, in the run-up to LinuxWorld, at last weeks OSCON confab, we saw the release of Bizgres Clickstream, which is what a trio of companies call the first complete open-source BI development stack.

Its built on top of Bizgres, a community-supported project whose aim is to make PostgreSQL the industrys platform of choice when it comes to BI.

Another top BI vendor, Siebel Systems, also announced it will run its applications on top of Linux, as well.

Siebel Systems and Novell have announced they have extended their partnership to provide support for Siebel business applications on Novells SuSE Linux Enterprise Server 9.

For its part, Emic Networks will announce on Tuesday that it is hooking up with Multrix, an application service provider, to make high-availability options available to users of its open-source application clustering technologies.

Dan Kusnetzky, an analyst at IDC, said that Emics news, along with other database-centric news, shows that IDC was spot-on when it said back in 1997 that Linux would be considered a mainstream choice and would be on peoples short list by 2005. In fact, IDC wasnt quite optimistic enough, as it got on that short list in a major way by 2004, Kusnetzky said.

"The things I hear revolve around enterprise support, providing the right application development, and supporting the integrity and security of storage on the Linux environment to bring it on a par with Windows," he said.

"Virtualization of all types is under discussion: Virtualization processing systems, storage, provision and management, and security—theres a lot of activity there."

In other words, the open-source platform is being put into service running critical enterprise applications, he said.

What it all boils down to, Kusnetzky said, is that Linux continues to evolve as a platform, following largely the same evolutionary course as Unix did some 20 years ago. Its being considered by for the same kinds of applications by the same kind of people, he said.

Whats on the horizon for databases and open source?

OGrady sees the start of people questioning the relational models aptness for particular jobs—a mirror of the same trend in proprietary database development, as witnessed by the adoption of increasingly sophisticated means of handling XML in proprietary databases.

Granted, open source already has Sleepycat for a nonrelational database, but OGrady said that he foresees yet more announcements of this ilk.

"Theres an increasing recognition in the open-source world that other nonrelational models are called for," he said. "Especially with Web formats dealing with RSS [Really Simple Syndication] or Atom. Whats the point of cramming those into relational databases on the back end when we have it in semistructured format to begin with? Folks are now cramming it into MySQL, or theyre doing the reverse: Theyre generating RSS or Atom out of MySQL."

Not having to do the mapping necessary to get such information into a relational database would be welcome by many, OGrady said.

The release of the object-oriented open-source database DB4Objects at LinuxWorld East was an early indication of what we may see coming from open-source database vendors in the future.

And at this weeks show, Gupta Technologies LLC put some XML icing on the open-source cake.

Gupta is a software development and data management tool vendor. On Monday, it announced that Team Developer 2005.1, publicly available later this month, will ship with new OOP-to-XML interfaces.

Tema Developer is a cross-platform development tool that allows developers to write and deploy rich business applications on Windows and Linux with full source-code compatibility.

Gupta also enhanced Linux database support for MySQL and other open-source databases, and the update includes major enhancements to Report Builder, Guptas reporting solution.

Editors Note: This story was updated to include news about Novell reselling MySQL, Business Objects releasing XI on Linux and EnterpriseDB releasing the final version of its EnterpriseDB 2005 database. It was also updated to correct the name of Stephen OGradys employer.

Check out eWEEK.coms for the latest database news, reviews and analysis.

Rocket Fuel