Method and system for providing a dynamic and real-time exchange between heterogeneous database systems

• US 20020174098A1
• Filed: 11/19/2001
• Published: 11/21/2002
• Est. Priority Date: 05/04/2001
• Status: Abandoned Application

• Current Assignee: Lasmsoft Corporation
• Original Assignee: Lasmsoft Corporation
• Inventors: Chen, Wei Chou, Tseng, Shu Hui, Lin, Ta Yu, Wu, Hsing Kong, He, Yu Chi, Liu, Yen Liang, Hsaio, Pai Kang
• Application Number:
  US09/997,489
• Publication Number:
  US 20020174098A1
• Time in Patent Office: Days
• US Class Current: 707/1
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

A system for dynamically exchanging heterogeneous databases in real-time, includes database table migration means for executing data migration by selecting a source database and a destination database, and then selecting source data table as a basis for selecting migration mode; relational table establishing means for defining a displayed relational field and exporting data module after selecting a source database and a source data table; data table export means for executing data export by selecting source database and selecting an export destination file; data table import means for executing data import by selecting a source file and selecting destination table according to said source file selection and setting table mapping field; data mapping rule means for mapping the data field via multiple operation means and an automatically encode and interpretation system after selecting source; screen data control mapping means for mapping a data file for storage and activating application program by selecting data picture, reading screen element, and setting a name of the element for storage and selecting storage element after selecting data picture; and data rule detecting means for setting execution rule and importing schedule after setting executing timing, selecting detected source, and selecting target.

Claims

1. A system for dynamically exchanging heterogeneous databases in real-time, comprising:

database table migration means for executing data migration by selecting a source database and a destination database, and then selecting source data table as a basis for selecting migration mode;

relational table establishing means for defining a displayed relational field and exporting data module after selecting a source database and a source data table;

data table export means for executing data export by selecting source database and selecting an export destination file;

data table import means for executing data import by selecting a source file and selecting destination table according to said source file selection and setting table mapping field;

data mapping rule means for mapping the data field via multiple operation means and an automatically encode and interpretation system after selecting source;

screen data control mapping means for mapping a data file for storage and activating application program by selecting data picture, reading screen element, and setting a name of the element for storage and selecting storage element after selecting data picture; and

data rule detecting means for setting execution rule and importing schedule after setting executing timing, selecting detected source, and selecting target.

2. A system for dynamically exchanging heterogeneous databases in real-time as claimed in claim 1, wherein said source file is a data file.

3. A system for dynamically exchanging heterogeneous databases in real-time as claimed in claim 1, wherein said source file is a spreadsheet file.

4. A system for dynamically exchanging heterogeneous databases in real-time as claimed in claim 1, wherein said source file is a text file.

5. A system for dynamically exchanging heterogeneous databases in real-time as claimed in claim 1, wherein said source file is a XML web page file.

6. A system for dynamically exchanging heterogeneous databases in real-time as claimed in claim 1, wherein said multiple operation is an operation for data table relational.

7. A system for dynamically exchanging heterogeneous databases in real-time as claimed in claim 1, wherein said multiple operation is an operation for functional operation.

8. A system for dynamically exchanging heterogeneous databases in real-time as claimed in claim 1, wherein said multiple operation is an operation for data combination.

9. A system for dynamically exchanging heterogeneous databases in real-time as claimed in claim 1, wherein said multiple operation is an operation for constants.

10. A system for dynamically exchanging heterogeneous databases in real-time as claimed in claim 1, wherein said multiple operation is an operation for variables.

11. A method for dynamically exchanging heterogeneous databases in real-time, comprising the steps of:

transferring database table for executing data migration by selecting a source database and a destination database, and then selecting source data table as a basis for selecting migration mode;

establishing relational table for defining a displayed relational field and exporting data module after selecting a source database and a source data table;

exporting data table for executing data export by selecting source database and selecting an export destination file;

importing data table for executing data import by selecting a source file and selecting destination table according to said source file selection and setting table mapping field;

data mapping rule means for mapping the data field via multiple operation means and an automatically encode and interpretation system after selecting source;

mapping screen data control for mapping a data file for storage and activating application program by selecting data picture, reading screen element, and setting a name of the element for storage and selecting storage element after selecting data picture; and

detecting data rule for setting execution rule and importing schedule after setting executing timing, selecting detected source, and selecting target.