Solution Builder - Channel Insider
Empowering the next generation Channel
 

Sponsored Links
  • Get up and running in as quickly as 30 days with BI. Learn how today.
  • FREE Securing Smartphones & Tablets for Dummies Book from Sophos
  • 5 New Technologies That Will Change Enterprise ITAdvertisement
  • Build an IT Infrastructure That Delivers the Future

  •  

    Primer: XQuery 1.0

    in Solution Builder



    Article Rating:starstarstarstarstar / 0
    Article Views: 2470

    XQuery 1.0 is a language that allows users to search for and extract information from databases and documents. Here's how it works and who is using it.

    Rate This Article:
    Add This Article To:
    What is it?
    A language that allows users to search for and extract information from databases as well as documents in which content is identified by tags based on the Internet's eXtensible Markup Language (XML).

    What does it do?
    XQuery makes it possible to pull data from multiple sources and merge it on screen at one time. That means data that reside in such relational databases as Oracle, IBM DB/2, Microsoft SQL or Sybase, or data from XML databases and documents can be combined instantly and used in a wide variety of Web-based applications—for example, supply chain management or corporate compliance systems.

    Where did it come from?
    XQuery 1.0 is a draft specification from the World Wide Web Consortium. Its predecessor, Quilt, was first defined in March 2000 by Don Chamberlin of IBM's Almaden Research Center, Daniela Florescu of France's INRIA research institute and Jonathan Robie, then at Software AG. As its original name implies, XQuery draws on a patchwork of features from earlier XML query languages along with such database query languages as Structured Query Language and Object Query Language.

    What are its advantages?
    Since XQuery can pull information from many places, less storage of data is required. XQuery also defines types of data (such as dates or totals), which can speed calculations and the search for data.

    Application server and middleware vendors use these XQuery features to make their services work over a wide range of data sources. And XQuery is better suited to process XML data when it is stored within relational databases. Such databases generally treat XML data as either chunks of raw XML chopped up into database tables or as amorphous masses of data known as "binary large objects," or BLOBs.

    What's the downside?
    XQuery is still a draft standard, and "it's about a year away from approval," says Michael Champion, a research and development specialist at Software AG.

    There are several early implementations of XQuery in XML-related databases, such as Software AG's Tamino and X-Hive Corp.'s X-Hive/DB. But XQuery has yet to be widely implemented in production products from the major database vendors. Major implementation work will fall to application server and middleware vendors such as Ipedo, WebMethods and BEA, which will have to stitch together relational and XML-based data sources.

    Relational and XML database vendors are expected to deploy only the pieces of the "core" language that apply to their own products, using special extensions.

    Who's using it?
    XQuery is currently being used in a number of portal and integration products. British Telecom uses XQuery features of Ipedo's Information Hub to produce pricing documents that comply with government regulations. The U.S. Navy is using the same software to move personnel records from old data sources into an XML-based repository. Emory University is using XQuery with Software AG's Tamino to search metadata of the school library's poetry collection.

    What's next?
    Future versions will probably incorporate extensions for searching plain-text documents and other data formats. Look for integration vendors to provide XQuery-based "adapters" for applications like Microsoft Word and Excel. This will provide instant access to company data in documents created on screen on the fly.

    To find out if your clients can derive benefit from XQuery, take Baseline's online quiz.




    comments dic


     
     
    >>> More Solution Builder Articles          >>> More By Sean Gallagher
     


     



    channel chatter


    HTML PLAIN TEXT

    Keep on top of news for VARs and Resellers with CI's Weekly Newsletter and Alerts.


    [ci] feeds
    XML
    Add Channel News, Product Reviews, Trends and Analysis to your RSS newsreader or My Yahoo!


     


    CHANNEL SPONSORED RESOURCE CENTER
     
     
     
    Start the New Year with business intelligence—it’s a smart move
    Join us on February 1 for an encore rebroadcast at either 5 am or 12 noon EST and discover how business intelligence (BI) supports companies in uncertain business and economic climates. Get expert advice on how to create a strategy that fits your organization's needs and budget and see how quickly it can pay for itself.
    Click Here
     
    Security and Availability Essentials for Running Your Business in the Cloud
    Are you moving to the cloud? Find out what every IT professional should know about security and availability before moving to the cloud. Hear what a security provider’s own CSO has to say.
    Watch Video
    A new algorithm automatically identifies relationships between variables to help reduce researcher prejudice.
    Click HereAdvertisement