CREATE

Creating a simple table which has uncertain attributes:
CREATE TABLE trucks
(
id INTEGER PRIMARY KEY,
xloc UCON,
yloc UCON,
cargo UDIS,
);

Creating a simple table which has correlated uncertain attributes:
CREATE TABLE trucks
(
id INTEGER PRIMARY KEY,
xpos UCON,
ypos UCON,
cargo UDIS,

DEPENDENT (xpos, ypos)
);

Alternatively, we could use curly braces. This eliminates the need to check consistencies (i.e. disjoint dependency sets) and simplifies the syntax of INSERT statements (i.e. the ordering of values). The downside is forces a reordering of columns whenever dependencies change (i.e. selections and joins).
CREATE TABLE trucks
(
id INTEGER PRIMARY KEY,
xpos UCON, ypos UCON,
cargo UDIS,
);



Rohit Jain 2011-08-02