REMOTE DATA MANAGEMENT SYSTEM WITH BUSINESS INTELLIGENCE IN REAL-TIME

• US 20130006665A1
• Filed: 12/29/2011
• Published: 01/03/2013
• Est. Priority Date: 12/29/2010
• Status: Active Grant

• Current Assignee: UNIVAL, Inc. (SPX Corporation)
• Original Assignee: UNIVAL, Inc. (SPX Corporation)
• Inventors: Fernandez, Ronald E.
• Granted Patent: US 8,788,290 B2
• Time in Patent Office: Days
• US Class Current: 705/3
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management
• CPC Class Codes: G16H 10/60 for patient-specific data, e.g. for electronic patient records
• CPC Class Codes: G16H 15/00 ICT specially adapted for medical reports, e.g. generation or transmission thereof
• CPC Class Codes: G16H 50/70 for mining of medical data, e.g. analysing previous cases of other patients

Abstract

The present disclosure provides a dynamic data management system and a method of using said system to locate, obtain, analyze, and report desired patient information in real-time. The data management system generally comprises an order in the form of a query that requests information regarding a specific patient or group of patients that resides on an electronics records server; a data collection and conversion system (DCCS), and a business intelligence engine in communication with the DCCS. The DCCS is capable of transporting the information from the electronic records server and creating a document that includes XML data, while the business intelligence engine is capable of breaking down the XML data to form at least one de-normalized fact table that can be used to report the desired information in real-time.

Claims

1. A dynamic data management system for locating, obtaining, analyzing, and reporting desired patient information in real-time, the system comprising:

an order in the form of a query that requests information regarding a specific patient or group of patients;

the information residing as source information on an electronics records server;

a data collection and conversion system (DCCS);

the DCCS comprising;

a query processor; and

an application interface capable of linking the query processor with the electronic records server through a generic interface; and

a business intelligence engine;

the business intelligence engine being in communication with the DCCS;

wherein the DCCS is capable of transporting the information from the electronic records server and creating a document that includes XML data;

the business intelligence engine capable of breaking down the XML data to form at least one de-normalized fact table used to report the desired information in real-time.

2. The data management system of claim 1, wherein the DCCS further comprises:

a communication channel;

a query transmitter; and

an XML receiver.

3. The data management system of claim 1, wherein the business intelligence engine comprises:

a query manager capable of interacting with the DCCS; and

a dynamic ETL system.

4. The data management system of claim 3, wherein the dynamic ETL system includes the de-normalized fact tables and dimensional tables.

5. The data management system of claim 4, wherein the de-normalized tables and dimensional tables define a dimensional cube that is used as a data formatting tool for reporting.

6. The data management system of claim 5, wherein the dimensional cube is dynamically updated at predetermined time intervals or upon predetermined events.

7. The data management system of claim 1, the system further comprising a document management and storage system (DMSS) having an application processor and a tool processor designed to manage and control the storage of electronic documents.

8. The data management system of claim 1, wherein the query processor further comprises a communication processor;

a datastream processor, and an XML creation procedure system.

9. The data management system of claim 1, wherein the electronic records server contains one selected from the group of electronic medical records (EMR) and electronic health records (EHR).

10. A method of locating, obtaining, analyzing, and reporting desired patient information in real-time, the method comprising the steps of:

providing an order in the form of a query that requests information regarding a specific patient or group of patients;

providing an electronics records server upon which the information regarding the specific patient or group of patients resides as source information;

providing a data collection and conversion system (DCCS);

the DCCS comprising a query processor; and

an application interface capable of linking the query processor with the electronic records server through a generic interface;

providing a business intelligence engine;

the business intelligence engine being in communication with the DCCS;

causing the DCCS to transport the information from the electronic records server and to create a document that includes XML data;

causing the business intelligence engine to break down the XML data to form at least one de-normalized fact table containing the desired patient information; and

using the de-normalized fact table to report the desired information in real-time.

11. The method of claim 10, wherein the step of providing a business intelligence engine in communication with the DCCS includes the business intelligence engine having a query manager capable of interacting with the DCCS and a dynamic ETL system.

12. The method of claim 11, wherein the business intelligence engine further forms at least one dimensional table in addition to the at least one de-normalized table.

13. The method of claim 12, wherein the method further includes defining a dimensional cube for use as a data formatting tool in reporting;

the dimensional cube including the de-normalized and dimensional tables.

14. The method of claim 13, wherein the method further includes the step of dynamically updating the dimensional cube at predetermined time intervals or upon predetermined events.