Patriot uses a Microsoft SQL database. Patriot can be installed with MS SQL Express which is provided free of charge or with a fully licensed MS SQL 2005/2008 package.

Some of the advantages of SQL databases:

  Speed and Network Efficiency
      MS SQL utilises server hardware architecture to a higher degree than standard databases. This removes
      the bottlenecks which occur when data is processed on workstations.  SQL databases are also more adept
      at quickly processing very large volumes of data. In-house testing with Patriot showed a 50 fold increase in
      the number of logged signals when  compared to software using  non SQL databases.

  Compatibility
     Third party software can access Patriot SQL data directly. This allows direct interaction between Patriot and
     other applications such as reporting tools, access control software, and accounting packages. 

  Data Replication and Warm Backups
     The Patriot SQL database can be readily backed up with no interruption to alarm processing. Backups can
     be configured in Patriot to run at frequent intervals ensuring that your  backup server has up to date data
     available at all times. (Automated data restore to the Patriot backup server is also available with the
     Enterprise version of Patriot).