SPDBMS
The Semistructured Probabilistic Database Management System
The Semistructured Probabilistic Database Management System (SPDBMS) is used to store and manage probability tables and related information for the Bayesian Advisor project and the Welfare to Work project. The Bayesian Advisor project is concerned with automating decision making and constraint checking aspects of advising in academia. The goal of the Welfare to Work project is to build software to support Welfare to Work case managers' advising of clients. The SPDBMS can handle simple, conditional, and joint probability distributions, and can access the data using SP-Algebra queries. The SPDBMS serves as a back end for storing probabilistic information and meta information (context) associated with network fragments built by the Bayesnet Builder tool (BNB) . The Probability Elicitation Tool (PET) allows experts in various domains to associate probabilities in the bayesian network that will be used in planning. These probabilities associated with different bayesian networks are stored in the SPDBMS. The BNB tool uses the underlying probabilistic data in the SPDBMS while performing Knowledge-based Model Construction (KBMC) for situation-specific network fragments.
These are the atomic query functionalities implemented in the SPDBMS server:
Selection on context, conditional, random variable and probability values
Projection on context, conditional and random variable
Conditionalization on random variable
Join and cartesian products
The Structured Queries Conjuctive (AND), disjunctive (OR), and negative (NOT) predicates are also supported. The current system supports any queries with predicates in CNF. Queries can be also nested.
Some of the current works:
Design and implementation of SPOQL (SQL like language) for SPDBMS
Some of the future works:
Aggregate queries for SPDBMS
Adapting the SPDBMS to different application domains
The SPDBMS connection object is required to communicate with the SPDBMS. It can be downloaded from the downloads section. The documentation needed to use the APIs is also provided in the downloads section. The SP-algebra query syntax will have to be followed while querying the SPDBMS. The new SPOQL syntax is available and a stable SPOQL engine for the current server is being updated. If any one is interested in knowing where the SPDBMS server is running, kindly email me at kkmath2@uky.edu or log on to the Wiki to find out.
A Theoretic Framework of Semistructured Probabilistic Database - Joint work by Dr. Zhao, Dr. Dekhtyar and Dr. Goldsmith
SPDBMS Connection Object (updated java program)
sample driver program implementing the new insertdata API (java program)
SPDBMS Connection and Query API
SP-Algebra query syntax along with examples
Sample xml file representing SPOs
The schemas for the above mentioned xml files is available at schema link
Page last modified 10/10/2005
problems? -- kkmath2@uky.edu