System for linking data between computer and portable remote terminal and data linking method therefor

• US 6,263,347 B1
• Filed: 04/28/1999
• Issued: 07/17/2001
• Est. Priority Date: 04/28/1998
• Status: Expired due to Term

• Current Assignee: NEC Personal Computers, Ltd. (Lenovo Group Ltd.)
• Original Assignee: NEC Corporation
• Inventors: Kobayashi, Osamu, Yoda, Seiichi
• Primary Examiner(s): Vu, Kim
• Assistant Examiner(s): ALAM, SHAHID AL
• Application Number:
  US09/300,463
• Time in Patent Office: 811 Days
• Field of Search: 707/1, 707/3, 707/8, 707/10, 707/100, 707/101, 707/102, 707/103, 707/201, 707/530, 709/227, 709/312, 709/315, 709/213, 709/238, 711/100, 711/133, 711/171, 711/203, 711/141, 711/202, 711/220, 711/221, 712/245, 712/229, 710/5, 710/6, 710/20, 710/132, 710/21, 455/428
• US Class Current: 1/1
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

In a data linking method of extracting data of a host data base on a computer into a portable remote terminal, an item definition data base which defines a record attribute, an object storage data base which stores object data on a record basis, a relation definition data base which defines relations among object data and a definition data base which defines relations among the respective data bases, and conducts synchronous processing of writing. The portable remote terminal conducts link data solution processing based on a record attribute of the item definition data base when a record item of the object storage data base refers to other object storage data base, and changes, when the display order of object data of the object storage data base is changed or when existence/non-existence of display is selected, the display order of object data of said item definition data base or an attribute indicative of existence/non-existence of display according to the contents of the change or the selection, and the computer further reads an updated record from said object storage data base of the portable remote terminal to update the host data base.

Claims

1. A System for linking data between a computer and a portable remote terminal which extracts data of a host data base on said computer into said portable remote terminal, displays and edits the extracted data on said portable remote terminal and conducts synchronous processing of updated data in said portable remote terminal and a data base in said computer, wherein

said computer comprissing:

means for selecting object data to be brought out from said host data base into said portable remote terminal and a record item of the object data;

means for creating on said portable remote terminal, with respect to selected object data, an item definition data base which defines a record attribute, an object storage data base which stores object data on a record basis correspondingly to said item definition data base, a relation definition data base which defines relations among object data stored in said object storage data base and a definition data base which defines relations among the respective data bases created;

means for writing, on the basis of a record taken out from said host data base, data into the corresponding one of said object storage data bases according to said item definition data base; and

synchronization means for conducting synchronous processing of reading updated data from said object storage data base of said portable remote terminal and writing the data into said host data base of said computer; and

said portable remote terminal comprising;

means for conducting, when a record item of said object storage data base refers to other said object storage data base, link data solution processing based on a record attribute of said item definition data base; and

means for changing, when the display order of object data of said object storage data base is changed or when existence/non-existence of display is selected, the display order of object data of said item definition data base or an attribute indicative of existence/non-existence of display according to the contents of the change or the selection; and

wherein

said synchronization means of said computer reads an updated record from said object storage data base of said portable remote terminal to update said host data base of said computer.

2. The system for linking data between a computer and a portable remote terminal as set forth in claim 1, wherein

said portable remote terminal further comprises

updating flag setting means for setting, when updating or addition of a record is made of said object storage data base, an updating flag at the corresponding record of the object storage data base.

3. The system for linking data between a computer and a portable remote terminal as set forth in claim 1, wherein

said portable remote terminal further comprises

editing means for editing object data stored in said object storage data base and conducting change of the display order of data items or selection of existence/non-existence of display.

4. The system for linking data between a computer and a portable remote terminal as set forth in claim 1, wherein

said portable remote terminal further comprises

updating flag setting means for setting, when updating or addition of a record is made of said object storage data base, an updating flag at the corresponding record of the object storage data base, and wherein,

said updating flag setting means, when updating or addition of a record is made of said object storage data base, sets a flag indicating that the object storage data base in question is updated at said definition data base, and

said synchronization means searches said object storage data base updated by a flag of said definition data base and reads a record at which said object storage data base updating flag searched is set to update said host data base of said computer.

5. The system for linking data between a computer and a portable remote terminal as set forth in claim 1, wherein

for each record item, said item definition data base has, as attributes, other object storage data base to be referred to by the record item in question and a record item, a record item with which the record item in question links, and a record item of an object storage data base to be referred to by the linked record item.

6. A method of linking data between a computer and a portable remote terminal which extracts data of a host data base on said computer into said portable remote terminal, displays and edits the extracted data on said portable remote terminal and conducts synchronous processing of updated data in said portable remote terminal and a data base in said computer, comprising

the steps of said computer of:

with respect to object data to be brought out into said portable remote terminal which is selected from said host data base and a record item of the object data, creating, on said portable remote terminal, an item definition data base which defines a record attribute, an object storage data base which stores object data on a record basis correspondingly to said item definition data base, a relation definition data base which defines relations among object data stored in said object storage data base and a definition data base which defines relations among the respective data bases created,

on the basis of a record taken out from said host data base, writing data into the corresponding one of said object storage data bases according to said item definition data base, and

conducting synchronous processing of reading updated data from said object storage data base of said portable remote terminal and writing the data into said host data base of said computer,

the steps of said portable remote terminal of;

when a record item of said object storage data base refers to other said object storage data base, conducting link data solution processing based on a record attribute of said item definition data base, and

when the display order of object data of said object storage data base is changed or when existence/non-existence of display is selected, changing the display order of object data of said item definition data base or an attribute indicative of existence/non-existence of display according to the contents of the change or the selection, and

the step of said computer of reading an updated record from said object storage data base of said portable remote terminal to update said host data base of said computer.

7. The method of linking data between a computer and a portable remote terminal as set forth in claim 6, further comprising

the step of said portable remote terminal of,

when updating or addition of a record is made of said object storage data base, setting an updating flag at the corresponding record of the object storage data base.

8. The method of linking data between a computer and a portable remote terminal as set forth in claim 6, further comprising

the steps of said portable remote terminal of:

when updating or addition of a record is made of said object storage data base, setting an updating flag at the corresponding record of the object storage data base and further setting a flag indicating that the object storage data base in question is updated at said definition data base, wherein

in synchronous processing of said computer, said object storage data base updated by a flag of said definition data base is searched and a record at which said object storage data base updating flag searched is set is read to update said host data base of said computer.

9. A computer readable memory which stores a program for linking data between a computer and a portable remote terminal which extracts data of a host data base on said computer into said portable remote terminal, displays and edits the extracted data on said portable remote terminal and conducts synchronous processing of updated data in said portable remote terminal and a data base in said computer, wherein

said data link program comprises the steps of:

on the side of said computer

with respect to object data to be brought out into said portable remote terminal which is selected from said host data base and a record item of the object data, creating, on said portable remote terminal, an item definition data base which defines a record attribute, an object storage data base which stores object data on a record basis correspondingly to said item definition data base, a relation definition data base which defines relations among object data stored in said object storage data base and a definition data base which defines relations among the respective data bases created,

on the basis of a record taken out from said host data base, writing data into the corresponding one of said object storage data bases according to said item definition data base, and

conducting synchronous processing of reading updated data from said object storage data base of said portable remote terminal and writing the data into said host data base of said computer,

on the side of said portable remote terminal

when a record item of said object storage data base refers to other said object storage data base, conducting link data solution processing based on a record attribute of said item definition data base, and

when the display order of object data of said object storage data base is changed or when existence/non-existence of display is selected, changing the display order of object data of said item definition data base or an attribute indicative of existence/non-existence of display according to the contents of the change or the selection, and

on said computer, reading an updated record from said object storage data base of said portable remote terminal to update said host data base of said computer.

10. The computer readable memory as set forth in claim 9, wherein

said data link program on the side of said portable remote terminal further comprises the step of,

when updating or addition of a record is made of said object storage data base, setting an updating flag at the corresponding record of the object storage data base.

11. The computer readable memory as set forth in claim 9, wherein

said data link program on the side of said portable remote terminal further comprises the step of,

when updating or addition of a record is made of said object storage data base, setting an updating flag at the corresponding record of the object storage data base and further setting a flag indicating that the object storage data base in question is updated at said definition data base, and wherein

in synchronous processing of the data link program on the side of said computer, said object storage data base updated by a flag of said definition data base is searched and a record at which said object storage data base updating flag searched is set is read to update said host data base of said computer.