More Info > Security > Data Integrity

Data Integrity

The database server is used as a simple data store and is responsible for all persistent storage. While the database contains definitions describing business logic, no processing is actually performed in this tier, other than create, read, update, and delete (CRUD) operations in response to requests from the Business Analytics Server. Referential integrity is enforced by the application, thereby protecting transactions. In addition, the database captures a complete audit log of all changes to data.

The data backup procedure is also an integral part of data integrity and while ITBA does not provide native backup capabilities, the following guidelines should be considered:

  • Database backup is especially important before critical actions such as upgrades.
  • Backup files should be stored properly according to the industry best practices to avoid unauthorized access.
  • Since database backup can be a resource intensive process, it is strongly recommended to avoid running backups during peak demand times.