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

Hackable 125kHz Access Control Migration Guide on May 19, 2017
Despite being one of the most popular credentials, 125 kHz credentials are easily copied and insecure as we showed in our test results, video...
Smartphone Controlled Kevo Lock Tested on May 04, 2017
Smartlocks are a growing market, with millions sold. Kwikset's Kevo is one of the most common choices, using the Unikey smart phone access control...
Hack Your Access Control With This $30 HID 125kHz Card Copier on May 01, 2017
You might have heard the stories or seen the YouTube videos of random people hacking electronic access control systems. The tools that claim to do...
IPVM First Dean's List W2017 - Thomas Atkinson, Matt Hurly and Fredrik Lundqvist on Apr 24, 2017
IPVM is happy to congratulate and celebrate our first "Dean's List", the top students in our courses. For the Winter 2017 IP Networking course...
Lenel President Is Out on Apr 20, 2017
Lenel's challenges continue. Now, Lenel's President is out, suddenly. This follows increasing challenges for the company who has broadly upset...
Access Control Course Spring 2017 on Apr 14, 2017
IPVM offers the most comprehensive access control course in the industry. Unlike manufacturer training that focuses only on a small part of the...
Bosch B-Series Intrusion Tested on Apr 10, 2017
Bosch is one of the biggest names in intrusion but their B-Series panels, targeted at smaller site installs and available through distribution, are...
Milestone / Lenel Resell Partnership on Apr 03, 2017
Lenel has never found success in video management. Nearly a decade ago Lenel OEMed an OEM of Milestone. Now, in an equally uncommon move,...
ConvergenceTP (CTP) Claims VMS Integrations Simplified on Mar 30, 2017
Developing integrations with 3rd party systems can be expensive and time consuming, especially in the physical security market with hundreds of...
2Gig Intrusion Megatest (GC2 & GC3 Panels Tested) on Mar 28, 2017
2Gig is one of the most widely used intrusion systems, with two product lines that are the main offering of many alarm companies, huge national...

Most Recent Industry Reports

Axis Criticizes OEMs: "When You Buy An Axis Camera, An Axis Camera Is What You Get!" on May 19, 2017
When you buy a Honeywell camera, you likely get a Hikvision, Dahua or some other company's product. The same goes for easily 100 different...
Hackable 125kHz Access Control Migration Guide on May 19, 2017
Despite being one of the most popular credentials, 125 kHz credentials are easily copied and insecure as we showed in our test results, video...
Forget The Backdoor, "ALL HIKVISION PRODUCTS" On Sale on May 18, 2017
Less than 2 weeks after the Hikvision Backdoor was confirmed, Hikvision has launched a sale "ON ALL HIKVISION PRODUCTS". In this note, we examine...
Amazon Techs Installing IP Cameras Tested on May 18, 2017
In 2015, Amazon started offering video surveillance installation. Now, Amazon has made it a lot easier, with automatic add-on options and...
Hanwha Recorder Vulnerability Analyzed on May 18, 2017
ICS-CERT has released a vulnerability notice for Hanwha SRN-4000 recorders.  Hanwha provided additional information to IPVM about this issue,...
ShotSpotter To IPO, Facing Low Revenue and Losses on May 17, 2017
A rare event for North American security manufacturers is upcoming. ShotSpotter is planning to IPO on the NASDAQ, aiming to raise $34.5...
DMP Video Doorbell / Access Reader Examined on May 17, 2017
Consumers increasingly demand video doorbells, with "doorbells selling like hotcakes, everyone wants a doorbell", according to ADT's CEO. At ISC...
FLIR Is Giving Away $3,000 Demo Kits on May 17, 2017
Everybody likes free stuff, and FLIR is using that concept to attract dealers by giving them $3,000 worth of demo gear for attending a...
Shark Tank Startup Guard Llama Mobile Panic Tested on May 16, 2017
A Shark Tank TV show appearance has attracted big attention for Guard Llama, a security startup touting a 'panic button' paired with mobile app...
Axis Beats Avigilon Growth Rate (AVO Q1 2017) on May 16, 2017
In what is likely the first time ever, Axis beat Avigilon's revenue growth for Q1 2017. Inside this note, we examine Avigilon's Q1 2017 financial...

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