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

ACRE-Acquired Open Options Access Company Profile on Dec 17, 2018
Who is the company ACRE is acquiring? In this note, we examine Open Options line for best customer fit, key features, pricing, and main...
Open Options Acquired By ACRE on Dec 17, 2018
ACRE is doing deals again. A year after they sold Mercury, they are buying another access control company - Open Options. In this note, we...
2019 Access Control Book Released on Dec 12, 2018
This is the best, most comprehensive access control book in the world, based on our unprecedented research and testing has been significantly...
Multi-Factor Access Control Authentication Guide on Dec 10, 2018
Can a stranger use your credentials? One of the oldest problems facing access control is making credentials as easy to use as keys, but restricting...
Top 2019 Trend - AI Video Analytics on Dec 10, 2018
160+ Integrators answered: What do you think the top industry trend will be in 2019? Why? AI / video analytics was the run-away winner with...
Cybersecurity Insurance For Security Integrators on Nov 29, 2018
Most security industry professionals carry insurance to cover themselves in the event of a general loss. However, most are not carrying cyber...
Startup Qumulex Aims For Unified Platform, Adds Infinias Access Founder on Nov 29, 2018
The startup founded by former Exacq executives, Qumulex has hired Wayne Jared, founder of access control manufacturer Infinias and most recently a...
HID Product Configurator Examined on Nov 26, 2018
HID is widely used. However, figuring out all the different configurations of features for a final credential or reader part number can be a real...
Openpath Access Control Tested on Nov 20, 2018
Big investment in access startups is uncommon, but Openpath has recently attracted $20 million doing just that. The company has limited security...
Arcules Cloud VMS Tested on Nov 19, 2018
Arcules is a big bet, or as they describe themselves a 'bold company', spun out and backed by Milestone and Canon.  But how good is Arcules cloud...

Most Recent Industry Reports

Dahua USA Sales Team Cuts - 'Strategic Right Sizing' on Dec 18, 2018
Dahua USA finishes a tumultuous year in which it acquired the Flir SMB business, was subject to the US government ban, terminated and restructured...
This Brooklyn Storefont Sells Millions In Uniview And Hikvision on Dec 18, 2018
Looking at their Brooklyn headquarters for this "CCTV Manufacturer", it is not much: Inside, it is not better: However, this company is one...
ACRE-Acquired Open Options Access Company Profile on Dec 17, 2018
Who is the company ACRE is acquiring? In this note, we examine Open Options line for best customer fit, key features, pricing, and main...
Open Options Acquired By ACRE on Dec 17, 2018
ACRE is doing deals again. A year after they sold Mercury, they are buying another access control company - Open Options. In this note, we...
8MP / 4K Fixed Lens Camera Shootout - Dahua, Hikvision, TVT, Uniview on Dec 17, 2018
8MP / 4K fixed lens models are now common in lower cost lines, with nearly every Chinese brand and their OEMs now offering multiple options. To...
Network Cable Shootout - Belden, Commscope, Hikvision, Honeywell, NavePoint CCA, Windy City Wire on Dec 17, 2018
Every IP camera install needs UTP cabling. But how much of a difference is there between dirt cheap generic cables found online and the bigger,...
Hikvision Government Parent Holds Communist Party Congress on Dec 17, 2018
The Communist Party committee of Hikvision’s government parent, CETHIK, held a Party Congress earlier this month where senior executives, including...
Imperial Capital Security Investor Conference 2018 Review - ADT, Resideo, Alarm.com, Arlo, Eagle Eye, ACRE, More on Dec 14, 2018
Imperial Capital Security Investor Conference is an event matching industry executives with financiers that frequently leads to future funding...
Cisco Meraki New Cameras and AI Analytics on Dec 14, 2018
Meraki has released their second generation of video surveillance with 3 new cameras, AI-based video analytics, and 2 cloud-based storage...
Foolish Strategy: OEMing Facial Recognition on Dec 13, 2018
Almost as 'hot' as face recognition marketing right now is OEMing facial recognition. Last year, they were a who's who of company's with...

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