1 / 13

Template-Based Wrappers in the TSIMMIS System

Template-Based Wrappers in the TSIMMIS System. Joachim Hammer Hector Garcia-Molina Svetlozer Nestorov Ramana Yerneni Marcus Breunig Vasilia Vassalos. SIGMOD97. Wrapper. Problem: A lot of effort required to develop and write a wrapper Solution Wrapper implementation toolkit

loyal
Download Presentation

Template-Based Wrappers in the TSIMMIS System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Template-Based Wrappers in the TSIMMIS System Joachim Hammer Hector Garcia-Molina Svetlozer Nestorov Ramana Yerneni Marcus Breunig Vasilia Vassalos SIGMOD97

  2. Wrapper • Problem: A lot of effort required to develop and write a wrapper • Solution • Wrapper implementation toolkit • Template-based translation technology

  3. Wrapper Architecture

  4. OEM • Every object has an OID, type, label, and value. • OEM Object Example (omitting the type and OID)

  5. MSL • A rule-based language • MSL rule • Head • Tail

  6. Example • Assumption • A relational database contains bibliographic information about books and papers • The database accepts SQL queries • The wrapper accepts MSL queries • Parser • Matcher • Engine

  7. MSL Query Find all publications labeledbookwhich have subobjectsyearandauthor, and for which the author field has value “Jones” and the year field value is less than1984. Parser

  8. Template Rule “Parameterized MSL query” Matcher

  9. Template Rule (Cont.) “Parameterized MSL query” Action: // $$ = “select * from book Where author = ” $X “Parameterized SQL query” “Jones”

  10. Native SQL Query select * from book where author = “Jones”

  11. Postprocessing B: -B: <book { <year Y>}> AND lt(Y, 1984) Engine select * from book where author = “Jones”

  12. Demo • A university-owned legacy system called FOLIO, which is accessible through an interactive front-end (called INSPEC) • A Sybase relational DBMS which is accessible through SQL • A collection of UNIX files which is accessible through a Perl script file • A World-Wide Web source which is accessible through a WWW extraction utility

  13. Conclusion • Wrappers hide all source specific details from the application/end user • Quickly enhance the query capabilities of a wrapper • Change the resulting answer structures • MOBIE

More Related