Efficient Data Processing
First Claim
Patent Images
1. A method for improving the operation of a computer by transferring data from an SQL database in a storage unit to a memory, the method comprising the steps of:
- copying the data from the SQL database to a binary file in the storage unit, the binary file having a data structure and a data type,configuring within the memory a data file having the data structure and the data type, andcopying the binary file in the storage unit to the data file in the memory with a single read/write operation.
1 Assignment
0 Petitions
Accused Products
Abstract
A method for improving the operation of a computer by transferring data from an SQL database in a storage unit to a memory by copying the data from the SQL database to a binary file in the storage unit, where the binary file having a data structure and a data type. A data file having the data structure and the data type is configured within the memory, and the binary file in the storage unit is copied to the data file in the memory with a single read/write operation.
-
Citations
13 Claims
-
1. A method for improving the operation of a computer by transferring data from an SQL database in a storage unit to a memory, the method comprising the steps of:
-
copying the data from the SQL database to a binary file in the storage unit, the binary file having a data structure and a data type, configuring within the memory a data file having the data structure and the data type, and copying the binary file in the storage unit to the data file in the memory with a single read/write operation. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A method for improving the operation of a computer by reading a data file of records in a memory, the method comprising:
-
reading through the entire data file only once to find record positions for data containing predetermined data characteristics, creating a pointer table in the memory, the pointer table including a single record position for a first instance of each of the predetermined data characteristics within the data file, and reading the data file starting at the record position in the pointer table that corresponds to a desired one of the predetermined data characteristics. - View Dependent Claims (8, 9)
-
-
10. A method for improving the operation of a computer by reading a data file of unsorted records to locate desired data, the method comprising:
-
reading through the entire data file only once to find record positions for data containing predetermined data characteristics, creating a first pointer table in the memory, the first pointer table including a single record position for a first instance of each of the predetermined data characteristics within the data file, creating a second pointer table in the memory, the second pointer table including, in association with the record position for the first instance of each of the predetermined data characteristics, a subsequent record position for a next subsequent instance of each of the predetermined data characteristics within the data file, and reading the data file starting at the record position in the first pointer table that corresponds to a desired one of the predetermined data characteristics, and if the data in the record position does not contain the desired data, iteratively reading the data file at the record position associated with the next subsequent instance in the second pointer table, until the desired data is found.
-
-
11. The method of claim 11, wherein a first pointer table and a second pointer table are created for each field within the data file.
-
12. A method for improving the operation of a computer by correlating variables in a data file, the method comprising the steps of:
-
reading the data file a first time to determine averages x andy for each x and y variable pair to be correlated,reading the data file a second time to determine for each xi and yi variable the following three values, where i represents the number of variables,
Σ
i(xi−x )(yi−y ),
√
{square root over (Σ
i(xi−x )2)},
√
{square root over (Σ
i(yi−y )2)},storing each of the three values in a cell of an array designated for the xi and yi variable pair, and using the three values in the array for each combination of xi and yi variables, computing the correlation value r according to the formula, - View Dependent Claims (13)
-
Specification