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

page 1

page 2

page 3

page 4

research
07/20/2021

Information Integration using the Typed Graph Model

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

An LSM-based Tuple Compaction Framework for Apache AsterixDB

Document database systems store self-describing records, such as JSON, "...
research
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...
research
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...
research
07/24/2023

Schema-Driven Actionable Insight Generation and Smart Recommendation

In natural language generation (NLG), insight mining is seen as a data-t...
research
05/10/2023

Building Interoperable Electronic Health Records as Purpose-Driven Knowledge Graphs

When building a new application we are increasingly confronted with the ...
research
09/17/2021

Towards Handling Unconstrained User Preferences in Dialogue

A user input to a schema-driven dialogue information navigation system, ...

Please sign up or login with your details

Forgot password? Click here to reset