Patent US5566332A successfully refreshed from Google Patents.
US5566332A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and combination for minimizing data conversions when data is transferred between a first database storing data in a first format and a second database storing data in a second format
Assignee: International Business Machines Corp
•
Filing: 1994-08-11
•
Granted: 1996-10-15
•
Expires: 2014-08-11
Abstract
Abstract The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved, and data conversions can be minimized. The invention accomplishes this by establishing layers of descriptive information which isolate machine characteristics, levels of support software, and user data descriptions. Optimized processing is achieved by processing the different descriptor levels at different times during the development and execution of the database management systems. Minimal descriptive information is exchanged between the cooperating database management systems. Any data conversions that may be necessary are done only by the receiver of the data, and only at the point where it is necessary to have the data represented in the receiver's native format for processing. For sending and receiving systems which match, data conversion is completely avoided, even when the data may have been forwarded through intermediate DBMS systems which do not match. For sending and receiving systems which do not match, data conversion is minimized. The data conversion routines and tables in each system are also minimized by requiring conversion only INTO a system's native format, never FROM its native format into some other format.
Inventors
- 👤 John G. Adair
- 👤 Daniel J. Coyle, Jr.
- 👤 Robert J. Grafe
- 👤 Bruce G. Lindsay
- 👤 Roger A. Reinsch
- 👤 Robert P. Resch
- 👤 Patricia G. Selinger
- 👤 Melvin R. Zimowski
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-01 20:47
CPC Classifications
G; G06; G06F; G06F17/00; G06F16/00; G06F16/20; G06F16/25; G06F16/258; Y; Y10; Y10S; Y10S707/00; Y10S707/912; Y10S707/922; Y10S707/99941; Y10S707/99942; Y10S707/99951; Y10S707/99952; Y10S707/99954
Claims Analysis
Total Claims: 22
Claim 1
Independent Claim
140 words
A combination for establishing a data conversion context at a first computer system which receives data from a second computer system, wherein the second computer system stores and processes data in a format different than the first computer system, the combination comprising: (a) descriptors in the first computer system defining machine and language characteristics of a plurality of computer systems; (b) means for obtaining from said descriptors, first and second descriptors which respectively define machine and language characteristics for said second computer system; (c) means for receiving data from the second computer system; and (d) means for combining the first and second descriptors with data descriptors in the received data which describe characteristics of data native to the second computer system to produce a context for converting the received data to data which is native to the first computer system.
Claim 2
Dependent Claim
140 words
A combination for establishing a data conversion context at a first computer system which receives data from a second computer system, wherein the second computer system stores and processes data in a format different than the first computer system, the combination comprising: (a) descriptors in the first computer system defining machine and language characteristics of a plurality of computer systems; (b) means for obtaining from said descriptors, first and second descriptors which respectively define machine and language characteristics for said second computer system; (c) means for receiving data from the second computer system; and (d) means for combining the first and second descriptors with data descriptors in the received data which describe characteristics of data native to the second computer system to produce a context for converting the received data to data which is native to the first computer system.
Claim 3
Independent Claim
159 words
A method for use by a user processor in making data requests to a server processor which stores and processes data in a format different than the user processor, comprising the user processor executed steps of: storing a dictionary of processor descriptors; creating a communication link to a server processor by: communicating to the server processor an identifier denoting the user processor; and receiving from the server processor an identifier denoting the server processor; sending a request for data to the server processor in the user processor data format, the request including a descriptor of the user processor data format; receiving from the server processor data responsive to the request for data, the data being in the server processor data format, and being accompanied by a descriptor of the server processor data format; and using the identifier denoting the server processor and the descriptor of the server processor data format, converting the data to the user processor data format.
Claim 4
Independent Claim
159 words
A method for use by a user processor in making data requests to a server processor which stores and processes data in a format different than the user processor, comprising the user processor executed steps of: storing a dictionary of processor descriptors; creating a communication link to a server processor by: communicating to the server processor an identifier denoting the user processor; and receiving from the server processor an identifier denoting the server processor; sending a request for data to the server processor in the user processor data format, the request including a descriptor of the user processor data format; receiving from the server processor data responsive to the request for data, the data being in the server processor data format, and being accompanied by a descriptor of the server processor data format; and using the identifier denoting the server processor and the descriptor of the server processor data format, converting the data to the user processor data format.
Claim 5
Dependent Claim
22 words
The method of claim 2, wherein the step of creating a communication link further includes validating the identifier denoting the server processor.
Claim 6
Dependent Claim
20 words
The method of claim 2, wherein the identifier denoting the server processor includes identification of a server processor machine descriptor.
Claim 7
Dependent Claim
74 words
The method of claim 4, wherein: the storing step includes storing a plurality of server processor machine descriptors at the user processor; and the step of converting includes: obtaining a server processor machine descriptor from the dictionary in response to the identifier denoting the server processor; and in response to the server processor machine descriptor, converting bit representations in the data received from the server processor to bit representations used by the user processor.
Claim 8
Dependent Claim
19 words
The method of claim 2, wherein the identifier denoting the server processor includes identification of a computer language descriptor.
Claim 9
Dependent Claim
74 words
The method of claim 6, wherein: the storing step includes storing a plurality of computer language descriptors in the dictionary; and the step of converting includes: obtaining a computer language descriptor from the dictionary in response to the identifier denoting the server processor; and in response to the computer language descriptor, converting control fields in the data received from the server processor to control fields of a computer language used by the user processor.
Claim 10
Dependent Claim
20 words
The method of claim 2, wherein the identifier denoting the server processor includes identification of a server processor code page.
Claim 11
Dependent Claim
74 words
The method of claim 8, wherein: the storing step includes storing a plurality of server processor code page descriptors in the dictionary; and, the step of converting includes: obtaining a server processor code page descriptor from the dictionary in response to the identifier denoting the server processor; and in response to the code page descriptor, converting character representations in the data received from the server processor to character representations used by the user processor.
Claim 12
Dependent Claim
74 words
The method of claim 8, wherein: the storing step includes storing a plurality of server processor code page descriptors in the dictionary; and, the step of converting includes: obtaining a code page descriptor from the dictionary in response to the identifier denoting the server processor; and in response to the code page descriptor, converting control function representations in the data received from the server processor to control function representations used by the user processor.
Claim 13
Dependent Claim
173 words
A combination for use by a user processor in making data requests to a server processor which stores and processes data in a format different than the user processor, the combination comprising, in the user processor: means for creating a communication link to a server processor by: communicating to the server processor an identifier denoting the user processor; and receiving from the server processor an identifier denoting the server processor; a dictionary of server processor descriptors; means for sending a request for data to the server processor on the communication link in the user processor data format, the request including a descriptor of the user processor data format; means for receiving from the server processor data responsive to the request for data, the data being in the server processor data format and being accompanied by a descriptor of the server processor data format; and means for converting the data to the user processor data format in response to the identifier denoting the server processor and the descriptor of the server processor data format.
Claim 14
Dependent Claim
173 words
A combination for use by a user processor in making data requests to a server processor which stores and processes data in a format different than the user processor, the combination comprising, in the user processor: means for creating a communication link to a server processor by: communicating to the server processor an identifier denoting the user processor; and receiving from the server processor an identifier denoting the server processor; a dictionary of server processor descriptors; means for sending a request for data to the server processor on the communication link in the user processor data format, the request including a descriptor of the user processor data format; means for receiving from the server processor data responsive to the request for data, the data being in the server processor data format and being accompanied by a descriptor of the server processor data format; and means for converting the data to the user processor data format in response to the identifier denoting the server processor and the descriptor of the server processor data format.
Claim 15
Dependent Claim
23 words
The combination of claim 11, wherein the means for creating a communication link is further for validating the identifier denoting the server processor.
Claim 16
Dependent Claim
20 words
The combination of claim 11, wherein the identifier denoting the server processor includes identification of a server processor machine descriptor.
Claim 17
Dependent Claim
74 words
The combination of claim 13, wherein: the server processor descriptors include a plurality of server processor machine descriptors; and, the means for converting includes: means for obtaining a server processor machine descriptor from the dictionary in response to the identifier denoting the server processor; and means for converting bit representations in the data received from the server processor to bit representations used by the user processor in response to the server processor machine descriptor.
Claim 18
Dependent Claim
19 words
The combination of claim 11, wherein the identifier denoting the server processor includes identification of a computer language descriptor.
Claim 19
Dependent Claim
68 words
The combination of claim 15, wherein: the server processor descriptors include a plurality of computer language descriptors; and, the means for converting includes: means for obtaining a computer language descriptor from the dictionary in response to the identifier denoting the server processor; and means for converting control fields in the data received from the server processor to control fields of a computer language used by the user processor.
Claim 20
Dependent Claim
20 words
The combination of claim 11, wherein the identifier denoting the server processor includes identification of a server processor code page.
Claim 21
Dependent Claim
75 words
The combination of claim 17, wherein: the server processor descriptors include a plurality of server processor code page descriptors; and, the means for converting includes: means for obtaining a server processor code page descriptor from the dictionary in response to the identifier denoting the server processor; and means for converting character representations in the data received from the server processor to character representations used by the user processor in response to the code page descriptor.
Claim 22
Dependent Claim
73 words
The combination of claim 17, wherein: the server processor descriptors include a plurality of code page descriptors; and, the means for converting includes: means for obtaining a code page descriptor from the dictionary in response to the identifier denoting the server processor; and means for converting control function representations in the data received from the server processor to control function representations used by the user processor in response to the code page descriptor.
References Cited (Backward Citations)
US4677552A
Cited
US4774655A
Cited
US4714995A
Cited
US5109483A
Cited
US5058000A
Cited
US5278978A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-10-15 | 2000-04-15 | 2000-10-15 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-10-15 | 2004-04-15 | 2004-10-15 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-10-15 | 2008-04-15 | 2008-10-15 | $7700.00 | Window Closed / Lapsed |