[MGI41-05] SIO7 database makeover.
Keywords:IODP, Chikyu, Database, FAIR, SIO7, SQL
Here we present our comprehensive new database model for scientific/drilling data storage, which aims at providing a high degree of data availability for efficient post-analysis utilising internet-based technology. The suggested data model proposes the web-based User Interface (UI) and Application Programmers Interface (API) are independent of the actual storing database. The web-based UI in the form of drop-down lists, maps with hole locations and searches gathers all the necessary information through API calls from the database at start-up time. The UI application will also have the capability to request data via SQL queries. These queries will not access the database directly. Instead, they will be sent to a database front-end that would handle the actual communication with the database engine.