110 likes | 203 Views
SO2DB From Symbolic Objects to Database Donato Malerba – University of Bari, Italy 6-8 October 2003. SO 2DB. The goal of SO2DB module is that of retrieving individuals with some characteristics described by a set of SO’s in a relational database and of storing them in a database table.
E N D
SO2DBFrom Symbolic Objects to DatabaseDonato Malerba – University of Bari, Italy6-8 October 2003
SO 2DB The goal of SO2DB module is that of retrieving individuals with some characteristics described by a set of SO’s in a relational database and of storing them in a database table. ASSO School, Athens
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 ASSO School, Athens
SO2DB …… …… …… DB2SO SOML file relational database relational data table SO2DB Goal …graphically ASSO School, Athens
matching operators ………… ………… SO2DB: input / output • Users choose an input SODAS file, from which they select one or more SO’s, and composing/storing/retrieving/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. ASSO School, Athens
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 SO’s is greater than or equal to T. retrieved individuals are those whose canonical matching against selected SO returns 1 ASSO School, Athens
maker_name fuel_type aspiration num_of_doors body_style drive_wheels alfa-romeo Gas Std two convertible Rwd alfa-romeo Gas Std two convertible Rwd alfa-romeo Gas Std two hatchback Rwd Audi Gas Std four sedan 4wd Audi Gas Std four wagon Fwd Audi Gas Turbo four sedan Fwd Audi Gas Turbo two hatchback 4wd Bmw Gas Std two sedan Rwd Bmw Gas Std four sedan Rwd An Example… SO [maker_name {Audi,Bmw}] [type_fuel {Gas, Diesel}] [body_style {wagon,sedan}] ' ASSO School, Athens
maker_name fuel_type aspiration num_of_doors body_style drive_wheels Audi Gas Std four sedan 4wd Audi Gas Std four wagon Fwd Audi Gas Turbo four sedan Fwd Bmw Gas Std two sedan Rwd Bmw Gas Std four sedan Rwd … 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”; ASSO School, Athens
car name Cylinders displacement horsepower weight "chevrolet chevelle malibu" 8 307 130 3504 "dodge challenger se" 8 383 170 3563 "chevrolet monte carlo" 8 400 150 3761 "buick estate wagon (sw)" 8 455 225 3086 "toyota corona mark ii" 4 113 95 2372 "plymouth duster" 6 198 95 2833 "amc hornet" 6 199 97 2774 "ford maverick" 6 200 85 2587 … An Example ' ASSO School, Athens
Canonical Matching SQL query Flexible Matching SQL query SO2DB: Matching operators ASSO School, Athens
Solution: • Select a set of SO’s; • 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 ASSO School, Athens