Range definition method and system
View Patent ↗A range-conversion method and system includes receiving data records. Each data record includes one or more data fields and a field value associated with each data field. One or more data fields are identified as a range-based data field. A plurality of text-based range descriptors are defined, such that each text-based range descriptor is associated with a range of field values for one of the range-based data fields.
1. A search method comprising:
executing, by a record searching module, a first search of a plurality of data records stored in a database for a target data range,
the database comprising a database record structure including range-based numeric data fields each specifying at least one defined target data range,
the first search including searching a plurality of text-strings associated with at least one of the data records,
each text string comprising one or more text-based data descriptors including a field descriptor that defines a specific range-based numeric data field within the data record to which the text- string is related, and
a text-based range descriptor that specifies one of a plurality of predetermined ranges of numeric values for the specific range-based numeric data field;
generating, by the record searching module, a first result set by identifying one or more text-strings that include a text-based range descriptor that specifies the target data range;
executing, by the record searching module, a second search of the plurality of data records stored in the database for target values,
wherein each of one or more numeric data fields within the database record structure of the database has a defined target value; and
generating a second result set by identifying one or more data records that include a field value that is equivalent to at least one of the target values.
2. The search method of claim 1 further comprising retrieving, by the record searching module, a data record associated with one or more of the text-strings identified in the first result set.
3. The search method of claim 1 wherein each text-string further includes a record identifier for associating the text-string and the data record to which the text-string is related.
4. The search method of claim 1 wherein each data descriptor includes one or more starting characters, one or more separator characters, and one or more ending characters.
5. The search method of claim 4 wherein the field descriptor is positioned between the separator characters and one of the starting characters and the ending characters.
6. The search method of claim 5 wherein the text-based range descriptor is positioned between the separator characters and the other of the starting characters and the ending characters.
7. The search method of claim 1 further comprising retrieving, by the record searching module, one or more of the data records identified in the second result set.
8. The search method of claim 1 wherein the data records are representative of the medical records of patients.
9. A computer program product residing on a non-transitory computer readable medium having a plurality of instructions stored thereon which, when executed by a processor, direct the processor to:
execute a first search of a plurality of data records stored in a database for a target data range,
the database comprising a database record structure including range-based numeric data fields each specifying at least one defined target data range,
the first search including searching a plurality of text-strings associated with at least one of the data records,
each text string comprising one or more text-based data descriptors including a field descriptor that defines a specific range-based numeric data field within the data record to which the text-string is related, and
a text-based range descriptor that specifies one of a plurality of predetermined ranges of values for the specific range-based numeric data field;
generate a first result set by identifying one or more text-strings that include a text-based range descriptor that specifies the target data range;
executing a second search of the plurality of data records stored in the database for target values, wherein each of one or more numeric data fields within the database record structure of the database has a defined target value; and
generating a second result set by identifying one or more data records that include a field value that is essentially equivalent to at least one of the target values.
10. The computer program product of claim 9 further comprising instructions for retrieving a data record associated with one or more of the text-strings identified in the first result set.
11. The computer program product of claim 9 wherein each text-string further includes a record identifier for associating the text-string and the data record to which the text-string is related.
12. The computer program product of claim 9 wherein each data descriptor includes one or more starting characters, one or more separator characters, and one or more ending characters.
13. The computer program product of claim 12 wherein the field descriptor is positioned between the separator characters and one of the starting characters and the ending characters.
14. The computer program product of claim 13 wherein the text-based range descriptor is positioned between the separator characters and the other of the starting characters and the ending characters.
15. The computer program product of claim 9 further comprising retrieving one or more of the data records identified in the second result set.
16. The computer program product of claim 9 wherein the data records are representative of the medical records of patients.
17. A searching system comprising:
a server system including a computer processor and associated memory,
the server system having a database that includes a plurality of data records;
wherein the server system is configured to
execute, by a record searching module, a first search of a plurality of data records stored in a database for a target data range, the database comprising a database record structure including range-based numeric data fields each specifying at least one defined target data range,
the first search including searching a plurality of text-strings associated with at least one of the data records,
each text string comprising one or more text-based data descriptors including a field descriptor that defines a specific range-based numeric data field within the data record to which the text-string is related, and
a text-based range descriptor that specifies one of a plurality of predetermined ranges of values for the specific range based numeric data field,
generate, by the record searching module, a first result set by identifying one or more text-strings that include a text-based range descriptor that specifies the target data range;
execute a second search of the plurality of data records stored in the database for target values, wherein each of one or more numeric data fields within the database record structure of the database has a defined target value; and
generate a second result set by identifying one or more data records that include a field value that is essentially equivalent to at least one of the target values.
18. The searching system of claim 17 wherein the server system is coupled to a distributed computing network.