H. Okumura

J. Kariya

M. Emoto

S. Yamaguchi

Y. Shamoto

National Institute for Fusion Science (NIFS-Repository)

§45. Relational Data Base for LHD Monitoring System Shamoto, Y. (freelance) Emoto, M. (NihonSun). Okumura, H(Matusaka Univ .) Kariya, J (Yamaguchi Univ.) and Yamaguchi,S. We are constructing the LHD monitoring system to watch the status of the operation. The channel number of this system is over 500, and therefore, the number of 10000 parts are used in the system, which include the isolation-amplifiers, its power supplies, ADCs, workstations, cables and their components system. They n1ust be managed and controlled efficiently. Moreover, since this is one of the data gathering system, the data are accumulated and the number of data are increasing with the operation. This situation needs to use the relational data base (RDB). In order to design the RDB, we must consider the response time, the relation of data, the structure of data, kind of data and types of data. There are three types of data in the system, one is the texts (ex; products' specifications submitted by manufacturers), others are images (ex; the partial drawings of the coils used in the experiments) and meta -data (ex; the numeric data measured in the experiments). Since the experimental data are the time sequential data and it is not suitable to store in RDB directly because of the time response of the system, the experimental data are stored in the different disk. The image data also need large stored area, and RDB engine only indicates the position of the data in the system. The structure of the system is shown in Fig. 1. Client- contents managemenet I input texts RDB Server- text data meta-data Other Server- . d t tmage a a Fig. 1: Structure of RDB system. The problem at this moment is how to design the database in dealing with the unstructured data management. After the start of the experiment, some change is needed to improve the RDB. RDB must be easy to access by many users, and the technique of WWW is the key for the different kinds of the client computers. In the future operations, we suspect that there should be a great deal of access in the use of WEB interface. 50 At this stage, it's necessary tothink twice about the index system and the buffer function. In this year, we develop the monitoring system for the IV -Coil experiment. The experimental comments can be written in Web server, and are able to share with many users. These comments are one of data to keep in the system, and the key-word searching system are must the part of RDB system. Some problems in the database planning are the technical innovation in the relational database is being accomplished to some extent. But it's still not clear how unstructured data should be managed, and how efficiently it should be done. Therefore, the text management in the relational data model or the other kinds of multimedia data are to be dealt with by the pointer-n1anagement. The data themselves are to be under the control of the UNIX file system. See the table of an ERD-chart in Fig. 2. I I • • Am T e T-i AmpTypeiD Amp TypeDea I er I D. Company I D (FK) AmpTypeName Amp TypeGa i nSett i ngAuto Amp TypeGa i nSett i ngF i xed Amp TypeRangeSett i ngAuto Amp TypeRangeSett i ngF i xed AmpTypeUseFi Iter Amp TypeF r equencyDependency AmpTypeOffset AmpTypeNoise Amp TypeCur rent AmpTypelowPassFi Iter Amp Type I so I at ion Amp TypeCreateDate Amp TypeUpdateDate Amp TypeMaker I D. Company I D (FK) AmpTypeNote r--( Am_p_Ty_pe_l D_(_FK_) __ ;; AmpTypeNote 1: AmpTypeNoteCreateDate : :~.;,:..~~.~.~.~.~~.~~.~.~.~.~.~.:.:...!f L Am Gain AmpTypeiD (FK) i l AmpTypeGain J: ·uunnunu1nunn• .. •nu1nn;.: Fig. 2: Table for Amplifier in ERD-chart. The isolation-amplifiers are used in the system, and there are several types of amplifiers. The gain of the amplifier are set for each sensors and operation parameters. The purchase date and person, the maker company are also managed by RDB. The future subjects In the computing server, large-scale operations show greater efficiency than a mass of small-scale operations. As for the capacity of the server, in terms of the easiest access, a large-scale single datum is preferable to a mass of small divisions of data. As for the solution to the relational-type, in some cases the better performance can be gotten as the volume is getting bigger. Now the biggest problem is how much response can be realized by operating this experimental system. 

Relational Data Base for LHD Monitoring System

Abstract

Similar works

Full text

Available Versions

National Institute for Fusion Science (NIFS-Repository)