Data Management System at the Photon Factory Macromolecular Crystallography Beamline

Macromolecular crystallography is a very powerful tool to investigate three-dimensional structures of macromolecules at the atomic level, and is widely spread among structural biology researchers. Due to recent upgrades of the macromolecular crystallography beamlines at the Photon Factory, beamline throughput has improved, allowing more experiments to be conducted during a user's beam time. Although the number of beamlines has increased, so has the number of beam time applications. Consequently, both the experimental data from users' experiments and data derived from beamline operations have dramatically increased, causing difficulties in organizing these diverse and large amounts of data for the beamline operation staff and users. To overcome this problem, we have developed a data management system by introducing commercial middleware, which consists of a controller, database, and web servers. We have prepared several database projects using this system. Each project is dedicated to a certain aspect such as experimental results, beam time applications, beam time schedule, or beamline operation reports. Then we designed a scheme to link all the database projects.