Getting Creative With Database Partitioning

Security directors have discovered that partitioning databases provides value to any security management system. It can become a profit center, provide independence and convenience while reducing the need for security guards.

To the average commercial real estate owner, using the database partitioning feature in a security management system provides two main benefits. First, it’s a profit center for the owner. The real estate owner installs one security system for the entire building, say a 30-floor commercial high rise. The owner charges his tenants a fee for the service, and the database is partitioned so each tenant can manage their own security and database of card holders. The tenant can run their own reports and operate autonomously from the other tenants.

Second, the owner provides a value added benefit to tenants. Tenants rent office space knowing they have a built in security system. The tenant is pleased they don’t have to source and budget for their own security system, and it may give the owner a competitive advantage in the commercial real estate market.

Some integrators have a central station operation in their building. Some security directors have found that when they allow their integrator to manage their security, it saves them time, money and headaches.

For example, a security system end user in a small office building installs access and security hardware, but the access control and intrusion software is kept at the central station. A central station officer monitors the building’s security and enters card holder information for new employees or dispatches police in the event of a serious alarm. The security director pays a fee for this service, and saves money by not budgeting for additional security staff or costly software upgrades.

Universities also benefit from database partitioning. One Big Ten university security director purchased a security management system and partitioned the database by individual college. Each college, such as the College of Nursing, was responsible for its own database management. Students received their security credentials from one central location at the start of the school year, and then each college managed the students and staff associated with it. Security officials assigned access levels for each card holder depending on their status within the security system, for example student, graduate student, professor, office staff, janitor, etc.

The campus security department may then manage all public areas or non-college areas on campus such as the student union, library, residence halls and administration buildings.

Separating it out by college made management easier. Independence was achieved by each college, and the responsibility of securing a Big Ten university was allocated over many people.

Security directors are finding creative ways to use database partitioning with minimal budgets and manpower, as well as finding ways to give ownership to tenants. The options are endless.

About the Author

Kim Rahfaldt is Director of Media Relations at AMAG Technology, Inc., based in Torrance, Calif.

Featured

  • Cost: Reactive vs. Proactive Security

    Security breaches often happen despite the availability of tools to prevent them. To combat this problem, the industry is shifting from reactive correction to proactive protection. This article will examine why so many security leaders have realized they must “lead before the breach” – not after. Read Now

  • Achieving Clear Audio

    In today’s ever-changing world of security and risk management, effective communication via an intercom and door entry communication system is a critical communication tool to keep a facility’s staff, visitors and vendors safe. Read Now

  • Beyond Apps: Access Control for Today’s Residents

    The modern resident lives in an app-saturated world. From banking to grocery delivery, fitness tracking to ridesharing, nearly every service demands another download. But when it comes to accessing the place you live, most people do not want to clutter their phone with yet another app, especially if its only purpose is to open a door. Read Now

  • Survey: 48 Percent of Worshippers Feel Less Safe Attending In-Person Services

    Almost half (48%) of those who attend religious services say they feel less safe attending in-person due to rising acts of violence at places of worship. In fact, 39% report these safety concerns have led them to change how often they attend in-person services, according to new research from Verkada conducted online by The Harris Poll among 1,123 U.S. adults who attend a religious service or event at least once a month. Read Now

  • AI Used as Part of Sophisticated Espionage Campaign

    A cybersecurity inflection point has been reached in which AI models has become genuinely useful in cybersecurity operation. But to no surprise, they can used for both good works and ill will. Systemic evaluations show cyber capabilities double in six months, and they have been tracking real-world cyberattacks showing how malicious actors were using AI capabilities. These capabilities were predicted and are expected to evolve, but what stood out for researchers was how quickly they have done so, at scale. Read Now

Most   Popular

New Products

  • QCS7230 System-on-Chip (SoC)

    QCS7230 System-on-Chip (SoC)

    The latest Qualcomm® Vision Intelligence Platform offers next-generation smart camera IoT solutions to improve safety and security across enterprises, cities and spaces. The Vision Intelligence Platform was expanded in March 2022 with the introduction of the QCS7230 System-on-Chip (SoC), which delivers superior artificial intelligence (AI) inferencing at the edge.

  • FEP GameChanger

    FEP GameChanger

    Paige Datacom Solutions Introduces Important and Innovative Cabling Products GameChanger Cable, a proven and patented solution that significantly exceeds the reach of traditional category cable will now have a FEP/FEP construction.

  • HD2055 Modular Barricade

    Delta Scientific’s electric HD2055 modular shallow foundation barricade is tested to ASTM M50/P1 with negative penetration from the vehicle upon impact. With a shallow foundation of only 24 inches, the HD2055 can be installed without worrying about buried power lines and other below grade obstructions. The modular make-up of the barrier also allows you to cover wider roadways by adding additional modules to the system. The HD2055 boasts an Emergency Fast Operation of 1.5 seconds giving the guard ample time to deploy under a high threat situation.