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

Biggest Problems Selling Access Control 2020 on Oct 29, 2020
Access control can cause integrators big headaches. What practical issues do...
Door Fundamentals For Access Control Guide on Aug 24, 2020
Doors vary greatly in how difficult and costly it is to add electronic access...
Free Online NFPA, IBC, and ADA Codes and Standards 2020 on Sep 03, 2020
Finding applicable codes for security work can be a costly task, with printed...
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...
HID Releases Lower-Cost Signo Readers on Mar 06, 2020
HID Global is releasing a new line of readers called Signo they claim read...
Mobotix Thermal Detection Camera Tested on Jun 09, 2020
For years Mobotix has struggled but now sales are surging driven by Mobotix's...
Mobile Access Control Usage Statistics 2020 on Sep 21, 2020
Most smartphones can be used as access control credentials, but how...
Infinova, March Networks and Swann H1 2020 Financials Examined on Sep 02, 2020
While Dahua and Hikvision, helped by fever camera sales, are recovering from...
Access Control and Video Integration Statistics 2020 on Oct 08, 2020
Video Surveillance and Access Control are two of the most common security...
Dedicated Vs Converged IP Video Networks Statistics 2020 on Sep 10, 2020
Running one's video system on a converged network with other devices can save...
Favorite Access Control Credentials 2020 on Sep 15, 2020
Credential choice is more debated than ever, with hacking risk for 125kHz and...
End User Buying Axis At Prices Better Than Axis Gold on Jan 10, 2020
IPVM recently found an integrator contract with an end-user that guaranteed...
AHJ / Authority Having Jurisdiction Tutorial on Aug 06, 2020
One of the most powerful yet often underappreciated characters in all...
Avigilon Aggressive Trade-In Program Takes Aim At Competitors on Oct 20, 2020
Avigilon has launched one of the most aggressive trade-in programs the video...
Verkada 2020 Cameras Image Quality Test on Oct 06, 2020
Verkada's first-generation cameras suffered from numerous video quality...

Recent Reports

Motorola Solutions Total Revenue Down, Video Revenue Up on Oct 30, 2020
Motorola Solutions' total revenue is down, but video (both fixed and...
Recruiters Show 2020 On-Demand Recordings on Oct 30, 2020
Recordings from the 12 recruiter presentations are now available...
Consultants Show 2020 On-Demand Recording on Oct 29, 2020
Recordings from the consultant show are available on-demand at the end of...
Hikvision AcuSense G2 Camera Test on Oct 29, 2020
Hikvision has released their next generation of AcuSense analytic cameras...
Biggest Problems Selling Access Control 2020 on Oct 29, 2020
Access control can cause integrators big headaches. What practical issues do...
Taiwan Geovision AI Analytics and NDAA Examined on Oct 29, 2020
Taiwan manufacturer Geovision's revenue has been falling for years. However,...
Bedside Cough and Sneeze Detector (Sound Intelligence and CLB) on Oct 28, 2020
Coronavirus has increased interest in detecting symptoms such as fever and...
Fever Tablet Thermal Sensors Examined (Melexis) on Oct 28, 2020
Fever tablet suppliers heavily rely on the accuracy and specs of...
Verkada Fires 3 on Oct 28, 2020
Verkada has fired three employees over an incident where female colleagues...
Eagle Eye Networks Raises $40 Million on Oct 27, 2020
Eagle Eye has raised $40 million aiming to "reinvent video...
Hikvision Q3 2020 Global Revenue Rises, US Revenue Falls on Oct 27, 2020
While Hikvision's global revenue rises driven by domestic recovery, its US...
VICE Investigates Verkada's Harassing "RawVerkadawgz" on Oct 26, 2020
This month, IPVM investigated Verkada's sexism, discrimination, and cultural...
Six Flags' FDA Violating Outdoor Dahua Fever Cameras on Oct 26, 2020
As Six Flags scrambled to reopen parks amid plummeting revenues caused by the...
ISC Brasil Digital Experience 2020 Report on Oct 23, 2020
ISC Brasil 2020 rebranded itself to ISC Digital Experience and, like its...
Top Video Surveillance Service Call Problems 2020 on Oct 23, 2020
3 primary and 4 secondary issues stood out as causing the most problems when...