System and method for database integrity checking

• US 8,078,592 B2
• Filed: 12/07/2007
• Issued: 12/13/2011
• Est. Priority Date: 12/07/2007
• Status: Active Grant

• Current Assignee: Roche Diabetes Care Inc. (Roche Holding AG)
• Original Assignee: Roche Diagnostics Operations Incorporated (Roche Holding AG)
• Inventors: Gejdos, Igor, Bernard, Keith B., Young, Morris J., Baker, Christopher Richard, Yarian, Lawrence G. III
• Primary Examiner(s): HICKS, MICHAEL J
• Application Number:
  US11/999,856
• Publication Number:
  US 20090150454A1
• Time in Patent Office: 1,467 Days
• Field of Search: None
• US Class Current: 707/690
• CPC Class Codes: G16H 10/60 for patient-specific data, e.g. for electronic patient records

Abstract

A method is disclosed for checking the integrity of a database through a test of database integrity information provided in the database and integrity information provided external to the database. The integrity information may be provided in a configuration file.

Claims

1. A method of checking the integrity of a database containing both physiological information and database integrity information the method including the steps of:

inputting physiological information into a database, the database stored on a computer readable memory accessible by a healthcare management software and further including database integrity information, the database integrity information comprising at least one value utilized by the healthcare management software in determining information relating to the physiological information to present with an output device;

storing integrity information on a computer readable media accessible by the healthcare management software system, the integrity information comprising at least one value utilized by the healthcare management software in determining information relating to the physiological information to present with an output device and stored separate from the database containing the physiological information, the healthcare management software system comprising a plurality of computer readable instructions and stored on a computer readable memory accessible by a computing device having a processor; and

determining an integrity of the database containing the physiological information based on a comparison of the at least one value of the integrity information and the at least one value of the database integrity information contained in the database, the step of determining performed by using the processor of the computing device to execute the plurality of machine readable instructions of the healthcare management software prior to the healthcare management software reading the physiological information.

2. The method of claim 1, wherein the at least one value of the integrity information includes at least one conversion quantity for the physiological information contained in the database, the at least one value of the database integrity information also including the at least one conversion quantity.

3. The method of claim 1, wherein the integrity information and the database integrity information further includes data not used by the healthcare management software system in determining output information to present with the output device, the data not used by the healthcare management software system in determining output information to present with the output device including at least one of a medical device key and a user identification code.

4. The method of claim 3, wherein the at least one value of the integrity information includes an identification code.

5. The method of claim 1, wherein the integrity information is included in a configuration file.

6. The method of claim 5, wherein the configuration file is encrypted.

7. The method of claim 5, wherein the at least one integrity information contained within the configuration file and utilized by the healthcare management software in determining information to present with the output device file is determined based on a global region identified by the user.

8. The method of claim 1, wherein the step of determining an integrity of the database containing the physiological information based on a comparison of the at least one value of the integrity information and the at least one value of the database integrity information contained in the database is performed as a part of an installation of the healthcare management software system.

9. The method of claim 1, wherein the step of determining an integrity of the database containing the physiological information based on a comparison of the at least one value of the integrity information and the at least one value of the database integrity information contained in the database is performed as a part of launching the healthcare management software system.

10. The method of claim 1, wherein the step of determining an integrity of the database containing the physiological information based on a comparison of the at least one value of the integrity information and the at least one value of the database integrity information contained in the database is performed in response to a request to load the database by the healthcare management software system.

11. The method of claim 1, wherein the step of determining an integrity of the database containing the physiological information based on a comparison of the at least one value of the integrity information and the at least one value of the database integrity information contained in the database is performed in response to a request to restore the database by the healthcare management software system.

12. The method of claim 1, wherein the step of determining an integrity of the database containing the physiological information based on a comparison of the at least one value of the integrity information and the at least one value of the database integrity information contained in the database is performed in response to a request to migrate the database from another format by the healthcare management software system.

13. The method of claim 1, wherein the step of determining an integrity of the database containing the physiological information based on a comparison of the at least one value of the integrity information and the at least one value of the database integrity information contained in the database is performed in response to a request to determine the integrity of the database provided to the healthcare management software system through an input device.

14. The method of claim 1, wherein the step of determining an integrity of the database containing the physiological information based on a comparison of the at least one value of the integrity information and the at least one value of the database integrity information contained in the database further includes the step of comparing the at least one value of the integrity information to the at least one value of the database integrity information to see if they are identical.

15. The method of claim 1, further comprising the step of:

providing an indication of the integrity of the database containing the physiological information with the output device accessible by the healthcare management software system, the step of providing performed by the healthcare management software system.

16. The method of claim 15, wherein the indication includes a visual indication provided with the output device by the healthcare management software system.

17. The method of claim 15, wherein the indication includes permitting a selection of at least one of a plurality of inputs of the healthcare management software system displayed on a display of the output device.

18. The method of claim 15, wherein the step of providing comprises providing an indication that the database includes an acceptable integrity.

19. The method of claim 1, wherein the database containing the physiological information and the database integrity information is stored on a medical device capable of generating the physiological information in an electronic format from a patient sample.

20. A system for managing healthcare related information, including

a display;

at least a first computing device having a processor;

a computer readable memory accessible by the first computing device, the computer readable memory including healthcare management software system comprising a plurality of instructions executable by the processor and adapted to display on the display a user interface of the healthcare management software system, the plurality of instructions of the healthcare management software system further adapted to display on the display representations of physiological information included in a patient database accessible by the healthcare management software system, the patient database stored on a computer readable memory and further including database integrity information comprising at least one value utilized by the healthcare management software system in determining representations of the physiological information to display on the display; and

at least one integrity information value, the at least one integrity information value stored on a computer readable memory and separate from the patient database, the at least on integrity information value accessible by the healthcare management software and utilized by the healthcare management software system in determining representations of the physiological information to display on the display, the healthcare management software adapted to verify an integrity of the patient database prior to displaying on the display representations of the physiological information included in the patient database, wherein the healthcare management software in verifying an integrity of the patient database compares the at least one value of the database integrity information contained in the patient database to the at least one integrity information value stored on the computer readable memory and separate from the patient database.

21. The system of claim 20, wherein the physiological information included in the patient database includes blood glucose values obtained from a glucose meter, the glucose meter being detected by the healthcare management software system.

22. The system of claim 20, wherein the file is an encrypted configuration file.

23. The system of claim 20, wherein the at least one integrity information value and the at least one value of the database integrity information comprises at least one of the values selected from the group consisting of:

a conversion quantity for the physiological information stored in the database;

a unit for the physiological information stored in the database;

a textual label for the physiological information stored in the database; and

an identification key independent of the physiological information stored in the database.

24. The system of claim 20, wherein the healthcare management software is configured to compare the at least one value of the database integrity information contained in the patient database to the at least one integrity information value stored on the computer readable memory and separate from the patient database by determining an amount of equivalence of the at least one value of the database integrity information to the at least one integrity information value.

25. The system of claim 20, further comprising a second patient database accessible by the healthcare management software system, the second patient database stored on a computer readable memory and including a second physiological information and an at least one value of a second database integrity information, wherein the healthcare management software is further adapted to check an integrity of the patient database prior to displaying on the display representations of the second physiological information included in the second patient database, the healthcare management software in verifying an integrity of the second patient database compares the at least one value of the second database integrity information contained in the second patient database to the at least one integrity information value stored on the computer readable memory and separate from the second patient database.

26. A method of verifying the integrity of a database containing physiological information and database integrity information, the method comprising the steps of:

inputting physiological information relating to a medical condition of a patient into a database stored on a computer readable media, the physiological information generated from a medical device comprising the database, the database further comprising database integrity information, the database integrity information comprising at least one value selected from the group consisting of;

a conversion quantity for the physiological information stored in the database;

a unit for the physiological information stored in the database; and

a textual label for the physiological information stored in the database;

storing at least one integrity information value on a computer readable media and separate from the database containing the physiological information, the at least one integrity information value comprising at least one value selected from the group consisting of;

a conversion quantity for the physiological information stored in the database;

a unit for the physiological information stored in the database; and

a textual label for the physiological information stored in the database;

executing a healthcare management software comprising a plurality of machine readable instructions and stored on a computer readable media of a computing device, the step of executing performed by a processor of the computing device, the healthcare management software adapted to access the database integrity information and further adapted to access the integrity information;

determining an integrity of the database containing the physiological information, the step of determining including comparing the at least one value of the database integrity information to the at least one integrity information value, the comparing of the at least one value of the database integrity information to the at least one integrity information value performed by the healthcare management software and comprising the healthcare management software determining an amount of equivalence of the at least one value of the database integrity information to the at least one integrity information value; and

providing an indication with an output device of the integrity of the database containing the physiological info, the indication determined by the amount of equivalence of the at least one value of the database integrity information to the at least one integrity information value determined in the step of determining.

27. The method of claim 26, wherein the step of providing further includes permitting a selection of at least one of a plurality of inputs of the healthcare management software system displayed on a display of the output device when the indication indicates the database includes an acceptable integrity.