System and method for storing, retrieving, and analyzing characterization data
First Claim
1. A method for structuring a set of data points, comprising:
- obtaining a plurality of data points, each having a data value and zero or more conditions associated therewith;
assigning a variable identifier to each unique condition associated with said plurality of data points, thereby assigning a plurality of variable identifiers;
constructing a number of variable arrays, each of said variable arrays representing a number of said variable identifiers;
designating a variable set handle for each unique combination of one or more of said variable identifiers, thereby assigning a plurality of variable set handles;
creating a VarSetInfo table that assigns said variable set handles to said variable arrays; and
, using said VarSetInfo table to relate individual data values to one of said variable set handles.
5 Assignments
0 Petitions
Accused Products
Abstract
A technique for efficiently structuring a database takes advantage of redundancy in data point conditions to reduce the time associated with the insertion of data points into a database and to reduce the amount of required storage space. The technique is particularly suited for semiconductor characterization data having a large number of test data points collected under repeated test conditions. The data point conditions are analyzed to inventory the different unique conditions associated with the given set of data points. Each unique combination of conditions is assigned a variable array, and each variable array element identifies a specific condition. The data point values are linked to variable set handles that represent the different variable arrays. In this manner, the data points can be inserted into the database without having to store each data point value with all of the corresponding conditions. Rather, the data point values are stored along with their respective variable set handles. The present invention also provides techniques for data extraction, management, and analysis, along with a database management system configured to carry out the various techniques.
44 Citations
31 Claims
-
1. A method for structuring a set of data points, comprising:
-
obtaining a plurality of data points, each having a data value and zero or more conditions associated therewith;
assigning a variable identifier to each unique condition associated with said plurality of data points, thereby assigning a plurality of variable identifiers;
constructing a number of variable arrays, each of said variable arrays representing a number of said variable identifiers;
designating a variable set handle for each unique combination of one or more of said variable identifiers, thereby assigning a plurality of variable set handles;
creating a VarSetInfo table that assigns said variable set handles to said variable arrays; and
,using said VarSetInfo table to relate individual data values to one of said variable set handles. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A method for extracting data points from a database, each data point having a data value and at least one condition associated therewith, comprising:
-
(a) reading, from a first data storage location, a number of individual data values and a number of corresponding variable set handles;
(b) reading a number of entries from a VarSetInfo table maintained at said first data storage location, said VarSetInfo table including said variable set handles and a number of variable arrays respectively assigned to said variable set handles;
(c) reading a number of entries from a VarInfo table maintained at said first data storage location, said VarInfo table including, for each unique condition associated with a set of data points, a variable name identifier, a variable value identifier, a variable array index identifier, and a variable value index identifier; and
(d) creating a master table that relates each of said individual data values with a number of conditions. - View Dependent Claims (12, 13, 14, 15, 16)
said variable arrays are initially encoded for compatibility with a first database format employed by said first data storage location; and
said method further comprises the step of decoding said variable arrays for compatibility with a second database format.
-
-
15. A method according to claim 14, wherein:
-
said first database format is compatible with character strings; and
said second database format is compatible with integer arrays.
-
-
16. A method according to claim 11, wherein:
-
said steps (a), (b), (c), and (d) are initially performed for a first set of data points;
said steps (a), (b), and (c) are repeated for a second set of data points; and
said method further comprises the step of formatting data values, variable set handles, VarSetInfo table entries, and VarInfo table entries for said second set of data points for merging with said master table.
-
-
17. A computer-readable data storage medium configured to accommodate a plurality of data points, said computer-readable data storage medium comprising:
-
a first data storage area defining a data point table that relates one of a plurality of variable set handles to each of a plurality of individual data values;
a second data storage area defining a VarSetInfo table that relates a unique variable array to each of said plurality of variable set handles; and
a third data storage area defining a VarInfo table having an entry for each unique condition associated with said plurality of data points, each entry including a variable name identifier, a variable value identifier, a variable array index identifier, and a variable value Index identifier. - View Dependent Claims (18, 19, 20, 21)
said first data storage area is associated with said file-based database format; and
said second and third data storage areas are associated with a DBMS-based storage format.
-
-
22. A method for structuring a set of data points, comprising:
-
obtaining a plurality of data points, each having a data value and at least one condition associated therewith;
creating a VarInfo table that includes, for each unique condition associated with said plurality of data points, a variable name identifier, a variable value identifier, a variable array index identifier, and a variable value index identifier;
constructing a number of distinct variable arrays, each of said variable arrays being associated with a unique combination of conditions associated with said plurality of data points; and
creating a VarSetInfo table that assigns a unique variable set handle to each of said variable arrays, thereby, assigning a plurality of variable set handles. - View Dependent Claims (23, 24, 25, 26, 27, 28, 29, 30, 31)
-
Specification