SkiQL: A Unified Schema Query Language

Fernández Candel, Carlos; García Molina, Jesús J.; Sevilla Ruiz, Diego

Publication:
SkiQL: A Unified Schema Query Language

dc.contributor.author	Fernández Candel, Carlos
dc.contributor.author	García Molina, Jesús J.
dc.contributor.author	Sevilla Ruiz, Diego
dc.contributor.department	Ingeniería y Tecnología de Computadores
dc.date.accessioned	2024-01-30T18:42:19Z
dc.date.available	2024-01-30T18:42:19Z
dc.date.issued	2023-04
dc.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.	es
dc.format	application/pdf	es
dc.format.extent	20	es
dc.identifier.citation	Data & Knowledge Engineering 148(9):102234, November 2023
dc.identifier.doi	https://doi.org/10.1016/j.datak.2023.102234
dc.identifier.issn	1872-6933
dc.identifier.issn	0169-023X
dc.identifier.uri	http://hdl.handle.net/10201/138202
dc.language	eng	es
dc.publisher	Elsevier	es
dc.relation	This work has been funded by the Spanish Ministry of Science and Innovation, project grant PID2020-117391GB-I00.	es
dc.relation.publisherversion	https://www.sciencedirect.com/science/article/pii/S0169023X23000940?via%3Dihub	es
dc.rights	Attribution-NonCommercial-NoDerivates 4.0 International
dc.rights.accessRights	info:eu-repo/semantics/openAccess
dc.rights.uri	http://creativecommons.org/licenses/by-nc-nd/4.0/
dc.subject	Generic Schema Query Language	es
dc.subject	NoSQL Logical Schemas	es
dc.subject	NoSQL Schema Visualization	es
dc.subject	Unified Data Model	es
dc.subject.other	CDU::0 - Generalidades.::00 - Ciencia y conocimiento. Investigación. Cultura. Humanidades.::004 - Ciencia y tecnología de los ordenadores. Informática.::004.2 - Arquitectura informática	es
dc.title	SkiQL: A Unified Schema Query Language	es
dc.type	info:eu-repo/semantics/article	es
dspace.entity.type	Publication	es