Embedded Databases Reveal Gems - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

01:26 PM

Embedded Databases Reveal Gems

Built-in databases are easy to use, cost-effective, and require little or no administration

Boating supplies retailer West Marine Inc. deployed a new point-of-sale system throughout its 250 stores in July. Buried in the software running on each store's server, and invisible to employees, is an embedded database handling a variety of pricing and inventory-management chores. Why an embedded database? "Total cost of ownership. And we don't have a database administrator in every store," says Wayne Freeman, retail systems applications manager.

The term "embedded database" covers a broad range of implementations. Some are built into devices ranging from industrial controllers and cable-television set-top boxes to medical-imaging systems and the flight controls of the Boeing 777. Others are used in the rapidly growing number of mobile phones, PDAs, and other portable consumer devices that rely on built-in databases as small as 50 Kbytes. Still others are used by corporate developers and independent software vendors, who build them into applications, making the databases invisible to users.

Embedded databases are particularly prevalent in accounting software, retail applications such as West Marine's, and applications for the health-care industry.

PixelPoint Technologies Inc., for example, develops point-of-sale applications for restaurants that have Sybase Inc.'s SQL Anywhere database built into them.

Wayne Freeman

West Marine chose an embedded system to meet performance, Freeman says.
The database has to be reliable and easy to use, because PixelPoint's resellers sell cash registers, not complex applications, CEO Lino D'Angicco says. "If we had to tell our resellers that they have to have a database administrator on-site, well, that's cost-prohibitive," he says. PixelPoint's software is designed to be self-configuring.

The automated, self-configuring capabilities in Pervasive Software Inc.'s database software is a key reason West Marine used it to replace the database that came with the Win/DSS point-of-sale system from JDA Software Group Inc. that runs the retailer's 1,400 cash registers and workstations. Also key was scalability: The system tracks the stores' 160,000 inventory items and 500,000 price records. "We desperately needed performance," Freeman says.

Despite their obvious benefit and almost ubiquitous nature, sales of database software for embedded applications have slumped badly during the recession--people aren't buying as many refrigerators, vending machines, industrial controllers, networking devices, airplanes, and medical-imaging systems, and so they're not buying as many embedded databases.

Sales of the software dropped from $416.9 million in 2000 to $349.7 million last year and are expected to sink further to $314.1 million this year, according to market researcher Gartner Dataquest. Sales are expected to stay flat next year before starting to grow again in 2004.

What's more, large packaged applications with embedded databases seem to be losing some of their popularity, while vertical-market and workgroup applications with embedded databases are becoming more prevalent, Aberdeen Group analyst Wayne Kernochan says.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
1 of 3
Comment  | 
Print  | 
More Insights
2018 State of the Cloud
2018 State of the Cloud
Cloud adoption is growing, but how are organizations taking advantage of it? Interop ITX and InformationWeek surveyed technology decision-makers to find out, read this report to discover what they had to say!
9 Steps Toward Ethical AI
Cynthia Harvey, Freelance Journalist, InformationWeek,  5/15/2019
How to Assess Digital Transformation Efforts
Lisa Morgan, Freelance Writer,  5/14/2019
Is AutoML the Answer to the Data Science Skills Shortage?
Guest Commentary, Guest Commentary,  5/10/2019
Register for InformationWeek Newsletters
Current Issue
A New World of IT Management in 2019
This IT Trend Report highlights how several years of developments in technology and business strategies have led to a subsequent wave of changes in the role of an IT organization, how CIOs and other IT leaders approach management, in addition to the jobs of many IT professionals up and down the org chart.
White Papers
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Sponsored Video
Flash Poll