Template-Based Schema Matching of Multi-Layout Tenancy Schedules:A Comparative Study of a Template-Based Hybrid Matcher and the ALITE Full Disjunction Model
Tim Uilkema 1 , Yao Ma 1 , Seyed Sahand Mohammadi Ziabari 1,2 , Joep van Vliet 3 · 2025
Read Template-Based Schema Matching of Multi-Layout Tenancy Schedules:A Comparative Study of a Template-Based Hybrid Matcher and the ALITE Full Disjunction Model by Tim Uilkema 1 , Yao Ma 1 , Seyed Sahand Mohammadi Ziabari 1,2 , Joep van Vliet 3 (2025) in the Tower of Babel, a free online library of public-domain works preserved in clean, searchable text. No sign-up. The full text is served as a plain-text file at a predictable URL, where text is present: https://antarctic-labs.com/tower-of-babel/arxiv-2507-02020.txt.
Introduction
Tim Uilkema and three co-authors wrote this 2025 arXiv paper on merging tenancy schedules, the rent rolls that real estate firms keep in wildly different table layouts. Forcing them into one database by hand is slow, and a leading automatic method prizes completeness so highly that it spawns bloated, sparse schemas few can use.
Their matcher instead aims at a fixed target schema agreed by the business. It scores column pairs by name likeness and by the data inside, then assigns matches with an algorithm that finds the best global pairing. Against hand-labeled truth, tuned settings reached a strong accuracy score with under half the cells empty. The rival method scored lower and left three-quarters empty. The authors say business knowledge, encoded as templates, beats blind completeness for usable data.
Catalog record
| CREATOR | Tim Uilkema 1 , Yao Ma 1 , Seyed Sahand Mohammadi Ziabari 1,2 , Joep van Vliet 3 |
|---|---|
| YEAR | 2025 |
| COLLECTION | PAPERS |
| FORMAT | TXT |
| FILE SIZE | 77 KB |
| VERSION | 1.0 |
| LICENSE | http://creativecommons.org/licenses/by/4.0/ |
| RIGHTS | CC BY |
| SOURCE | arXiv |
Source: https://arxiv.org/abs/2507-02020
Browse the full library · About the Tower of Babel
Full text
The opening of the work, from the library's hosted text:
Template-Based Schema Matching of Multi-Layout Tenancy Schedules:A Comparative Study of a Template-Based Hybrid Matcher and the ALITE Full Disjunction Model Tim Uilkema 1 , Yao Ma 1 , Seyed Sahand Mohammadi Ziabari 1,2 , Joep van Vliet 3 Abstract . The lack of standardized tabular formats for tenancy schedules across real estate firms creates significant inefficiencies in data integration. Existing automated integration methods, such as Full Disjunction (FD)-based models like ALITE, prioritize completeness but result in schema bloat, sparse attributes and limited business usability. We propose a novel hybrid, template-based schema matcher that aligns multi-layout tenancy schedules to a predefined target schema. The matcher combines schema- (Jaccard, Levenshtein) and instance-based metrics (data types, distributions) with globally optimal assignments determined via the Hungarian Algorithm. Evaluation against a manually labeled ground truth demonstrates substantial improvements, with grid search optimization yielding a peak F1-score of 0.881 and an overall null percentage of 45.7%. On a separate ground truth of 20 semantically similar column sets, ALITE achieves an F1-score of 0.712 and 75.6% nulls. These results suggest that combining structured business knowledge with hybrid matching can yield more usable and business-aligned schema mappings. The approach assumes cleanly extracted tabular input, future work could explore extending the matcher to support complex, composite tables. Github Repository https://github.com/TUilkema 1. Introduction Organizations increasingly rely on data-driven systems to support their decision-making. In the real estate industry, a significant amount of valuable information is stored in unstructured data formats such as PDFs, which often contain critical data for operations. An example is tenancy schedules, which are mostly stored in PDFs and formatted in tables. These documents use different table templates to store the same attribute information (Price, total area rented, start date lease). These documents are crucial for property management, financial reporting, and general business intelligence applications. However, manually extracting large quantities of data is impractical and highly time-consuming. Capturing relationships among heterogeneous datasets, commonly referred to as schema matching, is a fundamental challenge in data integration ( Koutras et al. 2021b ) . Schema matching methods fall into three main categories ( Koutras et al. 2021b ) : • Schema-based approaches which rely on metadata such as column names and data types (Cupid ( Madhavan et al. [n. d.] ) , COMA ( Do and Rahm 2002 ) ). • Instance-based approach which analyze data values to determine similarity. • Hybrid approaches which combine both schema and instance-based approaches. Existing work has mostly focused on structured databases, with significant work in holistic or automated schema integration techniques. Effectively processing unstructured data remains a key challenge in data-intensive industries, particularly due to the complexity and inconsistency of document formats ( Mishra and Misra 2017 ) . A major obstacle in this domain is the diversity of layouts in unstructured documents, which complicates automated information extraction. Several approaches have been developed to address schema matching and table integration, these focus on structured datasets. One recent framework, ALITE uses an approach that automatically merges tables from data lakes into one large unified schema while retaining all columns. ( Khatiwada et al. 2022 ) . Full Disjunction (FD) used in ALITE retains all columns and unifies tables into a large table. Unique and sparse attributes which are retained introduce schema bloat ( Paulraj 2024 ) . This FD method retains all information, however, it also introduces possible schema bloat with many columns containing null values. While this ensures no loss of information, it is not optimized for business applications, where a more concise and meaningful representation of critical attributes is required. A potential alternative is a template-based approach, where users define a target schema with all the essential columns. Traditional schema matching methods are used to map tables accordingly. The template-based approach, introduced in this paper, explicitly allows for the definition of a extendable target schema, ensuring that only essential attributes are integrated, without requiring separate templates for each table layout. Current research highlights the difficulty of handling varied table structures and points out a gap in how existing methods struggle to generalize across different layouts and integrate extracted data into a unified structured format ( Baviskar et al. 2021 ) . To address this gap, this research aims to introduce a template-based approach using schema matching methods to automate table integration. This research focuses on comparing the FD baseline of ALITE with a novel template-based based hybrid matcher. This research aims to apply and adapt hybrid schema matching methods to unify tables. This research hopes to address the challenge of harmonizing diverse table layouts into a single structured format. The study will focus on aligning schemas into a unified output, with an emphasis on handling the diverse table layouts of different tenancy schedules found in the real estate business. A Data Requirements Document (DRD) specifying attributes and layout used in internally by CBRE is chosen as the target schema. The hybrid matcher combines schema-based similarity metrics (such as name and string similarity) and instance-based similarity metrics (such as value type and distribution similarity) to improve alignment accuracy. By integrating multiple matching metrics, the hybrid approach hopes to provide a more robust accuracy across varied table layouts. In doing so, this research addresses the challenge of automated matching in tenancy schedules of varying table layouts by using hybrid matching signals and a novel target schema. This study investigates the effectiveness of a hybrid template-based schema matcher in aligning multi-layout tenancy schedules to a structured target schema, the DRD format. The research specifically compares this hybrid approach against a FD baseline, which retains all attributes across input tables at the cost of introducing redundancy and null-heavy schemas. The proposed matcher combines both schema-based and instance-based similarity metrics and leverages target-specific metric weights to guide the matching process. The evaluation assesses not only the alignment accuracy—using F1 scores against a manually annotated gold standard—but also examines how grid search optimization of these metric weights influences matching performance. In addition, schema usability is evaluated through compactness and null density, offering insight into the practicality of the resulting integrated schemas in downstream applications. The remainder of this paper is structured as follows. Section 2 surveys prior work on schema matching and table integration, highlighting key limitations of current approaches. Section 3 introduces the hybrid matcher and FD baseline, detailing their underlying mechanisms. Section 4 presents the evaluation methodology and experimental setup, followed by the results and discussion in Section 5. Finally, Section 6 concludes the paper with reflections on contributions and outlines directions for future research. 2. Related Work Recent research has focused on integrating heterogeneous tabular data from diverse sources, particularly in the context of data lakes and (semi or un)-structured documents. A recent survey emphasizes that different tasks such as table extraction, schema matching and schema augmentation are distinct yet related components of the tabular data augmentation pipeline. Each of these tasks has unique technical challenges and goals ( Cui et al. 2024 ) . Approaches such as ALITE ( Khatiwada et al. 2022 ) and DeepJoin ( Dong et al. 2023 ) represent state-of-the-art methods for combining tables through schema matching. ALITE applies Full Disjunction (FD) to preserve all attributes across all documents, this ensures completeness but at the cost of producing a