Hidden Access Cost: The Database

By: Brian Rhodes, Published on Mar 04, 2013

All decisions have a price, but some cost more than others. Choosing which type of database for your access control system can impact cost greatly, but many do not understand the full impact of their choice. In this note, we examine database selection, and how a fundamental up front decision can impact the system for years afterward.

Which Version?

Most access control systems are available in at least two versions:

  • Cheap: An option using a free or inexpensive database format (SQL Server Express, Microsoft Access, or DB2)
  • Costly: An options (typical offered as 'Enterprise' or "Multi-site') that integrates with a full-burdened instance of SQL.

Pricing between versions can vary by thousands of dollars, but understanding which type is best is more than just a question of cost. In the section below, we review the key considerations that must be weighed

  • Number of Cardholders: The cheaper options often have an upper limit to the number of cardholders they can contain. While this threshold may not be a constraint for small or medium sized systems, it may not be sufficient for multi-site distributed systems.
  • Integration With Other Systems: Because the card holder information often covers every member in an organization, the data is valuable to other applications. A variety of human resources or payroll platforms may need in integrate with the database, but the cheapest database may be proprietary and not allow for outside integration.
  • Dependencies: In other cases, a particular version may require additional database servers or software for use. The less expensive options typically can be installed and configured on a single workstation, but a full version of SQL is very seldom installed as a stand-alone machine. In addition, the maintenance and configuration burden of more complex databases could be markedly different than low-cost offerings.
  • Management Features: Less expensive options do not often include advanced features like backup utilities, failover management, report writers, or corruption recovery utilities.

Deciding which option is best also requires a full look at computing environment behind the access control system. Even when the need for more powerful features requires advanced database options, the end-user must understand additional skill sets needed to keep the system operational.

Using Full SQL

The largest 'hidden cost' of many access systems comes from requiring a full SQL database version, designated as Standard version or higher. In all, expect an additional $4000 to $8000 even before considering the cost of labor to administrate and maintain it.

Typically, unless a user already employs an IT staff including a System Administrator, the decision to use Standard SQL can be expensive. The skills required to manipulate data tables and maintain the database are beyond casual users. Incorporating a full version of a SQL database solely for the use of the access control system is not common, and the additional labor costs of using SQL can venture into tens of thousands of dollars per year.

Free Options

The 'cheaper' options are built using standalone examples of MySQLSQL Express, Microsoft Access, DB2, or custom proprietary databases. While advanced features are limited and data stability is susceptible to individual implementations, these platforms are developed with the 'casual' user in mind.

Basic Reporting Only

One of the biggest gaps between the two options comes in the flexibility of developing custom reports. When a free or proprietary database is used, the selection of reports referencing the data is limited to a stock group. When full SQL is used, a report writing program like Crystal Reports or SQL Reporting Services Report Builder can be leveraged to develop non-standard queries.

Practical Examples

The examples below do not consider the cost of the extra server and software licensing for full versions of SQL if needed:

  • DSX: Two versions of software are available, the Access-based WinDSX or WinDSX SQL version. Pricing differs between the two options by ~$1000 USD.
  • Lenel: OnGuard can be configured either as a standalone "SQL Express" version, or as part of a "SQL Standard" install. While pricing is the same for the base software, the upgrade process from Express to Standard is involved and  will require an experienced database administrator to successfully configure.
  • KeyScan: System VII offers two options , a free SQL Express version and an upgrade to Standard SQL. The cost between the two options is ~$1500, with the SQL version offering twice the card holder capacity of the free version.

1 report cite this report:

Access Control Server Guide on Sep 09, 2014
Electronic access control systems need to be managed. The 'server' though can range across: Panel based / 'serverless' systems Combo...
Comments : PRO Members only. Login. or Join.

Related Reports on Access Control

ZK Teco Atlas Access Control Tested on Aug 20, 2019
Who needs access specialists? China-based ZKTeco claims its newest access panel 'makes it very easy for anyone to learn and install access control...
Suprema Biometric Mass Leak Examined on Aug 19, 2019
While Suprema is rarely discussed even within the physical security market, the South Korean biometrics manufacturer made global news this past...
Biometrics Usage Statistics 2019 on Aug 13, 2019
Biometrics are commonly used in phones, but how frequently are they used for access? 150+ integrators told us how often they use biometrics,...
ProdataKey (PDK) Access Company Profile on Aug 09, 2019
 Utah based ProdataKey touts low cost cloud access, wireless controllers, and no dealer required national distribution availability.  But how does...
Axis Door Station A8207-VE Tested on Aug 07, 2019
Axis newest door station, the A8207-VE, claims to deliver "video surveillance, two-way communication, and access control" in a single device. But...
Mobile Access Control Shootout - Farpointe, HID, Openpath, Nortek, Proxy on Jul 29, 2019
One of the biggest rising trends in access control is using phones as credentials but which offering is best? IPVM has tested five of the...
Responsibility Split Selecting Locks - Statistics on Jul 22, 2019
A heated access debate surrounds who should pick and install the locks. While responsible for selecting the control systems, integrators often...
Mobile Access Usage Statistics 2019 on Jul 18, 2019
The ability to use mobile phones as access credentials is one of the biggest trends in a market that historically has been slow in adopting new...
How To Troubleshoot Wiegand Reader Problems - Inverted Wiring on Jul 16, 2019
Wiegand is the dominant method of connecting access readers, but problems can arise for installers. In fact, one of the most difficult reader...
Nortek Blue Pass Mobile Access Reader Tested on Jul 11, 2019
Nortek claims BluePass mobile readers are a 'more secure and easy to use approach to access', but our testing uncovered security problems and...

Most Recent Industry Reports

TMA Apologizes to Amazon / Ring on Aug 23, 2019
Not only is Amazon / Ring making major incursions into the residential security market, the organization representing the biggest incumbents, The...
China Dahua Replaces Their Software With US Pepper on Aug 22, 2019
What does a US government banned company do to improve its security positioning in the US? Well, Dahua is unveiling a novel solution, partnering...
Security Integrators Outlook On Remaining Integrators In 2025 on Aug 22, 2019
The industry has changed substantially in the last decade, with the rise of IP cameras and the race to the bottom. Indeed, more changes may be...
First GDPR Facial Recognition Fine For Sweden School on Aug 22, 2019
A school in Sweden has been fined $20,000 for using facial recognition to keep attendance in what is Sweden's first GDPR fine. Notably, the fine is...
Anyvision Facial Recognition Tested on Aug 21, 2019
Anyvision is aiming for $1 billion in revenue by 2022, backed by $74 million in funding. But does their performance live up to the hype they have...
JCI Sues Wyze on Aug 21, 2019
The mega manufacturer / integrator JCI has sued the fast-growing $20 camera Seattle startup Wyze. Inside this note: Share the court...
Dahua 4K Camera Shootout on Aug 20, 2019
Dahua's new Pro Series 4K N85CL5Z claims to "deliver superior images in all lighting and environmental conditions", but how does this compare to...
ZK Teco Atlas Access Control Tested on Aug 20, 2019
Who needs access specialists? China-based ZKTeco claims its newest access panel 'makes it very easy for anyone to learn and install access control...
Uniview Beats Intel In Trademark Lawsuit on Aug 19, 2019
Uniview has won a long-running trademark lawsuit brought by Intel, with Beijing's highest court reversing an earlier Intel win, centered on...
Suprema Biometric Mass Leak Examined on Aug 19, 2019
While Suprema is rarely discussed even within the physical security market, the South Korean biometrics manufacturer made global news this past...

The world's leading video surveillance information source, IPVM provides the best reporting, testing and training for 10,000+ members globally. Dedicated to independent and objective information, we uniquely refuse any and all advertisements, sponsorship and consulting from manufacturers.

About | FAQ | Contact