Demonstration of a Multiresolution Schema Mapping System

12/18/2018
by   Zhongjun Jin, et al.
0

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.

READ FULL TEXT
POST COMMENT

Comments

There are no comments yet.

Authors

page 1

page 2

page 3

page 4

07/20/2021

Information Integration using the Typed Graph Model

Schema and data integration have been a challenge for more than 40 years...
10/17/2019

An LSM-based Tuple Compaction Framework for Apache AsterixDB

Document database systems store self-describing records, such as JSON, "...
02/27/2020

An Improved Generic ER Schema for Conceptual Modeling of Information Systems

The Entity-Relationship (ER) model is widely used for creating ER schema...
01/17/2022

An Approach for System Analysis with MBSE and Graph Data Engineering

Model-Based Systems Engineering aims at creating a model of a system und...
09/17/2021

Towards Handling Unconstrained User Preferences in Dialogue

A user input to a schema-driven dialogue information navigation system, ...
06/15/2020

Needles in the 'Sheet'stack: Augmented Analytics to get Insights from Spreadsheets

Business intelligence (BI) tools for database analytics have come a long...
This week in AI

Get the week's most popular data science and artificial intelligence research sent straight to your inbox every Saturday.