Semantic - Based Querying Using Ontology in Relational Database of Library Management System

Banu, Ayesha; Fatima, S. Sameen; Khan, Khaleel Ur Rahman

doi:10.5121/ijwest.2011.2402

Cited by 10 publications

(11 citation statements)

References 6 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…It uses D2RQ mappings for translating query requests from external applications to SQL queries on the RDB. The methodology, proposed by Banu et al [29] based on Library Management System (LMS) database to build ontology. This method depends on two steps, ontology extraction (offline) and semantic query (online).…”

Section: Semantic Query In Rdb Using Ontologymentioning

confidence: 99%

“…Additionally, the null -values in this table reflect  Our approach for semantic query is based on set of formal rules to rewrite the SPARQL query corresponding SQL relational algebra, with illustrated examples and results that proved the validity of our rules and the possibility of use in real applications. While authors [29], [38] use one example that shows SPARQL query corresponding SQL.  Our paper deals with the most important concepts of SQL relational algebra operations to generate formal rules of semantic query (SPARQL) on RDF data such as selection, projection, rename, union, difference, natural join, left Join, and binary relation.…”

Section: Experimental Analysismentioning

confidence: 99%

See 1 more Smart Citation

An Approach for Generation of SPARQL Query from SQL Algebra based Transformation Rules of RDB to Ontology

Hazber¹,

Li²,

Xu³

et al. 2018

JSW

View full text Add to dashboard Cite

Semantic web is a web of linked RDF data that can exchange and reuse data allowing for more use of traditional web documents. However, the huge amount of data on the web are still formed and stored in relational databases (RDBs), such data cannot be used directly via the Semantic Web. Consequently, construction of ontology (Semantic Web-side) from relational schema and data (RDBs-side) and querying of constructed ontology semantically are fundamental challenges for the development and integration of the Semantic Web from the data source (i.e. database). This paper proposes an approach for providing a formulated operation rules to express semantic queries against structured graph ontology in the relational query language SQL. This approach applied by rewriting SPARQL queries over generated ontology (i.e. RDF triples) corresponding to advantages of SQL relational algebra operation queries in RDBs and performed by two phases. The first phase focused on proposing and improving rules of extracting ontology directly from the important concepts in the relational database with considering database containing null-values to avoid data losses during the transformation process. The generated ontology represented in the form of OWL-RDFS/RDF triples to ensure its availability at Semantic Web, thus help semantic query engines to answer more queries. Furthermore, the first phase providing additional rules to generate the Internationalized Resource Identifiers (IRIs) for RDB schema and data. In the second phase, we proposed a set of rules inspired by fundamental operations of relational algebra (SQL algebra) for rewrit ing a relational algebra for SPARQL over RDBs that represented in RDF triples. In other words, translating SQL relational algebra operation queries into equivalent graph semantic queries (SPARQL). The proposed approach is demonstrated with examples, validated, implemented and compared with existing approach methods. The effectiveness of the proposed approach is evaluated by experimental results.

show abstract

Section: Semantic Query In Rdb Using Ontologymentioning

confidence: 99%

Section: Experimental Analysismentioning

confidence: 99%

An Approach for Generation of SPARQL Query from SQL Algebra based Transformation Rules of RDB to Ontology

Hazber¹,

Li²,

Xu³

et al. 2018

JSW

View full text Add to dashboard Cite

show abstract

“…Web service terdiri dari kumpulan fungsi dan method yang berpusat pada sebuah server yang dapat dipanggil oleh pengguna, dimana kita dapat mengakses method-method tersebut meskipun dengan bahasa pemrograman maupun platform yang berbeda (Martasari & Aminudin, 2010 (Gupta & Thakur, 2010). XML dirancang sebagai bahasa untuk mark-up yang memisahkan struktur data dari data itu sendiri (Banu, Fatima, & Khan, 2011…”

Section: Kajian Pustaka 1 Web Serviceunclassified

Implementasi Web Service Pada Sistem Pengindeksan Dan Pencarian Dokumen Tugas Akhir, Skripsi, Dan Praktik Kerja Lapangan

Paramartha

Suryaningsih²,

Aryanto³

2017

j. sains. teknologi.

View full text Add to dashboard Cite

AbstrakImplementasi web service pada sistem pengindeksan dan pencarian dokumen merupakan penyempurnaan sistem yang telah dikembangkan sebelumnya. Adapun kekurangan yang dimaksud meliputi data yang digunakan masih disediakan dan dikelola pada sistem itu sendiri yang menyebabkan manajemen data yang kurang efisien. Selain itu dalam proses pengindeksan dokumen, hasil index yang telah dibuat belum dapat diperbaharui apabila terjadi perubahan maupun penambahan dokumen baru. Berdasarkan hal tersebut, dikembangkan sistem pengindeksan dan pencarian dokumen dengan memanfaatkan web service pada sistem yang berbeda sebagai sumber data dan index yang telah dibuat dapat diperbaharui. Selain itu, sistem ini juga mengimplementasikan teknologi web service sebagai penyedia layanan yang dapat dimanfaatkan oleh pengembang maupun sistem yang berbeda. Layanan yang disediakan berupa layanan pencarian dokumen tugas akhir, skripsi dan praktik kerja lapangan. Keluaran dari layanan pencarian dokumen berupa dokumen yang sudah diberikan skor serta diurutkan berdasarkan relevansi dokumen dengan masukan berupa keywords dari pengguna.Kata kunci: Web service, pencarian dokumen, pembaharuan index. AbstractThe implementation of web service on document searching and indexing system is the improvement of the previous one. The weaknesses are the data used are still provided and managed in the system itself which cause inefficiency of data management. In indexing process, the index itself cannot be updated when there is some changes and added new document. Based on the problems, document searching system are developed using web service on different system as data source and the index can be updated. Beside that, this system also implementing web service technology as service provider which can be used by developer or other system. The service that is provided are scientific paper, thesis, and the report of internship document searching. The output of this service is in form of document which has been scored and sorted based on document relevancy using users' keywords.

show abstract

“…Penelitian selanjutnya adalah melakukan query semantic pada halaman web dengan media penyimpanan resource description framework (RDF), dimana proses query semantic pada relation database (RDB) sangat susah dilakukan. Maka dibuatkan relasi dari RDB ke RDF [9]. Proses query semantic akan menghasilkan informasi dengan menggunakan kata kunci bahasa alami yang memudahkan pengguna untuk mencari informasi yang dibutuhkan.…”

Section: Pendahuluanunclassified

Desain Sistem Semantic Data Warehouse dengan Metode Ontology dan Rule Based untuk Mengolah Data Akademik Universitas XYZ di Bali

Ambara

Sudarma

Kumara

2016

MITE

View full text Add to dashboard Cite

Data warehouse which is generaly known as traditional data warehouse has some weaknesses on data modeling which has lead to the quality of the resulting data is not specific and ineffective. Semantic data warehouse system is the solution to solve the problems on traditional data warehouse because it has some advantages, such as: data quality management with the same data format to support a good OLAP report, along with a more effective performance with natural language keywords. The modeling of semantic data warehouse using ontology method produces logic resource description framework scheme (RDFS) model which later will be transformed into physical snowflake scheme. The academic report needed is produced through Kimball's nine step method and semanctic search using rule based method. The trial has been done with two trial methods namely black box testing and checklist questionnaire. From the findings of this research, it can be concluded that semantic data warehouse can help the academic data processing which produces good quality report to support decision making process.

show abstract

Semantic - Based Querying Using Ontology in Relational Database of Library Management System

Abstract: The traditional Web stores huge amount of data in the form of Relational Databases (RDB) as it is good at

Cited by 10 publications

References 6 publications

An Approach for Generation of SPARQL Query from SQL Algebra based Transformation Rules of RDB to Ontology

An Approach for Generation of SPARQL Query from SQL Algebra based Transformation Rules of RDB to Ontology

Implementasi Web Service Pada Sistem Pengindeksan Dan Pencarian Dokumen Tugas Akhir, Skripsi, Dan Praktik Kerja Lapangan

Desain Sistem Semantic Data Warehouse dengan Metode Ontology dan Rule Based untuk Mengolah Data Akademik Universitas XYZ di Bali

Contact Info

Product

Resources

About