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

  • Automatic Systems V07

    Automatic Systems V07

    Automatic Systems, an industry-leading manufacturer of pedestrian and vehicle secure entrance control access systems, is pleased to announce the release of its groundbreaking V07 software. The V07 software update is designed specifically to address cybersecurity concerns and will ensure the integrity and confidentiality of Automatic Systems applications. With the new V07 software, updates will be delivered by means of an encrypted file.

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

  • AC Nio

    AC Nio

    Aiphone, a leading international manufacturer of intercom, access control, and emergency communication products, has introduced the AC Nio, its access control management software, an important addition to its new line of access control solutions.