;-) WINK WINK System: Intelligent Integration Framework Maurizio Vincini UniMORE Researcher Università di Modena e Reggio Emilia Università di Modena e Reggio Emilia WINK Architecture ;-) WHALES Client tier Web Server WINK Web Application Business logic tier Virtual Integrated Cockpit WHALES MIKS client requestor service provider service description service provider client requestor service description Università di Modena e Reggio Emilia Data tier Shared Data Data sources WINK Integration Framework ;-) WINK MIKS is an Agent mediator-based system for integrating multiple enterprises’ data sources into a single portal system. Distributed information stored in multiple, heterogeneous sources Global view Integration process Università di Modena e Reggio Emilia • Semantic reconciliation of multiple heterogeneous ontologies • Information fusion and query Agent support • Mobile Agents support in order to improve system flexibility and query performance (based on JADE) References I. Benetti, D. Beneventano, S. Bergamaschi, F. Guerra, M. Vincini, ‘An Information Integration Framework for ECommerce’. IEEE Intelligent Systems Magazine, January/February 2002. Semantic Information Integration process ;-) WINK Local schemata Common Thesaurus Clusters Global Virtual View with mapping tables Università di Modena e Reggio Emilia Artificial Intelligence reasoning (Description Logic) Cluster technique Lexical relationships (WordNet) Common Thesaurus (Domain Ontology) ;-) WINK Set of terminological relationships between classes and attributes names (terms) expresses both intra-schema and inter-schema knowledge Relationships added to Common Thesaurus: • schema derived • lexicon derived (WordNet) • designer supplied Università di Modena e Reggio Emilia • inferred exploiting ODB-Tools capabilities Semantic Information Integration process ;-) WINK Local schemata Common Thesaurus Clusters Global Virtual View with mapping tables Università di Modena e Reggio Emilia Artificial Intelligence reasoning (Description Logic) Cluster technique Lexical relationships (WordNet) Alenia test case GVV ;-) WINK Mapping table Università di Modena e Reggio Emilia Runtime: Query Processing Management ;-) WINK – – – – Discovering the relevant local sources Query rewriting w.r.t. local sources Independent local data retrieving Unified data answers In MIKS (WINK Integration Framework): – OQL-like query over GVV – Query Reformulation/Optimization – Local sub-queries execution – Mediated query result obtained by object fusion Università di Modena e Reggio Emilia Query Example ;-) WINK User Query: Select Activity, Effort from Activity where Requirement=‘IC-5’ and Closed=‘Y’ AIVDB: Q1 Select PROD_ID from VER_DOC_LINK where REQ_SEQ=‘IC-5’ and REOPENING=‘Y’ Università di Modena e Reggio Emilia GVV WHALES: Q2 Select Activity, Effort, Test_ID from Work_Plan Fusion Select Activity, Effort from Q1, Q2 where Q1.PROD_ID= Q2.Test_ID WINK Integration Framework WINK Project Collaboration Portal ;-) client requestor Business Logic ASP XSL HTML WINK WINK Integration Framework service provider Service Agent HTTP XML WINK Agency Query Agents GVV Wrapper Agent Wrapper Agent Wrapper Agent Wrapper Agent WHALES Storage DB AIVDB+ NCRDB Wrapper Agent Università di Modena e Reggio Emilia SAP Agent-based vs. Service-centric applications ;-) WINK Expected advantages: • Agent Mobility – Distributed computation – Decreased communication costs – Increased information availability even during network failure • Mediation: Intelligence and coordination – Semantic view of the physical query – Enables asynchronous processing – Warning on source data structure changes Università di Modena e Reggio Emilia DEMO ;-) WINK • Collaboration Portal: – Home Page – Project Plans (from MS Project 2000) – Function and Reports • Agent-based user-defined queries – Purchase Requests Università di Modena e Reggio Emilia