19th International CODATA Conference
Category: Interoperability

Organizing Geochemical Kinetics Data Base System

Shumin Hu, Open Research Lab of Geochemical Kinetics, Chinese Academy of Geological Sciences, China
Junsheng Zhang, College of Information Science, Beijing Normal University, China
Ronghua Zhang, Open Research Lab of Geochemical Kinetics, Chinese Academy of Geological Sciences, China
Yan Fang, College of Information Science, Beijing Normal University, China
Rongfang Bie, College of Information Science, Beijing Normal University, China
(zrhhsm@pku.edu.cn; zrhhsm@bj163.com)

The kinetics experiments include several aspects: kinetics process (dissolution and precipitation); fluid systems; fluid flow and reaction; surface or fluid/solid interface etc. The kinetics data consist of the properties of minerals and solutions, experimental system, experiment conditions, fluid systems and reactor models etc.  Experiment al systems evolve with the time evolution, the continuously changeable experiment environments and the data recording process, which lead the data to be mass, excessive, imperfection (data lack), uncertain (system of random noise data), scarcity (little and invaluable data) etc.

We have built the kinetic database system to describe natural and experimental systems, and it is a one to one mapping. And it has functions for organization, evaluation and prediction of chemical kinetics data.

It is of much complicated how to implement geochemical kinetics database through integrating Client/Server and Browser/Server technology based on Oracle DBMS. Two platforms are proposed, one is computing platform for scientific research, and the other is a remote managing platform. The platforms enhance the efficiency of the scientific research by convenient administration and application of experimental data. And proposed an efficient and effective solution to organize and manage kinetic data, and assure the consistency and security of the data through a checking mechanism.

The kinetics system adopts both “system control” method and “node control” method. To simplify the research, we let the mineral subsystem/fluid subsystem be a certain mineral/solution, and this is “system control” method; during experimental process, if only temperature is changed, then it is “node control” method. 

Now there are two main kinds of network patterns based on database system: Browser/Server and Client/Server. Data in the kinetics database include basic experiment data, graph data, user data and literature data. To realize the data isolation, table spaces are built as follows:DATA table-space (basic experiment data), GRAPH table-space, USER table-space, REFERENCE table-space and INDEX table-space (index). SYSTEM table-space should be reduced progressively.  Oracle DBMS realizes the physical integrity, and increase new spaces to satisfy the requirements. Clustered storage method is adopted since some correlated tables are often queried together, namely, to store the group having same values in adjacent disk space in order to speed up the query speed.

*Supported by the Ministry of Science and technology Project of ‘CODATA Chinese data base for physics and chemistry’.