A blackboard-based cooperative system for schema integration

摘要

Corporate information system environments are heterogeneous, consisting of multiple and independently managed databases. Many applications that assist decision making call for access to data from multiple heterogeneous databases. To facilitate this, there needs to be an integrated representation of the underlying databases that allows users to query multiple databases simultaneously. The process of deriving this integrated representation is called schema integration. Schema integration is time consuming and complex, as it requires a thorough understanding of the underlying database semantics. Since no data model can capture the entire real world semantics of each database's objects, this process requires human agent assistance. Although certain aspects of schema integration can be automated, interaction with designers and users is still necessary. We describe a four-level blackboard architecture that supports schema integration and provide a detailed description of the communication among human and computational agents that this system allows.