Schema Matching results

1
Schema Matching results

• Lars Olson

2
Baseline test data

• Test 1 (Course Washington ? Reed)
• R 3/9 (33), P 3/3 (100)
• room, title, days
• Test 2 (Course Washington ? Rice)
• R 4/9 (44), P 4/4 (100)
• room, credits, title, days
• Test 3 (Faculty Washington ? Berkley)
• R 8/10 (80), P 8/8 (100)
• name, research, degrees, fac_title, award, year,
  building, title
• Test 4 (Faculty Washington ? Cornell)
  (identical to Test 3)

3
After Improvements

• Test 1 (Course Washington ? Reed)
• Name matcher R 8/9 (89), P 8/8 (100)
  (missed schedule_line ? reg_num)
• Bayes R 4/9 (44), P 4/12 (33) (also
  missed schedule_line)
• Test 2 (Course Washington ? Rice)
• Name matcher R 9/9 (100), P 9/9 (100)
• Bayes R 4/9 (44), P 4/12 (33)
• Test 3 (Faculty Washington ? Berkley Cornell)
• Name matcher R 10/10 (100), P 10/10 (100)
• Bayes R 8/10 (80), P 8/10 (80)

4
Comments

• Improvements made
• Name matcher
• Remove all symbols (e.g. _) from string
• Build thesaurus based on training set
• Bayes learner
• Attempt 1 classify all numbers together
• Attempt 2 replace all digits with
• Idea FSA tokenizer (to recognize phone numbers
  ?, times )
• Difficulties
• What are the correct matches? (e.g. restrictions
  ? comments)
• Aggregate matches were not included in recall
  measures