Title: SO2DB From Symbolic Objects to Database Donato Malerba
1SO2DBFrom Symbolic Objects to DatabaseDonato
Malerba University of Bari, Italy6-8 October
2003
2SO 2DB
- The goal of SO2DB module is that of retrieving
individuals with some characteristics described
by a set of SOs in a relational database and of
storing them in a database table.
3SO2DB INPUT/OUTPUT
-
- INPUT ? - sds or xml file containing
symbolic objects - - Access Database
- OUTPUT ? an Access Database table
reporting the name of selected symbolic variables
and one record for single matching or one
record for multiple matchings, according the
user selected option
4SO2DB Goal
graphically
5SO2DB input / output
- Users choose an input SODAS file, from which they
select one or more SOs, and composing/storing/ret
rieving/modifying a query (stored in a XML file)
for the description of individuals.
Compute the extension of a SO (SOs), which was
originally defined on a set ?, on another set ?'
(possibly coincident with ?) of individuals.
Possible if the variable used to described the
individuals on ?' allow to compute the extension
of the SO (Sos).
- Retrieved individuals are stored in a relational
database table.
6SO2DB Matching operators
SO
Boolean
Boolean
Probabilistic
Canonical Matching
Flexible Matching
The user may introduce a threshold T?0, 1 that
represents the degree of flexible matching.
Retrieved individuals are those whose degree of
match against the selected SOs is greater than
or equal to T.
retrieved individuals are those whose canonical
matching against selected SO returns 1
7An Example
SO ? maker_name ? Audi,Bmw ? type_fuel ?
Gas, Diesel ? body_style ? wagon,sedan
?'
8 An Example
SO ? maker_name ? Audi,Bmw ? type_fuel ?
Gas, Diesel ? body_style ? wagon,sedan We
can calculate the extension of A on ?' through
the SQL query SELECT FROM Car WHERE make
Audi OR make Bmw AND fueltype Gas OR
fueltype Diesel AND bodystyle wagon OR
bodystyle sedan
9 An Example
?'
10SO2DB Matching operators
11Solution
- Select a set of SOs
- Determine the set ?' through a database query
- Establish the association variable names-database
attributes - Select a matching function.
- Compute matching
A GUI is developed to support users in
propagating SO to DB