Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Ontology based searches for

No description
by

kanaganayagam Janakan

on 21 January 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Ontology based searches for

Ontology based searches for
Relational Databases

Name of Candidate : K. Janakan
Registration No : 2011/mcs/026

THE PROBLEM DEFINITION
Difficulties / Issues
Knowledge about the underlying structure
of the Database schema

Knowledge of SQL syntax

Multiple data sources

Database needs to remain
the way it is for
better performance in terms of managing data
large storage
Integrity of data

Can we better represent the DB ?
ONTOLOGY
database
Proposed Solution
1. Create an Ontology that
represents the Database
2. Cross refer with a
Reputed Ontology
and enhance
3. Match the
user entered
words
to the

Ontology
4. Formulate SQL Queries
transformation steps
and the
Database Schema
The Ontology which was
created in step 2
and
enhanced in Step 3
Parser
using
using
using
Pre processing
phase 1

Pre processing
phase 2
Search phase
SQL queries
RULE 1
Ontology classes
-
All tables in the relational database schema are converted to Ontology classes unless they are bridge tables
Rule 2
Data Type properties
-
Any column which is not a foreign key is transformed to a data type property
Rule 3
Inheritance-

If table T‘s local attributes of the referential integrity constraint equals its primary key and the primary key of another table T1 , then T is a subclass of T1
Rule 4.1
Handling bridge tables – If a table’s columns are foreign keys to two other tables, then it is classified as a bridge table and handled as following
object properties
Generic scenario – All foreign keys except that match rule 4.1 are handled as below
BACKGROUND STUDY
Similar systems
Volz method
DataGenie
DataMaster
Relational.OWL
Qualeg DB
vis A vis
R2O
DB2OWL
RDOTE
Triplify
D2O Mapper
RDB2Onto
MARSON

R20
Contribution
Propose a
step by step process
to do transformations from
Database to Ontology
Propose an architecture to implement an end to end solution
Built a prototype for demonstration
Database Schema - Ontology mapping
creation of new Ontologies
map with existing Ontologies
ontology
map
ontology
generate
Steps
Transformation or mapping
of formats

Migration or query mechanism
combines the benefits of both mapping and transformation
qualeg DB
RDB2Onto
OGSRD
K. Muni, M. Odeh, R. McClatchey
Assumptions
The database schema was created properly
- entities, constraints identified properly
The end user has full access to the data
How we search the content of websites
Search engines
Website search
The problem is. . . ..
Data
web pages
small fraction
Can Only search Here
Cannot search Here
Some applications do support. . but
data
Online store
e.g Amazon
short comings
-Only accommodates few fields
- Not suitable for other types of applications
Can we let the end user query the data directly ??
Approach . .
e.g Health system DB
health domain Ontology
mapping with existing Ontologies
Full transcript