Multi-SQL: An extensible multi-model data query language

11/17/2020
by   Yu Yan, et al.
0

Big data management aims to establish data hubs that support data in multiple models and types in an all-around way. Thus, the multi-model database system is a promising architecture for building such a multi-model data store. For an integrated data hub, a unified and flexible query language is incredibly necessary. In this paper, an extensible and practical query language–Multi-SQL is proposed to realize the unified management of multi-model data considering the co-processing of multi-model data. To the best of our knowledge, Multi-SQL is the first query language based on various data models. We take four popular data models, i.e., RELATION, GRAPH, KV, DOCUMENT, as the foundation of Multi-SQL design. Multi-SQL can also be expanded to suit more complicated scenarios as it is flexible to add other data models. Moreover, we provide a formal semantic definition of the core features of Multi-SQL and propose an effective algorithm based on equivalence class rule (ECT) to process multi-query. Compared with some existing popular databases' query languages, experimental results demonstrate that Multi-SQL is remarkable in the case of complex multi-queries.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
10/07/2022

Integration of Skyline Queries into Spark SQL

Skyline queries are frequently used in data analytics and multi-criteria...
research
02/08/2018

SQL Query Completion for Data Exploration

Within the big data tsunami, relational databases and SQL are still ther...
research
02/06/2018

Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries

Deciding the equivalence of SQL queries is a fundamental problem in data...
research
05/21/2021

ConQuer-92 – The revised report on the conceptual query language LISA-D

In this report the conceptual query language ConQuer-92 is introduced. T...
research
12/12/2021

Graph Pattern Matching in GQL and SQL/PGQ

As graph databases become widespread, JTC1 – the committee in joint char...
research
05/28/2019

One SQL to Rule Them All

Real-time data analysis and management are increasingly critical for tod...
research
12/11/2009

Design of Intelligent layer for flexible querying in databases

Computer-based information technologies have been extensively used to he...

Please sign up or login with your details

Forgot password? Click here to reset