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

  • From Surveillance to Intelligence

    Years ago, it would have been significantly more expensive to run an analytic like that — requiring a custom-built solution with burdensome infrastructure demands — but modern edge devices have made it accessible to everyone. It also saves time, which is a critical factor if a missing child is involved. Video compression technology has played a critical role as well. Over the years, significant advancements have been made in video coding standards — including H.263, MPEG formats, and H.264—alongside compression optimization technologies developed by IP video manufacturers to improve efficiency without sacrificing quality. The open-source AV1 codec developed by the Alliance for Open Media—a consortium including Google, Netflix, Microsoft, Amazon and others — is already the preferred decoder for cloud-based applications, and is quickly becoming the standard for video compression of all types. Read Now

  • 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

Most   Popular

New Products

  • EasyGate SPT and SPD

    EasyGate SPT SPD

    Security solutions do not have to be ordinary, let alone unattractive. Having renewed their best-selling speed gates, Cominfo has once again demonstrated their Art of Security philosophy in practice — and confirmed their position as an industry-leading manufacturers of premium speed gates and turnstiles.

  • 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.

  • Camden CM-221 Series Switches

    Camden CM-221 Series Switches

    Camden Door Controls is pleased to announce that, in response to soaring customer demand, it has expanded its range of ValueWave™ no-touch switches to include a narrow (slimline) version with manual override. This override button is designed to provide additional assurance that the request to exit switch will open a door, even if the no-touch sensor fails to operate. This new slimline switch also features a heavy gauge stainless steel faceplate, a red/green illuminated light ring, and is IP65 rated, making it ideal for indoor or outdoor use as part of an automatic door or access control system. ValueWave™ no-touch switches are designed for easy installation and trouble-free service in high traffic applications. In addition to this narrow version, the CM-221 & CM-222 Series switches are available in a range of other models with single and double gang heavy-gauge stainless steel faceplates and include illuminated light rings.