Skip to Main content Skip to Navigation
Conference papers

Schema Inference for Massive JSON Datasets

Abstract : Recent years have seen the widespread use of JSON as a data format to represent massive data collections. JSON data collections are usually schemaless. While this ensures several advantages, the absence of schema information has important negative consequences: the correctness of complex queries and programs cannot be statically checked, users cannot rely on schema information to quickly figure out structural properties that could speed up the formulation of correct queries, and many schema-based optimizations are not possible. In this paper we deal with the problem of inferring a schema from massive JSON data sets. 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 main contribution, which is the design of a schema inference algorithm, its theoretical study and its implementation based on Spark, enabling reasonable schema inference time for massive collections. Finally, we report about an experimental analysis showing the effectiveness of our approach in terms of execution time, precision and conciseness of inferred schemas, and scalability.
Complete list of metadata
Contributor : Mohamed-Amine Baazizi Connect in order to contact the contributor
Submitted on : Friday, March 17, 2017 - 12:55:01 PM
Last modification on : Friday, January 8, 2021 - 5:32:09 PM
Long-term archiving on: : Sunday, June 18, 2017 - 1:16:08 PM


Files produced by the author(s)



Mohamed-Amine Baazizi, Houssem Ben Lahmar, Dario Colazzo, Giorgio Ghelli, Carlo Sartiani. Schema Inference for Massive JSON Datasets. Extending Database Technology (EDBT), Mar 2017, Venise, Italy. ⟨10.5441/002/edbt.2017.21⟩. ⟨hal-01491765⟩



Record views


Files downloads