The My.N Database

My.N uses Microsoft's SQL Server as its database engine.

This provides high performance and provides scalability up to very large numbers of users. SQL Server also has a high level of in-built security.

The database's Transaction Processing feature ensures that no partially complete transaction can ever be written to the database. In practice, this means that a control account can never be updated without the underlying detailed record being written. Or a one-sided transaction could never be written to the general ledger.

SQL Server also has Referential Integrity. This enforces rules at a deep level over what can be written to the database. In practice this means that a transaction to a non-existent account could never be written to the general ledger, and an invoice for an invalid account could never be posted to the sales ledger.

These features together provide a high-performance, secure, reliable platform with guaranteed data integrity.