JP4645293B2 - Data management system for instrument analysis - Google Patents

Description

  The present invention relates to a data management system for storing and managing various data obtained by various analyzers (for example, chromatograph devices, spectrophotometers, mass spectrometers, etc.) used for instrumental analysis in a database.

  In the field of instrumental analysis, a system has been developed in which data obtained by various measuring / analyzing devices and various data resulting from analyzing the data are made into a database and used by multiple analysts as shared assets. ,It's being used. In particular, recent measuring / analyzing devices use a general personal computer as a control unit that controls the overall operation of the device and a data processing unit that analyzes and processes data, so it is easy to build a network that connects these computers together. The database is also centrally managed by server computers arranged in the network.

  In general, data collected by a measurement / analysis apparatus and data obtained by performing qualitative analysis / quantitative analysis processing based on such measurement data are stored in a predetermined file or database. Depending on the purpose of the database, it is often convenient to organize and manage various data and data files by dividing them into various classifications such as sample names, analyst names, analysis years, and analyzers. Therefore, a plurality of databases may be provided. For example, when it is desired to sequentially browse measurement / analysis data for a specific sample, if the data is arranged for each sample name, quick reading is possible and work efficiency is improved. In such a case, a database may be created separately for each sample name, and data collected by each measurement / analyzer may be stored in a different database according to the sample name.

  In the case where a plurality of databases are provided, each data is usually automatically distributed and stored in a predetermined database. As an example of the device analysis data management system having such an automatic distribution function, there is “Network tool for database management / registration CLASS-Agent ver.2” which is the product of the applicant of the present application (see Non-Patent Document 1). .

  In addition, in order to ensure the reliability of food inspection, new drug development, etc., guidelines called GLP (Good Laboratory Practice) and GMP (Good Manufacturing Practice) have been introduced in recent years. Strict standards are set for the management of data including the results. In an instrument analysis data management system, in order to comply with these guidelines, measurement / analysis data is usually managed by instrument analysis application software.

Shimadzu Corporation, "CLASS-Agent ver.2 Database Management / Registration Network Tool", [online], [Search April 19, 2005], Internet <URL: http: //www.an.shimadzu. co.jp/products/data-net/agent1.htm>

  When using the data management system for device analysis as described above, a failure that the measurement / analysis data cannot be stored in the database may occur due to a failure of the database itself or a failure of the network. (In the present invention, this failure is referred to as “storage failure”.) When a storage failure occurs, the measurement / analysis data is stored in a predetermined database (hereinafter referred to as “storage destination database”). Therefore, the measurement / analysis data is stored in a temporary database in a storage device provided in the analysis instrument itself or the computer for the analysis apparatus.

  After the storage failure is resolved, the measurement / analysis data stored in the temporary database must be moved to the storage destination database to be originally stored. Conventionally, this operation has to be performed manually by a key operation or a mouse operation while confirming the name of a storage destination database attached to each measurement / analysis data, which is troublesome. In particular, when the number of data accumulated in the temporary database is large or the types of storage destination databases are large, the operation becomes very complicated. In addition, since the operation is manual, there is a problem that a mistake that the storage destination is wrong is likely to occur.

A data management system for instrument analysis according to the present invention made to solve the above problems,
A device management data management system for storing and managing measurement data obtained by device analysis and measurement / analysis data including various data derived from this measurement data in a database on specific application software. In a system capable of constructing a plurality of the databases,
A failure detection means for detecting a storage failure in which measurement / analysis data cannot be stored in a predesignated database;
Temporary storage means for storing measurement / analysis data in a temporary database when a storage failure is detected by the failure detection means;
After the storage failure is resolved, storage location specifying means for reading storage location information relating to the measurement / analysis data,
Data recovery means for storing measurement / analysis data in a predesignated database based on the storage location information;
It is characterized by providing.

  Automating the operation of storing the measurement / analysis data stored in the temporary database due to the occurrence of a storage failure in the storage destination database that should be stored after the storage failure has been resolved by the data recovery means according to the present invention. Can do. Therefore, the troublesome work of manually moving data, which had to be performed individually until now, becomes unnecessary, and the labor of the operator can be greatly reduced. In addition, since measurement / analysis data is surely registered in a desired database, work efficiency when using these databases is improved.

In the data management system for instrument analysis according to the present invention, a system can be constructed by only one computer provided for one measuring / analyzing apparatus (stand-alone type). A server / client type in which a plurality of computers provided to the analyzer are connected via a network, and data acquired by the measurement / analyzer is managed by one server. You can also.
In the case of the stand-alone type, a plurality of databases serving as storage destinations and a temporary database are provided in a system including the single computer.
In the case of the server / client type, normally, a plurality of databases serving as storage destinations are provided on the server side, and a temporary database is provided for each of a plurality of computers provided for the measurement / analysis apparatus.

  The device analysis data management system according to the present invention automatically detects the presence of a storage failure when a storage failure occurs, and stores measurement / analysis data that could not be stored in the storage destination database in a temporary database. It has a function to do.

Possible causes of storage failures in which measurement / analysis data is not stored in the storage destination database include the following.
-The database is damaged-The database size has reached the upper limit-The hard disk where the database is stored is damaged or the capacity is insufficient-The network cable is disconnected (in the case of a network system)
-The hub has failed (in the case of a network system)

  When the storage failure is resolved, the system of the present invention reads the storage location information for each measurement / analysis data stored in the temporary database. Next, by referring to the storage location information, the measurement / analysis data is moved to a storage location database designated in advance. As this storage location information, information included in measurement / analysis data may be used, or information included in a log generated when the measurement / analysis data is stored in a temporary database. It can also be used.

  Hereinafter, an instrument analysis data management system according to an embodiment of the present invention will be described with reference to the drawings. FIG. 1 is an overall configuration diagram showing an example of a device analysis data management system using a network.

  The data management system of this embodiment is configured by a server / client system centered on the server 10. Here, the analyzers are a liquid chromatograph (LC) 21, a gas chromatograph mass spectrometer (GC / MS) 23, an ultraviolet-visible spectrophotometer (UV) 25, and an electronic balance 27, but are not limited thereto. Of course not. These analyzers are provided with computers 22, 24, 26, and 28 for control and data processing, respectively, and these computers are connected to the network 11 as clients.

  In this embodiment, the server 10 and each client computer are equipped with application software for managing the data acquired by the analyzer on the database, and the database can be used on this application software. It has become.

  FIG. 2 is a block diagram showing a functional configuration of a main part of the computer 22 as a client. As shown in FIG. 2, a central control unit 53 is provided at the center of the processing. The central control unit 53 includes an input unit 57 that is an input device such as a keyboard and a mouse, and a display unit 58 that is a CRT, a liquid crystal display, and the like. A network I / O 59 is connected to transmit and receive data via the network 11. Further, the function of the temporary database recovery processing unit 531 is achieved by the application software installed in the computer 22. A temporary database storage unit 32 is provided below the temporary database recovery processing unit 531. This configuration is basically the same as the main configuration of the computers 24, 26 and 28.

  The server 10 is provided with a database storage unit 30 in the hard disk drive, and the analysis / measurement data acquired by each analyzer is converted into a database so that it can be centrally managed and can be shared. Accumulated. In FIG. 1, databases A, B, C, and D independent from each other are constructed. Data stored in these databases includes, for example, raw data collected by analysis, analysis data including data that is the result of analysis processing, documents such as reports created by pasting graphs such as chromatograms and spectra, Although it is method data etc., such as analysis conditions and data analysis conditions, the contents of data are not restricted to these.

  Hereinafter, processing performed by the computer 22 will be described as processing performed by the client computer. When normal, the raw data output from the analyzer 21 passes through the A / D converter 56 and then the central controller 53 provides various information such as sample name, sample ID, analyst name, analyzer name, and analysis date. It is added and stored in a storage destination database constructed in the database storage unit 30 of the server 10 connected on the network 11 via the network I / O 59. Usually, at the time of this storage, the additional information of the measurement / analysis data is sorted based on a predetermined condition, and each measurement / analysis data is automatically stored in a desired storage destination database.

When the system detects that a storage failure has occurred, the measurement / analysis data is automatically stored in the temporary database in the temporary database storage unit 32. At the same time, a temporary database log is generated in the temporary database storage unit 32. An example of this temporary database log is shown in FIG. The temporary database log includes log information including date / time, contents, user name, program name, operation, sample name, sample ID, and the like regarding all measurement / analysis data stored in the temporary database.
When a storage failure occurs, the central control unit 53 further displays a warning pop-up notifying that the storage has failed in the storage destination database on the display unit 58.

  Thereafter, when the storage failure is resolved and the operator performs a predetermined operation on the computer 22, the temporary database recovery processing unit 531 transfers the data stored in the temporary database to the storage destination database that was originally scheduled to be stored. A message box that allows the operator to instruct whether to perform data recovery processing (temporary database recovery processing) to be stored is displayed on the display unit 58 (FIG. 4).

  The processing operation of the temporary database recovery processing unit 531 when the operator selects the data recovery processing by the input unit 57 will be described with reference to the flowchart of FIG.

  First, the temporary database restoration processing unit 531 confirms whether measurement / analysis data exists in the temporary database of the temporary database storage unit 32 (step S1). When the measurement / analysis data does not exist in the temporary database, a predetermined message indicating that the restoration process is unnecessary is displayed on the display unit 58 and the process is terminated.

  When the measurement / analysis data is stored in the temporary database, the temporary database recovery processing unit 531 refers to the log data stored in the temporary database storage unit 32, and the database storage unit 30 provided on the server side. The original storage destination database name in is confirmed (step S2). In the temporary database log shown in FIG. 3, one line shows a part of log information corresponding to one measurement / analysis data. Here, in the item of “content”, after displaying the cause of the storage failure “cannot open the database”, characters A, C, A, D... The original storage destination database of the measurement / analysis data stored in the temporary database is shown in order from the top (that is, the measurement / analysis data a, b, c, d stored in the temporary database in FIG. 6). ,... Are stored in databases A, C, A, D.

  When the storage database name of the measurement / analysis data is confirmed, the temporary database restoration processing unit 531 performs a process of moving each measurement / analysis data to the storage database. If the storage failure in the storage destination database has been resolved (Yes in step S3), the temporary database recovery processing unit 531 stores each measurement / analysis data in the storage destination database in the database storage unit 30 as shown in FIG. The data recovery process to move to is performed (step S4), and the process ends.

  If the storage failure of the storage destination database has not been resolved (No in step S3), the temporary database recovery processing unit 531 ends the process without moving the measurement / analysis data.

  The above embodiment is an example of the present invention, and it goes without saying that modifications and corrections can be made as appropriate within the spirit of the present invention. For example, when the storage location information is included in the measurement / analysis data itself, the temporary database is created by referring to the storage location information of the measurement / analysis data itself, rather than referring to the log of the storage location information. It is also possible to automatically move data from to a desired database. It is also possible to recover the data by obtaining storage destination information by applying the automatic distribution function as described above to the measurement / analysis data in the temporary database.

  Further, in the above embodiment, the data recovery processing is started by the operator performing a predetermined operation and selecting to execute the data recovery processing. However, the data recovery is automatically performed when the computer is started up. A configuration may be adopted in which processing is executed and started. This makes it possible to perform data recovery more efficiently.

BRIEF DESCRIPTION OF THE DRAWINGS The schematic block diagram of the data management system for apparatus analysis which is one Example of this invention. The block diagram which shows the functional structure of the principal part of the client computer in one Example of this invention. An example of a temporary database log. A message box for inputting an instruction as to whether or not to start data recovery processing. The flowchart of the processing operation of a temporary database recovery process part. FIG. 3 is a conceptual diagram of data recovery in which analysis / measurement data stored in a temporary DB is stored in an original storage destination DB.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 ... Server 11 ... Network 21, 23, 25, 27 ... Analysis apparatus 22, 24, 26, 28 ... Computer 30 ... Database storage part 32, 34, 36, 38 ... Temporary database storage part 53 ... Central control part 531 ... Temporary Database recovery processing unit 56 ... A / D converter 57 ... input unit 58 ... display unit 59 ... network I / O

Claims (1)

A device management data management system for storing and managing measurement data obtained by device analysis and measurement / analysis data including various data derived from this measurement data in a database on specific application software. In a system capable of constructing a plurality of the databases,
A failure detection means for detecting a storage failure in which measurement / analysis data cannot be stored in a predesignated database;
Temporary storage means for storing measurement / analysis data in a temporary database and generating a log including storage destination information related to the measurement / analysis data when a storage failure is detected by the failure detection means;
After the storage failure is resolved, storage location specifying means for reading storage location information relating to the measurement / analysis data from the log ,
Data recovery means for storing measurement / analysis data in a predesignated database based on the storage location information;
A data management system for device analysis, comprising:

Images