Supported Features
Samples Tab
Clicking a button to load sample data erases the existing database if there is one, creates sample tables, and populates them with initial data. (WARNING: any existing tables and data will be erased!) Once the data is loaded, sample queries for it appear in the other box.
Schema Tab
Scripts Tab
Commands in script files must be separated by semicolons. Blank lines and lines beginning with “–” (for comments) are ignored. Here is a
sample script.
Home: <current database> Tab
This is the main tab, used primarily for entering queries or other commands into the Query box, executing them (”Execute” button), and browsing query results.
Note that a “create table T as...” query does not display results. Rather, it creates a table T that now appears in the Schema tab and in the View Tables menu. To see the results, select T from the View Tables menu, or visit the Schema tab and click on T.
Queries and Commands
The query box also accepts DDL and data modification commands. These commands are not documented in the TriQL language manual but you can easily learn them from the
sample script. The DDL and Insert commands currently supported are
described here. (See also some planned
upcoming features.)
Data and Query Result Browsing
This is the richest and potentially most confusing part of the interface. Here are some of the features, separated into data and lineage:
Data
GREEN TABLES
Alternatives - Tuples shaded in “3D” indicate that there are multiple alternatives for (i.e., uncertainty about) the tuple’s value. Click on the tuple to display the alternatives, and click again to “fold” the tuple back to 3D. When folded, the the vertical bars indicate alternative possible values for attributes, but note the tuple must be unfolded to see the exact alternatives for the entire tuple, since not all combinations of attribute alternatives may be present.
Question marks - indicate uncertainty about a tuple’s presence.
ORANGE TABLES
Alternatives - same as for green tables.
Confidence values - The number in the orange box is the confidence value for an entire tuple (if the tuple is folded, or if it only has one alternative), or for a tuple alternative (if the tuple is unfolded). If there’s a “conf” link instead of a value, clicking the link will cause the system to compute the confidence value. If there’s a “CONF-ALL” link next to the table heading, clicking that link will cause the system to compute confidence values for the entire relation.
Lineage