The objectives of the project were to improve the accessibility of the Modern Ocean Sediment Archive and Inventory of Carbon (MOSAIC) database through three work packages:

1. Implement a representational state transfer application programming interface (REST-API) that securely queries the database.
2. Set up and deploy a new user-friendly website that actively queries the database through the REST API.
3. Deploy additional APIs in the form of Python and R packages to allow researchers to query MOSAIC in their data processing workflows

Work packages 1 and 2 were successfully implemented. In October 2023 a beta version of the new MOSAIC website (www.mosaic.ethz.ch) was launched.

However, we identified that the REST API was not optimally constructed, since it was affecting the performance and speed when querying it through the web server and the Python API that we were building (mosaicpy). Close analysis of the REST API revealed that the main issue was the database architecture, which needed to be refactored. Given the importance of having a well-constructed and optimal database architecture to ensure the functionality of the REST API, we prioritized refactoring the database architecture rather than completely achieving the third work package.