Exploring schema similarity at multiple resolutions

Large, dynamic, and ad-hoc organizations must frequently initiate data integration and sharing efforts with insufficient awareness of how organizational data sources are related. Decision makers need to reason about data model interactions much as they do about data instance interactions in OLAP: at multiple levels of granularity. We demonstrate an integrated environment for exploring schema similarity across multiple resolutions. Users visualize and interact with clusters of related schemas using a tool named Affinity. Within any cluster, users may drill-down to examine the extent and content of schema overlap. Further drill down enables users to explore fine-grained element-level correspondences between between two selected schemas. Categories and Subject Descriptors: H.5 Information Interfaces and Presentation. I.5.3 Clustering. General Terms: Human Factors, Design, Algorithms Keywords. Schema Similarity Exploration

• Type: Conference
• Year: 2010
• Where: SIGMOD
• Authors: Ken Smith, Craig Bonaceto, Chris Wolf, Beth Yost, Michael Morse, Peter Mork, Doug Burdick
• Keywords: Data Instance Interactions, Database, Organizational Data Sources, Schema Similarity, SIGMOD 2010