Actions

Ontolog Forum

Ontolog Mini-Series on "Database And Ontology" (Session-8) - Thu 28-June-2007

  • Title: "Building Database Infrastructure for Managing Semantic Data"

Conference Call Details

  • Date: Thursday, June 28, 2007
  • Start Time: 10:30am PDT / 1:30pm EDT / 6:30pm BST / 17:30 GMT/UTC
  • Expected Call Duration: 1.5~2.0 hours
  • Dial-in Number:
    • Direct call from from Skype: +990008275823120
    • When calling in from a phone, use Conference ID: "5823120#"
    • from US & Canada, call: +1-605-475-8590 (South Dakota, USA)
    • from Europe, call:
      • Belgium 070-35-9989
      • France 0826-100-277
      • Germany 01805-00-7649
      • Ireland 0818-270-034
      • Italy 0848-390-175
      • Switzerland 0848-560-195
      • UK 0870-738-0763
    • callers from other countries please dial into either one of the US or European numbers
  • Shared-screen support (VNC session) will be started 5 minutes before the call at: http://vnc2.cim3.net:5800/
    • view-only password: "ontolog"
    • 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.
    • people behind corporate firewalls may have difficulty accessing this. If that is the case, please download the slides below and running them locally. The speaker will prompt you to advance the slides during the talk.
  • 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.

Attendees

Background

This is the 8th event of the "Database and Ontology mini-series" of talks and discussions, during which this community will be exploring the landscape, issues and interactions between databases and ontologies.

This is a community-driven set of activities, and is probably long overdue. On 15-Aug-2006, Tatiana Malyuta (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 Forum 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.

A planning meeting for this mini-series took place on 31-Aug-2006. Matthew West was invited to champion the effort, and a "Program & Technical Advisory Team" was formed, comprising Matthew West (Lead), Adrian Walker, Atilla Elci, Chris Partridge, Leo Obrst, Peter P. Yim, Susie Stephens & TatianaMalyuta.

See also: DatabaseAndOntology (the 'project' homepage for this mini-series)

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.)

Agenda & Proceedings: "Database And Ontology" - Mini-series Session-8

  • Session Format: this is a virtual session conducted over an augmented conference call.
  • Agenda:
    • 1. Opening by the Session Chair - Matthew West
    • 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.)
    • 2. Introduction of the invited speaker - Susie Stephens
    • 3. Invited Speaker Presentation (60~75 minutes) - Souripriya Das and Melliyal Annamalai
    • 5. Q & A and Open discussion by all participants (20~30 minutes)
    • 7. Summary / Conclusion / Follow-up by the Session Chair - Susie Stephens (~5 minutes)

Title: Building Database Infrastructure for Managing Semantic Data

. . . . . . By: Dr. Souripriya Das and Dr. Melliyal Annamalai (Oracle)

http://ontolog.cim3.net/file/work/DatabaseAndOntology/2007-06-28_SouripriyaDas-MelliyalAnnamalai/SouripriyaDas_20070628.jpg . . . . . . . . http://ontolog.cim3.net/file/work/DatabaseAndOntology/2007-06-28_SouripriyaDas-MelliyalAnnamalai/MelliyalAnnamalai_20070628.jpg

[Dr. Souripriya Das] [Dr. Melliyal Annamalai]

Abstract (by Souripriya Das and MelliyalAnnamalai)

Extending database technology to store and manage ontologies and semantic data has several advantages:

  • (1) the ability to use ontologies with database queries,
  • (2) the ability to use SQL to query semantic data,
  • (3) extension of database benefits of data management such as security, concurrency, transaction control, robustness, availability. etc. to ontologies and semantic data, and
  • (4) applying the scalability of a database to the management of large ontologies.

Our initial work focused on storage, query, and management of RDF data in a database. We developed a storage model for storing RDF data in relational structures, and extended SQL to create an interface for querying RDF data in the database. The SQL extension is implemented through a table function interface, which allows for the results of an ontology query to be returned as a table that can then be combined with other relational data using standard SQL constructs. Our ongoing work focuses on extending ontology management to include support for an expressive subset of OWL DL (basic constructs, property characteristics, class comparisons, individual comparisons, and class expressions), and the addition of two new SQL operators to enhance the query of relational data using ontologies.

In this talk we will talk about our experiences in building the infrastructure for storage and management of ontologies and semantic data in the database, and include examples that show the power of combining ontologies with relational queries. In a subsequent talk we will focus on the support for OWL.

About the Invited Speakers

Dr. Souripriya Das, a.k.a. Souri, pioneered the work on semantic technologies in Oracle and has led the development effort over two product cycles since its inception in 2002. Prior to semantic technologies, he was the lead developer and project leader for novel database features at Oracle. Souri is a Consultant Member of Technical Staff at Oracle. Besides working on semantic technologies development, he also represents Oracle at the W3C Data Access Working Group that is responsible for the SPARQL query language and protocol. Souri has a Ph.D. in Computer Science and has been interested in all areas of Computer Science right from his undergraduate days at the Indian Institute of Technology at Kharagpur. His other interests are in trying to understand the philosophy of life, evolution of the Universe, and playing soccer with friends.
Dr. Melliyal Annamalai is a Principal Member of Technical Staff at Oracle. She has a Ph.D. in Computer Science and is part of the Semantic Technologies development group (at Nashua, New Hampshire, USA.) Projects she has worked on at Oracle include semantic operator support in the database and using semantic technology to enhance image metadata based search. She is a member of the W3C Semantic Web Education and Outreach group and the W3C Multimedia Semantics Incubator Group. Her responsibilities in the development group include understanding customer requirements and helping them use Oracle Database Semantics technology in their applications.

Resources

Questions, Answers & Discourse

  • Please mute your phone, by pressing "*2" on your phone keypad, when the talk is in progress. To un-mute, press "*3"
  • 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.
    • experimental: try using the queue management chat tool
    • point a separate browser tab (or window) to http://webconf.soaphub.org/conf/room and enter: Room="ontolog_20070628" and My Name="Your Own Name" (e.g. "JaneDoe")
    • or point your browser to: http://webconf.soaphub.org/conf/room/ontolog_20070628
      • 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.
    • 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.
  • ... More Questions
  • Session ended 2007.06.28 12:18 pm PDT

Audio Recording of this Session

  • To download the audio recording of the session, click here
    • the playback of the audio files require the proper setup, and an MP3 compatible player on your computer.
  • Conference Date and Time: 28-Jun-2007 10:38am~12:18pm Pacific Standard Time
  • Duration of Recording: 1 Hour 34 Minutes
  • Recording File Size: 10.7 MB (in mp3 format)
  • Telephone Playback
    • Prior to the Expiration Date of 28-Jul-2007 0:00 AM PST, one can call-in and hear the telephone playback of the session.
    • Playback Dial-in Number: (long distance costs apply)
      • US: +1-605-475-8599
      • Belgium: +070 35 9990
      • France: +0826 100 279
      • Germany: +01805 00 7641
      • Ireland: +0818 270 036
      • Italy: +0848 390 177
      • Switzerland: +0848 560 197
      • UK: +0870 738 0768
      • Skype: +990008271111 (free computer-to-computer call)
      • non-Skype callers from other countries can dial into either the US or UK number for the playback (long distance costs apply)
      • Conference ID: 5823120#
      • Recording Reference Number: 98245#
    • suggestions: