Database Activity Monitoring

What Does Database Activity Monitoring Mean?

Database activity monitoring (DAM) is the process of observing, identifying and reporting a database’s activities. Database activity monitoring tools use real-time security technology to monitor and analyze configured activities independently and without relying on the DBMS auditing or logs.

Advertisements

These tools also help in detecting unusual and unauthorized, internal or external activities while still gauging the effectiveness of security tools and policies in place. In so doing, system administrators are able to improve the prevention and protection of sensitive data from intruders.

Techopedia Explains Database Activity Monitoring

Database activity monitoring tools are implemented as standalone configurations or as software modules loaded on the database servers. Either way, they provide real-time monitoring and data security by capturing, keeping logs, analyzing and alerting on policy violations without interfering with the systems’ performance.

Database activity monitoring is done by combining several techniques such as network sniffing, memory scraping and reading system tables and database audit logs. Regardless of the methods used, DAM tools enable data correlation so as to provide an accurate picture of all the activities in the database.

These tools also allow relevant authorities to detect, identify and take corrective measures against threats and attacks, and provide forensic evidence when a data breach occurs. Depending on the configuration of the DAM tools, an administrator or auditor may be able to reconstruct data or restore it to a previous state.

Database activity monitoring tools capture and record all SQL activities in near real time. There are several tools available, with varying levels of activity monitoring. However, the five main features that distinguish DAM tools are their ability to:

  • Monitor and audit all database activity independently including SELECT transactions and privileged users’ activities, without performance degradation
  • Securely store the database activity outside the monitored database
  • Generate alerts whenever policy violations are detected
  • Aggregate and correlate database activities from multiple heterogeneous database management systems
  • Enforce separation of duties of database administrators, monitor the administrators’ activities and prevent the manipulation or tampering of recorded activities or logs

Database activity monitoring tools also enable operations monitoring, data protection and compliance control. They provide an insight on how data is viewed and by whom, including the administrator and across multiple platforms.

Advertisements

Related Terms

Margaret Rouse

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical, business audience. Over the past twenty years her explanations have appeared on TechTarget websites and she's been cited as an authority in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine and Discovery Magazine.Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages. If you have a suggestion for a new definition or how to improve a technical explanation, please email Margaret or contact her…