Information Integration System Using Common Model for Disparate Data
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing information integration technologies face challenges in seamlessly integrating information from disparate data sources with different conceptual, contextual, and typographical representations, requiring manual integration and being non-extensible when new sources are added.
Innovation Solution
An information integration system that employs a set of integration services with connectors configured to integrate data across disparate information systems using a common model, overlaying the CMIS data model with common property definitions and a security model, enabling dynamic addition of new connectors and sources.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data warehousing technology is used to extract, transform, and load information from source databases into a data warehouse, then information integration is achieved, but manual integration is required when new sources are added and the entire new data set must be manually integrated to comply with the existing database schema
Solution Approach 1:
The patent introduces an information integration system as an intermediary layer between disparate information systems and end users. This system includes connectors that interface with multiple information systems, a unified index that consolidates data from all sources, and services that manage the integration logic. When new sources are added, the system automatically indexes their data through the unified index without requiring manual integration, thus resolving the contradiction between reliable information integration and reduced manual integration effort
Solution Approach 2:
The information integration system provides a universal platform that can connect to multiple types of information systems through standardized connectors. The unified index serves as a universal data structure that can accommodate data from various sources with different schemas. This multi-functional approach allows the system to handle diverse data sources uniformly, eliminating the need for manual integration when new sources are added while maintaining reliable information integration
2Adaptability or versatility
If virtual data integration solution is implemented with virtual schema and wrappers/adapters for each data source, then information from disparate sources can be integrated, but the system is not extensible and new wrappers or adapters must be written when new sources are added
Solution Approach 1:
The patent segments the information integration system into distinct modular components: connectors that interface with individual information systems, a unified index that consolidates data, and services that manage integration logic. Each connector is an independent module that can be added or modified without affecting other parts of the system. This segmentation allows the system to integrate disparate sources while maintaining low complexity, as each new source requires only a simple connector addition rather than comprehensive wrapper development
Solution Approach 2:
The unified index serves as an intermediary data structure that standardizes data from disparate information systems. Instead of creating complex wrappers for each source, the system uses the unified index as a common interface that all connectors feed into. This mediator approach simplifies the integration process, allowing new sources to be added by creating simple connectors that populate the unified index, thereby reducing device complexity while maintaining adaptability to disparate sources
3Reliability
If traditional information integration systems are used, then information from existing sources can be integrated, but the systems lack extensibility and require manual reconstruction when new sources are added
Solution Approach 1:
The information integration system implements dynamic extensibility through a service-oriented architecture where connectors, indexes, and services can be dynamically added, removed, or modified. The unified index is designed to adapt to new data sources without requiring system reconstruction. When new information sources are added, the system dynamically registers new connectors and automatically indexes their data, maintaining reliable information integration while providing high adaptability and extensibility
Data Source
AI summary
An information integration system may include a set of integration services embodied on one or more server machines in a computing environment. The set of integration services may include connectors communicatively connected to disparate information systems. The connectors may be configured for integrating data stored in the disparate information systems utilizing a common model employed by the set of integration services. The common model may overlay, augment, integrate, or otherwise utilize a content management interoperability services data model and may include common property definitions and a common security model. The common security model may include permissions particularly defined for use by the set of integration services. These common property definitions and permissions may be uniquely defined and utilized by the information integration system.