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?

**** ****** ******* ******* *** ********* ** ** ***** *** versions:

  • *****: ** ****** ***** * **** ** *********** ******** ****** (SQL ****** *******, ********* ******, ** ***)
  • ******: ** ******* (******* ******* ** '**********' ** "*****-****') **** integrates **** * ****-******** ******** ** ***.

******* ******* ******** *** **** ** ********* ** *******, *** understanding ***** **** ** **** ** **** **** **** * question ** ****. ** *** ******* *****, ** ****** *** key ************** **** **** ** *******

  • ****** ** ***********:*** ******* ******* ***** **** ** ***** ***** ** *** number ** *********** **** *** *******. ***** **** ********* *** not ** * ********** *** ***** ** ****** ***** *******, it *** *** ** ********** *** *****-**** *********** *******.
  • *********** **** ***** *******:******* *** **** ****** *********** ***** ****** ***** ****** ** an ************, *** **** ** ******** ** ***** ************. * variety ** ***** ********* ** ******* ********* *** **** ** integrate **** *** ********, *** *** ******** ******** *** ** proprietary *** *** ***** *** ******* ***********.
  • ************:** ***** *****, * ********** ******* *** ******* ********** ******** servers ** ******** *** ***. *** **** ********* ******* ********* can ** ********* *** ********** ** * ****** ***********, *** a **** ******* ** *** ** **** ****** ********* ** a *****-***** *******. ** ********, *** *********** *** ************* ****** of **** ******* ********* ***** ** ******** ********* **** ***-**** offerings.
  • ********** ********: **** ********* ******* ** *** ***** ******* ******** ******** like ****** *********, ******** **********, ****** *******, ** ********** ******** utilities.

******** ***** ****** ** **** **** ******** * **** **** at ********* *********** ****** *** ****** ******* ******. **** **** the **** *** **** ******** ******** ******** ******** ******** *******, the ***-**** **** ********** ********** ***** **** ****** ** **** the ****** ***********.

Using **** ***

*** ******* '****** ****' ** **** ****** ******* ***** **** requiring * **** *** ******** *******,********** ** ******** ******* ** ******. ** ***, ****** ** ********** $**** ** $**** **** before *********** *** **** ** ***** ** ************ *** ******** it.

*********, ****** * **** ******* ******* ** ** ***** ********* a ****** *************, *** ******** ** *** ******** *** *** be *********. *** ****** ******** ** ********** **** ****** *** maintain *** ******** *** ****** ****** *****. ************* * **** version ** * *** ******** ****** *** *** *** ** the ****** ******* ****** ** *** ******, *** *** ********** labor ***** ** ***** *** *** ******* **** **** ** thousands ** ******* *** ****.

Free *******

*** '*******' ******* *** ***** ***** ********** ******** *******, *** *******,********* ******,***, ** ****** *********** *********. ***** ******** ******** *** ******* and **** ********* ** *********** ** ********** ***************, ***** ********* are ********* **** *** '******' **** ** ****.

Basic ********* ****

*** ** *** ******* **** ******* *** *** ******* ***** in *** *********** ** ********** ****** *******. **** * **** or *********** ******** ** ****, *** ********* ** ******* *********** the **** ** ******* ** * ***** *****. **** **** SQL ** ****, * ****** ******* ******* *********** ************ ********* ******** ****** ********** ** ********* ** ******* ***-******** *******.

Practical ********

*** ******** ***** ** *** ******** *** **** ** *** extra ****** *** ******** ********* *** **** ******** ** *** if ******:

  • ***: *** ******** ** ******** *** *********, *** ******-***** ****** or ****** *** *******. ******* ******* ******* *** *** ******* by ~$**** ***.
  • *****: ******* *** ** ********** ****** ** * ********** "*** Express" *******, ** ** **** ** * "*** ********" *******. While ******* ** *** **** *** *** **** ********, *** upgrade ******* **** ******* ** ******** ** ******** ***  **** require ** *********** ******** ************* ** ************ *********.
  • *******: ****** *** ****** *** ******* , * **** *** Express ******* *** ** ******* ** ******** ***. *** **** between *** *** ******* ** ~$****, **** *** *** ******* offering ***** *** **** ****** ******** ** *** **** *******.
Login to read this IPVM report.
Why do I need to log in?
IPVM conducts unique testing and research funded by member's payments enabling us to offer the most independent, accurate and in-depth information.

Related Reports on Access Control

Vulnerability Directory For Access Control Cards on Aug 14, 2017
Knowing which access credentials are insecure can be unclear, especially because most look and feel the same. Even the most insecure 125 kHz types...
Competing Against G4S on Aug 09, 2017
G4S Secure Solutions is a global company, operating in multiple countries and offering a suite of products and services from guards to their AMAG...
ONVIF Releases Profile A for Access on Aug 08, 2017
ONVIF has struggled so far in access control. In 2014, ONVIF released Profile C for access control, but in the 3 years since, only 2 companies...
Access Control Commissioning / Install Checklist on Aug 03, 2017
This 80+ point checklist helps end users, integrators and consultants verify that access control installation is complete. It covers the following...
Bosch G-Series Intrusion Tested on Jul 26, 2017
Bosch is one of the biggest names in intrusion, and the company's G-Series panels are their most advanced commercial and high-security panels. But...
Smartcard Copier Tested (13.56MHz) on Jul 05, 2017
Copying 125kHz cards is certainly easy, as our test results showed, but how about 13.56MHz smart cards? Are they more secure? IPVM focused on the...
Biometrics Pros and Cons For Electronic Access Control on Jun 26, 2017
Biometrics has been long sought as an alternative to the security risks of cards, pins and passwords. While biometrics has improved somewhat over...
Access Control Course Winter 2018 on Jun 11, 2017
The Winter 2018 IPVM Access Control Course is now open; save $50 on early registration. IPVM offers the most comprehensive access control course...
RMR Integrator Importance Statistics on Jun 08, 2017
How do integrators feel about offering RMR / recurring revenue services? For many, their business revolves around RMR, while others see no...
HID Edge EVO Tested on Jun 07, 2017
HID Edge controllers have been one of most common offerings in IP door controllers for years. The new generation is called Edge EVO. We tested...

Most Recent Industry Reports

Final Day Save $50 - IP Networking Course September 2017 on Aug 17, 2017
Today, Thursday, August 17th is the last day to save $50 on the September IP Networking Course. This is the only networking course designed...
Knightscope Raises $10 Million With $3,320 Average Per Investor on Aug 17, 2017
Congrats to Knightscope. And condolences to their legion of little investors. Knightscope has disclosed they have raised $10+ million from their...
Axis and Arecont Legal Conflict Over Multi-Imager Cameras on Aug 17, 2017
Arecont threatened Axis. Axis has responded by moving to invalidate an Arecont patent. It is an important contest. Multi-imagers are Arecont's...
Directory Of Consumer Security Cameras on Aug 16, 2017
The consumer camera segment continues to grow, with new startups and models from existing players released seemingly every month. In this report we...
Cat 5e vs Cat 6 vs Cat 6a Network Cable Usage Statistics on Aug 16, 2017
Cat 5e? Cat 6? Cat 6a? What do integrators use in practice, today? 140+ integrators told IPVM. Here are the results: For those who want to...
Hikvision Responds To Cracked Security Codes on Aug 15, 2017
Hikvision has responded to IPVM's report on Hikvision's security code being cracked, both with a 2 page update to dealers and communication...
Stolen Video NVR / DVR Statistics on Aug 15, 2017
"But what happens if someone steals my recorder?" Anyone who has done more than a handful of jobs has probably heard this question several times....
Hikvision Europe Cutting Out Unauthorized End User Sales on Aug 15, 2017
The days of anyone buying Hikvision from anywhere off the Internet are numbered, at least in Europe, if Hikvision's plan comes to fruition. In...
Axis Laser Focus PTZ Tested on Aug 14, 2017
Axis has been touting its new Q6155-E laser focus PTZ as 'always in focus' and 'always in color'. Does it really deliver? We bought and tested...
Vulnerability Directory For Access Control Cards on Aug 14, 2017
Knowing which access credentials are insecure can be unclear, especially because most look and feel the same. Even the most insecure 125 kHz types...

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