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 [link no longer available]. 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 [link no longer available]: 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...
Comments : Members only. Login. or Join.

Related Reports

Mobotix Thermal Detection Camera Tested on Jun 09, 2020
For years Mobotix has struggled but now sales are surging driven by Mobotix's...
Hikvision and Uniview Entry Level Thermal Handheld Cameras Tested on Jun 05, 2020
While most screening systems cost $10,000 or more, manufacturers such as...
Hikvision MinMoe Temperature Screening Terminal Tested on Jun 23, 2020
Hikvision has expanded its temperature screening options. We tested...
IronYun AI Analytics Tested on Feb 17, 2020
Taiwan / US startup IronYun has raised tens of millions for its "mission to...
Injes Tiny Temperature Terminal Tested on Jul 17, 2020
While temperature terminals have trended bigger, the Injes DFace801 is...
Brivo Presents ACS100 Single-Door Combo Controller & Reader on Apr 27, 2020
Brivo presented its first integrated reader and controller, the ACS100 at the...
Disaster Relief Loans For Integrators Examined on Mar 23, 2020
Integrators are being impacted by the coronavirus. Now, the US government is...
Milestone Presents XProtect On AWS on May 04, 2020
Milestone presented its XProtect on AWS offering at the April 2020 IPVM New...
Worsen: Integrators Hit Even Harder By Coronavirus on Mar 30, 2020
Integrator's problems have worsened over the past 2 weeks, according to new...
Pivot3 Mass Layoffs on Mar 27, 2020
Pivot3 has conducted mass layoffs, the culmination of grand hopes, a quarter...
Directory of 199 "Fever" Camera Suppliers on Aug 04, 2020
This directory provides a list of "Fever" scanning thermal camera providers...
Coronavirus Hits Manufacturers, Standing Now, Worse To Come on Apr 06, 2020
Coronavirus is hitting security manufacturers, though overall modestly for...
Converged vs Dedicated Networks For Surveillance Tutorial on Feb 12, 2020
Use the existing network or deploy a new one? This is a critical choice in...
Fever Camera Sales From Integrators Surveyed on Jun 01, 2020
Fever cameras are the hottest trend in video surveillance currently but how...
FLIR A Series Temperature Screening Cameras Tested on Jun 04, 2020
FLIR is one of the biggest names in thermal and one of the most conservative....

Recent Reports

Indian Government Restricts PRC Manufacturers From Public Projects on Aug 04, 2020
In a move that mirrors the U.S. government’s ban on Dahua and Hikvision...
Directory of 199 "Fever" Camera Suppliers on Aug 04, 2020
This directory provides a list of "Fever" scanning thermal camera providers...
Face Masks Increase Face Recognition Errors Says NIST on Aug 04, 2020
COVID-19 has led to widespread facemask use, which as IPVM testing has shown...
Dahua Loses Australian Medical Device Approval on Aug 04, 2020
Dahua has cancelled its medical device registration after "discussions" with...
Google Invests in ADT, ADT Stock Soars on Aug 03, 2020
Google has announced a $450 million investment in the Florida-based security...
US Startup Fever Inspect Examined on Aug 03, 2020
Undoubtedly late to fever cameras, this US company, Fever Inspect, led by a...
Motorola Solutions Acquires Pelco on Aug 03, 2020
Motorola Solutions has acquired Pelco, pledging to bring blue back and make...
False: Verkada: "If You Want To Remote View Your Cameras You Need To Punch Holes In Your Firewall" on Jul 31, 2020
Verkada falsely declared to “3,000+ customers”, “300 school districts”, and...
US GSA Explains NDAA 889 Part B Blacklisting on Jul 31, 2020
With the 'Blacklist Clause' going into effect August 13 that bans the US...
Access Control Online Show July 2020 - On-Demand Recording of 45+ Manufacturers Presentations on Jul 30, 2020
The show featured 48 Access Control presentations, all now recorded and...
Face Detection Shootout - Dahua, Hanwha, Hikvision, Uniview, Vivotek on Jul 30, 2020
Face detection analytics are available from a number of manufactures...
Sunell is The First China Manufacturer to Market NDAA Compliance on Jul 30, 2020
Most China manufacturers are going to be impacted by the NDAA 'Blacklist...
Ink Labs Relabels China YCX Fever Camera And Steals Dahua's Marketing on Jul 30, 2020
A US company marketed a 'thermal temperature scanner' as its own, selling...
Genetec and Dahua-Backed Intelbras Split Examined on Jul 29, 2020
China is the cause of the breakup between Canada's and Brazil's largest video...
This YouTuber is Now Selling ThermoHealth Temperature Screening on Jul 29, 2020
An enterprising 20-year old is mass marketing medical devices on Facebook and...