US 7,774,377 B2Grant
Range definition method and system
Issue Date:2010-08-10
•23 Claims
•9 Drawing Sheets
Abstract
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.
Metadata
Assignee
- The TriZetto Group, Inc.
Inventor
- Roy Schoenberg
Application Information
Application Number:US 10/727,184
Filing Date:2003-12-03
Priority Date:2003-12-03
Art Unit:2156
Classifications
IPC:
G06F17/30G06F7/00
Patent Drawings (9 sheets)
Description
Related Applications
[0001] The following U.S. patent is hereby incorporated by reference into the subject application as if set forth herein in full: (1) U.S. Pat. No. 6,463,417, entitled “Method of Distributing Health Information”.
Field of the Invention
[0002] This invention relates to database record searching, and, more particularly, to text-based range searching of database records.
Background
[0003] The efficient management of large sets of computer-based data is a difficult task. In addition to the physical hardware requirements needed to effectuate the storage of the data, once the data is stored, the management and organization of the data may prove daunting.
[0004] Databases are often used to manage and maintain large sets of data, such that the data is organized around a defined database structure. When retrieving data stored within the database, the individual records of the database must be searched. Unfortunately, as the number of records within the database increases, the search time associated with retrieving the data increases dramatically, which often results in unacceptable delay times and latency.
Summary of the Invention
[0005] According to a first implementation, a range-conversion method 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.
[0006] One or more of the following features may also be included. A text-string may be associated with a specific data record. The specific data record may include a range-based data field. The text-based range descriptor that is associated with the field value of the range-based data field included in the specific data record may be incorporated into the text-string associated with the specific data record. A text-string may be generated for each data record. Each text-string may include one or more text-based data descriptors, and each data descriptor may include: a field descriptor that defines a specific data field within the data record to which the text-string is related, and a value descriptor that defines the field value associated with the specific data field.
[0007] Each text-string may include a record identifier that identifies the data record to which the text-string is related. A specific data record may include a range-based data field. The text-based range descriptor that is associated with the field value of the range-based data field included in the specific data record may be incorporated, as the value descriptor, into the text-string associated with the specific data record. Each data descriptor may include one or more starting characters, one or more separator characters, and one or more ending characters. The field descriptor may be positioned between the separator characters and one of the starting characters and the ending characters. The value descriptor may be positioned between the separator characters and the other of the starting characters and the ending characters. Each range of field values is a numeric range.
[0008] According to a further implementation, a search method includes defining a target data range for a range-based data field within a database record structure of a database. The database includes a plurality of data records. A plurality of text-strings are searched. Each text string is associated with one of the data records and includes one or more text-based data descriptors. At least one data descriptor within each text-string includes: a field descriptor that defines a specific range-based data field within the data record to which the text-string is related, and a text-based range descriptor that is associated with a range of field values for the specific range-based data field. A first result set is generated by identifying one or more text-strings that include a text-based range descriptor that is essentially equivalent to the target data range.
[0009] One or more of the following features may also be included. The data record associated with one or more of the text-strings identified in the first result set may be retrieved. Each text-string further may include a record identifier for associating the text-string and the data record to which the text-string is related. Each range of field values may be a numeric range. Each data descriptor may include one or more starting characters, one or more separator characters, and one or more ending characters. The field descriptor may be positioned between the separator characters and one of the starting characters and the ending characters. The text-based range descriptor may be positioned between the separator characters and the other of the starting characters and the ending characters. A target value may be defined for each of one or more data fields within the database record structure of the database.
[0010] The plurality of data records included in the database may be searched. A second result set may be generated by identifying one or more data records that include a field value that is essentially equivalent to at least one of the target values. One or more of the data records identified in the second result set may be retrieved. The data records may be representative of the medical records of patients.
[0011] According to a further implementation, a computer program product resides on a computer readable medium on which a plurality of instructions are stored. When executed by the processor, the instructions cause that processor to receive 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. Each text-based range descriptor is associated with a range of field values for one of the range-based data fields.
[0012] According to a further implementation, a computer program product resides on a computer readable medium on which a plurality of instructions are stored. When executed by the processor, the instructions cause that processor to define a target data range for a range-based data field within a database record structure of a database. The database includes a plurality of data records. A plurality of text-strings are searched. Each text string is associated with one of the data records and includes one or more text-based data descriptors. At least one data descriptor within each text-string includes a field descriptor that defines a specific range-based data field within the data record to which the text-string is related, and a text-based range descriptor that is associated with a range of field values for the specific range-based data field. A first result set is generated by identifying one or more text-strings that include a text-based range descriptor that is essentially equivalent to the target data range.
[0013] According to a further implementation, a searching system includes a server system having a computer processor and associated memory. The server system includes a database having a plurality of data records. The server system is configured to receive 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.
[0014] According to a further implementation, a searching system includes a server system having a computer processor and associated memory. The server system includes a database having a plurality of data records. The server system is configured to define a target data range for a range-based data field within a database record structure of a database. The database includes a plurality of data records. A plurality of text-strings are searched. Each text string is associated with one of the data records and includes one or more text-based data descriptors. At least one data descriptor within each text-string includes a field descriptor that defines a specific range-based data field within the data record to which the text-string is related, and a text-based range descriptor that is associated with a range of field values for the specific range-based data field. A first result set is generated by identifying one or more text-strings that include a text-based range descriptor that is essentially equivalent to the target data range.
[0015] One or more of the following features may also be included. The above-described systems may be coupled to a distributed computing network.
[0016] According to a further implementation, a data structure includes a database having a plurality of data records. Each data record includes one or more data fields. A field value is associated with each data field. The data structure includes a text-string for one or more data records. Each text-string has one or more text-based data descriptors, such that each data descriptor includes: a field descriptor that defines a specific range-based data field within the data record to which the text-string is related, and a text-based range descriptor that is associated with a range of field values for the specific range-based data field.
[0017] One or more of the following features may also be included. The text-strings may be stored within a text-based data file, such as an ASCII file.
[0018] The details of one or more implementations is set forth in the accompanying drawings and the description below. Other features and advantages will become apparent from the description, the drawings, and the claims.
Brief Description of the Drawings
[0019] FIG. 1 is a diagrammatic view of a record organization system coupled to a distributed computing network;
[0020] FIG. 2 is a more-detailed diagrammatic view of the record organization system of FIG. 1 ;
[0021] FIG. 3 is a diagrammatic view of a key maintenance module and a key processing module of the record organization system of FIG. 1 ;
[0022] FIG. 4 is a diagrammatic view of a record processing module of the record organization system of FIG. 1 ;
[0023] FIG. 5 is a diagrammatic view of a medical record;
[0024] FIG. 6 is a diagrammatic view of a patient selection display screen rendered by the record organization system of FIG. 1 ;
[0025] FIG. 7 is a diagrammatic view of a record searching module of the record organization system of FIG. 1 ; and
[0026] FIG. 8 is a diagrammatic view of a query definition display screen rendered by the record organization system of FIG. 1 .
Detailed Description of the Preferred Embodiments
[0027] Referring to FIG. 1 , there is shown a record organization system 10 that manages the various access keys 12, 14, 16 possessed by a medical service provider 18. Access keys 12, 14, 16 allow the medical service provider 18 to access the medical records (not shown) of various patients 20, 22, 24 (respectively).
[0028] Record organization system 10 typically resides on and is executed by a computer 26 that is connected to a network 28. Computer 26 may be a web server running a network operating system, such as Microsoft Window 2000 Server™, Novell Netware™, or Redhat Linux™. Typically, computer 26 also executes a web server application, such as Microsoft IIS™, Novell Webserver™, or Apache Webserver™, that allows for HTTP (i.e., HyperText Transfer Protocol) access to computer 26 via network 28.
[0029] The instruction sets and subroutines of record organization system 10, which are typically stored on a storage device 30 coupled to computer 26, are executed by one or more processors (not shown) and one or more memory architectures (not shown) incorporated into computer 26. Storage device 30 may be, for example, a hard disk drive, a tape drive, an optical drive, a RAID array, a random access memory (RAM), or a read-only memory (ROM).
[0030] As will be explained below in greater detail, a patient (e.g., patient 20) typically provides a key (e.g., access key 12) to medical service provider 18 through a patient computer 32, which is also connected to network 28. Additionally, medical service provider 18 accesses record organization system 10 through a client computer 34.
[0031] Referring also to FIG. 2 , record organization system 10 includes a centralized key repository 50 and a centralized medical records repository 52. Additionally, record organization system 10 includes a key maintenance module 54, a key processing module 56, a record processing module 58, and a record searching module 60, each of which will be discussed below in greater detail.
[0032] Centralized medical records repository 52 allows for the centralized storage of medical records 62, 64, 66 concerning various patients 20, 22, 24 respectively. As disclosed in U.S. Pat. No. 6,463,417, medical records 62, 64, 66 are typically divided into portions or levels, in that certain portions are considered more confidential than other portions. For example, a portion/level of the medical record that may be considered the least confidential might include general patient identification information and information concerning the patient's blood type and allergies. A portion/level of a medical record that may be considered to have an intermediate level of confidentiality might include information concerning the serological data, psychiatric data, cardiology data, and genetic data. A portion/level of the medical record that may be considered highly confidential may include infectious disease (e.g., HIV, and sexually transmitted diseases) data.
[0033] This specific assignment of confidentiality levels and the apportionment of the medical record into various portions/levels is for illustrative purposes only and is not intended to limit the scope of this disclosure.
[0034] Medical records 62, 64, 66 may be incrementally generated/configured online by the various medical service providers that provide care to patients 20, 22, 24. Alternatively, existing medical records may be uploaded (i.e., transferred) to medical records repository 52 from a remote storage location (not shown).
[0035] Referring also to FIG. 3 , patients 20, 22, 24 use key maintenance module 54 to generate 100 access keys 12, 14, 16 that grant access to various portions of the respective medical records 62, 64, 66. Accordingly, though the use of key maintenance module 54, the patient can generate access keys that not only regulate who has access to their medical records, but also regulate the level of access (i.e., which portions of a patient's medical record are viewable by the medical service provider to which the key is provided). Examples of access keys 12, 14, 16 are passwords (that allow access to various portions of a medical record) and decryption keys (that decrypt various portions of an encrypted medical record).
[0036] Typically, key maintenance module 54 is a web-enabled application that is accessed by the patients (e.g., patient 20) through a browser application (e.g., Microsoft Internet Explorer™, or Netscape Navigator™) that is running on patient computer 32. Alternatively, key maintenance module 54 may be a local application that is executed locally on patient computer 32.
[0037] As stated above, key maintenance module 54 allows a patient to generate 100 an access key for a specific medical service provider that grants, to that medical service provider, a defined level of access to that patient's medical records. Once this access key is generated, the access key is transmitted 102 to the medical service provider 18. This transmission of the access key may be implemented by transferring the access key from the patient to the medical service provider. This may occur by attaching the access key to an email that is transmitted to the medical service provider. Once received, the medical service provider may then transfer the newly-generated key to the key processing module 56 (to be discussed below in greater detail) of the record organization system 10. Alternatively, the patient may directly transfer the newly-generated key to the key processing module 54 of the record organization system 10.
[0038] Regardless of the manner in which the patient transfers the access key to the medical service provider, the access key will ultimately be received 120 by key processing module 56, which receives any access keys (e.g., keys 12, 14, 16) generated and transmitted by patients 20, 22, 24. Once these keys are received 120, they are stored 122 on centralized key repository 50. Additionally, if record organization system 10 is servicing multiple medical service providers (e.g., medical service providers 17, 18, 19), the received keys are associated 124 with the appropriate medical service provider so that the keys transmitted to a first provider are not available to a second provider.
[0039] Referring also to FIG. 4 , when medical records (i.e., uploaded existing records, newly-generated records, and/or amended records) are initially received 138, record processing module 58 stores 140 the medical record on centralized medical record repository 52. Typically, medical record repository 52 is a database that allows for the organized storage and retrieval of the medical records 62, 64, 66.
[0040] Once these medical records are stored on medical record repository 52, record processing module 58 allows the medical service provider 18 to access 142 the medical records 62, 64, 66 stored on medical records repository 52. However, the medical service provider 18 is only given access to the portions of the medical records for which the medical service provider 18 possesses the appropriate key. For example, assume that medical service provider 18 is a medical clinic that provides an array of medical services to its patients. Further, assume that patient 20 uses medical service provider 18 for all of their medical needs; patient 22 uses medical service provider 18 solely for treatment of depression; and patient 24 uses medical service provider 18 solely for treatment of HIV.
[0041] Concerning the access keys generated by each of these patients for medical service provider 18: patient 20 would typically provide medical service provider 18 with an access key (i.e., key 12) that grants access to their entire medical record; patient 22 would typically provide medical service provider 18 with an access key (i.e., key 14) that grants access to the general and psychiatric portions of their medical record; and patient 22 would typically provide medical service provider 18 with an access key (i.e., key 16) that grants access to the general and infectious disease portions of their medical record.
[0042] Record processing module 58 is typically a web-enabled application that is accessed by the medical service provider 18 through a browser application (e.g., Microsoft Internet Explorer™, or Netscape Navigator™) that is running on client computer 34. Typically, medical service provider 18 logs into key organization system 10 using an encrypted SSL (i.e., secure sockets layer) connection.
[0043] Referring also to FIG. 5 , medical records 62, 64, 66 are typically database records 160 that contain data fields (e.g., data field 162), each of which includes a field name 164 and a field value 166. Additionally, as discussed above, medical records 62, 64, 66 includes serological data 168, psychiatric data 170, cardiology data 172, genetic data 174, and infectious disease data 176, each of which may be further broken down into data fields.
[0044] To enhance the searchability of centralized medical record repository 52, record processing module 58 may process each record to generate 144 a text string that relates to that record. A example of a text string for record 160 is:
[0045]
| <first_name:timothy> <last_name:smith> <ss#:123456789> <street:20 |
| elm street> <city:boston> <state:ma> <zip:02110> <gender:male> |
| <weight:183> <cholosterol:172> <sys_press:12)> <dia_press:70> |
| <data_record: 1243562> |
[0046] The above-listed text string is a textual representation of the field-based data included within the “patient identification information” portion of the medical record 62 of patient 22 (i.e., Timothy Smith).
[0047] The text string includes one or more data descriptors (e.g., <dia_press:70>), each of which includes a field descriptor (e.g., dia_press) and a field value (e.g., 70). The field descriptor and the field value are typically separated by a separator character (e.g.,:), and the data descriptor begins with beginning characters (e.g., <) and ends with ending characters (e.g., >).
[0048] The field descriptor defines a specific data field within the data record to which the text-string is related. For example, the field descriptor “dia_press” relates to data field 164 in record 62. Further, the value descriptor defines the field value associated with the same specific data field. For example, the value descriptor “70” relates to field value 166
[0049] The text string typically also includes a record identifier (e.g., <data_record: 1243562>) that associates the text-string with the medical record upon which the text-string is based, so that the medical record may be subsequently retrieved.
[0050] Various types of data fields (e.g., data field 162) may be included in database records (e.g., record 160) and, therefore, the medical records of patients 20, 22, and 24. The type of data field varies depending on the type of field value expected to be entered. For example, some data fields are unstructured text data fields (e.g., first name, last name, street, city, and state). Additionally, data fields may require structured text data (e.g., Gender). Other data fields are binary data fields, in that they require a yes or no answer (e.g., a data field inquiring as to whether a patient is a smoker; not shown). Data fields may also be numeric data fields that require structured numerical data (e.g., the patient's social security number, or the patient's phone number (not shown)). Further, data fields may be unstructured numeric data fields, in which the field value entered spans a numeric range. Examples of this type of data field are weight, cholesterol, systolic pressure, diastolic pressure, and age (not shown).
[0051] When generating 144 a text string for a data record that contains data fields in which the possible field values span a numeric range (i.e., range-based data fields), it is often desirable to break down the numeric range into manageable portions (i.e., sub-ranges) to enhance searchability.
[0052] For example, total cholesterol readings are often divided by the medical community into the following ranges: <150 is ideal; 150-199 is desirable; 200-239 is a moderate risk; 240-274 is a high risk; and >275 is an extremely high risk.
[0053] Accordingly, when generating 144 text-strings, if it is determined 146 that the database records contain range-based data fields (e.g., the “cholesterol” data field 178), the user (e.g., a medical service provider, an administrator, etc.) may identify 148 one or more range-based data fields (within the database record structure) that the user intends to break down into manageable portions.
[0054] For example, as discussed above, total cholesterol readings are typically broken down into five ranges. If desired, record processing module 58 may define 150 multiple range descriptors, such that a unique text-based range descriptor is associated with each one of the total cholesterol ranges defined above. For example, a “1” may represent a total cholesterol reading of <150, a “2” may represent a total cholesterol reading of 150-199; a “3” may represent a total cholesterol reading of 200-239, a “4” may represent a total cholesterol reading of 240-274, and a “5” may represent a total cholesterol reading of >275. Therefore, one of the five range descriptors (i.e., “1”, “2”, “3”, “4”, or “5”) may be incorporated 152 into each text-string instead of the actual cholesterol reading. This results in the above-described text-string appearing as follows:
[0055]
| <first_name:timothy> <last_name:smith> <ss#:123456789> | |
| <street:20 elm street> <city:boston> <state:ma> <zip:02110> | |
| <gender:male> <weight:183> <cholosterol:2> <sys_press:12)> | |
| <dia_press:70> <data_record:1243562> | |
[0056] The incorporation of a text-based range descriptor into a text-string may occur when the text-string is initially generated, or may occur as a modification to an existing text-string.
[0057] The text-strings generated by record processing module 58 are typically stored 154 within centralized medical record repository 52. The text-strings may be stored in a group as a single text file, such as an ASCII (i.e., American Standard Code for Information Interchange) file. Alternatively, the text-strings may be stored as individual text-based files. Regardless of the manner in which the text-strings are stored, as will be discussed below, by searching the text strings for the occurrence of specific data descriptors, the medical records that contain desired information may be quickly identified.
[0058] Referring also to FIG. 6 , when accessing record organization system 10, record processing module 58 provides the medical service provider 18 with a rendered screen display 180 that includes a list of patient identifiers 182. Patient identifiers 182 define the particular patient(s) who provided access keys to medical service provider 18 (i.e., granting medical service provider 18 access to various portions of their medical record(s)). The patient identifiers 182 may be any element that uniquely identifies the patient, such as the patient's name, the patient's social security number, or a unique patient number. In this particular example, Mary Jones is patient 20, Timothy Smith is patient 22, and James Greco is patient 24.
[0059] The presence of each of these names in the list of patient identifiers 182 indicates that a key was received from that patient. In order to access the medical record of a patient for which the medical service provider has a key (i.e., for one of the patients listed in the list of patient identifiers 182), the medical service provider 18 selects the appropriate identifier using a mouse pointer 184 (or some other pointing device, not shown). For example, if the medical service provider wanted to access the medical record of Timothy Smith (i.e., patient 22), medical service provider 18 would typically click (using a mouse) on the specific identifier 186 associated with Timothy Smith. Record processing module 58 would then, in turn, use access key 14 to access (i.e., retrieve, decrypt, and display) medical record 62, the medical record of Timothy Smith, i.e., patient 22.
[0060] Medical record 62 may be displayed in a separate window or displayed full screen on the display of client computer 34. As discussed above, the key provided to the medical service provider 18 only allows access to the portion(s) of the patient's medical record that the patient wishes to allow access. Further, Timothy Smith (i.e., patient 22) is being treated by medical service provider 18 for depression and access key 14 grants access to the general and psychiatric portions of Timothy Smith's medical record. Accordingly, a link (e.g., link 188) to each available portion is displayed on the right-hand side of medical record 62. However, access key 14 does not permit access (i.e., prohibits access) to the other portions of Timothy Smith's medical record, namely Allergies, Serological Data, Cardiology Data, Genetic Data, and Infectious Disease Data. Accordingly, the links (e.g., link 190) to the unavailable data portions are struck-through. Other methods of differentiating the available portions from the unavailable portions of a medical record may be used, such as graying-out or not displaying links to the unavailable portions.
[0061] By clicking on the links to the available portions of the medical record, a specific available portion is displayed by record processing module 58.
[0062] Referring also to FIG. 7 , record searching module 60 facilitates the searching of medical records stored on the centralized medical record repository 52. This searching may be performed by a medical service provider (e.g., medical service provider 18) or an administrator of record organization system 10. However, the party doing the searching may only search the portions of the medical records to which they are granted access. This access may be based on the possession of keys (i.e., for medical service providers) or administrative privileges (i.e., for administrators), for example.
[0063] Record searching module 60 allows a user (e.g., a medical service provider, an administrator, etc.) to define 200 a target value or range of values for one or more of the data fields (e.g., data field 162) within the database record structure of the medical records (e.g., medical record 62) stored on centralized medical record repository 52. This target value may be a name, a number, a key word, or a text-based range descriptor, for example.
[0064] The database record structure refers to the field structure of a database records. For example, database record 62 includes twelve specific data fields (namely, first name, last name, social security number, street, city, state, zip code, gender, weight, cholesterol, systolic pressure, and diastolic pressure) and five data portions (namely serological data, psychiatric data, cardiology data, genetic data, and infectious disease data). As stated above, the patient controls the access to the various portions of their medical record through the use of access keys. Additionally, these portions are typically subdivided into numerous data fields.
[0065] Typically, record searching module 60 is a web-enabled application that is accessed by the user (e.g., medical service provider 18) through a browser application (e.g., Microsoft Internet Explorer™, or Netscape Navigator™) that is running on a computer (e.g., client computer 34). Alternatively, record searching module 60 may be a locally-executed application.
[0066] Referring also to FIG. 8 , when a user initiates a search, a query definition display 240 is rendered by record searching module 60 that allows the user to define 200 the search terms (e.g., target values and/or target ranges) of a database record query. For example, if medical service provider 18 wished to search the medical records (to which they have access) to determine which of their patients had an ideal total cholesterol reading (i.e., a total cholesterol reading of 150-199; which was assigned text-based range descriptor “2)), medical service provider 18 would enter the search term “2” into field 242 of display 240. In addition to text-based range descriptors, these search terms may be whole words, portions of words, wildcard descriptors (e.g., *), or any combination thereof.
[0067] Medical service provider 18 would then initiate 202 the search by “clicking” on the text-string search button 244 with mouse pointer 246. As, in the example, medical service provider 18 only has access to the medical records of three patients, namely Mary Jones (i.e., patient 20), Timothy Smith (i.e., patient 22), and James Greco (i.e., patient 24), the result list (not shown) for the query includes two entries, namely Mary Jones (who has a total cholesterol reading of 153) and Timothy Smith (who has a total cholesterol reading of 172). As James Greco has a total cholesterol reading of 206, he is not included in the result list.
[0068] When executing a text-string based search, the search is executed by associating the search term(s) entered (i.e., “2”) with the data field into which that search term was entered (i.e., “cholesterol”). This, in turn, generates a search term in the form of a data descriptor (i.e., <cholesterol:2>). Therefore, when executing the text-string search, the text string for each medical record available to the initiator of the search is examined to determine if any of these text strings contain the search term data descriptor. As discussed above, the text-string associated with patients Mary Jones (i.e., patient 20) and Timothy Smith (i.e., patient 22) include the data descriptor <cholesterol:2>. Additionally, each text-string includes a record identifier that associates the text-string to the medical record on which it is based. Therefore, once the relevant text strings are determined, the related medical records are easily ascertained. By performing text-based searches on text-strings, the search speed is increased and latency is reduced.
[0069] The result list (not shown) generated 204 in response to this query includes the names of Mary Jones and Timothy Smith. Typically, the result list is in the form of an HTML document. As the patient names are typically embedded links, when the user clicks on one or more of these links, the corresponding medical record is retrieved 206.
[0070] In addition to the text-based searches performed above, a record-based search may also be performed. Typically, a text-based search is performed as an initial search to generate a first result set. Often, this result set is quite large and, therefore, a secondary search may be performed on the first result set. Accordingly, once a determination 208 is made that the first result set needs to be further reduced in size, a secondary record-based search may be performed by defining 210 additional search terms (i.e., target values) that further restrict the result set. The new search is then performed 212 and a refined result set is generated 214 and presented to the user.
[0071] Assuming that Timothy Smith weighs 230 pounds, if the additional search term defines the desired weight as “<200 pounds”, Mary Jones will be the only patient specified in the second result set, as she weighs 143 pounds. As above, the medical record(s) specified in the second result set are easily retrieved 216 by clicking on the appropriate link. The search terms may be repeatedly refined until the result set is reduced to a size acceptable to the user.
[0072] As stated above, the secondary query may be performed using traditional record-based searching technique employed by database search engines. If record-based searching is desired, a record based search is initiated 212 by “clicking” on the record-based search button 248 with mouse pointer 246.
[0073] While medical record 66 is shown to include a plurality of links to the available portions of the medical record, other configurations are possible. For example, when clicking on a specific identifier (e.g., identifier 164), a medical record may be displayed that only includes the portions to which the medical service provider has access.
[0074] While the centralized key repository 50 and the centralized medical record repository 52 are described above as being located on a remote server, other configurations are possible. For example, as is known in the art, one or more of these repositories may be distributed across multiple computers/servers.
[0075] A number of implementations have been described. Nevertheless, it will be understood that various modifications may be made. Accordingly, other implementations are within the scope of the following claims.
Claims
What is claimed is:
1. A range-conversion method comprising:
receiving medical data records, wherein each of the medical data records includes at least a portion of a corresponding patient's medical history that includes one or more data fields and a field value associated with each data field;
identifying one or more of said data fields as a range-based data field;
defining, by an authorized user who has authorized access to the medical data records, a plurality of text-based range descriptors, wherein each text-based range descriptor is associated with a range of field values for one of the range-based data fields; and
generating a text-string for each of the medical data records, wherein the text-string includes one or more text-based data descriptors, such that each data descriptor includes:
a field descriptor that defines a specific data field within the each of the medical data records to which the text-string is related, and
a value descriptor that defines the field value associated with the specific data field;
wherein a specific data record includes a range-based data field, the range-conversion method further comprising:
incorporating, as the value descriptor of the text-string associated with the specific data record, the text-based range descriptor that is associated with the field value of the range-based data field included in the specific data record.
2. The range-conversion method of claim 1 wherein a text-string is associated with a specific data record.
3. The range-conversion method of claim 2 wherein the specific data record includes a range-based data field, the range-conversion method further comprising:
incorporating, into the text-string associated with the specific data record, the text-based range descriptor that is associated with the field value of the range-based data field included in the specific data record.
4. The range-conversion method of claim 1 wherein each text-string further includes a record identifier that identifies the data record to which the text-string is related.
5. The range-conversion 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.
6. The range-conversion method of claim 5 wherein the field descriptor is positioned between the separator characters and one of the starting characters and the ending characters.
7. The range-conversion method of claim 6 wherein the value descriptor is positioned between the separator characters and the other of the starting characters and the ending characters.
8. The range-conversion method of claim 1 wherein each range of field values is a numeric range.
9. The range-conversion method of claim 1 wherein each of the defined text-based range descriptors represents a corresponding medical status of the patient reflected by field values contained in the range of field values associated with the text-based range descriptor.
10. The range-conversion method of claim 1 wherein said authorized user comprises an authorized medical service provider of a patient.
11. The range-conversion method of claim 10 wherein said medical records are stored to a computer-based repository, and wherein said authorized medical service provider possesses an access key for the patient that permits access to at least a portion of the patient's medical records.
12. A computer program product residing on a computer readable medium having a plurality of instructions stored thereon which, when executed by the processor, cause that processor to:
receive medical data records, wherein each of the medical data records includes at least a portion of a corresponding patient's medical history that includes one or more data fields and a field value associated with each data field;
receive user selection of one or more of said data fields as a range-based data field;
receive user definition of a plurality of text-based range descriptors, wherein each text-based range descriptor is associated with a range of field values for the selected one or more of the range-based data fields; and
generate a text-string for each of the medical data records, wherein the text-string includes one or more text-based data descriptors, such that each data descriptor includes:
a field descriptor that defines a specific data field within the each of the medical data records to which the text-string is related, and
a value descriptor that defines the field value associated with the specific data field;
wherein a specific data record includes a range-based data field, the computer program product of claim further comprising instructions for:
incorporating, as the value descriptor of the text-string associated with the specific data record, the text-based range descriptor that is associated with the field value of the range-based data field included in the specific data record.
13. The computer program product of claim 12 wherein a text-string is associated with a specific data record.
14. The computer program product of claim 12 wherein the specific data record includes a range-based data field, the computer program product further comprising instructions for:
incorporating, into the text-string associated with the specific data record, the text-based range descriptor that is associated with the field value of the range-based data field included in the specific data record.
15. The computer program product of claim 12 wherein each text-string further includes a record identifier that identifies the data record to which the text-string is related.
16. The computer program product of claim of claim 12 wherein each data descriptor includes one or more starting characters, one or more separator characters, and one or more ending characters.
17. The computer program product of claim of claim 16 wherein the field descriptor is positioned between the separator characters and one of the starting characters and the ending characters.
18. The computer program product of claim of claim 17 wherein the value descriptor is positioned between the separator characters and the other of the starting characters and the ending characters.
19. The computer program product of claim of claim 12 wherein each range of field values is a numeric range.
20. The computer program product of claim 12 wherein each or the defined text-based range descriptors represents a corresponding medical status of the patient reflected by field values contained in the range of field values associated with the text-based range descriptor.
21. The computer program product of claim 12 wherein said user comprises an authorized medical service provider of a patient.
22. 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 medical data records, wherein each of the medical data records includes at least a portion of a corresponding patient's medical history;
wherein the server system is configured to:
receive medical data records, wherein each data record includes one or more data fields and a field value associated with each data field, and wherein said field value includes a patient-specific value or the corresponding patient;
identify one or more of said data fields as a range-based data field that can accept any numeric value within a range of valid numeric values;
define a plurality of text-based range descriptors, wherein each text-based range descriptor is associated with a range of field values for one of the range-based data fields, wherein each of the text-based range descriptors represents a corresponding medical status of the patient reflected by field values contained in the range of field values associated with the text-based range descriptor; and
generate a text-string for each of the medical data records, wherein the text-string includes one or more text-based data descriptors, such that each data descriptor includes:
a field descriptor that defines a specific data field within the each of the medical data records to which the text-string is related, and
a value descriptor that defines the field value associated with the specific data field;
wherein a specific data record includes a range-based data field, the range-conversion method further comprising:
incorporating, as the value descriptor of the text-string associated with the specific data record, the text-based range descriptor that is associated with the field value of the range-based data field included in the specific data record.
23. The searching system of claim 22 wherein the server system is coupled to a distributed computing network.
Patent Citations (17)
| Patent | Date | Inventor | Cited By |
|---|---|---|---|
| US4882474(A) | 1989-11-01 | Anderi et al. | Applicant |
| US5249169(A) | 1993-09-01 | Ogawa | Examiner |
| US5579407(A) | 1996-11-01 | Murez | Examiner |
| US5704044(A) | 1997-12-01 | Tarter et al. | Applicant |
| US5805719(A) | 1998-09-01 | Pare, Jr. et al. | Applicant |
| US6076166(A) | 2000-06-01 | Moshfeghi et al. | Applicant |
| US6104798(A) | 2000-08-01 | Lickiss et al. | Examiner |
| US6110224(A) | 2000-08-01 | Kawabe et al. | Examiner |
| US6154466(A) | 2000-11-01 | Iwasaki et al. | Examiner |
| US6463417(B1) | 2002-10-01 | Schoenberg | Applicant |
| US6643644(B1) | 2003-11-01 | Furusho | Examiner |
| US6772141(B1) | 2004-08-01 | Pratt et al. | Examiner |
| US2002/0171673(A1) | 2002-11-01 | Brown et al. | Examiner |
| US2003/0050803(A1) | 2003-03-01 | Marchosky | Examiner |
| US2003/0101238(A1) | 2003-05-01 | Davison | Examiner |
| US2003/0120622(A1) | 2003-06-01 | Nurmela et al. | Examiner |
| WO1/26020(A1) | 2001-04-01 | Applicant |
Non-Patent Literature (17)
- Annas, G., “A National Bill of Patient's Rights”, NEJM, 338, p. 695-699, Mar. 5, 1998.Applicant
- Barrows, R. Jr. et al., “Privacy, Confidentiality, and Electronic Medical Records”, J. Amer. Med. Inf. Assoc., 3, p. 139-148, Mar. 1996.Applicant
- Dudeck, J., “Aspects of Implementing and Harmonizing Healthcare Communication Standards”, Int. J. Med. Inf., 48, p. 163-171, Feb. 1998.Applicant
- Epstein, M. et al., “Security for the Digital Information Age of Medicine: Issues, Applications, and Implementation”, J. Digit Imaging, 11, p. 33-44, Feb. 1998.Applicant
- Espinosa, A., “Availability of Health Data: Requirements and Solutions”, Int. J. Med. Inf., 49, p. 97-104, Mar. 1998.Applicant
- Gibby, G. et al., “Availability of Records in an Outpatient Preanesthetic Evaluation Clinic”, J. Clin. Mon. & Computing, 14, p. 385-391, Aug. 1998.Applicant
- Leape, L., “Error in Medicine”, JAMA, 272, p. 1851-1857, Dec. 21, 1994.Applicant
- Leape, L. et al., “Promoting Patient Safety by Preventing Medical Error”, JAMA, 280, p. 1444-1447, Oct. 28, 1998.Applicant
- Mandl, K. et al., “Electronic Patient-Physician Communication: Problems and Promise”, Ann. Intern. Med., 129, p. 495-500, Sep. 15, 1998.Applicant
- Auston, I. et al., “Confidentiality of Electronic Health Data: Methods for Protecting Personally Identifiable Information”, National Library of Medicine, CBM 95-100, Mar. 1996.Applicant
- Neame, R., “Smart Cards—The Key to Trustworthy Health Information Systems”, BMJ, 314, p. 573-577, Feb. 22, 1997.Applicant
- Rind, D. et al., “Maintaining the Confidentiality of Medical Records Shared Over the Internet and the World Wide Web”, Ann. Intern. Med., 127, p. 138-141, Jul. 15, 1997.Applicant
- Schoenberg. R. et al., “Internet Based Repository of Medical Records that Retains Patient Confidentiality”, BMJ, 321, p. 1199-1203, Nov. 11, 2000.Applicant
- Slack, W. et al., “The CCC System in Two Teaching Hospitals: A Progress Report”, Int. J. Med. Inf., 54, p. 183-196, Sep. 1999.Applicant
- Toyada, K., “Standardization and Security for the EMR”, Int. J. Med. Inf., 48, p. 57-60, Feb. 1998.Applicant
- Woodward, B., “The Computer-Based Patient Record and Confidentiality”, NEJM, 333, p. 1419-1422, Nov. 23, 1995.Applicant
- Bell Atlantic and EMX Team Up to Provide Doctors Instant Online Access to Medical Data, PR Newswire, Feb. 23, 1999.Applicant