Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1998-08-12
2001-06-05
Ho, Ruay Lian (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
06243705
ABSTRACT:
FIELD OF THE INVENTION
This invention relates to the field of handheld computing devices. Specifically, the present invention discloses a method and apparatus for synchronizing information between a desktop computing system and a handheld computing device.
BACKGROUND OF THE INVENTION
Handheld computing devices or “palmtops” typically weigh less than a pound and fit in a pocket. These palmtops generally provide some combination of personal information management, database functions, word processing and spreadsheets. Users of palmtops may also own personal computers (PCs) running applications that manage data similar to the data carried in the palmtops. In such cases, the user normally would want the data on their palmtop to be easily synchronized with the data on their PC.
A number of programs today transfer data between palmtops and PCs, but they are currently limited in functionality. Some programs transfer all the information from the palmtop to the PC without regard for the prior content on the PC. These programs assume that changes to that particular data are only made on the palmtop, and that the changes made on the palmtop take precedence over any changes made on the PC. As a result, any independent updates made directly on the PC will be lost.
Other methods use ‘flags’ to facilitate synchronization. These methods create update ‘flags’ in each record that has changed, both on the palmtop and the PC. Corresponding files on the palmtop and the PC are then compared, and if one or more flags are set in a file, the file is recognized as having changed. If both the palmtop and PC files have changed, the flags are used to determine which records need to be updated in the other file. The databases of most existing programs, however, do not contain such flags since the databases of most existing programs were not designed to be synchronized. Thus, a different method must be used to synchronize data from programs that are already on the market.
Some programs attempt to synchronize the data on the PC with the palmtop by comparing the information in each application and prompting the user for answers to determine which data to overwrite. For example, U.S. Pat. No. 5,392,390 describes a method for reconciling information between two calendar database files by interrogating the user about which file to update when a difficult case arises. Although these types of programs provide an advantage over programs that assume only one database has changed since they do not indiscriminately overwrite data, they are cumbersome and time consuming. Using these methods, users may have to spend an inordinate amount of time answering questions whenever they attempt to synchronize information between their palmtops and their PCs.
SUMMARY OF THE INVENTION
It is therefore an object of the present invention to provide a solution to the problem of synchronizing records on two different computer systems. It is a further object of the present invention to present a method that reconciles two changeable databases without any user interactions. Specifically, the present invention discloses a method and apparatus for automatically reconciling records in corresponding files on palmtop and a personal computer (PC) by comparing the records in the palmtop and PC files with the records in a backup file in a backup directory from the previous synchronization.
When a user is ready to synchronize information on the two computer systems, the palmtop is connected to the PC. The present invention then compares each record of a file on the palmtop with the records in the backup file in the backup directory to determine whether each record on the palmtop file is new, updated or if it has been deleted from the palmtop file. Next, a comparison is performed between the contents of the corresponding file on the PC and the backup file in the backup directory to determine whether each record on the PC is new, updated or if it has been deleted from the PC file. The results of both compares are stored, e.g., in a new file called a reconcile file, or a temporary data structure. After all the records in both files have been checked, the results of the compare, whether stored in a reconcile file or temporary data structure, are copied over the selected files on the palmtop, the PC and the backup file in the backup directory, thus guaranteeing that all three files are identical after the synchronization. The reconcile file is then deleted.
Other objects, features and advantages of the present invention will be apparent from the accompanying drawings, and from the detailed description.
REFERENCES:
patent: 4432057 (1984-02-01), Daniell et al.
patent: 4807182 (1989-02-01), Queen
patent: 4866611 (1989-09-01), Cree et al.
patent: 4875159 (1989-10-01), Cary et al.
patent: 4956809 (1990-09-01), George et al.
patent: 5001628 (1991-03-01), Johnson et al.
patent: 5065360 (1991-11-01), Kelly
patent: 5142619 (1992-08-01), Webster, III
patent: 5187787 (1993-02-01), Skeen et al.
patent: 5210868 (1993-05-01), Shimada et al.
patent: 5237678 (1993-08-01), Kuechler et al.
patent: 5251291 (1993-10-01), Malcolm
patent: 5261045 (1993-11-01), Scully et al.
patent: 5261094 (1993-11-01), Everson et al.
patent: 5272628 (1993-12-01), Koss
patent: 5283887 (1994-02-01), Zachary
patent: 5301313 (1994-04-01), Tereda et al.
patent: 5315709 (1994-05-01), Alston, Jr. et al.
patent: 5327555 (1994-07-01), Anderson
patent: 5333252 (1994-07-01), Brewer, III et al.
patent: 5339392 (1994-08-01), Risberg et al.
patent: 5339434 (1994-08-01), Rusis
patent: 5355476 (1994-10-01), Fukumura
patent: 5379057 (1995-01-01), Clough et al.
patent: 5392390 (1995-02-01), Crozier
patent: 5432994 (1995-07-01), Shaheen et al.
patent: 5463772 (1995-10-01), Thompson et al.
patent: 5475833 (1995-12-01), Dauerer et al.
patent: 5519606 (1996-05-01), Frid-Nielsen et al.
patent: 5537592 (1996-07-01), King et al.
patent: 5544356 (1996-08-01), Robinson et al.
patent: 5574859 (1996-11-01), Yeh
patent: 5592669 (1997-01-01), Robinson et al.
patent: 5598536 (1997-01-01), Slaughter, III et al.
patent: 5630081 (1997-05-01), Rybicki et al.
patent: 5666530 (1997-09-01), Clark et al.
patent: 5684990 (1997-11-01), Boothby
patent: 5696702 (1997-12-01), Skinner et al.
patent: 5701423 (1997-12-01), Crozier
patent: 5729452 (1998-03-01), Smith et al.
Cobb et al., “Paradox 3.5 Handbook 3rdEdition” Bantam (1991), pp. 803-816.
Alfieri, “The best book of: Wordperfect 5.0”, Hayden Books (1988), pp. 153-165 and 429-435.
User Manual For PC-Link for the B.O.S.S. and the PC-link for the B.O.S.S, Traveling Software, Inc. (1989).
User Manual For Connectivity Pack for the HP 95LX, Hewlett Packard Company (1991).
Organizer Link II Operation Manual, Sharp Electronics Corporation, No Date.
“Open Network Computing-Technical Overview”, Sun Technical Report, Sun Microsystems, Inc. pp. 1-32 (1987).
Zahn, et al., “Network Computing Architecture”, pp. 1-11, 19-31, 87-115, 117-133, 187-199, 201-209 (1990).
IntelliLink Brochure (1990).
“Logical Connectivity: Applications, Requirements, Architecture, and Research Agenda”, Stuart Madnick & Y. Richard Wang, MIT System Sciences, 1991, Hawaii Int'l , vol. 1 IEEE, Jun. 1991.
“Automatically Synchronized Objects”, Research Disclosure #29261, p. 614 (Aug. 1988). No Copy Available.
“FRx Extends Reporting Power Of Platinum Series: (IBM Desktop Software's Line of Accounting Software)” Doug Dayton, PC Week, v. 8, No. 5, p. 29(2), Feb. 1991.
Ho Ruay Lian
Mahamedi Van
Palm Inc.
Wilson Sonsini Goodrich & Rosati
LandOfFree
Method and apparatus for synchronizing information on two... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and apparatus for synchronizing information on two..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for synchronizing information on two... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2541304