Parametric schema inference for massive JSON datasets - LAMSADE (Laboratoire d'Analyse et de Modélisation des Systèmes pour l'Aide à la Décision) Accéder directement au contenu
Article Dans Une Revue The VLDB Journal Année : 2019

Parametric schema inference for massive JSON datasets

Résumé

In recent years, JSON established itself as a very popular data format for representing massive data collections. JSON data collections are usually schemaless. While this ensures several advantages, the absence of schema information has important negative consequences as well: Data analysts and programmers cannot exploit a schema for a reliable description of the structure of the dataset, the correctness of complex queries and programs cannot be statically checked, and many schema-based optimizations are not possible. In this paper, we deal with the problem of inferring a schema from massive JSON datasets. We first identify a JSON type language which is simple and, at the same time, expressive enough to capture irregularities and to give complete structural information about input data. We then present our contributions, which are the design of a parametric and parallelizable schema inference algorithm, its theoretical study, and its implementation based on Spark, enabling reasonable schema inference time for massive collections. Our algorithm is parametric as the analyst can specify a parameter determining the level of precision and conciseness of the inferred schema. Finally, we report about an experimental analysis showing the effectiveness of our approach in terms of execution time, conciseness of inferred schemas, and scalability.

Dates et versions

hal-02301677 , version 1 (30-09-2019)

Identifiants

Citer

Mohamed-Amine Baazizi, Dario Colazzo, Giorgio Ghelli, Carlo Sartiani. Parametric schema inference for massive JSON datasets. The VLDB Journal, 2019, 28 (4), pp.497-521. ⟨10.1007/s00778-018-0532-7⟩. ⟨hal-02301677⟩
230 Consultations
0 Téléchargements

Altmetric

Partager

Gmail Facebook X LinkedIn More