SO2DB From Symbolic Objects to Database Donato Malerba

1
SO2DBFrom Symbolic Objects to DatabaseDonato
Malerba University of Bari, Italy6-8 October
2003
2
SO 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.

3
SO2DB 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

4
SO2DB Goal
graphically
5
SO2DB 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.

6
SO2DB 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
7
An 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
?'
 
10
SO2DB Matching operators
11
Solution

• 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