Send the link below via email or IMCopy
Present to your audienceStart 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.
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.
Ontology based searches for
Transcript of Ontology based searches for
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
Integrity of data
Can we better represent the DB ?
1. Create an Ontology that
represents the Database
2. Cross refer with a
3. Match the
4. Formulate SQL Queries
The Ontology which was
created in step 2
enhanced in Step 3
All tables in the relational database schema are converted to Ontology classes unless they are bridge tables
Data Type properties
Any column which is not a foreign key is transformed to a data type property
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
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
Generic scenario – All foreign keys except that match rule 4.1 are handled as below
vis A vis
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
Transformation or mapping
Migration or query mechanism
combines the benefits of both mapping and transformation
K. Muni, M. Odeh, R. McClatchey
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
The problem is. . . ..
Can Only search Here
Cannot search Here
Some applications do support. . but
-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