Hidden Access Cost: The Database

Author: 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

Access Control Course Spring 2019 - Last Chance on Apr 18, 2019
This is the last chance to register for the Spring Access Control Course. IPVM offers the most comprehensive access control course in the...
Door Operators Access Control Tutorial on Apr 17, 2019
Doors equipped with door operators, specialty devices that automate opening and closing, tend to be quite complex. The mechanisms needed to...
Alarm.com Favorability Results 2019 on Apr 15, 2019
The once dot com startup has evolved to become a core provider for home security and is now expanding into commercial. In their first entry in...
ISC West 2019 Report on Apr 12, 2019
The IPVM team has finished at the Sands looking at what companies are offering and how they are changing their positioning. See below for 50+...
Spring 2019 50+ New Products Directory on Apr 08, 2019
We are compiling a list of new products for Spring 2019 and have over 50 already. Contrast to Fall 2018 New Products Directory and Spring 2018...
Startup GateKeeper Aims For Unified Physical / Logical Access Token on Apr 04, 2019
This startup's product claims to 'Kill the Password' you use to keep your computers safe.  They have already released their Gatekeeper Halberd...
Airship VMS Profile on Apr 03, 2019
Airship has been developing VMS software for over 10 years, however, with no outside investment, and minimal marketing, the company is not well...
Silicon Valley Access Startup Proxy Raises $13.6 Million on Mar 28, 2019
This mobile-credential based access startup just raised $13.6 million in funding.  Further, they claim that their technology can free businesses...
Casino Security Consultant Carl Lindgren Interview on Mar 26, 2019
For more than 20 years, Carl Lindgren worked as a casino surveillance pro, while being active (and sometimes outspoken) on various online video...
Lenel Favorability Results 2019 on Mar 26, 2019
The positive news for Lenel is that integrators do not dislike them as much as they used to.  The negative news for Lenel is that integrators...

Most Recent Industry Reports

The Fastest Growing Video Surveillance Sales Organization Ever - Verkada on Apr 17, 2019
Verkada has the fastest growing video surveillance sales organization ever. In less than 2 years, they already have more salespeople in the US...
Door Operators Access Control Tutorial on Apr 17, 2019
Doors equipped with door operators, specialty devices that automate opening and closing, tend to be quite complex. The mechanisms needed to...
Securadyne CEO: IPVM 'Entertaining For An Ignorant Few' on Apr 16, 2019
Securadyne's CEO Carey Boethel is unhappy with IPVM's report - Failed Integrator Rollup, Securadyne Sells to Guard Giant Allied. Indeed, he...
Dahua Repositionable IR Multi-Imager Camera Tested on Apr 16, 2019
Dahua has released their first repositionable multi-imager camera, the Multi-Flex 4x2MP, claiming integrated IR, true WDR, and flexible...
Strong ISC West 2019 For Manufacturers But Concerns For 2020 March Move on Apr 16, 2019
ISC West 2019 was strong for manufacturers, according to new IPVM survey results of 100+ manufacturers, consistent with 2018 results. However,...
Axis Supports HD Analog on Apr 15, 2019
In 2017, Axis declared 'Everything is IP': Now, in 2019, Axis has released support for HD analog, with their new encoders.  Why the change?...
Alarm.com Favorability Results 2019 on Apr 15, 2019
The once dot com startup has evolved to become a core provider for home security and is now expanding into commercial. In their first entry in...
UK Camera Commissioner Calls for Regulating Facial Recognition on Apr 15, 2019
IPVM interviewed Tony Porter, the UK’s surveillance camera commissioner after he recently called for regulations on facial recognition in the...
ISC West 2019 Report on Apr 12, 2019
The IPVM team has finished at the Sands looking at what companies are offering and how they are changing their positioning. See below for 50+...
Pole Mount Camera Installation Guide on Apr 11, 2019
Poles are a popular but challenging choice for deploying surveillance cameras outdoors. Poles are indispensable for putting cameras at the right...

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