Mnova DB Server (User Manual)

Importance of MnServer in Analytical Data Management

MnServer provides a centralized platform for storing, sharing and managing chemical information and analytical data across multiple operating systems and users, ensuring data consistency, secure access and improved collaboration.

Objectives and Overview

This manual outlines the installation, configuration and operation of the MnServer 2.0 database back‐end for the Mnova software suite. It covers three editions (MyData, MnDB Group, MnDB Enterprise), quick‐start instructions and detailed guidance on setting up user access, database connectivity and audit capabilities.

Methodology and Instrumentation

The MnServer is implemented in Java and is compatible with Windows, macOS and Linux. It supports SQLite (MyData, MnDB Group) and enterprise RDBMS (Oracle, MySQL, PostgreSQL) back‐ends. Key components include:

• Java Runtime Environment (minimum 1.8, recommended 11)
• Operating Systems: Windows 7 or higher; macOS 10.13 or higher; various Linux distributions with Xlib support
• Database engines: SQLite, Oracle, MySQL, PostgreSQL

Key Features and Discussion

Three server editions address different scales: MyData for local use without extra license; MnDB Group for networked sharing with licensing; and MnDB Enterprise for large‐scale deployments with full RDBMS support. The system offers flexible installation, cross‐platform client connectivity, Active Directory integration for user management and a detailed audit trail logging all data modifications.

Benefits and Practical Applications

The solution simplifies collaborative workflows by unifying molecule, NMR, MS and other analytical data in a central repository. Role-based access control streamlines quality assurance processes, while the audit trail supports compliance and data integrity. Backup and restore procedures are straightforward via file copies for SQLite or standard RDBMS tools.

Future Trends and Potential Uses

Emerging enhancements may include cloud-native deployment models, advanced analytics integration using AI, automated metadata extraction and improved scalability for high-throughput laboratories. Enhanced security features and deeper integration with laboratory information management systems are anticipated.

Conclusion

MnServer 2.0 delivers a robust, cross-platform database back‐end for NMR and MS data management within the Mnova ecosystem. Its flexible architecture and comprehensive feature set support a wide range of laboratory sizes and workflows, fostering collaboration and regulatory compliance.

Reference

This summary is based on the MnServer Manual version 2.0, Mestrelab Research, June 2022.