TY - JOUR
AU - Frozza, Angelo Augusto
AU - Defreyn, Eduardo Dias
AU - Mello, Ronaldo dos Santos
PY - 2020
TI - A Process for Inference of Columnar NoSQL Database Schemas
JF - Anais do Simpósio Brasileiro de Banco de Dados (SBBD); 2020: Anais do XXXV Simpósio Brasileiro de Bancos de Dados
DO - 10.5753/sbbd.2020.13637
KW -
N2 - Although NoSQL Databases do not require a schema a priori, to be aware of the database schema is essential for activities like data integration, data validation or data interoperability. This paper presents a process for inference of columnar NoSQL DB schemas. We validate the proposed process through a prototype tool that is able to extract schemas from the HBase columnar NoSQL database system. HBase was chosen as a case study because it is one of the most popular columnar NoSQL solutions. When compared to related work, we novel by proposing a simple solution for the inference of column data types for columnar NoSQL databases that store only byte arrays as column values, as well as a generated schema that follows the JSON Schema format.
UR - https://sol.sbc.org.br/index.php/sbbd/article/view/13637