Seaward SQL Information Pack - Manual (Page 3)

Last updated: 10/02/2009
1. Introduction
With the introduction of the PATGuard Elite SQL program, Seaward were the first
company to offer a corporate database format for PAT records. This new format
enables very large databases to be created, with fast response times to database
queries as well as simultaneous shared access and other features associated with
database management platforms such as integration with other data.
2. Database Formats
The most important difference between all other PATGuard database programs
(including previous versions) is that the database is contained in a single file (mdb)
while for PATGuard Elite SQL the program links to third party program which
controls and manages databases.
Both formats allow for multiple databases. That is for PATGuard programs that use
mdb files, new database files can be created and for PATGuard Elite SQL multiple
databases can be created through the third party program.
The following table compares features between the two database formats:
Mdb files SQL databases
Multiple individual databases Yes Yes
Simultaneous shared database access No Yes
Query response times Dependent* Very Fast
Database Integration No Yes
Data mining No Yes
* Dependent on PC resource and Database size. Larger the database – the slower it
will become.
Standard PATGuard database schematic
Rev 1.0 3