Ontolog Mini-Series on "Database And Ontology" (Session-4) - Thu 08-Feb-2007 (TCK)
- Session Chair: Dr. Matthew West (Shell International Petroleum Co) (TCL)
- Invited Speaker: Mr. Martin O'Connor (Stanford Medical Informatics) (TCM)
- Topic: "Efficiently Querying Relational Databases using OWL and SWRL" (TCN)
- Archive: slides & audio recording of the session (mp3) (TCO)
Conference Call Details (TCP)
- Date: Tuesday, February 8, 2007 (TCQ)
- Start Time: 10:30am PST / 1:30pm EST / 18:30 GMT/UTC (TCR)
- ref: World Clock (TCS)
- Expected Call Duration: 1.5~2.0 hours (TCT)
- Dial-in Number: (TCU)
- from a telephone (US): +1-605-475-8590 (South Dakota, USA) (TCV)
- from a phone (Europe): 0870-738-0763 (UK) or 01805 00 7620 (Germany) (TCW)
- callers from other countries please dial into either one of the US or European numbers (TCX)
- Conference ID: "5823120#" (TCY)
- Direct call from from Skype: +990008275823120 (TCZ)
- Shared-screen support (VNC session) will be started 5 minutes before the call at: http://vnc2.cim3.net:5800/ (TD0)
- view-only password: "ontolog" (TD1)
- if you plan to be logging into this shared-screen option (which the speaker may be navigating), and you are not familiar with the process, please try to call in 5 minutes before the start of the session so that we can work out the connection logistics. Help on this will generally not be available once the presentation starts. (TD2)
- people behind corporate firewalls may have difficulty accessing this. If that is the case, please download the slides below and runing them locally. The speaker will prompt you to advance the slides during the talk. (TD3)
- Please review our Virtual Session Tips and Ground Rules - see: VirtualSpeakerSessionTips (TD4)
- see below regarding our in-session Q & A process (TD5)
- RSVP to peter.yim@cim3.com appreciated. (TD6)
- This session, like all other Ontolog events, is open to the public. Information relating to this session is shared on this wiki page: http://ontolog.cim3.net/cgi-bin/wiki.pl?ConferenceCall_2007_02_08 (TD7)
- Please note that this session will be recorded, and the audio archive is expected to be made available as open content to our community membership and the public at-large under our prevailing open IPR policy. (TD8)
- Special appreciation to Dr. Timothy Redmond for recommending this talk by Mr. O'Connor to us. (TIA)
Attendees (TD9)
- Attended: (TDA)
- MatthewWest (TDC)
- MartinOConnor (TDD)
- PeterYim (TDE)
- TatianaMalyuta (TKK)
- Kate Nguyen (General Dynamics) (TKZ)
- AdrianWalker (TL7)
- BobSmith (TLT)
- AtillaElci (TME)
- TaniaTudorache (TMV)
- TimRedmond (TMW)
- KenBaclawski (TMX)
- JamesDouma (TMY)
- Kiavash Bahreini (Eastern Mediterranean University, TRNC) (TMF)
- Tom Adams (TMZ)
- EvanWallace (TN3)
- Expecting: (TDB)
- MitchRinger (TF5)
- Shahid Shah (Netspective) (TKJ)
- Fred Banks (Boeing) (TKM)
- Kristi Eckerson (CDC) (TKN)
- DaveMcComb (TKT)
- JuanSequeda (TKU)
- BiswanathDutta (TLM)
- ... to register for participation, please add your name (plus your affiliation, if you aren't already a member of the community) above, or e-mail <peter.yim@cim3.com> so that we can reserve enough resources to support everyone's participation. ... (TDF)
- Regrets: (TDG)
- LisaColvin (TFC)
- PatrickDurusau (TFD)
- GeorgeStrawn (planning to get this from the archive afterwards) (TKL)
- JoshuaLieberman (TKV)
- DougHolmes (will catch this in the archive) (TLL)
- EdDodds (ditto archive) (TNL)
Background (TDH)
This is the 4th event of the "Database and Ontology" min-series of talks and discussions, during which this community will be exploring the landscape, issues and interactions between databases and ontologies. (TDI)
This is a community-driven set of activities, and is probably long overdue. On 15-Aug-2006, TatianaMalyuta (who just joined the community after participating at our 23-Jul-2006 face-to-face workshop at Stanford, brought up her request for the Ontolog to delve into the subject of "Database and Ontologiy." An almost unprecedented flurry of online responses were received from the community. It was decided that we could systematically pursue the subject by mounting a min-series on the matter at hand. (TDJ)
A planning meeting for this mini-series took place on 31-Aug-2006. MatthewWest was invited to champion the effort, and a "Program & Technical Advisory Team" was formed, comprising MatthewWest (Lead), AdrianWalker, AtillaElci, ChrisPartridge, LeoObrst, PeterYim, SusieStephens & TatianaMalyuta. (TDK)
See also: DatabaseAndOntology (the 'project' homepage for this mini-series) (TDL)
The community is requested to contribute their thoughts by posting to [ontolog-forum] or to the DatabaseAndOntology wiki page (and/or its subpages). We hope to accumulate and synthesize the knowledge gathered and compile it into a written deliverable (a paper or even a handbook) that we could publish this collaboratively authored work to other relevant media and channels (like relevant conferences or the wikipedia.) (TDM)
Agenda & Proceedings: "Database And Ontology" - Mini-series Session-4 (TDN)
Mr. Martin O'Connor, from Stanford Medical Informatics, presents: "Efficiently Querying Relational Databases using OWL and SWRL" (TDO)
- Session Format: this is a virtual session conducted over an augmented conference call (TDP)
- 1. Opening by the Session Chair - MatthewWest (TDQ)
- 2. we'll go around with a self-introduction of participants (10~15 minutes) - All - we'll skip this if we have moe than 20 participants (in which case, it will be best if members try to update their namesake pages on this wiki prior to the call so that everyone can get to know who's who more easily.) (TDR)
- 2. Introduction of the invited speaker - TimRedmond (TDS)
- 3. Invited Speaker Presentation (60~75 minutes) - MartinOConnor (TDT)
- 5. Q & A and Open discussion by all participants (20~30 minutes) (TDU)
- 7. Summary / Conclusion / Follow-up by the Session Chair - MatthewWest (~5 minutes) (TDV)
Topic: "Efficiently Querying Relational Databases using OWL and SWRL" by Mr. Martin O'Connor (TDW)
[Mr. Martin O'Connor] (TDX)
- Abstract (by MartinOConnor): (TDY)
For the foreseeable future most data will continue to be stored in relational databases. To work with these data in OWL-based applications, tools and techniques that bridge the two models are required. Mapping all relational data to instances in an OWL knowledge base is often not practical, and is inappropriate in query-driven systems. To address this problem we have developed tools that allow the direct querying of relational data from OWL applications. We use OWL's rule language SWRL to express these queries. A number of optimizations are employed to ensure that this process is efficient and scales to large data sets. (TDZ)
- Bio of Mr. Martin O'Connor: (TE0)
Mr. Martin O'Connor is a member of the Research Staff at Stanford Medical Informatics (SMI) of the Stanford University School of Medicine. Before joining SMI, Mr. O'Connor worked for several years at IBMs T.J. Watson Research Center in Yorktown Heights, N.Y. At Stanford he was involved in the development of the EON system, a component-based architecture for developing decision support systems for guideline based care. Mr. O'Connor also developed the Chronus temporal query system, which has been used in a number of projects to perform temporal queries on biomedical data. Martin also coordinated the development of the BioSTORM, a research system to develop and evaluate intelligent systems for epedimic detection and characerization. In parallel with the BioSTORM efforts he is investigating the use of rules and query languages on the Semantic Web. Mr. O'Connor is currently developing the SWRLTab, an open source Protege-OWL-based development environment for the Semantic Web rule language (SWRL). (TE1)
- Mr. O'Connor's prepared slides can be accessed by pointing your web browsers to: (TE2)
- http://ontolog.cim3.net/file/work/DatabaseAndOntology/2007-02-08_MartinOConnor/Querying-RDB-Using-OWL-n-SWRL--MartinOConnor_20070208.ppt (TE3)
- links to additional relevant resources: (TE4)
- see: OntologyMeasurementEvaluation (the 'project' homepage for this mini-series) (TE5)
- Protégé - http://protege.stanford.edu (TE6)
- Protégé-OWL - http://protege.stanford.edu/overview/protege-owl.html (TE7)
- SWRLTab - http://protege.cim3.net/cgi-bin/wiki.pl?SWRLTab (TE8)
- SWRL - http://www.w3.org/Submission/SWRL/ (TE9)
- ... 'add resources here ... (TEA)
- Any material outside of the prepared presentation, if they are called up during the session, may be shared under the VNC session detailed above (TEB)
Questions, Answers & Discourse: (TEC)
- Please mute your phone, by pressing "*2" on your phone keypad, when the talk is in progress. To un-mute, press "*3" (TED)
- If you want to speak or have questions or remarks to make, please "raise your hand (virtually)" by pressing "11" on your phone keypad. You may speak when acknowledged by the speaker or the session moderator. (TEE)
- experimental: try using the queue management chat tool (TEF)
- point a separate browser window (or tab) to http://webconf.soaphub.org/conf/room and enter: Room: "ontolog_20070208" & My Name: e.g. "JaneDoe" (TEG)
- or point your browser to: http://webconf.soaphub.org/conf/room/ontolog_20070208 (TEH)
- instructions: once you got access to the page, click on the "settings" button, and identify yourself (by modifying the Name field). You can indicate that you want to ask a question verbally by clicking on the "hand" button, and wait for the moderator to call on you; or, type and send your question into the chat window at the bottom of the screen. (TEI)
- For those who have further questions or remarks on the topic, please post them to the [ontolog-forum] so that everyone in the community can benefit from the discourse. (TEJ)
- ... More Questions (TEK)
- Session ended 2007.02.08 12:27 pm PST (TEL)
Audio Recording of this Session (TEM)
- To download the audio recording of the session, click here (TEO)
- the playback of the audio files require the proper setup, and an MP3 compatible player on your computer. (TEP)
- Conference Date and Time: 08-Feb-2007 10:38am~12:27pm Pacific Standard Time (TEQ)
- Duration of Recording: 1 Hour 45 Minutes (TER)
- Recording File Size: 12.0 MB (in mp3 format) (TES)
- Telephone Playback (TET)
- Prior to the Expiration Date of 08-Mar-2007 0:00 AM PST, one can call-in and hear the telephone playback of the session. (TEU)
- Playback Dial-in Number: (TEV)
- US: 1-605-475-8599 (long distance costs apply) (TEW)
- UK: 0870 738 0768 (long distance costs apply) (TEX)
- Skype: +990008271111 (TEY)
- non-Skype callers from other countries can dial into either the US or UK number for the playback (long distance costs apply) (TEZ)
- Conference ID: 5823120# (TF0)
- Recording Reference Number: 69569# (TF1)
- suggestions: (TF2)
- its best that you listen to the session while having the slide presentation opened in front of you. You'll be prompted to advance slides by the speaker. (TF3)
- if you want to skip the opening introductions, and jump straight to the body of talk, please start your playback at the 05:41 (mm:ss) time point. (TN6)