Demonstration of a Multiresolution Schema Mapping System

by   Zhongjun Jin, et al.

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.


page 1

page 2

page 3

page 4


Information Integration using the Typed Graph Model

Schema and data integration have been a challenge for more than 40 years...

An LSM-based Tuple Compaction Framework for Apache AsterixDB

Document database systems store self-describing records, such as JSON, "...

An Improved Generic ER Schema for Conceptual Modeling of Information Systems

The Entity-Relationship (ER) model is widely used for creating ER schema...

An Approach for System Analysis with MBSE and Graph Data Engineering

Model-Based Systems Engineering aims at creating a model of a system und...

Schema-Driven Actionable Insight Generation and Smart Recommendation

In natural language generation (NLG), insight mining is seen as a data-t...

Building Interoperable Electronic Health Records as Purpose-Driven Knowledge Graphs

When building a new application we are increasingly confronted with the ...

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