WO2002013070A2 - Appareil et procede servant a integrer, trier et analyser des ensembles de donnees heterogenes - Google Patents

Appareil et procede servant a integrer, trier et analyser des ensembles de donnees heterogenes Download PDF

Info

Publication number
WO2002013070A2
WO2002013070A2 PCT/GB2001/003477 GB0103477W WO0213070A2 WO 2002013070 A2 WO2002013070 A2 WO 2002013070A2 GB 0103477 W GB0103477 W GB 0103477W WO 0213070 A2 WO0213070 A2 WO 0213070A2
Authority
WO
WIPO (PCT)
Prior art keywords
data
analysis system
data analysis
standardised
data sets
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Ceased
Application number
PCT/GB2001/003477
Other languages
English (en)
Other versions
WO2002013070A3 (fr
Inventor
Neville Cannon
Roy Hawes
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
HANON SOLUTIONS Ltd
Original Assignee
HANON SOLUTIONS Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Priority claimed from GBGB0019317.7A external-priority patent/GB0019317D0/en
Application filed by HANON SOLUTIONS Ltd filed Critical HANON SOLUTIONS Ltd
Priority to AU2001275753A priority Critical patent/AU2001275753A1/en
Priority to GB0305244A priority patent/GB2384893A/en
Publication of WO2002013070A2 publication Critical patent/WO2002013070A2/fr
Anticipated expiration legal-status Critical
Publication of WO2002013070A3 publication Critical patent/WO2002013070A3/fr
Ceased legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2365—Ensuring data consistency and integrity
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/258—Data format conversion from or to a database

Definitions

  • the present invention relates to apparatus and method for extracting data sets from remote, disparate locations in order that the data can be analysed and used to report the occurrence of adverse events.
  • the described apparatus and method can be used as an early warning system to predict where an adverse event may occur.
  • a data analysis system for use in determining the occurrence of adverse events represented in heterogeneous data sets, the system comprising; a) means for formatting and transmitting said heterogeneous data sets to a central processing means in a standardised format, b) inference means for determining whether the data sets are outwith a "normal" reference criteria or range, c) reporting means for reporting adverse events associated with locations, organisations or individuals.
  • the system comprises a centralised platform and one or more local platforms.
  • the centralised platform receives data in a standardised format from the one or more local platforms.
  • the one or more local platforms act as a gateway through which data must pass in order to be standardised.
  • Preferably data is transmitted from the one or more local platforms to the centralised platform.
  • the system may be used to report and predict the occurrence of adverse events within a community, wherein the community is typically an official organisation such as the National Health Service, Civil Service or police Force.
  • the central processing means typically comprises at least one database.
  • the heterogeneous data sets are typically located within a plurality of remote locations.
  • heterogeneous data seta are extracted, formatted and transmitted from the remote locations to the central processing means by one or more acquisition server.
  • heterogeneous data sets are formatted into a standardised format by an acquisition server schema.
  • acquisition server schema hold a plurality of mapping tables.
  • Preferably data is standardised within the system by the attachment of codes.
  • the one or more acquisition servers holds national coding standards and mappings of local data.
  • the system also comprises a national code sets warehouse.
  • the national codes held within the local acquisition server are synchronised with the national codes held within the national code sets warehouse.
  • a normalisation engine attaches national codes to the data.
  • the system also comprises a data cleanse application.
  • the data cleanse application will extract irregular data and send it to a suspense area. The data can then be accessed for correction or re-submission.
  • Preferably users can upload data directly to the acquisition server.
  • the inference means is typically a hardware or software engine which operates in programming language applicable to the computer system or network with which it is used.
  • the inference means typically applies a series of rules in order to analyse the risk of an adverse event occurring and to predict where an adverse event may occur. For example, the inference means may calculate the "normal" or average number of deaths per year of patients having a particular illness, and then deduce which, if any of the data sets deviate widely from this number.
  • the inference means may also comprise a statistical analysis programme.
  • the central processing means is adapted to receive information from printed source material.
  • the criteria and ranges against which the data sets are assessed are easily adjustable.
  • the data may be communicated from the remote data locations to the central data storage means in an encrypted and secure format.
  • the data may be communicated from the remote data locations to the central data storage means via an existing database system, such as NHSnet.
  • the data may be communicated in XML.
  • reporting means can be escalated.
  • the system has an incident acknowledgement and closure application.
  • a computer program comprising program instructions which, when loaded into a computer, constitute the data analysis system according to the first aspect of the present invention.
  • a method for determining the occurrence of adverse events from heterogeneous data sets comprising the steps of:
  • Figure 1 is a schematic diagram of a simplified exemplary embodiment of the system in accordance with the present invention.
  • Figure 2 is a more detailed schematic diagram of the extraction, transfer and processing of data from one remote data location to a relevant body or individual.
  • a plurality of remote data locations (1) (2) (3) and (4), data extraction formatting and transmitting means (5) and (6), data processing means (7), and indicating means (8) together form an exemplary embodiment of the present invention.
  • the exemplary embodiment is for use within the National Health Services and the remote data locations (1) to (4) may be clinical based patient administration systems (PAS) , which presently exists within hospitals, surgeries and trusts.
  • PAS patient administration systems
  • These existing patient administration systems contain information and data which relate to patient medical history, such as treatment schedules, practitioner's name and location, and locations where particular events take place.
  • the format and information contained on these systems will usually vary markedly.
  • the actual systems and IT infrastructure will generally vary from location to location.
  • the system of the present invention can determine the occurrence or incidence of adverse events or "clinical incidents" within the Health Service. Specifically the system extracts, standardises and transmits heterogeneous data sets thereby allowing the data sets to be analysed against set criteria, enabling clinical incidents to be identified, and most importantly reported to a relevant party to ensure that action is taken to remedy the incident, and prevent further incidents from taking place.
  • the system of the present invention is divided into two main systems, a National Information Delivery Platform and Local Data Acquisition Platforms.
  • the National Information Delivery Platform is a centralised information centre into which normalised, standardised and validated clinical incidents are loaded, and this system will host all the data against which the present invention analysis and reports will process.
  • the Local Data Acquisition Platforms (5) are located in various DH locations and act as a gateway through which incident data must pass. All incident data generated will be validated, normalised and standardised through these systems. Only when these processes have been achieved will the incident data be allowed onto the National Delivery Platform.
  • the data extraction and formatting means extracts predetermined data sets from the main types of patient administration systems (1) to (4) automatically. It is envisaged in the present invention that it would be advantageous if the type of data which is extracted could be adjusted to suit the needs of the relevant body or individual (10) to which the warning would be given. For example where the system is used within the national health service, it is envisaged that the Department of health and/or NHS Executive would have an active role in deciding the n ' ature of the data which is to be reported on.
  • the system also is also adapted to receive paper returns (9) . Once the information is extracted either automatically from the existing administration systems or via paper returns, it is standardised by translation means (5) and transmitted via an input means (6) to the central processing means (7). It will be appreciated that in alternative embodiments the translation means (5) and input means (6) may be combined.
  • an acquisition server schema will be built to hold a series of mapping tables which will be used to maintain a universal keying system throughout the entire system deployment. Because incident data will be uploaded from a large variety of sources and locations (1) to (4), it is important that the data is normalised into a common format before it is entered into the National Delivery system, which in the embodiment is represented by (7).
  • the Acquisition Server Schema will not only hold the national coding standards relevant to the National Delivery System, for example readcodes, OCS, ICD and/or OPCS, it will also contain mappings of local data (11) relevant to the Local Data Acquisition Platforms. This is important, for example, within a hospital where there may be discrepancies in patient information, i.e. a single patient may have more than one code across various systems or various departments. If this is found, the codes will be mapped to one of the system identifiers for the patient, and it is that identifier which will be passed with the incident data to the national database.
  • the data is transferred in a secure and encrypted format to prevent tampering with the system and to ensure patient confidentiality.
  • the data is transmitted via the existing NHS web-server, NHSnet, to ensure maximum security.
  • the data is typically transferred using XML (extensible mark-up language) .
  • a document type definition will define the data upload format for interfacing systems, both on and off line. Any clinical incident that is processed by the acquisition servers will be in an XML format conforming to Data Upload DTD.
  • the system typically also comprises a national coding synchronisation manager, which synchronises the image of the national codes held within the local acquisition server (5) with the national code sets warehouse (13) that holds the latest versions of the codes.
  • the Synchronisation manager may also be able to upload national code sets from off line storage media.
  • the existence of a normalisation engine relating to the Acquisition Server is the key to the success and quality of the information delivered from the national information delivery platform.
  • the engine takes each reported incident and breaks it down into all of its ⁇ elements. It looks at each of the elements individually and ensures that the relevant national codes are attached to it. For example, an incident may have the following attributes: patient (s), doctor (s), nurse (s), location, ward, diagnosis, drug(s) and disease.
  • the normalisation engine will attach a national code to each of these attributes.
  • a unique code will be generated if the patient has not already had an incident recorded on the acquisition server. This code will be unique to the system of the present invention.
  • the patient mapping table on the acquisition server will be updated with a reference of the patient's originating code, i.e. the code held on the originating hospital system. This originating code will point to he unique code of the system of the present invention. By maintaining this mapping table on the acquisition server, other incidents originating from other systems within the same hospital can be mapped to the same unique patient code of the system of the present invention.
  • the normalisation engine will find the appropriate codes from the local image on the acquisition server of the national codes.
  • the system also comprises a mapping tables manager which is used to maintain the local mapping tables on the acquisition server (5) .
  • the mapping tables will be updated by the mapping tables manager application, the normalisation engine and by a on-line data cleanse application (14) .
  • the latter is an on-line user application that is used to clean data that has failed the validation and normalisation process.
  • the normalisation engine When data has been uploaded from systems that cannot be reconciled to codes either in the national codes set or the mapping tables of the system of the present invention, the normalisation engine will drop these upload items into a suspense area (15) . Users of the originating system will then be notified by the acquisition server (5) that there are items in suspense outstanding. The users will subsequently come on-line with the data cleanse application and correct the data. It will be appreciated that in existing systems within the National Health Service it is difficult, if not impossible, to monitor the information entered into existing systems. For example, in a system where it is necessary for a nurse or doctor to enter their unique identification, number or a unique patient number, one pre-entered number may be used many times by many different doctors or nurses for the sake of expedience.
  • An on-line upload application is also provided which allows users to upload adverse clinical incident data directly to the acquisition database (5).
  • the normalised data gateway acts as a "pipe" through which the processed clinical incident data will pushed into the national database of the present invention. This incident data will then be deleted from the acquisition database.
  • the central data processing means (7) decrypts and stores the data.
  • the information is then processed at an initial level by inference in the data processing means (7), which is typically a hardware or software engine, and which applies a set of rules to the data sets in order to predict locations, organisations or individuals where they may be cause for concern.
  • the inference means may determine the "normal" number of deaths within a particular group of patients, and then use this data to determine whether any particular practitioner or location appear to deviate from this norm.
  • the system may be used to compare the number of complaints made against different organisations, locations and individuals.
  • the data may then be drawn into a statistical analysis component program to further refine and analyse the data.
  • the data processing means (7) comprises a delivery database schema which will hold on a national level all of the adverse clinical incidents reported through the various localised acquisition servers.
  • the foundation for the schema design was driven by the need to create an analytical platform upon which many algorithms could run. It is tuned to delivery a variety of results for reporting a range of formats, including graphical images. It is also designed to perform a high level of performance and be extremely scaleable to accommodate large volumes of data.
  • the incidents alerts engine is a stand-alone system that is highly scaleable in that multi instances of the engine can run on separate machines, upgrading processor power limitlessly.
  • the engine runs analysis algorithms on the database, then cross-references the user profiles for notification parameters that it then sends to the notification gateway.
  • the alerts engine runs on a hierarchical model, whereby it determines whether previous alerts have been acknowledged and where applicable it will escalate the alert up the chain of command.
  • the reporting module (8) will report the results to the relevant body or individual (10) . For example, this may be the Chief executive of the particular Trust in which a particular area of concern has been identified.
  • the reporting module (8) may be configured to operate in a number of ways, for example if we have a number of indicator means to highlight possible areas, organisations or individuals of concern.
  • the indicator means may be, in one example, warning lights of red, amber and green, which warn an individual or organisation that action needs to be taken. Alternatively, alerts may be given by e-mail or SMS.
  • the reporting means (8) will warn if the results obtained from analysis of a particular data set deviates from a "normal" range or benchmark criteria.
  • the reporting module (8) will issue a warning, for example, to the Chief Executive of the particular trust (10) to monitor the given situation and to take pre-emptive action to remedy the area concerned before a crisis emerges.
  • the indicator means providing an early warning would be an illumination of a particular colour of light, for example, the amber light. If no action was taken, the warning would progress to red, then the warning would progress to illumination of the red light to indicate that determined action should be mandated.
  • the escalation may arise from the use of indicator means as described above.
  • the escalation system may provide warnings in an escalated manner through a hierarchy of organisations or individuals. For example, in the case of the National Health Service, in the first instance, a Ward Sister may be given a warning and if no action is taken on this warning, a subsequent warning may be given to the Head of the Department in which the Ward Sister works. In this vein, later escalated warnings could be given, for example, to a Medical Director or to the Health Service Head.
  • a further important aspect of the present invention is the provision of an incidents acknowledge and closure application, which is web based and built with the latest application server technology. High scaleable, robust and performant, it takes advantage of the latest multi- tier platform architecture to provide rapid development environment for building maintainable solutions.
  • This application will be very secure, but at the same time available to browser based clients running in any remote location. Incidents will be updated from the upload state into an acknowledged state during which investigations will be carried out. The incident will next be closed using the same application when the resulting outcome is recorded. In other words, repeated updates will be sent until acknowledgement is obtained from he organisation or individual to which a warning has been sent, that the warning has in fact been received and action will be taken. Closure will only come about once a suitable action has been carried out.
  • the multiple tier architecture enables the use of application servers to host Enterprise Java Beans that contain the delivery system business logic of the present invention. Keeping this logic separate means the application code can be maintained and upgrade separately from the presentation of that logic. This makes it very easy to accommodate new requirements with a minimum of disruption to a live system.
  • the presentation logic is contained within web servers servlets and JSPs. There is also a separate tier on the architecture that can be maintained separately with all the benefits that this brings. Multiple user connections are managed with the web servers where sessions are tracked and kept secure. Having a multiple tier architecture also ensures multiple options for scaling the system to accommodate very large volumes of users.
  • the system of the present invention has Internet portal security which is guaranteed with a combination of features included.
  • Netscape servers LDAP authentication system provides secure log-on interface to the portal. This combined with a firewall surround provides a very secure environment to host the national information delivery platform.
  • An advantage of the present invention is that it overcomes the short-comings of existing systems without being unduly expensive, as it utilises existing data systems which already exist, but which cannot be used for comparative analysis as they exists in disparate format and content.
  • a further advantage lies in the fact that the individual health care providers do not need to change their existing recording or reporting systems as the invention provides means for integrating the existing disparate data.
  • a yet further advantage of the present invention lies in the fact that the system provides a unified and standardised system for reporting and analysing adverse events, using data which already exists in clinically based patient administration systems.
  • the system integrates agreed data sets and allows reporting protocols to be standardised so that an early warning can be given in relation to individuals or areas of concern.

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computer Security & Cryptography (AREA)
  • Alarm Systems (AREA)
  • Medical Treatment And Welfare Office Work (AREA)

Abstract

L'invention concerne un système permettant d'extraire, de normaliser et d'intégrer des données stockées sur des systèmes de données existants et disparates (1) à (4), de manière que plusieurs organisations, régions et individus puissent être comparés les uns par rapport aux autres. Plus précisément, le système permet de normaliser et de transmettre des ensembles de données hétérogènes à un moyen de traitement (7) capable de déterminer si les ensembles de données normalisés sont en dehors d'un critère de référence normal ou d'une gamme de référence normale et d'avertir un corps compétent ou une personne compétente de l'occurrence d'un événement adverse pouvant être associé à un emplacement, une organisation ou un individu.
PCT/GB2001/003477 2000-08-08 2001-08-03 Appareil et procede servant a integrer, trier et analyser des ensembles de donnees heterogenes Ceased WO2002013070A2 (fr)

Priority Applications (2)

Application Number Priority Date Filing Date Title
AU2001275753A AU2001275753A1 (en) 2000-08-08 2001-08-03 Apparatus and method for integrating, sorting and analysing heterogeneous data sets
GB0305244A GB2384893A (en) 2000-08-08 2001-08-03 Apparatus and method for integrating, sorting and analysing heterogeneous data sets

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
GB0019317.7 2000-08-08
GBGB0019317.7A GB0019317D0 (en) 2000-08-08 2000-08-08 Apparatus and method for integrating sorting and analysing heterogenous data sets
GB0100002.5 2001-01-02
GB0100002A GB2365565B (en) 2000-08-08 2001-01-02 Apparatus and method for integrating sorting and analysing heterogeneous data sets

Publications (2)

Publication Number Publication Date
WO2002013070A2 true WO2002013070A2 (fr) 2002-02-14
WO2002013070A3 WO2002013070A3 (fr) 2003-05-30

Family

ID=26244803

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/GB2001/003477 Ceased WO2002013070A2 (fr) 2000-08-08 2001-08-03 Appareil et procede servant a integrer, trier et analyser des ensembles de donnees heterogenes

Country Status (3)

Country Link
AU (1) AU2001275753A1 (fr)
GB (1) GB2384893A (fr)
WO (1) WO2002013070A2 (fr)

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4714995A (en) * 1985-09-13 1987-12-22 Trw Inc. Computer integration system
US5692107A (en) * 1994-03-15 1997-11-25 Lockheed Missiles & Space Company, Inc. Method for generating predictive models in a computer system
AU6252496A (en) * 1995-06-07 1996-12-30 E-Systems Incorporated Apparatus and method for centralized storage of heterogeneou s medical records in managed health care organization
US6012042A (en) * 1995-08-16 2000-01-04 Window On Wallstreet Inc Security analysis system
GB9725347D0 (en) * 1997-11-28 1998-01-28 Ncr Int Inc Database relationship analysis and strategy implementation tool

Also Published As

Publication number Publication date
AU2001275753A1 (en) 2002-02-18
WO2002013070A3 (fr) 2003-05-30
GB0305244D0 (en) 2003-04-09
GB2384893A (en) 2003-08-06

Similar Documents

Publication Publication Date Title
US6993402B2 (en) Method and system for identifying and anticipating adverse drug events
US11194810B2 (en) System and method for comparing and utilizing activity information and configuration information from multiple device management systems
US6611806B1 (en) Lot tracking system for pharmaceuticals
US8171094B2 (en) System and method for communicating over a network with a medical device
US7921020B2 (en) Method for generating medical intelligence from patient-specific data
CA2684241C (fr) Systemes et procedes de reponse d'aide a la decision
US20020099273A1 (en) System and user interface for use in providing medical information and health care delivery support
US20060004745A1 (en) Structured reporting report data manager
CA2752692A1 (fr) Support de decision
CA2605278A1 (fr) Systeme et procede d'utilisation et de tenue a jour d'un indice mmi
CN1495635A (zh) 一种用于监视健康护理病人遭遇相关信息的系统
US20120232927A1 (en) System for the control and integral management of the medical records of patients in health care centres, hospitals, outpatient centers and the general healthcare system
US20070100659A1 (en) Management of clinical data exceptions in clinical information systems
NZ727697A (en) Managed medical information exchange
US20250087328A1 (en) Methods and systems for analyzing accessing of drug dispensing systems
US20040030579A1 (en) Method, system and computer program product for providing medical information
KR100567865B1 (ko) 데이터베이스 기반의 실시간 ｈｌ7 메시지 생성/전송시스템 및 그 방법
WO2002013070A2 (fr) Appareil et procede servant a integrer, trier et analyser des ensembles de donnees heterogenes
US20050209884A1 (en) Method, system and computer program product for providing medical information
JP5486649B2 (ja) データ参照システム、ドキュメント表示システムおよび医療情報システム
CA2947792C (fr) Systeme et procede pour comparer et utiliser des informations d'activite et informations de configuration de plusieurs systemes de gestion de dispositifs
KR20080042256A (ko) 약물부작용감시 시스템
GB2365565A (en) Apparatus and method for integrating, sorting and analysing heterogenous data sets
US20190392925A1 (en) Self-aware data storage, retrieval, and notification
HK1170324A (en) Decision support

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

ENP Entry into the national phase

Ref document number: 0305244

Country of ref document: GB

Kind code of ref document: A

Free format text: PCT FILING DATE = 20010803

Format of ref document f/p: F

121 Ep: the epo has been informed by wipo that ep was designated in this application
DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

122 Ep: pct application non-entry in european phase
NENP Non-entry into the national phase

Ref country code: JP