Hasso-Plattner-Institut
Prof. Dr. Felix Naumann
 

Data Preparation

Data preparation is the process of transforming data before serving them to downstream tasks, such as data analytics, data cleaning, and machine learning. Much data do not meet the requirements of the following tasks, leading users, including both expert data scientists and novice data users, to frequently conduct ad-hoc data preparation. It is reported that preparing data is both labour-intensive and tedious work, which accounts for 50%-80% of the time spent in the whole data lifecycle. 

We explore to build a data preparation framework to achieve two goals:

  • Enable users to rapidly prepare data
  • Enable repeatability of scientific experiments by deriving suitable data preparation specification

Taxonomy

We propose for both metadata and preparators a respective taxonomy. We use the defined metadata and preparators to create standard specifications of data transformations. The whole taxonomies can be found here.

Team Members

Projects

  • Strudel - Structure Detection in Verbose CSV Files
  • AggreCol - Aggregation Detection in Verbose CSV Files
  • Mondrian - Detecting layout templates in complex multiregion files
  • Pollock - A Data Loading Benchmark                                    
  • Suragh - Syntactic Pattern Matching to Identify Ill-Formed Records
  • Survey -  Data Preparation: A Survey of Commercial Tools

Publications

  • Gerardo Vitagliano, Lucas Reisener, Lan Jiang, Mazhar Hameed, Felix Naumann: Mondrian: Spreadsheet Layout Detection. Proceedings of the International Conference on Management of Data (SIGMOD), 2022 (to appear) 
  • Lan Jiang, Gerardo Vitagliano, Mazhar Hameed, Felix Naumann: Aggregation Detection in CSV Files. Proceedings of the International Conference on Extending Database Technology (EDBT), 2022 (to appear)
  • Mazhar Hameed, Gerardo Vitagliano, Lan Jiang, Felix Naumann: SURAGH: Syntactic Pattern Matching to Identify Ill-Formed Records. Proceedings of the International Conference on Extending Database Technology (EDBT), 2022 (to appear)
  • Gerardo Vitagliano, Lan Jiang, Felix Naumann: Detecting Layout Templates in Complex Multiregion Files. PVLDB 15:(3), 2022
    [Paper]  [ACM] 
  • Lan Jiang, Gerardo Vitagliano, Felix Naumann: Structure Detection in Verbose CSV Files. Proceedings of the International Conference on Extending Database Technology (EDBT), 2021
    [Paper]  [GitHub] 
  • Mazhar Hameed, Felix Naumann: Data Preparation: A Survey of Commercial Tools. SIGMOD Record 49:(3), 2020
    [Paper]  [ACM] 
  • Koumarelas, Ioannis, Lan Jiang, and Felix Naumann. Data Preparation for Duplicate Detection. Journal of Data and Information Quality (JDIQ) 12, no. 3 (2020): 1–24.
  • Lan Jiang, Gerardo Vitagliano, Felix Naumann: A Scoring-based Approach for Data Preparator Suggestion. Lernen, Wissen, Daten, Analysen (LWDA), 2019
    [Paper] 

Related Work

We have compiled the related work corresponding to the individual research topics on data preparation. For the whole list please refer to here.

Contact

For further information on this project please fell free to contact us: Felix NaumannLan Jiang, Gerardo Vitagliano, Mazhar Hameed.