# Demonstration of a Multiresolution Schema Mapping System

## TL;DR

This paper introduces PRISM, a multiresolution schema mapping system that allows users to specify schema mappings using constraints of varying detail levels, simplifying the process for complex enterprise databases.

## Contribution

The paper presents a novel schema mapping system enabling multiresolution constraints, enhancing user flexibility over traditional sample-driven approaches.

## Key findings

- PRISM supports constraints of various resolutions including incomplete data and value ranges.
- Demonstration shows effective schema mapping in real enterprise databases.
- User interaction is more flexible compared to existing sample-driven methods.

## Abstract

Enterprise databases usually contain large and complex schemas. Authoring complete schema mapping queries in this case requires deep knowledge about the source and target schemas and is thereby very challenging to programmers. Sample-driven schema mapping allows the user to describe the schema mapping using data records. However, real data records are still harder to specify than other useful insights about the desired schema mapping the user might have. In this project, we develop a schema mapping system, PRISM, that enables multiresolution schema mapping. The end user is not limited to providing high-resolution constraints like exact data records but may also provide constraints of various resolutions, like incomplete data records, value ranges, and data types. This new interaction paradigm gives the user more flexibility in describing the desired schema mapping. This demonstration showcases how to use PRISM for schema mapping in a real database.