Patriot uses the 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.
Why does Patriot use an SQL Database?
Speed and Network Efficiency
MS SQL utilises server
hardware architecture to a
higher degree than standard
databases. This prevents the
bottlenecks that 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 easier integration with reporting
and
analysis applications, accounting packages and
other 3rd party software.
Data Replication and Warm Backups
The Patriot SQL database is backed up
with no interruption to
alarm signal processing.
Backups are
configured in Patriot to run at preset intervals.
This ensures that your
Patriot backup server has
current
data available at all times. Automated data restore to
the Patriot backup server is
an important feature
available in Patriot Enterprise.
Patriot Enterprise
Database Mirroring
Patriot Enterprise 6.1
features support for
Microsoft SQL database
mirroring. Available with
SQL Server Standard or
Enterprise, this feature
enables Patriot to maintain
two identical databases on
two separate SQL Servers.
This ensures that in the
event of a failure of the
primary Patriot SQL Server,
the mirrored server will
maintain service with no
data loss.
The SQL servers must be in
the same domain but can be
located remotely from each
other provided that there is
fast, reliable TCP/IP
connectivity between the
sites.
Patriot provides a simple
applet which automates the
change in operating mode
required to bring the
secondary SQL database into
service. Every Patriot
system also includes free
backup server licensing
enabling CMS Managers to
configure duplicate
facilities which ensure
ongoing data and operational
security.