US5778350A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Data collection, processing, and reporting system
Assignee: Google LLC
•
Filing: 1995-11-30
•
Granted: 1998-07-07
•
Expires: 2015-11-30
Abstract
Abstract A system and method (10) for collecting and processing input data (16) and generating output data (24). The system (10) uses a plurality of dictionary tables (22) to control the reading, processing, and outputting of data. The system (10) includes at least one input processing table (32) having format and content information of the input data (16), and at least one output processing table (34) having format and content information of said output data (24). A multi-tasking process (60) is used to spawn a plurality of subtasks (90), each subtask processing one type of data, said subtasks accessing said input processing table (32) for determining how said input data (16) are to be read, and further accessing said output processing table (34) for determining how to create and format said output data (24). Other data dictionary tables (22) are used to track system activity and statistics, define the system that generated the data, and avoid duplicate processing of data.
Inventors
- 👤 Raymond J. Adams
- 👤 Harriet E. Brichta
- 👤 Roger J. Henn
- 👤 Drew A. Hollander
- 👤 Robert W. Adas
- 👤 Gerald R. Dolan
- 👤 Donna M. Bermender
- 👤 William D. Hawthorne
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-28 23:11
CPC Classifications
G; G06; G06F; G06F40/00; G06F40/10; G06F40/12
Claims Analysis
Total Claims: 66
Claim 1
Independent Claim
85 words
A system for collecting and processing input data and generating output data, comprising: at least one input processing table having format and content information of said input data; at least one output processing table having format and content information of said output data; and a process spawning at least one subtask, said subtask accessing said input processing table for determining how said input data are to be read, and further accessing said output processing table for determining how to create and format said output data.
Claim 2
Independent Claim
85 words
A system for collecting and processing input data and generating output data, comprising: at least one input processing table having format and content information of said input data; at least one output processing table having format and content information of said output data; and a process spawning at least one subtask, said subtask accessing said input processing table for determining how said input data are to be read, and further accessing said output processing table for determining how to create and format said output data.
Claim 3
Dependent Claim
23 words
The system, as set forth in claim 1, further comprising a user interface providing interactive access to said input and output processing tables.
Claim 4
Dependent Claim
20 words
The system, as set forth in claim 2, wherein said user interface further provides interactive access to said output data.
Claim 5
Dependent Claim
30 words
The system, as set forth in claim 1, wherein said input data are in the form of records and said output data are in the form of tables and reports.
Claim 6
Dependent Claim
30 words
The system, as set forth in claim 1, further comprising at least one view table containing rules for providing logical views of said output data having predetermined columns and rows.
Claim 7
Dependent Claim
24 words
The system, as set forth in claim 1, further comprising at least one grant table containing rules for authorizing access to said output data.
Claim 8
Dependent Claim
41 words
The system, as set forth in claim 1, wherein said input data are generated by a plurality of software and said at least one input processing table includes a table defining a software and release combination that generated said input data.
Claim 9
Dependent Claim
49 words
The system, as set forth in claim 1, wherein said input data are in the form of records and are generated by a plurality of software and said at least one input processing table includes a table defining sections and offsets into said input data records to each section.
Claim 10
Dependent Claim
58 words
The system, as set forth in claim 1, wherein said input data are in the form of records and are generated by a plurality of software and said at least one input processing table includes a table defining sections and section offsets into said input data records, and a table defining fields and field offsets into said sections.
Claim 11
Dependent Claim
35 words
The system, as set forth in claim 1, wherein said output data are in the form of tables and said output processing table further comprises a table containing information for naming said output data tables.
Claim 12
Dependent Claim
38 words
The system, as set forth in claim 1, wherein said output data are in the form of tables and said output processing table further comprises a table defining the information to be contained in each output data table.
Claim 13
Dependent Claim
42 words
The system, as set forth in claim 1, wherein said output data are in the form of tables and said output processing table further comprises a table defining the formulas to compute for values to be contained in each output data table.
Claim 14
Dependent Claim
39 words
The system, as set forth in claim 1, wherein said output processing table further comprises a table defining the action to be taken when a particular data element is present in an input processing table or output processing table.
Claim 15
Dependent Claim
47 words
The system, as set forth in claim 1, wherein said input data are in the form of records and said output data are in the form of tables, said output processing table further comprises a table specifying data input records used as input to output data tables.
Claim 16
Dependent Claim
28 words
The system, as set forth in claim 1, further comprising at least one system definition table containing information on a system from which said input data are collected.
Claim 17
Dependent Claim
26 words
The system, as set forth in claim 1, further comprising at least one system definition table containing record type and record name of said input data.
Claim 18
Dependent Claim
46 words
The system, as set forth in claim 1, further comprising a base table containing information unique to each processed input data record, said input data being in the form of input data records, said base table being used to avoid duplicate processing of input data records.
Claim 19
Dependent Claim
57 words
The system, as set forth in claim 1, further comprising a checkpoint summary table containing a range of time stamps of processed input data, said input data being in the form of input data records and each said record includes a time stamp, said checkpoint summary table being used to avoid duplicate processing of input data records.
Claim 20
Dependent Claim
19 words
The system, as set forth in claim 1, further comprising a table containing a formula for creating a table.
Claim 21
Dependent Claim
17 words
The system, as set forth in claim 1, further comprising a table recording job activities and statistics.
Claim 22
Dependent Claim
19 words
The system, as set forth in claim 1, further comprising a table logging all activities performed on each table.
Claim 23
Dependent Claim
27 words
The system, as set forth in claim 1, wherein said process is a multi-tasking process spawning a plurality of subtasks, each subtask processing one type of data.
Claim 24
Independent Claim
111 words
A method for collecting and processing input data and generating output data in response thereto, comprising the steps of: reading said input data according to at least one input processing table having format and content information of said input data; generating said output data according to at least one output processing table having format and content information of said output data; and said reading and generating steps being performed in a process spawning at least one subtask, said subtask accessing said input processing table for determining how said input data are to be read, and further accessing said output processing table for determining how to create and format said output data.
Claim 25
Independent Claim
111 words
A method for collecting and processing input data and generating output data in response thereto, comprising the steps of: reading said input data according to at least one input processing table having format and content information of said input data; generating said output data according to at least one output processing table having format and content information of said output data; and said reading and generating steps being performed in a process spawning at least one subtask, said subtask accessing said input processing table for determining how said input data are to be read, and further accessing said output processing table for determining how to create and format said output data.
Claim 26
Dependent Claim
23 words
The method, as set forth in claim 23, further comprising the step of providing interactive access to said input and output processing tables.
Claim 27
Dependent Claim
20 words
The method, as set forth in claim 24, further comprising the step of providing interactive access to said output data.
Claim 28
Dependent Claim
37 words
The method, as set forth in claim 23, wherein said input data reading step includes the step of reading input data records and said output data generation step includes the step of generating output tables and reports.
Claim 29
Dependent Claim
35 words
The method, as set forth in claim 23, further comprising the step of providing logical views of said output data having predetermined columns and rows according to at least one view table containing viewing rules.
Claim 30
Dependent Claim
29 words
The method, as set forth in claim 23, further comprising the step of authorizing access to said output data according to at least one grant table containing rules therefor.
Claim 31
Dependent Claim
44 words
The method, as set forth in claim 23, wherein said input data are generated by a plurality of software and the step of reading input data includes the step of accessing a table defining a software and release combination that generated said input data.
Claim 32
Dependent Claim
39 words
The method, as set forth in claim 23, wherein the step of reading input data includes the step of reading input data records according to a table defining sections and offsets into said input data records to each section.
Claim 33
Dependent Claim
48 words
The method, as set forth in claim 23, wherein the step of reading input data includes the step of reading input data records according to a table defining sections and section offsets into said input data records, and a table defining fields and field offsets into said sections.
Claim 34
Dependent Claim
35 words
The method, as set forth in claim 23, wherein the step of generating output data includes the step of generating output data tables according to a table containing information for naming said output data tables.
Claim 35
Dependent Claim
38 words
The method, as set forth in claim 23, wherein the step of generating output data includes the step of generating output data tables according to a table defining the information to be contained in each output data table.
Claim 36
Dependent Claim
42 words
The method, as set forth in claim 23, wherein the step of generating output data includes the step of generating output data tables according to a table defining the formulas to compute for values to be contained in each output data table.
Claim 37
Dependent Claim
49 words
The method, as set forth in claim 23, wherein the step of generating output data includes the step of generating output data tables according to a table defining the action to be taken when a particular data element is present in an input processing table or output processing table.
Claim 38
Dependent Claim
41 words
The method, as set forth in claim 23, wherein the step of generating output data includes the step of generating output data tables according to a table specifying which data input records are used as input to said output data tables.
Claim 39
Dependent Claim
30 words
The method, as set forth in claim 23, further comprising the step of accessing a system definition table containing information on a system from which said input data are collected.
Claim 40
Dependent Claim
30 words
The method, as set forth in claim 23, further comprising the step of accessing at least one system definition table containing record type and record name of said input data.
Claim 41
Dependent Claim
50 words
The method, as set forth in claim 23, further comprising the step of accessing a base table containing information unique to each processed input data record, said input data being in the form of input data records, said base table being used to avoid duplicate processing of input data records.
Claim 42
Dependent Claim
61 words
The method, as set forth in claim 23, further comprising the step of accessing a checkpoint summary table containing a range of time stamps of processed input data, said input data being in the form of input data records and each said record includes a time stamp, said checkpoint summary table being used to avoid duplicate processing of input data records.
Claim 43
Dependent Claim
67 words
The method, as set forth in claim 23, further comprising the steps of: creating a base table for a group of input data records; adding an entry in said base table for each processed input data record; accessing said base table prior to reading each input data record for processing; and skipping an input data record if an entry representative thereof is found in said base table.
Claim 44
Dependent Claim
23 words
The method, as set forth in claim 23, further comprising the step of accessing a table containing a formula for creating a table.
Claim 45
Dependent Claim
21 words
The method, as set forth in claim 23, further comprising the step of recording job activities and statistics in a table.
Claim 46
Dependent Claim
23 words
The method, as set forth in claim 23, further comprising the step of logging all activities performed on each table in a table.
Claim 47
Dependent Claim
32 words
The method, as set forth in claim 23, wherein said reading and generating steps are performed in a multi-tasking process spawning a plurality of subtasks, each subtask processing one type of data.
Claim 48
Dependent Claim
50 words
A plurality of dictionary tables for controlling a data processing process receiving input data and generating output data, comprising: at least one input processing table having format and content information of said input data; and at least one output processing table having format and content information of said output data.
Claim 49
Dependent Claim
50 words
A plurality of dictionary tables for controlling a data processing process receiving input data and generating output data, comprising: at least one input processing table having format and content information of said input data; and at least one output processing table having format and content information of said output data.
Claim 50
Dependent Claim
31 words
The dictionary tables, as set forth in claim 46, further comprising at least one view table containing rules for providing logical views of said output data having predetermined columns and rows.
Claim 51
Dependent Claim
25 words
The dictionary tables, as set forth in claim 46, further comprising at least one grant table containing rules for authorizing access to said output data.
Claim 52
Dependent Claim
42 words
The dictionary tables, as set forth in claim 46, wherein said input data are generated by a plurality of software and said at least one input processing table includes a table defining a software and release combination that generated said input data.
Claim 53
Dependent Claim
50 words
The dictionary tables, as set forth in claim 46, wherein said input data are in the form of records and are generated by a plurality of software and said at least one input processing table includes a table defining sections and offsets into said input data records to each section.
Claim 54
Dependent Claim
59 words
The dictionary tables, as set forth in claim 46, wherein said input data are in the form of records and are generated by a plurality of software and said at least one input processing table includes a table defining sections and section offsets into said input data records, and a table defining fields and field offsets into said sections.
Claim 55
Dependent Claim
36 words
The dictionary tables, as set forth in claim 46, wherein said output data are in the form of tables and said output processing table further comprises a table containing information for naming said output data tables.
Claim 56
Dependent Claim
39 words
The dictionary tables, as set forth in claim 46, wherein said output data are in the form of tables and said output processing table further comprises a table defining the information to be contained in each output data table.
Claim 57
Dependent Claim
43 words
The dictionary tables, as set forth in claim 46, wherein said output data are in the form of tables and said output processing table further comprises a table defining the formulas to compute for values to be contained in each output data table.
Claim 58
Dependent Claim
40 words
The dictionary tables, as set forth in claim 46, wherein said output processing table further comprises a table defining the action to be taken when a particular data element is present in an input processing table or output processing table.
Claim 59
Dependent Claim
48 words
The dictionary tables, as set forth in claim 46, wherein said input data are in the form of records and said output data are in the form of tables, said output processing table further comprises a table specifying data input records used as input to output data tables.
Claim 60
Dependent Claim
29 words
The dictionary tables, as set forth in claim 46, further comprising at least one system definition table containing information on a system from which said input data are collected.
Claim 61
Dependent Claim
27 words
The dictionary tables, as set forth in claim 46, further comprising at least one system definition table containing record type and record name of said input data.
Claim 62
Dependent Claim
47 words
The dictionary tables, as set forth in claim 46, further comprising a base table containing information unique to each processed input data record, said input data being in the form of input data records, said base table being used to avoid duplicate processing of input data records.
Claim 63
Dependent Claim
58 words
The dictionary tables, as set forth in claim 46, further comprising a checkpoint summary table containing a range of time stamps of processed input data, said input data being in the form of input data records and each said record includes a time stamp, said checkpoint summary table being used to avoid duplicate processing of input data records.
Claim 64
Dependent Claim
20 words
The dictionary tables, as set forth in claim 46, further comprising a table containing a formula for creating a table.
Claim 65
Dependent Claim
18 words
The dictionary tables, as set forth in claim 46, further comprising a table recording job activities and statistics.
Claim 66
Dependent Claim
20 words
The dictionary tables, as set forth in claim 46, further comprising a table logging all activities performed on each table.
References Cited (Backward Citations)
US4370707A
Cited
US3822378A
Cited
US4003031A
Cited
US4031515A
Cited
US4032900A
Cited
US4034350A
Cited
US4064553A
Cited
US4103334A
Cited
US4079234A
Cited
US4133041A
Cited
US4360872A
Cited
US4321672A
Cited
US4555759A
Cited
US4633397A
Cited
US4851999A
Cited
US4730252A
Cited
US4809170A
Cited
US4852000A
Cited
US5526518A
Cited
US5528492A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-07-06 | 2002-01-05 | 2002-07-07 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-07-06 | 2006-01-05 | 2006-07-07 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-07-06 | 2010-01-05 | 2010-07-07 | $7700.00 | Window Closed / Lapsed |