Sony Online opts for open-source database over Oracle

The switch to open-source EnterpriseDB is eased by compatibility with Oracle

Sony Online Entertainment Inc. is starting to move away from the Oracle databases that are the foundation of its online games, opting instead for a 2-year-old commercial open-source database based on PostgreSQL.

San Diego-based Sony Online offers a number of popular Massively Multiplayer Online Role-Playing Games, or MMORPGs, including EverQuest, EverQuest 2, Star Wars Galaxies and others.

They have "hundreds of thousands" of subscribers, said Rick Herman, vice president of business and legal affairs at Sony Online Entertainment.

The databases store terabytes of data about the "worlds" in which game characters live, battle and fall in love.

"If you took a virtual character in EverQuest and had him start running in one direction, it would take 30 days before he would reach the end of the world," Herman said.

The games also store data on players’ characters. In Star Wars Galaxies, for instance, every object -- be it lightsaber, X-Wing fighter or blaster gun -- can be heavily customized by its owner. That means the database must store each object in the game individually, rather than storing one version that it provides to every player.

Sony Online now operates more than 150 Oracle 9i databases around the world.

But by midyear, Sony Online expects to have three services moved to EnterpriseDB’s Advanced Server 8.1 database, according to Chris Yates, the company’s vice president of technology.

One will be Sony’s Station Exchange service, which creates an eBay-like marketplace for players of EverQuest and EverQuest 2 to buy and sell online goods such as swords, potions and spells.

The service, which debuted last year, is still small; there were fewer than 1,000 items up for auction at the end of last week, according to Sony. Even so, buyers pay as much as $2,000 for digital items.

Sony also plans to move one of its smaller games, Matrix Online, which it bought last summer, to EnterpriseDB. It also plans to move a message board over to EnterpriseDB.

Yates had been looking for an alternative to Oracle for a year. "We think it’s a great product, but it’s so expensive," he said. "We use a lot of Oracle’s advanced features: clusters, materialized views, high transactions. We knew that our alternative needed to be a real database."

Oracle’s free Express edition was "not a lot of use," said Yates, who also looked at open-source databases such as MySQL and PostgreSQL. He liked the latter’s "richness" and its lower price tag. But Yates balked at the costs and hassle of retraining his staff and rewriting the database applications to run on PostgreSQL.

EnterpriseDB, on the other hand, is based on PostgreSQL but offers Oracle compatibility. That helped Yates overcome his concerns.

"Close to 80% to 90% of our applications don’t need to be rewritten to use with EnterpriseDB," said David Manifold, director of database services at Sony Online.

Because of the similarity of EnterpriseDB, training has been minimal so far: three days of classes for the Oracle database administrators and developers. "Most of them have found it to be fairly intuitive," Yates said.

Savings are "hard to quantify at this point in time," he noted. "We need to prove it out in production first." Although Sony Online will continue to use Oracle, it will slowly migrate other databases onto EnterpriseDB.

Oracle officials declined to comment about Sony's decision.

Although open-source still gives IT executives "heartburn," it has evolved a lot in recent years, Herman said. "If you'd told me five years ago we'd be looking at open source I'd have said you were insane," he said.

In a related move, Sony also became a minority shareholder in EnterpriseDB, which was founded in 2004. Sony joined in a $7.5 million round of financing, along with venture capital firms Charles River Ventures and Valhalla Partners and some of EnterpriseDB’s original angel investors.

Andy Astor, CEO of Iselin, N.J.-based EnterpriseDB, said Sony’s investment was less than $1.5 million.

James Niccolai, of the IDG News Service, contributed to this report.

Copyright © 2006 IDG Communications, Inc.

7 inconvenient truths about the hybrid work trend
Shop Tech Products at Amazon