Flexible, modular electronic element patterning method and apparatus for compiling, processing, transmitting, and reporting data and information

• US 5,852,819 A
• Filed: 01/30/1997
• Issued: 12/22/1998
• Est. Priority Date: 01/30/1997
• Status: Expired due to Term

• Current Assignee: Beller, Stephen E.
• Original Assignee: Beller, Stephen E.
• Inventors: Beller, Stephen E.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Ho, Buay Lian
• Application Number:
  US08/790,549
• Time in Patent Office: 691 Days
• Field of Search: 707/1-10, 707/100-104, 707/200-206, 701/208, 701/213, 701/215, 701/207, 345/507, 345/326, 345/333, 345/334, 364/420, 364/489, 364/488, 364/490, 364/491
• US Class Current: 1/1
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

A method and apparatus for compiling(acquiring and storing), processing (analyzing, integrating, and organizing), transmitting, and reporting data and information, which is comprised of a flexible, modular system that overcomes major limitations of conventional and multidimensional databases. The method and apparatus utilizes computer programming code modules and modules of logically arranged digital signal function and formula formations to :(a) acquire data/information units using modules of query instruction items and response instruction items, which can be presented via a branching-logic process, (b))store the responses to the items in independent record files and internal database files, (c)integrate them with digital signals stored in other sources via an integration file, (d)process the digital signals in the digital signal processing files, (e) produce portable report files, and (f)generate reports utilizing report format tiles.

Claims

1. An apparatus with a modular structure for acquiring, storing, analyzing, integrating, organizing, transmitting, and reporting information and/or data and for presenting the information and/or data as digital signals, comprising:

(a) an electronic execution means providing control over said apparatus via instructions from at least one algorithm, stored in at least one file, comprised of at least one of computer programming code, macros, functions, and formulas;

(b) a user input means for entering commands providing further control over said apparatus, and for entering said digital signals and algorithms into said apparatus;

(c) a memory means for maintaining said digital signals in electronic and/or magnetic form;

(d) a data and information compilation means for acquiring and storing said digital signals;

(e) a storage means for storing at least one of said digital signals and algorithms;

(f) at least one independent record file and/or at least one internal database file providing a means for storing and transmitting said information and/or data referring to a single entity or occurrence;

(g) at least one processing file providing a means for processing said digital signals;

(h) at least one portable report file providing a means for storing and transmitting said digital signals in report ready format;

(i) at least one report format file providing a means for structuring report formats and retrieving information and/or data from external sources;

(j) a presentation means for providing an indication of said operation of said apparatus and for displaying said reports; and

(k) an output means for outputting said reports;

whereby said modular structure provides a substantially flexible and efficient means by which to compile, process, transmit, and report data and information, including the ability to readily modify modules without disrupting the structure or content of the other modules;

the ability to compile a multitude of data efficiently and with minimal sparseness and overhead;

the ability to enter a multitude of data types in a single field;

the ability to utilize independent record files with differing fields;

the ability to track data and information longitudinally;

the ability to integrate, analyze, and organize a multitude of data and information from a multitude of sources utilizing a multitude of algorithms and a multitude of data, information, and computer function and formula patterns;

the ability to transmit raw and processed data and information in a substantially compact and efficient form; and

the ability to generate, with substantial ease and flexibility, reports comprised of a multitude of formats and contents.

2. The apparatus of claim 1 wherein said data and information compilation means may utilize branching logic to facilitate the acquisition of said digital signals.

3. The apparatus of claim 1 wherein at least one data/information retrieval and processing file provides a means for retrieving and processing said digital signals from said independent record file and for storing the processed digital signals in at least one processed digital signal file.

4. The apparatus of claim 1 wherein at least one internal database file provides a means for storing said digital signals in database tables and processing said digital signals in said in database tables via conventional and/or multidimensional database methods, artificial intelligence methods, and statistical analyses.

5. The internal database file of claim 4 wherein said internal database file may be comprised of at least one of:

(a) a table record, comprising a database record in a database table, which is comprised of at least one of said digital signal elements from said independent record file;

(b) an extended table record, comprising a database record in a database table, which is comprised of at least one of said digital signal elements from said independent record file together with at least one digital signal elements from said processed digital signal file; and

(c) an aggregate digital signal unit which is comprised of said digital signal elements aggregated via database calculations.

6. The apparatus of claim 1 wherein at least one digital signal integration file provides a means for integrating, into at least one unified pattern, at least two digital signal elements comprising at least one of:

(a) said processed digital signal files;

(b) said internal database files;

(c) external database files comprising at least one element of information and/or data residing as digital signals in other than said processed digital signal files and said internal database files;

(d) reference information files comprising at least one element of reference information in digital signal form that is related to at least one element of said digital signals in said processed digital signal files and/or said internal database files; and

(e) the digital signal output from database analysis programs, which may be comprised of a program selected from the group consisting of online analytic processors with multidimensional databases, artificial intelligence programs, and statistical analysis programs.

7. The apparatus of claim 1 further comprised of a backup system which is comprised of:

(a) an electronic execution means for controlling the apparatus via instructions of at least one algorithm;

(b) a user input means for entering commands providing control over said apparatus and for entering information and/or data into the apparatus;

(c) a memory means for maintaining said data and information in electronic and/or magnetic form;

(d) a presentation means for providing an indication of said operation of said apparatus and for displaying said reports; and

(e) an output means for outputting said reports;

wherein said backup system provides a redundancy system for controlling the operation of the present apparatus and for storing, presenting, and outputting said digital signals.

8. The apparatus of claim 1 comprised of a user interactive means which is further comprised of:

(a) a user input means;

(b) a user display means; and

(c) a user output means;

wherein said user interactive means provides for remote accessing and utilization of said apparatus, and further wherein said user interactive means facilitates at least one of information and/or data entry, transmission and control over said apparatus, and further wherein output data may be obtained from said apparatus via said user output means, and further wherein said user interactive means may be interfaced with said apparatus by means of at least one of a telecommunication means, a radio communication means, and a satellite communication means, and may be utilized in one of a local area network and a wide area network.

9. A method utilizing modular processes for acquiring, storing, analyzing, integrating, organizing, transmitting, and reporting information and/or data, and for presenting the information and/or data as digital signals, comprising the steps of utilizing at least one algorithm comprised of at least one of computer programming code, macros, functions, and formulas for:

(a) obtaining preexisting information and/or data from external databases;

(b) obtaining new information and/or data utilizing electronic and/or nonelectronic means;

(c) storing said preexisting and new information and/or data as digital signals in at least one independent record file and/or at least one internal database file;

(d) processing said digital signals;

(e) producing at least one portable report file; and

(f) generating at least one output report indicative of said digital signals utilizing at least one report format file;

whereby said modular process provides a substantially flexible and efficient means for compiling, processing, transmitting, and reporting data and information, including the ability to readily modified modules without disrupting the structure or content of the other modules, the ability to compile a multitude of data efficiently and with minimal sparseness and overhead, the ability to enter a multitude of data types in a single field, the ability to utilize independent record files with differing fields, the ability to track data and information longitudinally, the ability to integrate, analyze, and organize a multitude of data and information from a multitude of sources utilizing a multitude of algorithms and a multitude of data, information, and computer function and formula patterns, the ability to transmit raw and processed data and information in a substantially compact and efficient form, and the ability to generate, with substantial ease and flexibility, customized reports comprised of a multitude of formats and contents.

10. The method of claim 9, wherein the process for storing said preexisting information and/or data comprises converting said preexisting information and/or data from an external database into digital signals which are stored in at least one of said independent record files;

and further wherein the process for storing said new information and/or data may comprise converting said new information and/or data from said internal database into digital signals which are stored in at least one of said independent record files.

11. The method of claim 9, wherein said process for obtaining new information and/or data via electronic means is comprised of the steps of utilizing:

(a) at least one query item for obtaining information and/or data in digital signal form by presenting a request for said information and/or data via an electronic presentation device;

(b) a query item header associated with each query item comprised of the steps of utilizing

(c) a query item identifier for identifying said query item with a unique alphanumeric string;

(d) at least one query item format code, comprised of an alphanumeric string, for indicating the form in which the query item is presented;

(e) at least one response instruction code, comprised of an alphanumeric string, for indicating the type of response instruction associated with said query item;

(f) at least one branching logic code, comprised of an alphanumeric string, for indicating Boolean branching logic variables used to navigate the order of presentation of said query items;

(g) at least one branching criterion, comprised of an alphanumeric string, for use in conjunction with said branching logic code for defining branching logic conditions; and

(h) at least one branch to location, comprised of an alphanumeric string, for use in conjunction with said branching logic code for defining the query item for presentation;

(i) at least one response instruction module comprised of at least one response instruction unit associated with each said query item comprised of the steps of utilizing

(j) at least one response instruction item for presenting, via a digital signal presentation device, instructions indicating the manner in which said query item is to be answered;

(k) at least one response-instruction header associated with each response instruction item comprised of the steps of utilizing

(l) at least one response instruction identifier, comprised of an alphanumeric string, for identifying said response instruction items;

(m) at least one response instruction format code, comprised of an alphanumeric string, for indicating the form in which the query item is presented;

(n) at least one input prompt code, comprised of an alphanumeric string, for indicating the format in which an input prompt is presented; and

(o) at least one response validation code, comprised of an alphanumeric string, for indicating acceptable types of responses;

or

(p) said query items with their associated response-items combined within them for presenting said query items without utilizing said response instruction identifier and response instruction format code;

whereby substantial varieties and quantities of data and information can be acquired with substantial efficiency, and whereby substantial modifications can readily be made to the types of data and information acquired and to the manner in which said data and information are obtained.

12. The method of claim 9, wherein said process for obtaining new information and/or data via nonelectronic means is comprised of utilizing nonelectronic query items and response instruction items to obtain information and/or data which are converted to digital signals.

13. The method of claim 9, wherein said process for storing said preexisting and new information and/or data as digital signals in at least one independent record file can be repeated over time;

whereby said digital signals in said independent record files provide an efficient and effective means to track data and information longitudinally and to analyze them to determine historical trends.

14. The method of claim 9, wherein said process for processing said digital signals comprises the steps of:

(a) retrieving at least one element of said digital signals from said independent record file;

(b) performing at least one processing routine on said digital signals comprising at least one of a mathematical and/or logical analysis, formatting, and organizing of said digital signals; and

(c) storing said processed digital signals in at least one processed digital signal file;

whereby said digital signals are transmitted and processed.

15. The method of claim 9, wherein a process for storing said digital signals in at least one internal database file comprises of the steps of storing said digital signals in:

(a) a table record, comprising a database record in a database table, which is comprised of at least one of said digital signal elements from said independent record file;

(b) an extended table record, comprising a database record in a database table, which is comprised of at least one of said digital signal elements from said independent record file together with at least one digital signal elements from said processed digital signal file;

whereby said digital signals are transmitted to and combined in database tables.

16. The method of claim 15, wherein said process for storing said digital signals in at least one of said internal database files further comprises an aggregate data/information unit which is comprised of said digital signals aggregated via database calculations.

17. The method of claim 9 wherein at least one digital signal integration file integrates, into at least one unified pattern, at least two digital signal elements comprising at least one of:

(a) said processed digital signal files;

(b) said internal database files;

(c) external database files comprising one element of information and/or data residing as digital signals in other than said processed digital signal files and said internal database files;

(d) reference information files comprising at least one element of reference information in digital signal form that is related to at least one element of said digital signals in said processed digital signal files and/or said internal database files; and

(e) the digital signal output from database analysis programs, which may be comprised of a program selected from the group consisting of online analytic processors with multidimensional databases, artificial intelligence programs, and statistical analysis programs;

whereby said digital signals from a plurality of sources can be saved as patterns in a single file.

18. The method of claim 9 wherein said process for producing at least one of said portable report files is comprised of the steps of processing at least one digital signal element of at least one of said digital signal integration files and/or said processed digital signal files to produce at least one of said portable report files;

and further wherein said digital signals in said portable report file are organized into one or a plurality of digital signal patterns and stored in one or a plurality of said portable report files;

whereby said digital signal patterns provide a flexible and efficient means for storing and transmitting digital signals used to generate a plurality of said output reports.

19. The method of claim 9 wherein the process for generating said output reports utilizing at least one of said report format file is comprised of the steps of:

(a) obtaining at least one element of said digital signals selected from the group consisting of said portable report files, said external database files, and said reference information files utilizing algorithms comprising said report format file;

(b) processing said digital signals utilizing formatting templates further comprising said report format file; and

(c) generating reports by presenting at least a portion of said report format file templates and the processed digital signals therein to a presentation device;

whereby said report format file templates and said processed digital signals therein generate, with substantial ease, customized reports comprised of a multitude of formats and contents; and

further whereby said reports can be comprised of digital signals from a plurality of sources; and

further whereby said reports can present longitudinal as well as single occurrence data and information.