A System for Integrated Management of
Data, Uncertainty, and Lineage


Trio is a new kind of database management system: one in which data, uncertainty of the data, and data lineage are all first-class citizens. Trio is based on an extended relational model called ULDBs, and it supports a SQL-based query language called TriQL. (See the online TriQL Language Manual.)

A wide variety of application domains can benefit from using Trio, including but not limited to: scientific and sensor data management; data cleaning and integration; information extraction systems; and approximate and hypothetical query processing.

We have completed an initial working prototype of the Trio system, available for download or use over the web as detailed below. A book chapter we wrote provides a comprehensive overview of Trio as of July 2008.

The Trio project is supported in part by the National Science Foundation under grants IIS-0414762 and IIS-0904497, and by a grant from the Boeing Corporation.

Trio Online Demo

The Trio system is available for use over the web. You can create your own databases or use our samples, and you can run TriQL queries and browse the results.

Download Trio Source Code and Binaries

The Trio prototype is available as open-source code under the BSD license.

To install the Trio system at your own site, a package containing the source code and some precompiled binaries is available for download here. The Trio client can be used via a convenient browser interface (TrioExplorer), through a command-line interface (trioplus), using direct API calls linked from another Python script, or as an external command-line call.

We are currently running Trio successfully under Linux, Mac OS X, and Win-32 (XP, Vista, and 32-bit Server). For more eccentric environments, the required Trio binaries can be recompiled.


Papers: Overviews and Demo Descriptions

In reverse chronological order of when they were written

Papers: Technical Topics

In reverse chronological order of when they were written


In reverse chronological order of when they were first given