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

Favorite Biometrics 2018 on Apr 23, 2018
Biometrics are on the rise, or at least integrator opposition to them is declining, according to new IPVM integrator statistics.   Almost half of...
Dedicated Vs Converged Access Control Networks (Statistics) on Apr 20, 2018
Running one's access control system on a converged network, with one's computers and phones, can save money. On the other hand, hand, doing so can...
Worst Access Control 2018 on Apr 18, 2018
Three access control providers stood out as providing the most problems for integrators. In this report, we analyze the answers to: "In the...
Key Control For Access Control Tutorial on Apr 16, 2018
End users spend thousands on advanced systems to keep themselves secure, but regularly neglect one of the lest expensive yet most important aspects...
Alarm.com Business Market Expansion on Apr 13, 2018
Alarm.com has millions of subscribers, but the company has traditionally been mostly a residential/home focused offering.  ADC's new Smart Business...
Average Access Control Project Size 2018 on Apr 10, 2018
  The most common access control project size is 5 - 16 doors per project. This 2018 result mirrors previous statistics, most recently in 2016...
ISC West 2018 Access Control Rundown on Apr 06, 2018
For ISC West 2018, what is new and interesting in access control?  This rundown will bring you up to speed on the exhibitors, what they are...
VMS New Developments Spring 2018 (Avigilon, Exacqvision, Genetec, Hikvision, Milestone, Network Optix) on Apr 04, 2018
What's new with VMS software? In this report, we examine new features and releases for Spring 2018 to track different areas of potential...
Forced Door Alarms For Access Control Tutorial on Apr 04, 2018
One of the most important access control alarms is also often ignored. "Forced Door" provides a vital and even critical notification against...
The 5 Major Lock Profiles Guide - Euro, Oval, KIK, Interchangeable Core, Mortise on Apr 03, 2018
Locks are used everywhere, but they are not all the same. In fact, even the shape of the lock changes, sometimes for no other reason than...

Most Recent Industry Reports

The Yolo Bro And The Death of Journalism on Apr 24, 2018
There's an old quote: The job of the newspaper is to comfort the afflicted and afflict the comfortable Unfortunately, the opposite is more...
DMP Adds Ring Video Doorbell Integration on Apr 24, 2018
Video doorbells have become one of the hottest items for security systems. After several years with no doorbell, DMP has announced integration with...
Milestone 2017 Financials Examined on Apr 24, 2018
For ISC West 2018, Milestone released ... their financials, touting "strong revenue growth in 2017". However, there were discrepancies with the...
Chinese Manufacturer Kickstarter Campaign Huge Success (EverCam) on Apr 23, 2018
In a week, a Chinese manufacturer's expertly done Kickstarter campaign has received $1.4 million in pledges, an incredible amount for a video...
Favorite Biometrics 2018 on Apr 23, 2018
Biometrics are on the rise, or at least integrator opposition to them is declining, according to new IPVM integrator statistics.   Almost half of...
Dahua and Hikvision Win Over $1 Billion In Government-Backed Projects In Xinjiang on Apr 23, 2018
Dahua and Hikvision have won well over $1 billion worth of government-backed surveillance projects in China’s restive Xinjiang province since 2016,...
May 2018 Camera Course on Apr 20, 2018
Save $50 on early registration until this Thursday, the 26th. Register now (save $50) for the Spring 2018 Camera Course This is the only...
Global Real-Time Video Surveillance - EarthNow on Apr 20, 2018
A new company, EarthNow, with backing from Bill Gates, Airbus and more, is claiming that: Users will be able to see places on Earth with a delay...
Dedicated Vs Converged Access Control Networks (Statistics) on Apr 20, 2018
Running one's access control system on a converged network, with one's computers and phones, can save money. On the other hand, hand, doing so can...
April 2018 IP Networking Course on Apr 19, 2018
This is the last chance to register for our IP Networking course. Register now. NEW - 2 sessions per class, 'day' and 'night' to give you double...

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