The present invention relates to the field medical devices. Specifically, the present invention relates to medical software capable of querying a database.
Software for monitoring medical information for a patient is known. For example, prior art software is capable of compiling blood glucose and other similar measurements for a patient with diabetes. The data gathered for each patient, in addition to the vital statistics associated with the patient, such as name, age, gender, etc., may be stored in a database. A user, such as a medical professional caring for multiple patients, may need to query the database in order to locate a patient or groups of patients satisfying specific criteria of interest to the medical professional.
An embodiment of the invention includes a method of constructing a search to query a database including a plurality of records. The method comprises the steps of listing at least one type of search criteria in a first portion of a display; selecting at least one of the search criteria and listing it in a second portion of the display; and locating the records satisfying the search criteria displayed in the second portion.
The method may further comprise the step of listing a second type of search criteria in the second portion of the display. The position of the second type of search criteria with respect to the position of the first type of search criteria determines the type of Boolean operation connecting the search criteria. The method may further include the step of indicating the type of Boolean operation as the second type of search criteria is positioned. The indication may occur in the second portion of the display, and a line may indicate the type of Boolean operation. In embodiments of the invention, the size of the line indicates the type of Boolean operation, and in embodiments of the invention, the color of the line indicates the type of Boolean operation.
In embodiments of the invention, the method further comprises the step of displaying the number of records satisfying the search criteria in a display box. In embodiments of the invention, the placing step is accomplished by dragging the search criteria from the first portion of the display and dropping the search criteria in the second portion of the display. In addition, the type of search criteria may include at least one drop down menu.
Embodiments of the invention include a method for constructing a search of a database including a plurality of data records. The method may comprise the steps of listing a set of possible search criteria in a first portion of a display; and selecting at least one search criteria from the first portion of the display; and moving the selected search criteria to a second portion of the display.
Embodiments of the invention include a method of constructing a search of a database including a plurality of recordings. The method comprises the steps of listing a plurality of search criteria on a first portion of a display; dragging and dropping a first search criteria onto a second portion of the display; dragging and dropping a second search criteria onto the second portion of the display; and comparing the records to the search criteria on the second portion of the display.
The above-mentioned and other features of this invention, and the manner of attaining them, will become more apparent and the invention itself will be better understood by reference to the following description of embodiments of the invention taken in conjunction with the accompanying drawings, wherein:
Although the drawings represent embodiments of various features and components according to the present invention, the drawings are not necessarily to scale and certain features may be exaggerated in order to better illustrate and explain the present invention. The exemplification set out herein illustrates certain embodiments of the invention, and such exemplification is not to be construed as limiting the scope of the invention in any manner.
For the purposes of promoting an understanding of the principles of the invention, reference will now be made to the embodiments illustrated in the drawings, which are described below. It will nevertheless be understood that no limitation of the scope of the invention is thereby intended. The invention includes any alterations and further modifications in the illustrated device and described method and further applications of the principles of the invention, which would normally occur to one skilled in the art to which the invention relates. Moreover, the embodiment was selected for description to enable one of ordinary skill in the art to practice the invention.
Concepts described below may be further explained in one of more of the co-filed patent applications entitled HELP UTILITY FUNCTIONALITY AND ARCHITECTURE Ser. No. 11,999,906, METHOD AND SYSTEM FOR GRAPHICALLY INDICATING MULTIPLE DATA VALUES Ser. No. 11/999,853, SYSTEM AND METHOD FOR DATABASE INTEGRITY CHECKING Ser. No. 11/999,856, METHOD AND SYSTEM FOR DATA SOURCE AND MODIFICATION TRACKING Ser. No. 11/999,888, PATIENT-CENTRIC HEALTHCARE INFORMATION MAINTENANCE Ser. No. 11/999,874 EXPORT FILE FORMAT WITH MANIFEST FOR ENHANCED DATA TRANSFER Ser. No. 11/999,867, GRAPHIC ZOOM FUNCTIONALITY FOR A CUSTOM REPORT Ser. No. 11/999,932, METHOD AND SYSTEM FOR SELECTIVE MERGING OF PATIENT DATA Ser. No. 11/999,859, METHOD AND SYSTEM FOR PERSONAL MEDICAL DATA DATABASE MERGING Ser. No. 11/999,772, METHOD AND SYSTEM FOR WIRELESS DEVICE COMMUNICATION Ser. No. 11/999,879, METHOD AND SYSTEM FOR SETTING TIME BLOCKS Ser. No. 11/999,968, METHOD AND SYSTEM FOR ENHANCED DATA TRANSFER Ser. No. 11/999,911, COMMON EXTENSIBLE DATA EXCHANGE FORMAT Ser. No. 11/999,871, METHOD OF CLONING SERVER INSTALLATION TO A NETWORK CLIENT Ser. No. 11/999,876, METHOD AND SYSTEM FOR EVENT BASED DATA COMPARISON Ser. No. 11/999,921, DYNAMIC COMMUNICATION STACK Ser. No. 11/999,934, SYSTEM AND METHOD FOR REPORTING MEDICAL INFORMATION Ser. No. 11/999,878, METHOD AND SYSTEM FOR MERGING EXTENSIBLE DATA INTO A DATABASE USING GLOBALLY UNIQUE IDENTIFIERS Ser. No. 11/999,947, METHOD AND SYSTEM FOR ACTIVATING FEATURES AND FUNCTIONS OF A CONSOLIDATED SOFTWARE APPLICATION Ser. No. 11/999,880, METHOD AND SYSTEM FOR CONFIGURING A CONSOLIDATED SOFTWARE APPLICATION Ser. No. 11/999,894, METHOD AND SYSTEM FOR DATA SELECTION AND DISPLAY Ser. No. 11/999,896, METHOD AND SYSTEM FOR ASSOCIATING DATABASE CONTENT FOR SECURITY ENHANCEMENT Ser. No. 11/999,951, METHOD AND SYSTEM FOR CREATING REPORTS Ser. No. 11/999,851, METHOD AND SYSTEM FOR CREATING USER-DEFINED OUTPUTS Ser. No. 11/999,905, DATA DRIVEN COMMUNICATION PROTOCOL GRAMMAR Ser. No. 11/999,770, HEALTHCARE MANAGEMENT SYSTEM HAVING IMPROVED PRINTING OF DISPLAY SCREEN INFORMATION Ser. No. 11/999,855, and METHOD AND SYSTEM FOR MULTI-DEVICE COMMUNICATION Ser. No. 11/999,866, the entire disclosures of which are hereby expressly incorporated herein by reference. It should be understood that the concepts described below may relate to diabetes management software systems for tracking and analyzing health data, such as, for example, the A
The present software is configured for use with a database containing information on a plurality of patients. Generally, for each patient, the database includes personal information such as the patient's name, birth date, gender, etc., along with medical information such as the type of diabetes that the patient has, blood glucose measurements associated with the patient over time, the type of insulin utilized by the patient, etc. Furthermore, the information for each patient may be linked to the other stored information for a given patient in any suitable manner.
With reference still to
As shown in
Referring still to
Interface box 26 further includes a toggle 31. Toggle 31 allows a user to create a session-persistent ad-hoc group that is not stored in the memory of the computer once the session ends. Instead, the group is deleted from the memory of the computer upon the ending of a session. Accordingly, a user may click the toggle 31, in the event that the user would like to find patients satisfying search criteria on a one time basis, or in the event the user does not desire to store the results in memory.
Upon actuating the OK icon 32, the software presents the user with a create new query group interface box 34, as shown in
In the depicted embodiment, search parameter menu 40 includes a list of search parameters, generally indicated by numeral 44. The list of search parameters 44 may include any desired data information that may be associated with the patients. For example, the search parameters may include personal information, such as name, birth date, age, gender, etc. and diabetes information, such as diabetes type, diagnosis date, insulin start date, etc. along with various other type of information.
Referring still to
With reference still to
It should be noted with reference to
With reference now to
As shown in
As shown in
With reference now to
As shown in
As shown in
With reference now to
As shown in
With reference still to
Actuation of the show results icon 46 causes, as shown in
Upon releasing the icon 80, the user is presented with the screen capture depicted in
By continuing to drag and drop search parameters 44 from search parameter menu 40 into query box 42, the user may construct a search comprising any number of search parameters. In addition, the search constructed by the user may include any number of Boolean connectors. By positioning the search boxes in a manner similar to that described above, the user may arrange for various Boolean operations connecting the various search parameters. It should be noted that in embodiments of the invention, the software will utilize intelligent constraints in order to prevent a user from conducting a search that will necessarily produce zero results. For example, the software may prevent a user from constructing a search for patients at least 30 years old and also falling between the age of 21 and 25. Since no patient could possibly meet this search criteria, the software may prevent a user from arranging this search.
If the user desires to remove one of the search parameters, the user may click one of the boxes 62, 81 and then actuate the remove a parameter icon 48, in a suitable manner. Furthermore, if the user is satisfied with the search, the user may actuate the OK icon 50 in order to save the group of patients meeting the search criteria.
Referring still to
As shown in
It should be noted that this group assignment feature works with the session persistent ad-hoc groups, described above. Accordingly, a user may construct a session persistent ad-hoc group and conduct a group assignment with the listing of patients. The group assignment will continue to be associated with the individual patients, even after the session ends and the temporary group is removed from memory.
Although the software is described herein for operation on a computer (e.g., desktop, laptop or tablet), it should be understood that the principles of the invention may be embodied in software for operation on various devices, including but not limited to personal digital assistants (“PDAs”), infusion pumps, blood glucose meters, cellular phones, or integrated devices including a glucose measurement engine and a PDA or cellular device.
The invention is described herein with reference to healthcare data management software, and more particularly, with reference to diabetes management software, although the invention may be applied, generally, to data management systems in fields unrelated to healthcare management.
While the invention is described herein with reference to medical devices, and more particularly, with reference to diabetes management devices, the invention is applicable to any data obtained from any device.
While this invention has been described as having an exemplary design, the present invention may be further modified within the spirit and scope of this disclosure. This application is therefore intended to cover any variations, uses, or adaptations of the invention using its general principles. Further, this application is intended to cover such departures from the present disclosure as come within known or customary practice in the art to which this invention pertains.
Number | Name | Date | Kind |
---|---|---|---|
5251126 | Kahn et al. | Oct 1993 | A |
5497486 | Stolfo et al. | Mar 1996 | A |
5671404 | Lizee et al. | Sep 1997 | A |
5671409 | Fatseas et al. | Sep 1997 | A |
5950190 | Yeager et al. | Sep 1999 | A |
5951300 | Brown | Sep 1999 | A |
5995962 | Horowitz | Nov 1999 | A |
6024699 | Surwit et al. | Feb 2000 | A |
6032119 | Brown et al. | Feb 2000 | A |
6322502 | Schoenberg et al. | Nov 2001 | B1 |
6425863 | Werner et al. | Jul 2002 | B1 |
6562001 | Lebel et al. | May 2003 | B2 |
6564105 | Starkweather et al. | May 2003 | B2 |
6571128 | Lebel et al. | May 2003 | B2 |
6577899 | Lebel et al. | Jun 2003 | B2 |
6585644 | Lebel et al. | Jul 2003 | B2 |
6605038 | Teller et al. | Aug 2003 | B1 |
6635014 | Starkweather et al. | Oct 2003 | B2 |
6648821 | Lebel et al. | Nov 2003 | B2 |
6658404 | Cecchini | Dec 2003 | B1 |
6659948 | Lebel et al. | Dec 2003 | B2 |
6668196 | Villegas et al. | Dec 2003 | B1 |
6684191 | Barnard et al. | Jan 2004 | B1 |
6687546 | Lebel et al. | Feb 2004 | B2 |
6694191 | Starkweather et al. | Feb 2004 | B2 |
6733446 | Lebel et al. | May 2004 | B2 |
6740075 | Lebel et al. | May 2004 | B2 |
6748402 | Reeves | Jun 2004 | B1 |
6758810 | Lebel et al. | Jul 2004 | B2 |
6781522 | Sleva et al. | Aug 2004 | B2 |
6785668 | Polo et al. | Aug 2004 | B1 |
6804656 | Rosenfeld et al. | Oct 2004 | B1 |
6810290 | Lebel et al. | Oct 2004 | B2 |
6811533 | Lebel et al. | Nov 2004 | B2 |
6811534 | Bowman, IV et al. | Nov 2004 | B2 |
6813519 | Lebel et al. | Nov 2004 | B2 |
6852104 | Blomquist | Feb 2005 | B2 |
6873268 | Lebel et al. | Mar 2005 | B2 |
6873807 | Umetsu | Mar 2005 | B2 |
6958705 | Lebel et al. | Oct 2005 | B2 |
6990434 | Minogue et al. | Jan 2006 | B2 |
7020508 | Stivoric et al. | Mar 2006 | B2 |
7024236 | Ford et al. | Apr 2006 | B2 |
7029455 | Flaherty | Apr 2006 | B2 |
7041468 | Drucker et al. | May 2006 | B2 |
7050735 | Bardolatzy et al. | May 2006 | B2 |
7063665 | Hasegawa et al. | Jun 2006 | B2 |
7082334 | Boute et al. | Jul 2006 | B2 |
7113946 | Cosic | Sep 2006 | B2 |
7120488 | Nova et al. | Oct 2006 | B2 |
7165062 | O'Rourke | Jan 2007 | B2 |
7179226 | Crothall et al. | Feb 2007 | B2 |
7181350 | Oberding et al. | Feb 2007 | B2 |
7207009 | Aamodt et al. | Apr 2007 | B1 |
7418600 | Dettinger et al. | Aug 2008 | B2 |
8073868 | Lavi | Dec 2011 | B2 |
20020016568 | Lebel et al. | Feb 2002 | A1 |
20020029776 | Blomquist | Mar 2002 | A1 |
20020040208 | Flaherty et al. | Apr 2002 | A1 |
20020059299 | Spaey | May 2002 | A1 |
20020099701 | Rippich | Jul 2002 | A1 |
20020140976 | Borg et al. | Oct 2002 | A1 |
20020169759 | Kraft et al. | Nov 2002 | A1 |
20020193679 | Malave et al. | Dec 2002 | A1 |
20030002848 | Kawaoka et al. | Jan 2003 | A1 |
20030011646 | Levine et al. | Jan 2003 | A1 |
20030018644 | Bala et al. | Jan 2003 | A1 |
20030065308 | Lebel et al. | Apr 2003 | A1 |
20030065536 | Hansen et al. | Apr 2003 | A1 |
20030069758 | Anderson et al. | Apr 2003 | A1 |
20030098869 | Arnold et al. | May 2003 | A1 |
20030140044 | Mok et al. | Jul 2003 | A1 |
20030145206 | Wolosewicz et al. | Jul 2003 | A1 |
20030163088 | Blomquist | Aug 2003 | A1 |
20030163455 | Dettinger et al. | Aug 2003 | A1 |
20030199739 | Gordon et al. | Oct 2003 | A1 |
20030208465 | Yurko et al. | Nov 2003 | A1 |
20040030987 | Manelli | Feb 2004 | A1 |
20040038389 | Maus et al. | Feb 2004 | A1 |
20040073464 | Huang | Apr 2004 | A1 |
20040086314 | Chen et al. | May 2004 | A1 |
20040111296 | Rosenfeld et al. | Jun 2004 | A1 |
20040119742 | Silbey et al. | Jun 2004 | A1 |
20040172284 | Sullivan et al. | Sep 2004 | A1 |
20050004911 | Goldberg et al. | Jan 2005 | A1 |
20050004947 | Emlet et al. | Jan 2005 | A1 |
20050010452 | Lusen | Jan 2005 | A1 |
20050137653 | Friedman et al. | Jun 2005 | A1 |
20050159977 | Green et al. | Jul 2005 | A1 |
20050182655 | Merzlak et al. | Aug 2005 | A1 |
20050187794 | Kimak | Aug 2005 | A1 |
20050192844 | Esler et al. | Sep 2005 | A1 |
20050259945 | Splaver | Nov 2005 | A1 |
20060010014 | Brown | Jan 2006 | A1 |
20060010098 | Goodnow et al. | Jan 2006 | A1 |
20060020491 | Mongeon et al. | Jan 2006 | A1 |
20060031094 | Cohen et al. | Feb 2006 | A1 |
20060095298 | Bina | May 2006 | A1 |
20060155581 | Eisenberger et al. | Jul 2006 | A1 |
20060161460 | Smitherman et al. | Jul 2006 | A1 |
20060167367 | Stanczak et al. | Jul 2006 | A1 |
20060178910 | Eisenberger et al. | Aug 2006 | A1 |
20060184524 | Pollanz | Aug 2006 | A1 |
20060224638 | Wald et al. | Oct 2006 | A1 |
20060272652 | Stocker et al. | Dec 2006 | A1 |
20070033074 | Nitzan et al. | Feb 2007 | A1 |
20070048691 | Brown | Mar 2007 | A1 |
20070055940 | Moore et al. | Mar 2007 | A1 |
20070088525 | Fotiades et al. | Apr 2007 | A1 |
20070089071 | Zinn et al. | Apr 2007 | A1 |
20070179352 | Randlov et al. | Aug 2007 | A1 |
20070179975 | Teh et al. | Aug 2007 | A1 |
20070185390 | Perkins et al. | Aug 2007 | A1 |
20070189590 | Fidrich et al. | Aug 2007 | A1 |
20070219432 | Thompson | Sep 2007 | A1 |
20070232866 | Nephin et al. | Oct 2007 | A1 |
20070276197 | Harmon | Nov 2007 | A1 |
20080082501 | Hardy | Apr 2008 | A1 |
Number | Date | Country |
---|---|---|
20217855 | Feb 2003 | DE |
0970655 | Jan 2000 | EP |
0649316 | Dec 2000 | EP |
1194864 | Apr 2002 | EP |
1416417 | May 2004 | EP |
1647929 | Apr 2006 | EP |
1662417 | May 2006 | EP |
04145774 | May 2004 | JP |
04145775 | May 2004 | JP |
04145776 | May 2004 | JP |
07058685 | Mar 2007 | JP |
WO9609590 | Mar 1996 | WO |
WO0018449 | Apr 2000 | WO |
WO0065522 | Nov 2000 | WO |
WO0072181 | Nov 2000 | WO |
WO0174229 | Oct 2001 | WO |
WO0200111 | Jan 2002 | WO |
WO02078512 | Oct 2002 | WO |
WO03015838 | Feb 2003 | WO |
WO2005037095 | Apr 2005 | WO |
WO2005096206 | Oct 2005 | WO |
WO2006050485 | May 2006 | WO |
WO2007005530 | Jan 2007 | WO |
WO2007084502 | Jul 2007 | WO |
WO2007093482 | Aug 2007 | WO |
Entry |
---|
Lawrence et al. Drag-and-drop multimedia: an interface framework for digital libraries, published 1999 International Journal on Digital Libraries. |
Wang, C. et al.; “A CORBA-Based Object Framework with Patient Identification Translation and Dynamic Linking, Methods for Exchanging Patient Data,” Methods of Information in Medicine, Mar. 1999, pp. 56-65, vol. 38, No. 1, F.K.Schattauer Verlagsgesellschaft mbH, Germany. |
Bilenko, M. et al.; “Adaptive Name Matching in Information Integration,” IEEE Intelligent Systems; Sep. 2003, vol. 18, No. 5; p. 16-23, IEEE Computer Society. |
Frenger, Paul; “GRANNIE 2: a Ubiquitious, Protean Robotic Guardian Angel,” Automation Science and Engineering, Sep. 1, 2007, pp. 857-862, IEEE International Conference on IEEE. |
Frenger, Paul; “GRANNIE: A Scalable, Interactive, Artificial Intelligence Supervisory System for Medical Devices,” Proceedings of Can. Med. Bio. Engr. Conference, 2007, p. 256-259. |
“CoPilot Health Management System Version 3.1,” User's Guide, Mar. 2007, 230 pp., ART 10641 Rev. D, Abbott Diabetes Care, Inc. |
“MediSense® Precision Link® Diabetes Data Management Software,” User's Guide, May 2006, 58 pp., 116-412 Rev. AC, Abbott Diabetes Care, Inc. |
Albisser, Michael A.; “A Graphical User Interface for Diabetes Management Than Integrates Glucose Prediction and Decision Support,” Diabetes Technology & Therapeutics, 2005, pp. 264-273, vol. 7, No. 2. |
Janssen et al., “Acensia® Winglucofacts® Professional Intelligent Diabetes Management Software is an Effective Tool for the Management of Diabetes,” Bayer HealthCare Clinical Summary Report, Jul. 2005, 10 pp. |
Joshy et al.; “Diabetes Information Systems: A Rapidly Emerging Support for Diabetes Surveillance and Care,” Diabetes Technology & Therapeutics, 2006, pp. 587-597, vol. 8, No. 5. |
“OneTouch Diabetes Management Software,” User Manual, 2006, 173 pp., v. 2.3.1, Lifescan, Inc. |
“Getting Started, CareLink Personal Therapy Management Software for Diabetes,” Brochure, 2007, 20 pp., Medtronic Minimed, Inc. |
“Accu-Chek® Camit Pro Diabetes Management Software,” User's Manual, 2005, 220 pp., v.2.1 and Addendum v. 2.4, Roche Diagnostics Corp. |
“Accu-Chek® Compass Diabetes Care Software,” User's Guide, 2005, 74 pp., Roche Diagnostics Corp. |
“Accu-Chek® Diabetes Assistant,” accessed with notional data and printed from www.diabetesassistant.com on Jan. 16, 2007, 20 pp., Roche Diagnostics Corp. |
Number | Date | Country | |
---|---|---|---|
20090150351 A1 | Jun 2009 | US |