US6308178B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
System for integrating data among heterogeneous systems
Assignee: Isix Ip LLC
•
Filing: 1999-10-21
•
Granted: 2001-10-23
•
Expires: 2019-10-21
Abstract
Abstract A system for integrating data among heterogeneous source applications and destination applications including a knowledge repository containing temporary data storage for storing data from the source applications during processing for population in the destination applications, a library of data elements each providing a discrete data manipulation friction, configuration data storage for storing user-provided information describing the integration environment, and a plurality of add-on modules or cartridges which each include a plurality of predefined instruction sets defining chains of data elements to perform interface functions corresponding to a particular destination application. The underlying interface communication and processing functions are performed by an active component (or engine) according to the configuration data and the module instruction sets. The active component is driven by the repository data to load source data into the temporary data storage, translate, synchronize, and validate that data, then interface the data to a destination application. A configuration interface permits the user to configure the system.
Inventors
- 👤 Chia-Pei Chang
- 👤 Brian J. Connolly
- 👤 Eric Blackledge
- 👤 Robert John Hoffman
- 👤 Bob Homan
- 👤 Klaus Schulz
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-02 09:00
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/258; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99936; Y10S707/99941; Y10S707/99944; Y10S707/99945
Claims Analysis
Total Claims: 37
Claim 1
Independent Claim
120 words
A system for integrating data among heterogeneous source applications and destination applications, comprising: a repository of information relating to the source applications and the destination applications, the repository including a plurality of data elements each being capable of performing a discrete operation on a piece of data, and a first module including a plurality of instruction sets, each instruction of each instruction set activating a data element; and an active component connected to the repository having an input for loading data from the source applications, and an output for populating the destination applications with processed data, the active component processing the data from the source applications by activating data elements according to the plurality of instruction sets in the module.
Claim 2
Independent Claim
120 words
A system for integrating data among heterogeneous source applications and destination applications, comprising: a repository of information relating to the source applications and the destination applications, the repository including a plurality of data elements each being capable of performing a discrete operation on a piece of data, and a first module including a plurality of instruction sets, each instruction of each instruction set activating a data element; and an active component connected to the repository having an input for loading data from the source applications, and an output for populating the destination applications with processed data, the active component processing the data from the source applications by activating data elements according to the plurality of instruction sets in the module.
Claim 3
Dependent Claim
21 words
The system of claim 1 wherein the plurality of instruction sets are predefined to facilitate interface with a particular destination application.
Claim 4
Dependent Claim
62 words
The system of claim 1 further comprising a second module including a plurality of instruction sets, each instruction of each instruction set activating a data element, the first module plurality of instruction sets being defined for interface with a first group of destination applications, the second module plurality of instruction sets being defined for interface with a second group of destination applications.
Claim 5
Dependent Claim
36 words
The system of claim 3 wherein at least one data element of the plurality of data elements is activated by both the first module plurality of instruction sets and the second module plurality of instruction sets.
Claim 6
Dependent Claim
45 words
The system of claim 3 wherein the repository further includes configuration data storage for storing configuration data describing data in the source applications, the configuration data storage including a first portion used by the first module and a second portion used by the second module.
Claim 7
Dependent Claim
19 words
The system of claim 1 wherein the temporary data and the data elements are stored in a relational database.
Claim 8
Dependent Claim
16 words
The system of claim 1 wherein the repository is capable of receiving a plurality of modules.
Claim 9
Dependent Claim
15 words
The system of claim 1 wherein the destination applications are included within an ERP product.
Claim 10
Dependent Claim
19 words
The system of claim 1 wherein the active component is capable of loading entire files from a source application.
Claim 11
Dependent Claim
19 words
The system of claim 1 wherein the repository further includes a library for storing the plurality of data elements.
Claim 12
Dependent Claim
29 words
The system of claim 1 wherein the repository further includes temporary data storage for storing data temporarily as the data is being processed for introduction into a destination application.
Claim 13
Dependent Claim
41 words
The system of claim 11 wherein the first module includes a plurality of predefined tables which are selectably installed in the temporary data storage to receive temporary data, each of the predefined tables being configured for compatibility with a destination application.
Claim 14
Dependent Claim
28 words
The system of claim 12 wherein each predefined table includes a plurality of selectable destination tables residing within the destination applications which are compatible with the predefined table.
Claim 15
Dependent Claim
49 words
The system of claim 11 wherein the repository further includes configuration data storage for storing configuration data describing data in the source applications and data in the temporary data storage, the active component loading data from the source applications into the temporary data storage according to the configuration data.
Claim 16
Dependent Claim
32 words
The system of claim 14 further comprising a configuration interface for generating the configuration data, the configuration interface providing a series of screens to assist the user in describing the source applications.
Claim 17
Dependent Claim
36 words
The system of claim 14 wherein the active component input is a loader which reads data in a source application and populates the temporary data storage with the source application data according to the configuration data.
Claim 18
Dependent Claim
47 words
The system of claim 14 wherein the active component further includes a validator which communicates with the module to verify that the data residing in the temporary data storage is consistent with the configuration data associated with the module and properly formatted for populating the destination application.
Claim 19
Dependent Claim
25 words
The system of claim 1 wherein the active component may be activated by the destination application to integrate data periodically according to a predetermined schedule.
Claim 20
Dependent Claim
23 words
The system of claim 1 wherein each of the plurality of data elements includes related inputs, related outputs, mapping rules, and validation rules.
Claim 21
Dependent Claim
33 words
The system of claim 19 wherein each of the data element outputs may populate a destination application, provide an input to another data element, or indicate the context of another data element's operation.
Claim 22
Dependent Claim
42 words
The system of claim 1 wherein the active component further includes a translator which communicates with the module to translate data from the source application into data acceptable to the destination application according to the plurality of instruction sets in the module.
Claim 23
Dependent Claim
52 words
The system of claim 1 wherein the active component further includes a synchronizer which compares the data loaded from the source application into the temporary storage to data residing in the destination application and returns to the temporary data storage only data which differs from the data residing in the destination application.
Claim 24
Independent Claim
176 words
A system for integrating data among heterogeneous source applications and destination applications, comprising: configuration data storage for storing configuration data relating to the source applications; temporary data storage for storing temporary data being integrated among the source and the destination applications; a library of data elements, each data element performing a predefined function; a first module including a plurality of instruction sets, each instruction set specifying a plurality of data elements to form a chain of data elements; and an active component operably associated with the configuration data storage, the temporary data storage, the library, and the first module, the active component including a loader for loading data from the source applications to the temporary data storage according to the configuration data relating to the source applications, and an interfacer for populating the destination applications with data from the temporary data storage after the data is processed by the active component, the active component processing the data by communicating with the first module and activating data element chains according to instruction sets of the first module.
Claim 25
Independent Claim
176 words
A system for integrating data among heterogeneous source applications and destination applications, comprising: configuration data storage for storing configuration data relating to the source applications; temporary data storage for storing temporary data being integrated among the source and the destination applications; a library of data elements, each data element performing a predefined function; a first module including a plurality of instruction sets, each instruction set specifying a plurality of data elements to form a chain of data elements; and an active component operably associated with the configuration data storage, the temporary data storage, the library, and the first module, the active component including a loader for loading data from the source applications to the temporary data storage according to the configuration data relating to the source applications, and an interfacer for populating the destination applications with data from the temporary data storage after the data is processed by the active component, the active component processing the data by communicating with the first module and activating data element chains according to instruction sets of the first module.
Claim 26
Dependent Claim
24 words
The system of claim 23 wherein the plurality of instruction sets of the first module are configured to operate with a particular destination application.
Claim 27
Dependent Claim
48 words
The system of claim 23 further comprising a second module including a plurality of instruction sets specifying chains of data elements, at least one of the data elements specified by the instruction sets of the first module also being specified by the instruction sets of the second module.
Claim 28
Dependent Claim
22 words
The system of claim 23 wherein the configuration data, the temporary data, and the data elements are stored in a relational database.
Claim 29
Dependent Claim
36 words
The system of claim 23 wherein the first module includes a plurality of predefined tables which are selectably installed in the temporary data storage, each predefined table being capable of receiving data from a source application.
Claim 30
Dependent Claim
17 words
The system of claim 27 wherein each predefined table is configured for compatibility with a destination application.
Claim 31
Dependent Claim
19 words
The system of claim 23 wherein each of the data elements includes inputs, outputs, mapping rules, and validation rules.
Claim 32
Dependent Claim
35 words
The system of claim 23 further comprising a configuration interface including a series of screens for permitting the user to describe the source applications, the configuration interface generating configuration data relating to the source applications.
Claim 33
Dependent Claim
33 words
The system of claim 23 wherein the active component further includes a validator which communicates with the first module to verify the content and format of the temporary data against the configuration data.
Claim 34
Dependent Claim
32 words
The system of claim 23 wherein the active component further includes a translator which communicates with the first module to translate data from the source applications according to the data element chains.
Claim 35
Dependent Claim
57 words
The system of claim 23 wherein the active component further includes a synchronizer which carries out a net change function wherein the synchronizer compares data in the destination applications to the temporary data and updates the temporary data such that the temporary data reflects the differences between the temporary data and the data in the destination applications.
Claim 36
Dependent Claim
152 words
A data integration system for providing end-to-end integration between a plurality of source applications and a destination application, the system comprising: repository means for containing information relating to the source applications and the destination application, the repository means including temporary storage means for storing temporary data from the source applications, configuration storage means for storing configuration data describing data in the source applications and in the temporary storage means, library means for storing a plurality of data element means for performing data interface functions, each of the data element means being capable of performing a single data interface function, and module means for providing instructions for executing predefined series of data element means; and active component means for moving data from the source applications to the temporary storage means, processing the data according to the module means instructions, and populating the destination application with resulting data residing in the temporary storage means.
Claim 37
Dependent Claim
152 words
A data integration system for providing end-to-end integration between a plurality of source applications and a destination application, the system comprising: repository means for containing information relating to the source applications and the destination application, the repository means including temporary storage means for storing temporary data from the source applications, configuration storage means for storing configuration data describing data in the source applications and in the temporary storage means, library means for storing a plurality of data element means for performing data interface functions, each of the data element means being capable of performing a single data interface function, and module means for providing instructions for executing predefined series of data element means; and active component means for moving data from the source applications to the temporary storage means, processing the data according to the module means instructions, and populating the destination application with resulting data residing in the temporary storage means.
References Cited (Backward Citations)
US4873630A
Cited
US5634124A
Cited
US5369778A
Cited
US5210870A
Cited
US5548769A
Cited
US5297279A
Cited
US5566330A
Cited
US5428791A
Cited
US5390330A
Cited
US5596744A
Cited
US5504885A
Cited
US5764973A
Cited
US5875330A
Cited
US6185629B1
Cited
US5721912A
Cited
US5781905A
Cited
US5542078A
Cited
US5850548A
Cited
US5862372A
Cited
US5692183A
Cited
US5634053A
Cited
US5745765A
Cited
US5893911A
Cited
US5884079A
Cited
US5878425A
Cited
US5970490A
Cited
US5857194A
Cited
US5950001A
Cited
US5974413A
Cited
US5946694A
Cited
US5924101A
Cited
US6236994B1
Cited
EP1016989A2
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2004-10-22 | 2005-04-23 | 2005-10-23 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2008-10-22 | 2009-04-23 | 2009-10-23 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2012-10-22 | 2013-04-23 | 2013-10-23 | $7700.00 | Window Closed / Lapsed |