Parametric schema inference for massive JSON datasets
Baazizi, Mohamed-Amine; Colazzo, Dario; Ghelli, Giorgio; Sartiani, Carlo (2019), Parametric schema inference for massive JSON datasets, The VLDB Journal, 28, 4, p. 497-521. 10.1007/s00778-018-0532-7
TypeArticle accepté pour publication ou publié
Journal nameThe VLDB Journal
MetadataShow full item record
Laboratoire de Recherche en Informatique [LRI]
Laboratoire d'analyse et modélisation de systèmes pour l'aide à la décision [LAMSADE]
Dipartimento di Informatica [Pisa]
Dipartimento di Matematica Informatica ed Economia [DiMIE]
Abstract (EN)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.
Subjects / KeywordsJSON; Schema inference; Map-reduce; Spark; Big data collections
Showing items related by title and author.