Situational data integration with data services and nested table

  • Authors:

  • Yanbo Han;Guiling Wang;Guang Ji;Peng Zhang

  • Affiliations:

  • Research Center for Cloud Computing, North China University of Technology, Beijing, China;Research Center for Cloud Computing, North China University of Technology, Beijing, China;Research Center for Cloud Computing, North China University of Technology, Beijing, China and Graduate University of Chinese Academy of Sciences, Beijing, China;Research Center for Cloud Computing, North China University of Technology, Beijing, China and Graduate University of Chinese Academy of Sciences, Beijing, China

  • Venue:
  • Service Oriented Computing and Applications
  • Year:
  • 2013

Quantified Score

Hi-index 0.00

Visualization

Abstract

Situational data integration is often ad hoc, involves active participation of business users, and requires just-in-time treatment. Agility and end-user programming are of importance. The paper presents a spreadsheet-like programming environment called Mashroom, which offers required agility and expressive power to support situational data integration by non-professional users. In Mashroom, various data sources are encapsulated as data services with nested tables as their unified data model both for internal processing and for external uses. Users can operate on the nested tables interactively. Mashroom also supports the basic control flow patterns. The expressive power of Mashroom is analyzed and proved to be richer than N1NF relational algebra. All the XQuery expressions can be mapped to Mashroom operations and formulas. Experiments have revealed the potentials of Mashroom in situational data integration.