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).
Some of the advantages of SQL databases:
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.
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.
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).






