HXQ: A Compiler from XQuery to Haskell

Download HXQ-0.18.2.tar.gz

Description

HXQ is a fast and space-efficient translator from XQuery (the standard query language for XML) to embedded Haskell code. The translation is based on Template Haskell. HXQ takes full advantage of Haskell's lazy evaluation to keep in memory only those parts of XML data needed at each point of evaluation, thus performing stream-based evaluation for forward queries (queries that do not contain backward steps). This results to an implementation that is as fast and space-efficient as any stream-based implementation based on SAX filters or finite state machines. Furthermore, the coding is far simpler and extensible since it is based on XML trees, rather than SAX events. Since HXQ uses lazy evaluation, you get the first results of non-blocking queries immediately, while the non-streaming XQuery processors must first parse the entire input file and construct the whole XML tree in memory before they produce any output.

Finally, HXQ can store XML documents in a relational database (currently MySQL or SQLite), by shredding XML into relational tuples, and by translating XQueries over the shredded documents into optimized SQL queries. The mapping to relational tables is based on the document's structural summary, which is derived from the document data rather than from a schema. It uses hybrid inlining to inline attributes and non-repeating elements into a single table, thus resulting to a compact relational schema. For each such mapping, HXQ synthesizes an XQuery that reconstructs the original XML document from the shredded data. This XQuery is fused with the user queries using partial evaluation techniques and parts of the resulting query are mapped to SQL queries using code folding rules so that all relevant predicates are promoted to SQL. This pushes most evaluation to the database query engine, thus resulting to a fast execution over large data sets.

Performance

HXQ shines best when used for data intensive applications. For example, the XQuery in Test2.hs, which is against the DBLP XML document (420MB), runs in 36 seconds on my laptop PC and uses a maximum of 3.2MB of heap space (using the runtime options +RTS -H2m -M3.2m). (All results are taken on an Intel Core 2 Duo 2.2GHz 2GB running ghc-6.8.3 on a 32-bit Linux 2.6.27 kernel.) To contrast this, Qexo, which compiles XQueries to Java bytecode, takes 1 minute 17 seconds and uses 1400MB of heap space for the same query, while XQilla, which is written in C++, takes 1 minute and 10 secs and uses 1150MB of heap space. For simple XPath queries, the fastest implementation I have ever tried is using SAX pipelines, which runs in 17secs and needs 3MB heap. Unfortunately, it is very hard to implement complex XQuery constructs using SAX, and one may end up simulating lazy evaluation using ad-hoc techniques.

For better performance in data intensive applications, one may use the database capabilities of HXQ. For example, when the DBLP file is shredded into a MySQL database and the appropriate index is created, the above query runs in 90 milliseconds.

HXQ uses the HXML parser for XML (developed by Joe English), which is included in the source. I have also tried hexpat, tagsoup, HXT, and HaXML Xtract, but they all have space leaks.

HXQ has two parsers: one that generates simple rose trees from XML documents, which can be processed by forward queries without space leaks, and another parser where each tree node has a reference to its parent. Some, but not all, backward axis steps (such as the parent axis /..) are removed from a query using optimization rules. If there are backward axis steps left in the query, then HXQ uses the latter parser, which may result to a performance penalty due to space leaks.

Installation Instructions (HXQ without Database Connectivity)

HXQ can be installed on most platforms but I have only tested it on Linux, Mac OS X, and Windows XP. The simplest installation is without database connectivity (ie, it can only process XQueries against XML text documents). If you want database connectivity (over MySQL or sqlite relational databases), look at the installation instructions for database connectivity.

First, you need to install the Glasgow Haskell Compiler, ghc. Optionally, if you want to modify the XQuery parser, you need to install the parser generator for Haskell, happy. If you are new to Haskell, please read How to install a Cabal package. The easiest way to install packages in Haskell is using cabal. On Linux, you can install Haskell and cabal using yum install ghc happy cabal-install. You must then update the list of known packages using cabal update.

The simplest way to install HXQ is by using the cabal command:

cabal install HXQ
which will automatically download and install all required packages.

An alternative way of installing HXQ is to download and install all required packages one-by-one: First download HXQ version 0.18.2 and untar it (using tar xfz on Linux/Mac or 7z x on Windows). Then, you execute the following commands inside the HXQ directory:

runhaskell Setup.lhs configure --user
runhaskell Setup.lhs build
runhaskell Setup.lhs install
If the configure command indicates that haskeline is missing, install the packages extensible-exceptions and haskeline first using the same process.

HXQ consists of the executable xquery, which is the XQuery interpreter, and the HXQ library.

To use the HXQ library in a Haskell program, simply import Text.XML.HXQ.XQuery.

Installation Instructions for Database Connectivity

Current Status

HXQ supports most essential XQuery features, although some system functions are missing (but are easy to add). Note that HXQ is a proof-of-concept (prototype) implementation; it's not fully compliant with the W3C specs. One may use HXQ as a basis for a fully compliant XQuery implementation (conforming to W3C test suits), but currently I do not have the time to do so. To see the list of supported system functions, run xquery -help. Here are some important differences between HXQ and the W3C specs:

XQuery Documentation

The complete XQuery syntax in HXQ is described in hxq-manual.pdf. I have also written a paper that describes some of the database related methods used in the implementation. Here some tutorials on XPath and XQuery. Here are two relevant courses on XML and databases at Stanford and ETH.

Using the Compiler

The main functions for embedding XQueries in Haskell are:

where query is a string value (a Haskell expression that evaluates to a string at compile-time). They both translate the query into Haskell code, which is compiled and optimized into machine code directly. The code that xe generates has type XSeq (a sequence of XML trees of type [XTree]) while the code that xq generates has type (IO XSeq). If the query reads a document (using doc(...)) or calls an external function, then you should use xq since it requires IO. You can use the value of a Haskell variable v inside a query using $v as long as v has type XSeq. To call a function in a query, it should be defined in Haskell with type (XSeq,...,XSeq) -> IO XSeq.

Here is an example of a main program:

f(x,y) = $(xq "<article><first>{$x}</first><second>{$y}</second></article>")

main = do a <- $(xq "<result>{                                                         /
                 /       for $x at $i in doc('data/dblp.xml')//inproceedings           /
                 /       where $x/author = 'Leonidas Fegaras'                          /
                 /       order by $x/year descending                                   /
                 /       return <paper>{ $i, ') ', $x/booktitle/text(),                /
                 /                       ': ', $x/title/text()                         /
                 /              }</paper>                                              /
                 /    }</result>                                                       ")
          putXSeq a
          b <- $(xq " f( $a/paper[10], $a/paper[8] ) ")
          putXSeq b
Another example, can be found in Test1.hs. You compile it using ghc -O2 --make Test1.hs -o a.out. Using the latest ghc (version >= 6.9), one may use quasi-quotations instead of strings, as is shown in Test2a.hs.

You can compile an XQuery file into a Haskell program (Temp.hs) using xquery -c file. Or better, you can use the script compile (on Unix/Mac or Windows) to compile the XQuery file to an executable. For example:

compile data/q1.xq
will compile the XQuery file data/q1.xq into the executable a.out.

Using the Interpreter

The HXQ interpreter is far more slower than the compiler; use it only if you need to evaluate ad-hoc XQueries read from input or from files. The only function is:

xquery :: String -> IO XSeq
which evaluates an XQuery in a string. The HXQ interpreter doesn't recognize Haskell variables and functions (but you may declare XQuery variables and functions using the XQuery 'declare' syntax). The main HXQ program, called xquery, evaluates an XQuery in a file using the interpreter. For example:
xquery data/q1.xq
Without an argument, it reads and evaluates XQueries and variable/function declarations from input. With xquery -p xpath-query xml-file you can evaluate an XPath query against an XML file. For example,
xquery -p "//inproceedings[100]" data/dblp.xml
With xquery -help you get the list of system functions and usage information.

XML Schema Validation and Type Inference

Currently, HXQ supports type testing and casting using the XQuery expressions: typeswitch, instance-of, cast-as, etc. The validation and type inference systems are still a work in progress. To use type inference, use the option -tp in xquery. To associate an XML document with an XML Schema, use the XQuery import schema statement. For example:

import schema default element namespace "dept" at "data/department.xsd";
validate {doc("data/cs.xml")//gradstudent};
(doc("data/cs.xml")//gradstudent[.//lastname='Galanis']//address) instance of element(address)*
For a faster validation of a document, use the Haskell function validateFile:
validateFile "data/dblp.xml" "data/dblp.xsd"

Release Notes


Last modified: 10/08/09 by Leonidas Fegaras