dor_id: 4110147

506.#.#.a: Público

590.#.#.d: Los artículos enviados a la revista "Journal of Applied Research and Technology", se juzgan por medio de un proceso de revisión por pares

510.0.#.a: Scopus, Directory of Open Access Journals (DOAJ); Sistema Regional de Información en Línea para Revistas Científicas de América Latina, el Caribe, España y Portugal (Latindex); Indice de Revistas Latinoamericanas en Ciencias (Periódica); La Red de Revistas Científicas de América Latina y el Caribe, España y Portugal (Redalyc); Consejo Nacional de Ciencia y Tecnología (CONACyT); Google Scholar Citation

561.#.#.u: https://www.icat.unam.mx/

650.#.4.x: Ingenierías

336.#.#.b: article

336.#.#.3: Artículo de Investigación

336.#.#.a: Artículo

351.#.#.6: https://jart.icat.unam.mx/index.php/jart

351.#.#.b: Journal of Applied Research and Technology

351.#.#.a: Artículos

harvesting_group: RevistasUNAM

270.1.#.p: Revistas UNAM. Dirección General de Publicaciones y Fomento Editorial, UNAM en revistas@unam.mx

590.#.#.c: Open Journal Systems (OJS)

270.#.#.d: MX

270.1.#.d: México

590.#.#.b: Concentrador

883.#.#.u: https://revistas.unam.mx/catalogo/

883.#.#.a: Revistas UNAM

590.#.#.a: Coordinación de Difusión Cultural

883.#.#.1: https://www.publicaciones.unam.mx/

883.#.#.q: Dirección General de Publicaciones y Fomento Editorial

850.#.#.a: Universidad Nacional Autónoma de México

856.4.0.u: https://jart.icat.unam.mx/index.php/jart/article/view/694/667

100.1.#.a: Soussi, Nassima; Bahaj, Mohamed

524.#.#.a: Soussi, Nassima, et al. (2017). Semantics preserving SQL-to-SPARQL query translation for Nested Right and Left Outer Join. Journal of Applied Research and Technology; Vol. 15 Núm. 5. Recuperado de https://repositorio.unam.mx/contenidos/4110147

245.1.0.a: Semantics preserving SQL-to-SPARQL query translation for Nested Right and Left Outer Join

502.#.#.c: Universidad Nacional Autónoma de México

561.1.#.a: Instituto de Ciencias Aplicadas y Tecnología, UNAM

264.#.0.c: 2017

264.#.1.c: 2019-06-14

653.#.#.a: SQL-to-SPARQL; Query transformation; Nested Left Outer Join; Nested Right Outer Join; Nested optional pattern

506.1.#.a: La titularidad de los derechos patrimoniales de esta obra pertenece a las instituciones editoras. Su uso se rige por una licencia Creative Commons BY-NC-SA 4.0 Internacional, https://creativecommons.org/licenses/by-nc-sa/4.0/legalcode.es, para un uso diferente consultar al responsable jurídico del repositorio por medio del correo electrónico gabriel.ascanio@icat.unam.mx

884.#.#.k: https://jart.icat.unam.mx/index.php/jart/article/view/694

001.#.#.#: 074.oai:ojs2.localhost:article/694

041.#.7.h: eng

520.3.#.a: Despite the emergence of semantic web due to its high performance in managing a large amount of data through semantic filters, the relational databases are still the most used. Therefore establishing a connection between both heterogeneous systems becomes a relevant need so as to bridge the gap between them. Regarding the query mapping from relational world to semantic world (SQL-to-SPARQL), some solutions have been developed to realize this transformation but unfortunately, all existing approaches do not consider the semantic correspondence between Left/Right Outer Join command(s) and Optional pattern(s). This weakness has motivated us to investigate in this direction and suggest an efficient solutionto deal with this problem by proposing, to the best of our knowledge, the first query mapping algorithm ensuring the semantic transformation of simple/nested Left/Right Outer Join command(s) in SQL queries to a simple/nested Optional pattern(s) in SPARQL equivalent ones without physical transformation of data.

773.1.#.t: Journal of Applied Research and Technology; Vol. 15 Núm. 5

773.1.#.o: https://jart.icat.unam.mx/index.php/jart

022.#.#.a: ISSN electrónico: 2448-6736; ISSN: 1665-6423

310.#.#.a: Bimestral

264.#.1.b: Instituto de Ciencias Aplicadas y Tecnología, UNAM

doi: https://doi.org/10.1016/j.jart.2017.05.001

harvesting_date: 2023-11-08 13:10:00.0

856.#.0.q: application/pdf

file_creation_date: 2017-11-23 17:15:47.0

file_modification_date: 2017-11-23 11:56:10.0

file_creator: Nassima Soussi

file_name: 40dcf91b0ac3716ebed33711c773dcb641544a690b0a8522097a0d49b65373c2.pdf

file_pages_number: 9

file_format_version: application/pdf; version=1.7

file_size: 1224318

last_modified: 2024-03-19 14:00:00

license_url: https://creativecommons.org/licenses/by-nc-sa/4.0/legalcode.es

license_type: by-nc-sa

No entro en nada

No entro en nada 2

Artículo

Semantics preserving SQL-to-SPARQL query translation for Nested Right and Left Outer Join

Soussi, Nassima; Bahaj, Mohamed

Instituto de Ciencias Aplicadas y Tecnología, UNAM, publicado en Journal of Applied Research and Technology, y cosechado de Revistas UNAM

Licencia de uso

Procedencia del contenido

Cita

Soussi, Nassima, et al. (2017). Semantics preserving SQL-to-SPARQL query translation for Nested Right and Left Outer Join. Journal of Applied Research and Technology; Vol. 15 Núm. 5. Recuperado de https://repositorio.unam.mx/contenidos/4110147

Descripción del recurso

Autor(es)
Soussi, Nassima; Bahaj, Mohamed
Tipo
Artículo de Investigación
Área del conocimiento
Ingenierías
Título
Semantics preserving SQL-to-SPARQL query translation for Nested Right and Left Outer Join
Fecha
2019-06-14
Resumen
Despite the emergence of semantic web due to its high performance in managing a large amount of data through semantic filters, the relational databases are still the most used. Therefore establishing a connection between both heterogeneous systems becomes a relevant need so as to bridge the gap between them. Regarding the query mapping from relational world to semantic world (SQL-to-SPARQL), some solutions have been developed to realize this transformation but unfortunately, all existing approaches do not consider the semantic correspondence between Left/Right Outer Join command(s) and Optional pattern(s). This weakness has motivated us to investigate in this direction and suggest an efficient solutionto deal with this problem by proposing, to the best of our knowledge, the first query mapping algorithm ensuring the semantic transformation of simple/nested Left/Right Outer Join command(s) in SQL queries to a simple/nested Optional pattern(s) in SPARQL equivalent ones without physical transformation of data.
Tema
SQL-to-SPARQL; Query transformation; Nested Left Outer Join; Nested Right Outer Join; Nested optional pattern
Idioma
eng
ISSN
ISSN electrónico: 2448-6736; ISSN: 1665-6423

Enlaces