Data exchange apparatus and methods

• US 5,021,995 A
• Filed: 12/17/1985
• Issued: 06/04/1991
• Est. Priority Date: 12/17/1985
• Status: Expired due to Term

• Current Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Original Assignee: Wang Laboratories Incorporated
• Inventors: Quint, Jeanne M., Pratt, John M.
• Primary Examiner(s): CLARK, DAVID
• Application Number:
  US06/809,985
• Time in Patent Office: 1,995 Days
• Field of Search: 364/200 MS File, 364/900 MS File, 364/300, 364/518, 364/521, 382/1, 382/6, 382/7, 382/56, 382/61
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

Apparatus and methods for the exchange of data between files having different types. The apparatus includes means for reading a logical record from a source file and using the data contained therein in the production of a generic form in which data is represented as an arrangement of displayable characters and means for using the data represented in the generic form to produce a logical record for a destination file. The means for producing the generic form may further include means for inserting a user-defined code in the generic form to mark fields of the source file logical record. The means for producing the destination file logical record may then employ the user-defined code to produce corresponding fields in the destination file logical record. The apparatus may further include data viewing means which permits the user to view the generic form and interactively define fields therein. The means for producing the destination file logical record may then employ the field definition for the generic form to produce corresponding fields in the destination file logical record.

Claims

1. A digital computer system including a data display apparatus and having access to files for storing items of data, the files belonging to a plurality of file types wherein the file types include a stream file type, a record file type, said digital computer system comprising:

a data viewing apparatus for viewing one or more of the items of data in a file having any one of the plurality of file types, the data viewing apparatus comprising;

(1) generic form production means for reading a logical record containing an item of data from a file and using the contents of the logical record to produce a generic form of the logical record which is non-specific to any of the file types and which represents the contents of the logical record as an arrangement of codes representing displayable characters and

(2) display production means for receiving the generic form of the logical record and producing a display thereof on the data display apparatus; and

a destination file production means for receiving the generic form of the logical record to produce a destination file logical record from contents of the generic form, said destination file logical record having a format proper for the file type of a destination file.

2. The digital computer system of claim 1 wherein:

the display production means displays the generic form as a row.

3. The digital computer system of claim 1 wherein:

the generic form production means produces a plurality of generic forms wherein each one of the plurality of generic forms corresponds to one of a sequence of logical records read from the source file and

the display production means produces a display of the generic forms in an order corresponding to an order of the logical records in the sequence.

4. The digital computer system of claim 1 wherein:

the digital computer system further includes a data input apparatus; and

the display production means receives a first display operation specifier from the data input apparatus and produces the display of a first generic form as specified by the first display operation specifier.

5. The digital computer system of claim 4 wherein:

a second display operation specifier specifies a second logical record different from a record corresponding to the first generic form currently being displayed; and

the generic form production means responds thereto by reading the second logical record from the file and using contents of the second logical record to produce a second generic form.

6. The digital computer system of claim 4 wherein:

the display operation specifier specifies that a portion of the generic form be displayed; and

the display production means responds thereto by producing a display of the portion.

7. The digital computer system of claim 4 wherein:

the display operation specifier specifies that the generic form be displayed as a sequence of hexadecimal values; and

the display production means responds thereto by displaying the generic form as the corresponding sequence of hexadecimal values.

8. In a digital computer system including a data display apparatus and a data exchange apparatus for exchanging data between a source file and a destination file, each of these files belonging to one of a plurality of file types wherein the file types include a stream file type, a record file type, a record and field file type and a document file type, a method for viewing one or more of the items of data in the source file to be exchanged with the destination file comprising:

selecting a file containing an item of data to be viewed;

reading a logical record which contains the item of data to be viewed from the selected file;

using the contents of the logical record to produce a generic form of the logical record which is non-specific to any of the file types which represents the contents of the logical record as an arrangement of codes representing displayable characters; and

producing a display of the generic form on the data display apparatus.

9. In a digital computer system having access to files belonging to a plurality of file types, a display apparatus for receiving a control input from a user of the digital computer system, a data exchange apparatus for exchanging data between a source file having a first file type and a destination file having a second file type different from the first file type, comprising:

(1) generic form production means for reading a source file logical record from the source file and producing a generic form representation of contents of the logical record wherein the contents are represented as an arrangement of codes representing displayable characters that are non-specific to the first file type or the second file type;

(2) destination record production means for receiving the generic form representation, using the representation therein to produce a destination file logical record, and writing the destination file logical record to the destination file;

(3) data viewing means for receiving the generic form representation and displaying the generic form representation on the display apparatus; and

(4) data exchange control means for receiving the control input from the input apparatus, for operating the generic form production means and the destination record production means to exchange contents of a first source file logical record between the source file and the destination file and for operating the generic form production means and the data viewing means to view contents of a second given source file logical record as determined by the control input.

10. A digital computer system having access to files for storing items of data, the files each having a file type selected from a plurality of file types wherein the file types include a stream file type, a record file type, a record and field file type and a document file type, wherein each file type identifies the format of items of data stored therein, said digital computer system including

a display apparatus for displaying data and

a data exchange apparatus for exchanging one or more items of data between a source file having a file type within the plurality of file types and a destination file having a different one of the plurality of file types, the data exchange apparatus comprising:

(1) for each of the file types, a generic form production means for operating when the source file has a corresponding source file type to read a source file logical record containing an item of data from the source file for each item of data to be exchanged and to produce a generic form from the source file logical record, the generic form representing each item of data as an arrangement of codes of displayable characters, said generic form being non-specific to any of the file types; and

(2) for each of the file types, destination record production means for operating when the destination file has a corresponding file type to receive the generic form for each item of data to be exchanged, to use the generic form of each item of data to produce a destination file logical record in which each item of data has a proper format for the corresponding file type of the destination file, and to write the destination file logical record to the destination file.

11. The digital computer system of claim 10 wherein:

the source file logical record contains a field of data and

the generic form production means includes means for receiving a field identifier code specified by a user and including a field identifier code in the generic form as identification for a representation of the field of data in the source file logical record in the generic form.

12. The digital computer system of claim 10 wherein:

the data exchange apparatus further includes data viewing means for receiving the generic form of the source file logical record from the generic form production means and for displaying the generic form of the source file logical record on the display apparatus.

13. The digital computer system of claim 12 wherein:

the data viewing means further includes interactive means for defining fields of data in source file logical records in the generic form; and

the destination record production means responds to such fields defined in the generic form by producing fields of data in destination file logical records corresponding to the defined fields of data in the generic form, said fields of data in the destination file logical records contain representations of data represented in the corresponding fields of the generic form.

14. The digital computer system of claim 10 wherein:

the data exchange apparatus further includes means for specifying operations to be performed during the exchange of data and

the generic form production means and the destination record production means each respond to the means for specifying operations by performing certain of the specified operations.

15. The digital computer system of claim 14 wherein:

the means for specifying operations is interactive.

16. The digital computer system of claim 10 wherein:

the source file has a stream file type;

the source file logical record is a sequence of codes from the source file; and

the generic form production means produces a generic form of the source file logical record which is an arrangement of displayable characters representing the sequence of codes of the source file logical record.

17. The digital computer system of claim 10 wherein:

the source file has a record file type; and

the generic form production means produces a generic form of the source file logical record which is an arrangement of displayable characters representing contents of the source file logical record.

18. The digital computer system of claim 10 wherein:

the source file has a record and field file type and represents a tabular display;

the source file logical record is a representation in the source file of a row of the tabular display; and

the generic form production means produces a generic form of the source file logical record which is an arrangement of displayable characters representing the row.

19. The digital computer system of claim 18 wherein:

the row of the tabular display is subdivided into empty and non-empty cells; and

the generic form production means further receives a user-defined field identifier code which it inserts ahead of the representation of each non-empty cell in the generic form and which it inserts at each location in the generic form corresponding to a location of an empty cell in the row.

20. The digital computer system of claim 10 wherein:

the source file has a document file type;

the logical source file record is a line of the document; and

the generic form production means produces a generic form of the source file logical record which is a representation in displayable characters of the line.

21. The digital computer system of claim 10 wherein:

the destination file has a stream file type;

the destination file logical record is a sequence of codes of types acceptable in the destination file; and

the destination record production means produces a sequence of codes of types acceptable in the destination file that represent the generic form of the source file logical record.

22. The digital computer system of claim 10 wherein:

the destination file has a record file type;

the destination file logical record is a physical record of the destination file; and

the destination record production means produces a physical record of the destination file which contains a representation of the generic form of the source file logical record.

23. The digital computer system of claim 10 wherein:

the destination file has a record and field file type;

the destination file logical record is a representation of a row in the destination file; and

the destination record production means produces a row representation using contents of the generic form of the source file logical record.

24. The digital computer system of claim 23 wherein:

the generic form includes a field identifier character defined by a user for identifying empty and non-empty fields; and

the destination record production means receives a field identifier character specification specifying the field identifier character and responds thereto by producing a row representation containing empty and non-empty fields as specified by the field identifier character.

25. The digital computer system of claim 10 wherein:

the destination file has a document file type;

the destination file logical record is a representation of a page containing a line in the destination file; and

the destination record production means produces a page wherein the line is a representation of contents of the generic form of the source file logical record.

26. The digital computer system of claim 25 wherein:

the destination record production means is responsive to a user specification that the generic form of the source file logical record corresponds to the line and appends a code specifying a new line to the representation of the contents of the generic form of the source file logical record.

27. In a digital computer system having access to files for storing items of data, the files belonging to a plurality of file types wherein the file types include a stream file type, a record file type, a record and field file type and a document file type, said file types identifying a format of the items of data stored therein,

a method of exchanging one or more of the items of data between any source file having one of the plurality of file types of the file types and any destination file having one of the plurality of file types which is different from the source file type, the method comprising the steps of:

from a plurality of generic form production means, each corresponding to one of the plurality of file types, selecting a generic form production means corresponding to the source file'"'"'s file type and from a plurality of destination record production means, each corresponding to one of the plurality of file types, selecting a destination record production means corresponding to the destination file'"'"'s file type; and

for each one of the items of data to be exchanged, performing the steps of

employing the selected generic form production means to perform the steps of

reading a source file logical record containing the item of data from the source file and

producing a generic form from the logical record, the generic form representing the item of data as an arrangment of codes representing displayable characters that are non-specific to any of the file types and

employing the selected destination record production means to perform the steps of

producing from the generic form a destination file logical record in which the item of data has a proper format for the type of the destination file and

writing the destination file logical record to the destination file.

28. The method of claim 27 wherein:

the source file has a stream file type and the source file logical record is a specified sequence of codes from the source file; and

the step of producing the generic form is performed by representing the specified sequence of codes by means of a sequence of distinct additional codes representing corresponding displayable characters.

29. The method of claim 27 wherein:

the source file has a record file type; and

the step of producing the generic form is performed by representing contents of the source file logical record by means of a sequence of distinct additional codes representing corresponding displayable characters.

30. The method of claim 27 wherein:

the source file has a record and field file type and represents a tabular display and the source file logical record is a representation in the source file of a row of the tabular display; and

the step of producing the generic form is performed by representing the contents of the row by means of a sequence of distinct additional codes representing corresponding displayable characters.

31. The method of claim 27 wherein:

the source file has a document file type and the source file logical record is a line of the document; and

the step of producing the generic form is performed by representing contents of the line by means of a sequence of distinct additional codes representing corresponding displayable characters.

32. The method of claim 27 wherein:

the destination file has a stream file type and the destination file logical record is a sequence of codes that are acceptable to the destination file given its stream file type; and

the step of producing the destination file logical record is performed by producing a sequence of codes representing the contents of the generic form.

33. The method of claim 27 wherein:

the destination file has a record file type; and

the step of producing the destination file logical record is performed by producing a physical record of the destination file which contains a representation of the generic form.

34. The method of claim 27 wherein:

the destination file has a record and field file type and represents a tabular display and the destination file logical record is the representation in the source file of a row of the tabular display; and

the step of producing the destination file logical record is performed by producing a row representation which contains a representation of the generic form.

35. The method of claim 34 wherein:

the destination file has a document file type and the destination file logical record is a representation of a page containing a line; and

the step of producing the destination file logical record is performed by using contents of the generic form to produce a line.

36. In a digital computer system having access to files for storing items of data, the files each having a file type of a plurality of file types, said file types including a stream file type, a record file type, a record and field file type and a document file type and identifying a format of the items of data stored therein,

a data exchange apparatus for exchanging one or more of the items of data between a source file having a first file type and a destination file having a second file type that is different from the first file type, comprising:

(1) operation specification means for specifying operations to be performed during exchange of items of data; and

(2) record exchange means operating as specified by the operation specification means for performing an exchange operation for each item of data, the exchange operation including reading a source file logical record from the source file, using contents of the source file logical record to produce a generic form in which the contents of the source file logical record are represented as an arrangement of codes representing displayable characters such that the arrangement is non-specific to any of the file types, using the contents of the generic form to produce a destination file logical record in which each item of data has a format proper for a file of a type of the destination file, and writing the destination file logical record to the destination file.

37. The data exchange apparatus of claim 36 wherein:

the operation specification means operates interactively to obtain specifications of operations from a user of the data exchange apparatus.

38. The data exchange apparatus of claim 37 wherein:

the operation specification means includes an interactive viewing means for viewing a display of the generic form and for specifying an operation in terms of the display.

39. The data exchange apparatus of claim 36 wherein:

the operation specification means specifies a file type of the source file and a file type of the destination file; and

the record exchange means reads the source file logical record and produces the destination logical record.

40. The data exchange apparatus of claim 36 wherein:

the data exchange involves a plurality of source file logical records; and

the record exchange means performs an operation specified by the operation specification means each time the record exchange means performs the exchange operation for one of the plurality of source file logical records.

41. The data exchange apparatus of claim 36 wherein:

the source file logical record includes at least one field;

the operation specification means specifies an input field identification operation and a field identifier code; and

the record exchange means performs the input field identification operation by employing the field identifier code in the generic form to identify a representation therein corresponding to the field of the source file logical record.

42. The data exchange apparatus of claim 41 wherein:

the field in the source file logical record is empty; and

the record exchange means further performs the input field identification operation by employing the field identifier code to identify a location in the generic form corresponding to the empty field in the source file logical record.

43. The data exchange apparatus of claim 41 wherein:

the operation specification means operates interactively to obtain a field identifier code from a user of the data exchange apparatus.

44. The data exchange apparatus of claim 36 wherein:

the destination file logical record contains at least one field;

the operation specification means specifies an output field identification operation; and

the record exchange means performs the output field identification operation by identifying a representation of the field in the generic form and using the representation of the field to produce the field in the destination file logical record.

45. The data exchange apparatus of claim 44 wherein:

the operation specification means specifies the output field identification operation by specifying a field identifier code in the intermediate representation; and

the record exchange means identifies the

representation of the field by means of the

field identifier code.

46. The data exchange apparatus of claim 45 wherein:

the operation specification means includes a viewing means for viewing a display of the generic form to determine the field identifier code.

47. The data exchange apparatus of claim 44 wherein:

the operation specification means specifies the output field identification operation by specifying a starting position and a length of the representation of the field in the generic form; and

the record exchange means identifies the representation of the field by means of the starting position and the length.

48. The data exchange apparatus of claim 47 wherein:

the operation specification means includes an interactive viewing means for viewing a display of the generic form and for specifying the starting position and length of the field in the generic form.

49. The data exchange apparatus of claim 47 wherein:

the operation specification means further specifies a type of the representation of the field in the generic form; and

the record exchange means represents the representation of the field in a manner consistent with a specified field type in the destination file.

50. The data exchange apparatus of claim 49 wherein:

the operation specification means includes an interactive viewing means for viewing a display of the generic form and specifying a field type of the field in the generic form.

51. The data exchange apparatus of claim 36 wherein:

the operation specification means specifies that the generic form be stored in the destination file logical record so that it is followed by a character code representing a new line; and

the record exchange means responds thereto by placing the character code representing a new line after the generic form in the destination file logical record.

52. The data exchange apparatus of claim 36 wherein:

the source file has a stream type;

the operation specification means specifies the source file logical record; and

the record exchange means responds thereto by reading the specified logical record from the source file.

53. The data exchange apparatus of claim 52 wherein:

the operation specification means specifies the source file logical record by specifying a number of character codes; and

the record exchange means responds thereto by reading a sequence of codes containing the specified number of codes from the source file as the specified logical record.

54. The data exchange apparatus of claim 52 wherein:

the operation specification means specifies the source file logical record by specifying a logical record terminator code; and

the record exchange means responds thereto by reading a sequence of codes from the source file until the logical record terminator code is encountered and then by employing the read sequence as the logical record.

55. The data exchange apparatus of claim 36 wherein:

the source file has an indexed record type wherein logical source file records are specified by index values;

the operation specification means specifies a range of the index values; and

the record means responds thereto by reading the source file logical record only if the source file logical record'"'"'s index value is within the specified range of index values.

56. The data exchange apparatus of claim 36 wherein:

the destination file has an indexed record type wherein logical records are specified by index values;

the operation specification means specifies a range of the index values; and

the record exchange means responds thereto by producing the destination file logical record only if the destination file logical record'"'"'s index value is within the specified range of index values.

57. The data exchange apparatus of claim 36 wherein:

the source file has a document type wherein the source file logical record is a page which has a page number;

the operation specification means specifies a range of page numbers; and

the record exchange means responds thereto by reading the source file logical record only if the source file logical record'"'"'s page number is within the specified range of page numbers.

58. The data exchange apparatus of claim 57 wherein:

the source file logical record contains at least one line which has a line number;

the operation specification means specifies a range of line numbers; and

the record exchange means responds thereto by reading the line only if the line'"'"'s line number is within the specified range of line numbers.

59. The data exchange apparatus of claim 36 wherein:

the destination file has a document type wherein the destination file logical record is a page made up of lines;

the operation specification means specifies a maximum number of lines on the page; and

the record exchange means responds thereto by placing the line in the destination file logical record only if the number of lines on the page does not exceed the specified maximum number of lines.

60. In a digital computer system having access to files for storing items of data, the files each having a file type of a set of file types, said file type identifying a format of the items of data sorted therein,

a method for exchanging one or more of the items of data between a source file having a first file type and a destination file having a second file type that is different from the first file type, comprising performing the steps of:

providing a specification of a data exchange operation; and

for each one of the items of data to be exchanged, performing the steps of

reading a source file logical record containing the item of data from the source file in accordance with the specification;

producing a generic form from the logical record in accordance with the specification, the generic form representing the item of data as an arrangement of codes representing displayable characters, said arrangement being non-specific to any of the file types;

using the generic form to produce a destination file logical record in which the item of data has a format consistent with a file type of the destination file in accordance with the specification; and

writing the destination file logical record to the destination file in accordance with the specification.

61. The method of claim 60 wherein:

the step of providing a specification of the data exchange operation is performed interactively.

62. The method of claim 61 wherein:

the step of interactively providing a specification of the data exchange operation is performed using a display of the generic form.