O R I O N

A Database System For Managing Uncertain Data

 

Documentation

Use this link to download Orion documentation in PDF format. You can find more information about the underlying theory by reading the related papers.

Example Queries

Create a table with UNCERTAIN type CREATE table T (
    k INTEGER primary key,
    a UNCERTAIN);
Insert Gaussian pdf (μ, σ) INSERT INTO T values (1,'(g, μ, σ)');
Display uncertain information of a if a > 5 SELECT a FROM T where a > 5;
Equality join of uncertain attributes
(=% returns probability of equality) 		SELECT R.k, S.k, R.a =% S.a
    FROM R,S
    WHERE R.a = S.a;
Entities with prob. giving min value of a
(e.g., {(3,0.5), (5,0.3), (11,0.2)}) 		SELECT Emin(T.a) from T;
Min value of a for table T (UNCERTAIN) SELECT Vmin(T.a) from T;
 

Known issues and bugs

  • The Entity functions (e.q. u_ennq, u_vmin, u_emin) for discrete datatype are not implemented yet.