Linux.com

Feature

db.* proves it's a database survivor

By Mary E. Tyler on July 08, 2005 (8:00:00 AM)

Share    Print    Comments   

The open source database db.* (pronounced D B star) has survived proprietary origins and the dot-com bust to find new life as an open source product.

db.* has been in the market for more than 20 years. Originally, it was a proprietary product called dbVista developed by a company called Raima. During the dot-com boom, it was acquired by a company called Centura and released into open source under a modified Mozilla license. Centura spent millions of dollars to bring the code base up to standards, including overhauling the documentation. However, in 2001, Centura dot-bombed and went belly up, leaving db.* orphaned. Unlike an orphaned proprietary product though, another company could -- and did -- step in.

"It's a shame to let this kind of investment and this kind of effort by top notch engineers go to waste," ITTIA's president Sasan Montaseri says. "We brought [db.*] back and introduced it to the market and we have been successful with that." In fact, ITTIA counts [international telecommunications giant] Marconi, JC Penney, Moody's Investors, and Ohio State University among its clients.

While db.* may be an interesting alternative, it's no market leader. According to Noel Yuhanna, senior analyst at Forrester Research, db.* remains a small player in a specialized niche. "db.* is not on our radar screen," says Yuhanna. "MySQL and PostgreSQL dominate the space. For the embedded market, open source databases SleepyCat and Berkley DB are more common."

But ITTIA's Montaseri claims db.* has some technology advantage over proprietary competitors that depend on languages like SQL to get information from the database. Most databases use a relational model, which relies on a set of indexes to get to the records. "Accessing those indexes takes its own time," says Montaseri. db.* uses a hybrid of a relational and a network model. Analyst Yuhanna confirms that with the hybrid model db.* uses, the designer can choose the indexes used, lessening resource-intensive I/O calls and resulting in a performance boost. However, since this approach forces db.* to abandon standards like the SQL language, it lessens the appeal of such a tactic.

Montaseri says another major advantage is db.*'s small size. "On [embedded systems], it's the footprint. You want to have the footprint as small as possible," explains Montaseri. "With other databases, because they use other APIs and other methods such as SQL the footprint is much higher."

"One of db.*'s benefits -- and one of its disadvantages -- is that it was developed for intelligent developers," Montaseri says. "There is a learning curve to become familiar with the code."

ITTIA also sometimes has to overcome significant resistance by customers because db.* is an open source product. "They sometimes feel [an open source product] is something free that nobody is standing behind," Montaseri says. The fact that ITTIA has been in business for five years, successfully implementing and supporting db.* with the largest of companies, helps give prospective customers some peace of mind.

One customer's story

An example of one such customer is Oshkosh, a manufacturer of heavy trucks (not related to Oshkosh B'Gosh the maker of childrens clothes). Recently ITTIA announced that Oshkosh selected db.* for the newest iteration of its A3 Heavy Expanded Mobility Tactical Truck (HEMTT) military vehicle. NewsForge attempted to get Oshkosh to speak about db.*, but the company declined, so we had to rely on ITTIA's account.

The A3 HEMTT is high-tech, compared to the average consumer's car. Electronics in the truck control the various subsystems and produce fault codes when errors occur. The database built into the truck's control module permanently stores the error codes and retrieves this information so that it may be displayed for the truck's operators on small color displays. The A3 HEMTT is currently used by the U.S. Army in Iraq and Afghanistan.

The A3 HEMTT uses ARM Linux, an embedded Linux OS for the ARM processor, so the database Oshkosh would use had to run on that platform. Due to the life-and-death nature of operations in combat zones, the selected database had to be reliable, robust, and fast, and be simple to use and maintain. Also, because of the nature of embedded solutions, the database needed to have a small footprint. Oshkosh was also concerned about cost, reliable technical support, and the availability of professional training from an established company.

After spending months testing various solutions, including proprietary databases like Polyhedra, Montaseri says Oshkosh decided it needed something faster, cheaper, and more robust than an off-the-shelf SQL database could provide. In the end, the company chose db.* -- and not just because of the zero license cost. "If I were to rank [Oshkosh's requirements]," says Montaseri, "The first thing was technology, the second thing was no licensing fee, and the third thing was service."

The power and complexity of db.* required Oshkosh engineers be given specific training. Oshkosh chose to do all of the training online. "We entertained them with an online training program, and provided consulting and technical support to make sure they were learning the product in a rapid fashion," says Montaseri. "We made sure they received technical support rapidly. Engineers cannot wait when they have questions."

Share    Print    Comments   

Comments

on db.* proves it's a database survivor

Note: Comments are owned by the poster. We are not responsible for their content.

Repeated repetiton

Posted by: Anonymous Coward on July 09, 2005 07:26 AM
"For the embedded market, open source databases SleepyCat and Berkley DB are more common."

In other words, SleepyCat's Berkeley DB has no competition?<nobr> <wbr></nobr>:)

#

Re:Repeated repetiton

Posted by: Anonymous Coward on July 11, 2005 01:09 AM
No, the article refers to Berkley DB, not Berkeley DB. Berkley DB doesn't exist, so it's APIs are more stable.

#

db4o opensource embedded database...

Posted by: Anonymous Coward on August 23, 2005 10:28 PM
is a good fit as mobile database for Java and<nobr> <wbr></nobr>.NET and a substitute for Berkeley DB JE <a href="http://www.db4o.com./" title="www.db4o.com">http://www.db4o.com./</a www.db4o.com>

#

Not Open Source

Posted by: Anonymous Coward on July 11, 2005 09:49 PM
From their <a href="http://www.ittia.com/dbstar/dbstar_license.html" title="ittia.com">License Page</a ittia.com>: "The Centura license is similar to the Mozilla license, allowing derivative works and combination with proprietary software. However, users are restricted to running the software on open-source operating systems. The license agreement defines open-source as..."

Yay. Let's try to force consumer decisions down their throats. Essentially, this means that db.* is not allowed to be run on Windows, older Solaris, HPUX, AIX, IRIX, or other commercial platforms. No great loss for me, since I use mostly FOSS OS'es, but don't you think the user should be able to make that decision?

If their intention is to promote FOSS OS'es, why not package their db.* library with some popular software using it on a LiveCD with other FOSS software? It's a hell of a lot nicer than saying, "If you don't play by my rules, you can use my toys!" The license obviously fails the OSI standards, and therefore should not be considered Open Source.

#

NC: s/can/cannot/

Posted by: Anonymous Coward on July 11, 2005 10:24 PM
s/can/cannot/

#

bad (definitely not open source by OSI standards)

Posted by: ammoQ on July 11, 2005 11:17 PM
This is exactly the kind of non-freedom that makes software unfree. You can probably copy it to a (say) AIX machine, compile it, run it - but you are not allowed to. BTW: the only company I know which used to use RaimaDB used HP/UX as their major OS. So, for them, this "open-sourcing" is pointless unless they want to replace their systems.

#

This story has been archived. Comments can no longer be posted.



 
Tableless layout Validate XHTML 1.0 Strict Validate CSS Powered by Xaraya