Free Newsletters
InfoWorld Daily

InfoWorld
Log-in | Register

XQuery takes center stage in eXist database

Maturing open source database proves excellent handler of XML content

By Rick Grehan
May 23, 2005
 

eXist is an open source XML database that has matured into an impressive XML content search and storage system. In eXist, unlike in Apache Xindice or Berkeley DB XML, XQuery plays a central role, but eXist is not quite as scalable as these databases. Nevertheless, its easy installation, slick documentation, and comprehensive API set make eXist an excellent choice for anyone who wants to get a powerful XML database up and running quickly.

Free IT resource

Open Source Business Conference (OSBC) May 22-23, 2007

Sponsored by OSBC

Free IT resource

Virtualization Insights from Top Experts - Learn how virtualization gets real!

Sponsored by Dell



eXist 1.0

eXist Project, sourceforge.net

Excellent  8.9
criteria score weight
Interoperability 9 20%
Performance 8 20%
Scalability 8 20%
Setup 10 20%
Documentation 10 10%
Value 9 10%

Cost:
Free

Platforms:
Systems with J2EE-compatible servlet container

Bottom Line:
Getting to know eXist is pure pleasure. If you want a smooth introduction to the power of XQuery and XML content management, this is the XML database for you.

About our Reviews and Scoring Methodology

A pure Java application, eXist is available as a JAR or WAR (Web Application Archive) file. I recommend the JAR file installer, because it sets everything up (including the Jetty servlet container and eXist source) with a single command line.

After the eXist database engine is started, you begin by navigating your browser to its HTML interface. You’ll swear you’ve been forwarded to the eXist home page, but it’s actually a kind of “live documentation” eXist hosts through its Web server. Very nice. For example, one tutorial automatically downloads and installs external documents at the click of a button, then demonstrates XQuery queries on the installed documents. The tutorial even provides a text box in which you enter and test your own queries, a feature I found so handy that I’ve begun using it to experiment with XQuery.

eXist also installs an administration application. The application’s upper pane displays a list of current resources (collections and documents), and the lower pane is a scrolling text window into a command-line shell. In the upper screen you select a resource and view or modify the access permissions granted to users of that resource. In the command-line shell you execute various commands for modifying collection contents (such as adding or removing documents).

Earlier versions of eXist used a relational database back end, but the current version is a native XML database optimized to handle XML. Queries are accelerated with the help of indexes that eXist invisibly creates for its important internal components. The system builds B+tree indexes for elements and words, and it creates indexes for collections (for mapping collection paths to collection objects) and DOM objects (for rapid location of a document’s nodes).

eXist provides quite an array of mechanisms for manipulating the database. The REST (Representational State Transfer)-style interface allows you to access data through simple HTTP requests. You can also perform more elaborate operations with POST requests, which expect an XUpdate document or a query request as an XML fragment in the content of the request.

Programming access is available through the XML:DB Java API, to which eXist adds three extra services. The UserManagementService allows you to manage users and permissions; DatabaseInstanceManager allows you to shut down the database; and IndexQueryService provides access to eXist’s automatically created indexes.

Of course, the most convenient interface into XML data is via eXist’s WebDAV support. Collections show up as folders, documents as documents, and you can create, add, and remove content with drag-and-click ease.

What really opened my eyes is that eXist proves that XQuery -- to which eXist adds several powerful extensions -- is not just for querying. It’s a full-blown functional language powerful enough to drive entire Web sites.

eXist’s next release, expected this summer, will add a sort of XQuery equivalent of stored procedures, so you’ll be able to store and execute XQuery code directly in the database. The next release will also include new index types for improved queries.

eXist is a worthwhile study in the power of XQuery, with excellent tutorials and documentation. It’s an open source gem.





 


 
Rick Grehan is a contributing editor at InfoWorld. Contact him at rick_grehan@infoworld.com.
 

TOP NEWS:


»  Four quick tips for choosing an IM security product
71 percent of businesses will invest in real-time messaging this year. If you're one of them, be sure to protect your enterprise

»  Forrester analysts ID hot IT jobs
Research group finds 16 IT roles with a promising future

»  Nvidia claims 10 hours of HD video on Tegra chip
The Tegra 600 and 650 can be used with hard disk drives and are designed partly for mobile Internet devices

»  Database vendors add Google's MapReduce
Greenplum and Aster Data Systems will support Google's programming technique, developed for parallel processing of large data sets across commodity hardware

»  Network management: Tips for managing costs
New technologies, changing requirements, and ongoing equipment maintenance and upgrades cost money, but there are ways to manage expenses

»  EMC targets SMBs, branch offices with new low-end storage
Celerra NX4 highlights include thin provisioning, snapshot technology for data recovery and backups, and Web-based console for management of storage volumes




FIVE WAYS TO REDUCE IT COSTS IN 2009
The demands on IT have never been greater, particularly in light of lower revenue and uncertain demand for the goods and services. There are many ways that IT can help organizations adjust to this new economic environment. Learn about five key technology trends that can immediately impact your organization's bottom line, and how to build a strategy to implement these technologies within your current budget. Sponsored by: Riverbed

»  Click here to view this Webcast
  Enterprise Data Security Solutions Guide
Data security used to be about outside threats. These days the biggest challenge for data-driven organizations is the management of secure information from the inside out. Data is available on laptops, your network and even USB devices, but not always secure. Read this Solutions Guide to learn the best ways to keep it safe. Sponsored by ISC2

»  Click here to download now

- Special Advertising Partners -
WHITE PAPERS
 

» Technology White Papers Library

Technology White Papers by Topic

Technology White Papers E-mail Alert

Find out when the latest white paper is available:
 
 
INFOWORLD MARKETPLACE
 
» BUY A LINK NOW
 

FIND PRODUCTS AND COMPANIES
» COMPLETE PRODUCT GUIDE



TECHNOLOGY INDEX
• Applications
• Application Development
• Security
• Networking
• Wireless
• Platforms
• Hardware
• Data Management
• Storage
• Web Services
• Business
• Telecom
• Professional Services
• Standards

TECH WATCH 


What's the 411 on GOOG-411?
Just as Google has become synonymous with "performing a Web search," 411 is understood to mean "information" -- as in "what's the 411?" I was thus surprised to discover, from a billboard, no less, that the king of search is taking on the ...

Apple HTML source reveals 'iPhone Extreme'
"This one's a stretch..." reports AppleInsider. Um, yeah. Reporting on HTML code sightings of product names could be called a stretch, but iPhone Extreme has a ring to it. Now, that sounds like the product Apple should have released first, rather ...

COLUMNISTS

Unified under law
Ephraim Schwartz's Column and Blog (InfoWorld) - In the litigious world we live in, deploying a unified communications platform in your enterprise could...
» MORE COLUMNISTS

MORE INFOWORLD BLOGS


Open Sources 
Product Management
When I joined MySQL four years ago, there was quite a lot of debate about product management. We didn't actually have ...

Zero Day 
Botnet herders tending smaller flocks
New research backs up the theory that botnet operators are keeping their networks smaller in a continued effort to keep ...



• Advice Line
• Database Underground
• The Deep End
• Enterprise Mac
• Geeks in Paradise
• Grid Meter
• The Gripe Line
• InfoWorld Daily
• Inside IT
• IT Troubleshooter
• ITXtreme
• Open Sources
• ProdBlog
• Real World SOA
• Reality Check
• Security Adviser
• SMB IT
• The Storage Network
• Tech Watch
• Virtualization Report
• Zero Day

ADVERTISEMENT


RESOURCE CENTERadvertisement 

GOVERNMENT IT & POLICY
'If you don't go after the network, you're never going to stop these guys. Never.'
From the State Department, All the News for Inquiring Minds
TechPresident, the Internet Citizenry's New Consensus Taker



Sponsored Technology Links

 
 
 HOME  NEWS  BLOGS  PODCASTS  VIDEOS  TECHNOLOGIES  TEST CENTER  EVENTS   About | Advertise | Awards | RSS | Contact Us 

Copyright © 2008, Reprints, Permissions, Licensing, IDG Network, Privacy Policy, Terms of Service.
All Rights reserved. InfoWorld is a leading publisher of technology information and product reviews on topics including viruses,
phishing, worms, firewalls, security, servers, storage, networking, wireless, databases, and web services.

CIO :: ComputerWorld :: CSO :: Demo :: GamePro :: Games.net :: IDG Connect :: IDG World Expo
Industry Standard :: IT World :: JavaWorld :: LinuxWorld :: MacUser :: Macworld :: Network World :: PC World :: Playlist
TecChannel :: TecCommunity