Publication:
SkiQL: A Unified Schema Query Language

Thumbnail Image
Files
1-s2.0-S0169023X23000940-main.pdf(2.75 MB)
Date
2023-04
relationships.isAuthorOfPublication
relationships.isSecondaryAuthorOf
relationships.isDirectorOf
Authors
Fernández Candel, Carlos ; García Molina, Jesús J. ; Sevilla Ruiz, Diego
item.page.secondaryauthor
item.page.director
Publisher
Elsevier
publication.page.editor
publication.page.department
Ingeniería y Tecnología de Computadores
DOI
https://doi.org/10.1016/j.datak.2023.102234
item.page.type
info:eu-repo/semantics/article
Description
Abstract
Most NoSQL systems are schema-on-read: data can be stored without first having to declare a schema that imposes a structure. This schemaless feature offers flexibility to evolve data-intensive applications when data change frequently. However, freeing from declaring schemas does not mean their absence, but rather that they are implicit in data and code. Therefore, diagramming tools similar to those available for relational systems are also needed to help developers and administrators to design and to understand NoSQL schemas. Visualizing diagrams is not practical if schemas contain hundreds of database entities, so exploration or query facilities are then needed. In schemaless NoSQL stores, data of the same entity can be stored with different structure (e.g., non-uniform types and optional fields), which can increase the difficulty of having readable diagrams. NoSQL schema management tools should therefore have three main components: schema extraction, schema visualization, and schema query. As there are four main NoSQL data models, it is convenient for such tools to be built on a generic data model so that they provide platform-independence (of data models and data stores) to query and visualize schemas. With the aim of favoring the creation of generic database tools, the authors of this paper defined the U-Schema unified data model that integrates the four main NoSQL data models as well as the relational model. This paper is focused on querying NoSQL and relational schemas which are represented as U-Schema models. We present the SkiQL language designed on U-Schema to achieve a platform-independent schema query service. SkiQL provides two constructs: schema-query and relationship-query. The former allows to obtain information of entity or relationship types, and the latter that of the aggregations or references (relations among types). We will show how SkiQL was evaluated by calculating well-known metrics for languages as well as using a survey with developers with experience in NoSQL.
publication.page.subject
Generic Schema Query Language , NoSQL Logical Schemas , NoSQL Schema Visualization , Unified Data Model
Citation
Data & Knowledge Engineering 148(9):102234, November 2023
URI
http://hdl.handle.net/10201/138202
item.page.embargo
Collections
Artículos
Ir a Estadísticas