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.



There are no comments yet.


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...

Towards Handling Unconstrained User Preferences in Dialogue

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

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.