This application claims the benefit of Japanese Patent Application No. 2007-100961, filed Apr. 6, 2007, in the Japanese Patent Office, the disclosures of which are incorporated herein by reference.
1. Field of the Invention
The present invention relates to a data gathering and processing system, usable in clinical trials or the like, for example, that is capable of efficiently gathering data and easily putting gathered data to secondary use in various applications.
2. Description of the Related Art
Heretofore, data gathering and processing systems for gathering data completed on a prescribed sheet or data entered into a prescribed form on a screen, and managing the gathered data by computer have been widely used in various fields.
In particular, being able to create data entry screens using a so-called structured document such as HTML (HyperText Markup Language) or XML (Extensible Markup Language) has become relatively easy in recent years. The growth of network communication technologies such as the Internet has meant that large amounts of data can be gathered efficiently by gathering data entered into the data entry screen of a terminal in servers or the like. Processing data entered into a data entry screen created with a structured document such as the above based on the tag names of the structured document also enables input data to be registered in a database efficiently (e.g., see JP 2000-99606 A).
However, while JP 2000-99606 A discloses a method of registering input data in a database, nothing is disclosed in relation to easily putting the registered data to secondary use.
In view of the above, an object of the present invention is to provide a data gathering and processing system capable of efficiently gathering data and easily putting gathered data to secondary use in various applications.
To achieve the above object, a data gathering and processing system according to the present invention includes a template storage unit storing a structured document describing a template of a data entry screen layout, a display unit that displays a data entry screen by analyzing a structured document corresponding to a template selected by a data inputter, an input data storage unit that, when there is data entry to the data entry screen, at least temporarily stores input data in association with a tag name corresponding to the input data, a structured document generation unit that, when data entry to the data entry screen is complete, generates a structured document with data describing a layout of a data entry screen that includes input data, with reference to a structured document corresponding to a template of the data entry screen, and to the input data and the tag name stored in the input data storage unit, an item extraction unit that extracts, as a search item, at least a tag name from the structured document with data, a database that stores, in association with at least a portion of the structured document with data, the search item extracted by the item extraction unit from the structured document with data, a search criteria setting unit that displays the search item and receives a search criteria related to the search item from a searcher, and a search execution unit that searches the database based on the search criteria received from the searcher, and presents input data obtained as a search result or a data entry screen that includes the input data.
In the data gathering and processing system according to the present invention, HTML or XML, for example, can be suitably used as the aforementioned structured document. Also, the data gathering and processing system according to the present invention is able to handle data related to a clinical trial as the input data.
To achieve the above object, a computer program according to the present invention causes a computer to execute the processes of displaying a data entry screen by reading out, from a template storage unit storing a structured document describing a template of a data entry screen layout, a structured document corresponding to a template selected by a data inputter and analyzing the read structured document, at least temporarily storing in an input data storage unit when there is data entry to the data entry screen, input data in association with a tag name corresponding to the input data, generating, when data entry to the data entry screen is complete, a structured document with data describing a layout of a data entry screen that includes input data, with reference to a structured document corresponding to a template of the data entry screen, and to the input data and the tag name stored in the input data storage unit, extracting, as a search item, at least a tag name from the structured document with data, and storing, in a database, the extracted search item in association with at least a portion of the structured document with data, displaying the search item and receiving a search criteria related to the search item from a searcher, and searching the database based on the search criteria received from the searcher, and presenting input data obtained as a search result or a data entry screen that includes the input data.
The present invention enables a data gathering and processing system capable of gathering data efficiently and easily putting gathered data to secondary use in various applications to be provided.
Hereinafter, embodiments of a data gathering and processing system according to the present invention will be described by way of examples, and configurations and operations thereof will be described with reference to the drawings.
The user terminal 11 is realized, for example, by a personal computer with a browser installed, and displays data entry screens written in a structured document (XML in the present embodiment) on a display. The user terminal 11 is, however, not limited to a personal computer. The user terminal 11 may be a mobile terminal such as a PDA (Personal Digital Assistant) or a mobile telephone, on condition that a browser can be loaded.
Here, the functional schematic configuration of the user terminal 11 is shown in
The communication unit 110 performs communication with the data gathering server 12 and with other user terminals as necessary, via the communication network 10.
The template storage unit 111 stores document definitions written in XML as the templates of data entry screens for use in the user terminal 11. With the data entry screen shown in
The input data reception unit 113 detects data entered into the data entry screen displayed on the user terminal 11, and at least temporarily stores the detected data in the input data storage unit 114 together with the tag name in relation to which the data was entered. Once data entry to the data entry screen is complete, the XML file generation unit 115 generates an XML file with data describing the layout of the data entry screen that includes input data, with reference to the template storage unit 111 and the input data storage unit 114. The generated XML file with data is sent from the user terminal 11 to the data gathering server 12 via the communication network 10.
The data gathering server 12 is provided with a communication unit 120, an item extraction unit 121, an XML database 122, a search criteria setting unit 123, a search execution unit 124 and a display unit 125, as shown in
The communication unit 120 performs communication with the respective user terminals 11a, 11b, 11c, and so on, via the communication network 10.
The item extraction unit 121 extracts tag names corresponding to the input fields of the data entry screen from the XML file with data sent from the user terminal 11. The XML database 122 stores an XML file with data sent from a user terminal in association with the tag names extracted from the XML file by the item extraction unit 121.
The search criteria setting unit 123 acquires and displays search items from the XML database 122, and allows a searcher to select a search item as necessary, as well as receiving search criteria related to the search item. The search execution unit 124 searches the XML database 122 based on the search criteria received from the searcher. The search results are presented to the searcher by the display unit 125 in an appropriate format or in the format of the data entry screen that includes the input data. Note that while the entry of search criteria and the display of search results may be performed using an input apparatus and a display apparatus provided in the data gathering server 12, these operations may also be performed using an input apparatus and a display apparatus provided in any of the user terminals 11. Alternatively, the search may be performed using a terminal, other than the user terminals 11 or the data gathering server 12, capable of accessing the data gathering server 12 via the communication network 10.
Next, the operations of the data gathering and processing system 1 according to the above configuration will be described.
Firstly, the data gathering and processing procedure in the data gathering and processing system 1 according to the present embodiment will be described, mainly with reference to
Once the data inputter has selected the template of a data entry screen in the user terminal 11, the display unit 112 of the user terminal 11 displays the data entry screen by reading out, from the template storage unit 111, XML corresponding the template selected by the data inputter and analyzing the read XML (step S11).
Once data has been entered by the data inputter into the data entry screen displayed on the user terminal 11, the input data reception unit 113 acquires this input data, and stores the acquired input data in the input data storage unit 114 in association with the tag names corresponding to the input data (step S12).
Here, assume that data has been entered as shown in
Once data entry to the data entry screen is thereby complete, and the data inputter has clicked an Issue button 33 on the data entry screen, the XML file generation unit 115 generates an XML file describing the layout of the data entry screen that includes input data, with reference to the XML of the template of the data entry screen and to the input data and tag names stored in the input data storage unit 114 (step S13).
For example, XML such as shown in
The XML file generated in step S13 as described above is sent by the communication unit 110 of the user terminal 11 to the data gathering server 12 via the communication network 10 (step S14).
In the data gathering server 12, the communication unit 120 receives the XML file sent from the user terminal 11 (step S21). The received XML file is stored in the XML database 122. At this time, the item extraction unit 121 extracts the tag names corresponding to input data items from the XML file, and stores the extracted tag names in the XML database 122 in association with the XML file (step S22). The tag names extracted by the item extraction unit 12 are used as options for allowing a searcher to select a search item in the search process described below. Note that when storing a received XML file in the XML database 122, parts of the description not related to the input data in the XML file may be removed, for example, and only those parts including description related to significant input data may be stored in the XML database 122 in order to conserve storage capacity.
The above procedure enables data entered at the user terminal 11 to be gathered in the XML database 122 of the data gathering server 12 as an XML file. Note that while the process of extracting tag names corresponding to input data items from an XML file is performed in the item extraction unit 121 provided in the data gathering server 12 in the above description, the tag name extraction process may be performed in the user terminal 11, and the extracted tag names sent to the data gathering server 12 together with the XML file and stored in the XML database 122.
Note that in the case where options or the like for a tag name are described in the XML, the item extraction unit 121, rather than only extracting the tag name as a search item from the XML file, preferably extracts these options or the like as search criteria for the search item. For example, the options “White”, “Black”, “Hispanic” and “Asian” are described in the XML for the tag name “Race” in the above example, so these options preferably are extracted as search criteria for the search item “Race”.
Also, in the case where there is a dominant concept common to a plurality of tags, the item extraction unit 121 may extract the item name representing the dominant concept of those tag names as a search item. For example, the item extraction unit 121 may extract “Observation Date”, as the dominant concept of the three tag names “Observation Date.yr”, “Observation Date.mth” and “Observation Date.dy”, in the above example.
Next, a search process using data gathered in the XML database 122 as aforementioned will be described with reference to
Note that, as described above, the data search process may be performed in the data gathering server 12 or in one of the user terminals 11, or alternatively using a terminal, other than the user terminals 11 or the data gathering server 12, capable of accessing the data gathering server 12 via the communication network 10. In the example described here, the search process is performed in one of the user terminals 11.
When a searcher starts a search mode in the user terminal 11, a search item selection screen is displayed on the user terminal 11 using the functions of the search criteria setting unit 123 and the display unit 125 (step S31). A configuration is also possible in which the searcher is allowed to select the XML filename (template name of a data entry screen) of data to be searched, when this search item selection screen is called. In the present embodiment, an exemplary search item selection screen in the case where the data of the above “Demographic Data” template is to be searched is shown in
The searcher selects a desired search item on this search item selection screen, using a pointing device such as a mouse. Once the searcher has thus selected a search item, the search criteria setting unit 123 acquires the selected search item, and controls the display unit 125 to update the display state of the search item selection screen (step S32). For example, in the
Also,
As a result of the searcher pressing a Start Search button 44 after thus setting the desired search criteria, the search execution unit 124 refers to the XML database 122 based on the set search criteria, and extracts XML files that include input data matching the search criteria (step S33).
The search execution unit 124 sends the search results to the display unit 125, and the display unit 125 displays the search results on the user terminal 11 as a search results screen such as shown in
Also, when the searcher clicks a desired line on the search results screen, the display unit 125 is able to display the search result using an image of a data entry screen, as shown in
Note that while a search process is performed in the example shown in the above embodiment as a mode of the secondary use of gathered input data, the secondary use of gathered data is not limited to a search process. Gathered data can be used in various applications such as aggregation/statistical processing and graphic processing.
As described above, the data gathering and processing system 1 according to the present embodiment enables input data to be gathered efficiently, and gathered input data to be easily put to secondary use in various applications, by using a structured document such as XML or the like.
Hereinafter, a further example will be described in which a data gathering and processing system of the present invention is applied to clinical trials as a second embodiment.
In the case of conducting a clinical trial of a new drug, the pharmaceutical company creates a document called a CRF (Clinical Research Form), which is distributed to the medical institutions implementing the clinical trial. The medical institutions administer the study drug to patients with a specific condition, observe the progress, and provide the CRF to the pharmaceutical company after completing the necessary information.
This information also, however, needs to be recorded in the medical records of the medical institutions. Therefore, conventionally this involved a great deal of work since the physician in the medical institution had to record this information in the medical records as well as transcribing the same information to the CRF. Even in the case where the medical institution employed an electronic medical record system, the CRF was conventionally distributed to the medical institution as a paper medium, making it necessary to transcribe the information on the electronic medical record system to the CRF.
Also, the pharmaceutical company is required to dispatch an MRO (Medical Review Officer) to the medical institution and compare the CRF submitted to the pharmaceutical company by the medical institution with the medical records kept at the medical institution, in order to check the accuracy of the CRF submitted by the medical institution at prescribed stages of the clinical trial. This process is called verification. The MRO has to go to the medical institution because the medical records are not allowed to be removed from the medical institution.
As described above, a clinical trial was conventionally a burden on the medical institution which had the hassle of completing the CRF, and on the pharmaceutical company which had to dispatch an MRO to the medical institution and verify the CRF. An object of the data gathering and processing system according to the present embodiment is to reduce both of these loads.
Thus, with the data gathering and processing system according to the present embodiment, the pharmaceutical company creates a template of the CRF using XML, and the passes the created CRF template to the medical institutions implementing the clinical trial as an XML file. There are various methods of delivering the CRF template (XML file) from the pharmaceutical company to the medical institutions at this time, with no particular limitations in this respect. For example, delivery may be performed with the XML file stored on a medium such as a flexible disk (FD) or a CD-ROM. Alternatively, the XML file may be delivered as an attachment to an email or by file transfer from the pharmaceutical company to the medical institutions via the Internet or a dedicated line.
Here, the configuration of the data gathering and processing system according to the present embodiment and a detailed example of the operations thereof will be described.
The terminal 21 of the medical institution is realized, for example, by a personal computer with a browser installed, and displays data entry screens written in a structured document (XML in the present embodiment).
Note that since the functions of a communication unit 210, a template storage unit 211, a display unit 212, an input data reception unit 213, an input data storage unit 214, and an XML file generation unit (structured document generation unit) 215 in the terminal 21 of the medical institution are the same as the functions of the corresponding units in the user terminal 11 shown in
In the data gathering and processing system of the present embodiment, a template (hereinafter, called a CRF template) for displaying on a display of the terminal 21 is created in the pharmaceutical company using XML, with the format of the CRF shown in
The terminal 21 of the medical institution stores the CRF template distributed from the pharmaceutical company in the template storage unit 211 as an XML file. The XML file of a CRF template stored in the template storage unit 211 can be selected in the terminal 21 from a document selection field 31 displayed on a screen, similarly to the first embodiment. Once the operator of the terminal 21 has selected a CRF template, the display unit 212 extracts the XML file of the selected CRF template from the template storage unit 211, and displays a data entry screen on the terminal 21 in accordance with the document definition of the extracted XML file.
Here, the operator of the terminal 21 is able to appropriately enter information obtained in the clinical trial into the data entry screen displayed on the terminal 21, as shown the
Once data has thus been entered into the data entry screen, the input data reception unit 213 detects the data entered into the data entry screen of the terminal 21, and at least temporarily stores the detected input data in the input data storage unit 214 together with the tag names into which the data was entered, similarly to the procedure described in the first embodiment. Once data entry to the data entry screen is complete, the XML file generation unit 215 creates an XML file with data describing the layout of the data entry screen that includes input data, with reference to the template storage unit 211 and the input data storage unit 214. The generated XML file with data is transmitted from the terminal 21 to the clinical trial data gathering server 22 of the pharmaceutical company via the communication network 20.
The clinical trial data gathering server 22 is provided with a communication unit 220, an item extraction unit 221, an XML database 222, a search criteria setting unit 223, a search execution unit 224 and a display unit 225, as shown in
When an XML file is transmitted from the terminal 21, the communication unit 220 in the clinical trial data gathering server 22 receives the XML file. The received XML file is stored in the XML database 222. At this time, the item extraction unit 221 extracts the tag names corresponding to the input data items from the XML file, and stores the extracted tag names in the XML database 222 in association with the XML file. The tag names extracted by the item extraction unit 221 are used as options for allowing a searcher to select a search item in the search process. Note that when storing a received XML file in the XML database 222, parts of the description not related to the input data in the XML file may be removed, for example, and only those parts including description related to significant input data may be stored in the XML database 222 in order to conserve storage capacity.
The above procedure enables data entered from the terminal 21 to be gathered in the XML database 222 of the clinical trial data gathering server 22 as an XML file. Note that the tag name extraction process may be performed in the terminal 21, and the extracted tag names sent to the clinical trial data gathering server 22 together with the XML file and stored in the XML database 222, similarly to the first embodiment.
Also, similarly to the item extraction unit 121 of the first embodiment, in the case where options or the like for a tag name are described in the XML, the item extraction unit 221, rather than only extracting the tag name as a search item from the XML file, preferably extracts these options or the like as search criteria for the search item. In the case where there is a dominant concept common to a plurality of tags, the item extraction unit 121 may extract the item name representing the dominant concept of those tag names as a search item.
As a result of the above processing, the data gathering and processing system according to the second embodiment enables information on a clinical trial to be gathered in the clinical trial data gathering server 22 simply by displaying the template of a CRF in the terminal 21 in electronic form as a data entry screen, and entering information obtained in the clinical trial into this data entry screen. Also, the item extraction unit 221 in the clinical trial data gathering server 22 extracts tag names that can be used as search items, enabling the search process to be readily performed in the clinical trial data gathering server 22. Note that since the procedure of the search process in the clinical trial data gathering server 22 is similar to the processing shown in
In the second embodiment, information entered into a data entry screen of the terminal 21 in a medical institution can be used by the electronic medical record system 23 of the medical institution without modification. That is, the terminal 21 captures the data entry screen with data entered therein as shown in
Hereinbefore, an example in which the data gathering and processing system of the present invention is used in the data gathering of a clinical trial was described in the first and second embodiments, although the application field of the data gathering and processing system of the present invention is not limited to only clinical trials or the medical field, but includes various data gathering and secondary use of gathered data.
While preferred embodiments have been described above with reference to the drawings, it will be apparent to those skilled in the art that various changes and modifications may be made to the embodiments of the invention without departing from the spirit or teachings of the invention. Accordingly, the foregoing embodiments are merely specific examples for illustrating the invention, and are not intended to limit the scope of thereof.
Number | Date | Country | Kind |
---|---|---|---|
2007-100961 | Apr 2007 | JP | national |