Method and apparatus for storing data in database form to a compact disc using a script file to describe the input format of data

• US 5,675,780 A
• Filed: 06/14/1996
• Issued: 10/07/1997
• Est. Priority Date: 06/01/1993
• Status: Expired due to Fees

• Current Assignee: Cd-Comm Systems Incorporated
• Original Assignee: Cd-Comm Systems Incorporated
• Inventors: Nguyen, David, Plant-Mason, William E.
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US08/664,376
• Time in Patent Office: 480 Days
• Field of Search: 395/606
• US Class Current: 1/1
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G11B 2220/213 Read-only discs
• CPC Class Codes: G11B 2220/218 Write-once discs
• CPC Class Codes: G11B 2220/2545 CDs
• CPC Class Codes: G11B 27/034 on discs G11B27/036, G11B27/038 take precedence
• CPC Class Codes: G11B 27/34 Indicating arrangements indicating means incorporated in magazine or cassette G11B23/046 and G11B23/0875; indicating measured values in general G01D
• CPC Class Codes: Y10S 707/99936 Pattern matching access

Abstract

A method and apparatus for rapidly storing input data in database form to a compact disc is provided. In one preferred embodiment, input data is provided to a computer via an input device, such as a 9-track tape or a disk drive. A script file descriptive of the characteristics of the input data is generated by a computer operator. A compact disc application development system (CADS) program processes the script file to create applications, indices and databases in accordance with commands from the script file. Undesired duplicative data may be discarded from the input data in accordance with commands from the script file. Additionally, data may be compressed using data compression techniques. The compressed or uncompressed data is then written to the previously created databases and indices. The application programs and related indices are designed to permit multiple field searches of all indexed fixed field data. The retrieval and applications programs created by the CADS program are designed to retrieve data records in the form of single page reports having some fixed field data common to all original pages of a multiple page report and additionally having scrollable detail or information lines. The database, applications programs and indices are all premastered using premastering software to convert it to a form suitable for storage on the compact disc. The premastered data is then written to a compact disc.

Claims

1. A method of storing data to a compact disc in database form, comprising the steps of:

analyzing the input data to determine the format of said input data;

generating a script file descriptive of the format of said data;

storing said script file in a computer containing a compact disc application development system program capable of processing said data in accordance with commands from said script file;

processing said script file with said compact disc application development system program on said computer to create application programs and empty indices and empty databases;

storing said application programs and created indices and databases to a storage device connected to said computer;

writing said input data to said created databases and created indices stored on said storage device;

premastering said applications programs, said written-to indices and said written-to databases using a premastering program executed by said computer to convert said generated applications programs, said generated indices and said generated databases into a predetermined format; and

writing said premastered applications, said premastered indices and said premastered databases to a compact disc.

2. The method of storing data to a compact disc of claim 1, additionally comprising the steps of:

storing said input data from an input device to a storage device connected to said computer; and

processing said input data in accordance with said script file to remove undesired duplicative data.

3. The method of storing data to a compact disc of claim 1, additionally comprising the step of:

compressing said data using a data compression program executed by said computer prior to writing said data to said empty indices and to said empty databases.

4. A method of storing data to a compact disc in database form, comprising the steps of:

analyzing the input data to determine the format of said input data;

generating a script file descriptive of the format of said data;

storing said script file in a storage device connected to a computer, said computer including a compact disc application development system program capable of processing said data in accordance with commands from said script file;

storing said input data from an input device to said storage device;

generating empty databases and empty indices on said computer in accordance with commands from said script file;

generating applications on said computer in accordance with information contained in said script file, said applications being designed to retrieve data in a single page-screen format, wherein fixed data common to all pages of a multiple page report is fixed on a first portion of said single page screen and wherein detail data unique to each page of a multiple page report may be displayed by scrolling through said detail data on a second portion of said single page screen;

writing said input data to said generated databases and generated indices;

premastering said applications programs, said written to indices and said written to databases using a premastering program executed by said computer to convert said applications programs, said written to indices and said written to databases into a predetermined format; and

writing said premastered applications, said premastered indices and said premastered databases, to a compact disc.

5. The method of storing data to a compact disc of claim 4, wherein said application programs are designed to search fixed-field data in response to a search query.

6. The method of storing data to a compact disc of claim 4, wherein said application programs are additionally designed to access multiple indices is response to a multiple field search query.

7. The method of storing data to a compact disc of claim 4, additionally comprising the steps of:

converting said input data from an EBCDIC format to ASCII;

separating relevant input data from irrelevant input data which was included in said input data when said input data was stored to said input device in said EBCDIC format;

discarding said irrelevant input data; and

inserting index points into said stripped and converted data.

8. The method of storing input data to a compact disc of claim 4, additionally comprising the step of:

compressing said data using a data compression program executed by said computer prior to writing said data to said indices and to said databases.

9. The method of storing input data to a compact disc of claim 4, additionally comprising the step of:

processing said input data to remove undesired duplicative data in accordance with commands from said script file.

10. A method of storing data to a compact disc in database form, comprising the steps of:

analyzing the input data to determine the format of said input data;

generating a script file, wherein said script file is descriptive of the format of said input data;

storing said script file onto a hard disc drive connected to a computer, said computer containing a compact disc application development system program capable of processing said input data in accordance with commands from said script file;

loading said input data from a 9-track tape drive to said computer;

converting said input data to an ASCII format using said computer;

inserting index points into said converted data;

storing said converted ASCII data in the form of at least one ASCII file on said hard drive of said computer;

generating applications programs using said computer in accordance with commands from said script file, said application programs being designed to retrieve data in a single page-screen format, wherein fixed data common to all pages of a multiple page report is fixed on a first portion of said single page screen and wherein detail data unique to each page of a multiple page report may be displayed by scrolling through said detail data on a second portion of said single page screen;

generating empty databases and empty indices on said computer in accordance with commands from said script file;

storing said applications programs, said generated indices and said generated databases to said hard drive of said computer;

processing said ASCII data to remove undesired duplicative data in accordance with commands from said script file;

writing said processed data to said generated databases and said generated indices;

premastering said applications programs, said written-to indices and said written-to databases using a premastering program executed by said computer to convert said applications programs, said written-to indices and said written-to databases to a predetermined format; and

writing said premastered applications, said premastered indices and said premastered databases, to a compact disc.

11. The method of storing data to a compact disc of claim 10, additionally comprising the step of:

compressing said data using a data compression program executed by said computer prior to writing said data to said indices and to said databases.

12. A system for storing data to compact disc in database form, comprising:

a computer for processing the input data in accordance with a script file descriptive of the format of said input data, said computer including storage means for storing processed and unprocessed data, processing means for processing data and memory means;

an input device connected to said computer for providing input data to be processed to said computer;

a compact disc applications development system program, stored in said memory of said computer, for generating applications programs, empty databases and empty indices in accordance with commands from said script file, for directing the processing of said input data in accordance with commands from said script file, and for writing said processed data to said generated databases and generated indices;

premastering means, stored in said memory of said computer, for converting said applications programs, said written-to databases and said written-to indices to a predetermined format; and

compact disc recorder means, connected to said computer, for storing said premastered applications programs, said premastered databases and said premastered indices to a compact disc.

13. The system for storing data to a compact disc of claim 12, additionally comprising compression means contained in said memory of said computer for compressing said processed data before said processed data is written to said databases and said indices.

14. The system for storing data to a compact disc of claim 12, wherein said input device is a 9-track tape drive.

15. The system for storing data to a compact disc of claim 12, wherein said application programs generated by said compact disc applications development system program are designed to retrieve data in a single page-screen format, wherein fixed data common to all pages of a multiple page report is fixed on a first portion of said single page screen and wherein detail data unique to each page of a multiple page report may be displayed by scrolling through said detail data on a second portion of said single page screen.

16. The system for storing data to a compact disc of claim 12, wherein said application programs are designed to search fixed field data in response to a search query.

17. The system for storing data to a compact disc of claim 16, wherein said application programs are additionally designed to access multiple indices in response to a multiple field search query.

18. A system for storing data to compact disc in database form, comprising:

means for generating a script file descriptive of the format of input data;

a computer for processing the input data in accordance with said script file, said computer including a hard disk drive, a microprocessor and memory;

a 9-track tape drive connected to said computer for providing input data to be processed to said computer;

conversion means contained in said memory for converting said input data into an ASCII format if said data is not already in ASCII;

a compact disc applications development system program, stored in said memory of said computer, for generating applications programs, empty databases and empty indices in accordance with commands from said script file, for processing said converted data to discard undesired repetitive data from said converted input data in accordance with commands from said script file, and for writing said processed data to said empty databases and indices;

premastering means, stored in said memory of said computer, for converting said applications programs, said written-to databases and said written-to indices to a predetermined format; and

compact disc recorder means, connected to said computer, for storing said premastered applications programs, said premastered databases and said premastered indices to a compact disc.

19. The system for storing data to a compact disc of claim 18, wherein said application programs generated by said compact disc applications development system program are designed to retrieve data in a single page-screen format, wherein fixed data common to all pages of a multiple page report is fixed on a first portion of said single page screen and wherein detail data unique to each page of a multiple page report may be displayed by scrolling through said detail data on a second portion of said single page screen and wherein said application programs are additionally designed to access multiple indices in response to a multiple field search query and wherein said application programs are additionally designed to search fixed field data in response to a search query.

20. The system for storing data to a compact disc of claim 19, additionally comprising compression means contained in said memory of said computer for compressing said processed data before said processed data is written to said databases and said indices.

21. A system for storing data to compact disc in database form, comprising:

a computer for processing input data in accordance with a script file descriptive of the format of said input data, said computer including storage means for storing processed and unprocessed data, processing means for processing data and memory means;

a compact disc applications development system program, stored in said memory of said computer, for generating applications programs, empty databases and empty indices in accordance with commands from said script file program, for directing the processing of said input data in accordance with commands from said script file, and for writing said processed data to said generated databases and generated indices;

premastering means, stored in said memory of said computer, for converting said applications programs, said written-to databases and said written-to indices to a format recognizable on said compact disc; and

compact disc recorder means, connected to said computer, for storing said premastered applications programs, said premastered databases and said premastered indices to a compact disc.

22. The system for storing data to a compact disc of claim 21, additionally comprising compression means contained in said memory of said computer for compressing said processed data before said processed data is written to said databases and said indices.

23. The system for storing data to a compact disc of claim 21, wherein said application programs generated by said compact disc applications development system program are designed to retrieve data in a single page-screen format, wherein fixed data common to all pages of a multiple page report is fixed on a first portion of said single page screen and wherein detail data unique to each page of a multiple page report may be displayed by scrolling through said detail data on a second portion of said single page screen.

24. The system for storing data to a compact disc of claim 21, wherein said application programs are designed to search fixed field data in response to a search query.

25. A system for storing data to compact disc in database form, comprising:

means for generating a script file descriptive of the format of input data;

a computer for processing the input data in accordance with said script file, said computer including a hard disk drive, a microprocessor and memory;

conversion means contained in said memory for converting said input data into an ASCII format if said data is not already in ASCII;

a compact disc applications development system program, stored in said memory of said computer, for generating applications programs, empty databases and empty indices in accordance with commands from said script file program, for processing said converted data to discard undesired repetitive data from said converted input data in accordance with commands form said script file, and for writing said processed data to said empty databases and indices;

premastering means, stored in said memory of said computer, for converting said applications programs, said written to databases and said written to indices to a format recognizable on said compact disc; and

compact disc recorder means, connected to said computer, for storing said premastered applications programs, said premastered databases and said premastered indices to a compact disc.

26. The system for storing data to a compact disc of claim 25, wherein said application programs generated by said compact disc applications development system program are designed to retrieve data in a single page-screen format, wherein fixed data common to all pages of a multiple page report is fixed on a first portion of said single page screen and wherein detail data unique to each page of a multiple page report may be displayed by scrolling through said detail data on a second portion of said single page screen and wherein said application programs are additionally designed to access multiple indices in response to a multiple field search query and wherein said application programs are additionally designed to search fixed field data in response to a search query.