← Back to Patent Explorer
US5701423A Expired / Lapsed US ⏱️ 0.0 years remaining

Method for mapping, translating, and dynamically reconciling data between disparate computer platforms

Assignee: Intellisync LLC
•
Filing: 1994-04-07
•
Granted: 1997-12-23
•
Expires: 2014-04-07
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract Traditionally, it has been difficult to share data among diverse computer applications and platforms because of underlying differences in data formats. Although the meaning or purpose of the data may be similar or identical (for example, two appointments entered using separate computer applications), the differences in data formats required by the various computer applications and platforms renders such sharing difficult. A method is disclosed for the translation of dissimilarly-formatted data between disparate computer applications and platforms. The method also provides for the dynamic reconciliation of conflicts in the data (for example, two appointments scheduled at the same time) based on both the content of the data and on specific preferences indicated by the user of the translation facility. First, the data is translated to a common format based on the user-specified mapping of data fields (identifying handheld and desktop fields to be translated) and considering the characteristics of the handheld or desktop computer application. Then, if the specific data item (such as an appointment, telephone book entry, or memo entry) already exists on the desktop computer application or platform, the user is optionally notified of the conflict and given the opportunity to replace the existing data, ignore the incoming data, or modify the incoming data. The criteria for determining the existence of conflicts is disclosed for updating schedule information and keyed databases.

Inventors

  • 👤 Keith Crozier

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-10-27 06:24
CPC Classifications
G; G06; G06Q; G06Q10/00; G06Q10/10; G06F; G06F15/00; G06F15/02; G06F15/0208; G06F15/025; G06F15/0266; G06F16/00; G06F16/20; G06F16/25; G06F16/258; G06Q10/08; G06Q10/087; G06Q20/00; G06Q20/08; G06Q20/20; G06Q20/203; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943; Y10S707/99944; Y10S707/99945; Y10S707/99948; Y10S707/99951; Y10S707/99952; Y10S707/99953; Y10S707/99954; Y10S715/00; Y10S715/961; Y10S715/963; Y10S715/971

Claims Analysis

Total Claims: 16
Claim 1
Independent Claim 191 words
A computer implemented method for translating computer data from a source record structure, in which information in a source file is arranged, to a destination record structure different from said source record structure, each of said source and destination record structures comprising a plurality of fields, each having a name, the method comprising (a) presenting the names of the fields of each of said source and destination record structures on a display (b) allowing a user to interactively select a field from said source record structure and a corresponding field from said destination record structure, thereby establishing a mapping between said fields, and (c) translating the information of the source file, which is arranged in said source record structure, into a form compatible with said destination record structure in accordance with said mapping, wherein said destination record structure differs from said source record structure in at least one of the following ways: (a) field name, or (b) field order, or (c) one-to-many or many-to-one field correspondence, wherein said source file exists on a first computer and said destination record structure is specified by a program for execution on a second computer.
Claim 2
Dependent Claim 191 words
A computer implemented method for translating computer data from a source record structure, in which information in a source file is arranged, to a destination record structure different from said source record structure, each of said source and destination record structures comprising a plurality of fields, each having a name, the method comprising (a) presenting the names of the fields of each of said source and destination record structures on a display (b) allowing a user to interactively select a field from said source record structure and a corresponding field from said destination record structure, thereby establishing a mapping between said fields, and (c) translating the information of the source file, which is arranged in said source record structure, into a form compatible with said destination record structure in accordance with said mapping, wherein said destination record structure differs from said source record structure in at least one of the following ways: (a) field name, or (b) field order, or (c) one-to-many or many-to-one field correspondence, wherein said source file exists on a first computer and said destination record structure is specified by a program for execution on a second computer.
Claim 3
Dependent Claim 58 words
The method of claim 1 wherein said selecting comprises said user clicking a pointer device on a displayed name of a source field of said source record structure and clicking said pointer device on a displayed name of a destination field of said destination record structure, thereby establishing a mapping between said source field and said destination field.
Claim 4
Dependent Claim 21 words
The method of claim 2 wherein said mapping between said source field and said destination field is displayed on said display.
Claim 5
Dependent Claim 27 words
The method of claim 3 wherein said displaying of said mapping comprises displaying the name of said destination field adjacent to the name of said source field.
Claim 6
Dependent Claim 44 words
The method of claim 1 wherein said field names are acquired by a first program for said presenting by examining a second program, the second program comprising an application that operates on files having at least one of said source and destination record structures.
Claim 7
Dependent Claim 15 words
The method of claim 5 wherein said examination is performed by an inter-application communication facility.
Claim 8
Dependent Claim 25 words
The method of claim 1 wherein said field names are acquired by a program for said presenting by examining data dictionary records in a file.
Claim 9
Dependent Claim 35 words
The method of claim 1 wherein said field names are acquired by a program for said presenting from a description of one of said record structures which is hard-coded into the program for said presenting.
Claim 10
Dependent Claim 97 words
The method of claim 1 wherein said field names for said source and destination record structures are acquired by a program for said presenting by techniques chosen from the list comprising: (a) examining a program that operates on files having at least one of said source and destination record structures, (b) examining data dictionary records stored in a file, or (c) hard-coding a description of said record structure into a program for said establishing, the method further comprising determining, for each of said source and destination record structures, which of said techniques to use for said acquiring.
Claim 11
Dependent Claim 52 words
The method of claim 1, wherein said mapping comprises mapping a source field of said source record structure to a destination field of said destination record structure, said destination field being of a different data format from the data format of said source field, and wherein said translating comprises data format conversion.
Claim 12
Dependent Claim 27 words
The method of claim 1 wherein said mapping comprises mapping one field of said source record structure to more than one field of said destination record structure.
Claim 13
Dependent Claim 27 words
The method of claim 1 wherein said mapping comprises mapping more than one field of said source record structure to one field of said destination record structure.
Claim 14
Dependent Claim 35 words
The method of claim 1, wherein a destination file of said destination record structure exists, further comprising the steps of comparing the translated information of said source file to the information of said destination file.
Claim 15
Dependent Claim 94 words
The method of claim 13 further comprising establishing a correspondence between records of said source file and records of said destination file, said correspondence based on comparisons of keys of said records, performing said translating on the information of each said record of said source file, thereby producing a translated record, and allowing a user, immediately after each said comparison in which a difference is discovered, to interactively select either said translated record or the corresponding records of said destination file, or both, or neither, and writing said selected records to an output file.
Claim 16
Dependent Claim 47 words
The method of claim 1, wherein said translating proceeds in two phases, the first phase being a translation from said source record structure to a common intermediate record structure, and the second phase being a translation from said common intermediate record structure to said destination record structure.

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 2000-12-22 2001-06-23 2001-12-23 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2004-12-22 2005-06-23 2005-12-23 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2008-12-22 2009-06-23 2009-12-23 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag