Topic: Development of distributed database system for borehole data using free and open source software
Presenter: Tatsuya Nemoto
A web-based distributed database system has been developed with an aim of continuing delivery of geologic data even if the system fault occurs. PostgreSQL and pgpool-II were utilized to construct the system. PostgreSQL is a powerful relational database management system. Pgpool-II that has some modes for management of distributed database is a middleware for PostgreSQL. The prototype distributed database system for management and sharing of borehole data has been successfully implemented by using Replication mode and Parallel query mode of pgpool-II.