We use cookies and other similar technologies (Cookies) to enhance your experience and to provide you with relevant content and ads. By using our website, you are agreeing to the use of Cookies. You can change your settings at any time. Cookie Policy.

In today’s world, most employees wear id badges that are scanned as they enter and leave any building. Security guards are present as an added measure. These safeguards have been put in place to insure the safety of the employees and protect the firm’s physical assets. Data is one of the firm’s most valuable assets as it contains critical customer information and the intellectual capital of the firm. This data must be monitored, controlled and safeguarded for the firm to thrive and grow.



As companies, continue to focus on cost controls and the plethora of legislative acts such as Sarbanes-Oxley, Gramm-Leach-Bliley, HIPAA and Privacy Act, data usage monitoring is essential. Another area driving the need for data monitoring is the increase in dynamic SQL access to databases. This type of dynamic access has led to spikes in database activity, missed service level agreements (SLA) which has resulted in poor application performance and unhappy clients. These and many other reasons have moved data usage monitoring to the top of many IT company’s priority list.

Data usage monitoring has typically been in the DBA domain as they have used it for performance and tuning purposes but now individuals across all levels of the organization require access to this data. This article describes data usage monitoring, its collection techniques and the third party products that use these techniques as well as how the usage data can be leveraged to provide value to the firm deploying it.

What is Data usage monitoring?

Data usage monitoring is the process of transparently acquiring and analyzing database usage activity. It does not analyze the underlying data values, which is data quality monitoring, but how the clients are using the tables and columns that comprise the database. Data usage monitoring will be able to answer the how, what, where and when questions about data usage patterns. It can not on its own answer the “why” question but it can provide important insights by analyzing client access patterns.

What information is collected?

A data usage monitoring tool will capture Data Manipulation Language (DML) commands executed in the database such as select, update, delete and insert and Data Definition Language (DDL) commands such as create/drop/grant statements as well as external programs and stored procedures executed against a database or a data warehouse. For example, the statements below would be captured by a data usage monitoring tool.

-1-

1  2  3  4  5  

   Next Page

Explore Our Topics

  • EDITOR'S BRIEFING
  • Virtual Conferences
  • Webinars
  • Roundtables

BPM in Action

March 10, 2011

The sixth annual BPM in Action 2011 Virtual Conference will explore cutting-edge market developments in BPM and describe how to leverage them for improved business operation and performance. More

View All Virtual Conferences

Smart Case Management: Why It's So Smart.

Date:Nov 05, 2009
Time:12:00 PM ET- (17:00 GMT)

REGISTER TODAY!

Date:Oct 29, 2009
Time:15:00 PM ET- (19:00 GMT)

REGISTER TODAY!
View All Roundtables
  • Research Library
  • Podcasts
  • News

Joe McKendrick: Part II of II: Designing Evolve-ability into SOA and IT Systems

In part two of Joe McKendrick's recent podcast with Miko Matsumura, chief strategist for Software AG, they talk about how SOA and IT systems need to change and grow and adapt with the organization around it.

Listen Now

Phil Wainewright: Helping Brands Engage with Social Media

Phil Wainewright interviews David Vap, VP of products at RightNow Technologies, and finds out how sharing best practices can help businesses understand how best to engage with online communities.

Listen Now

Peter Schooff: Making Every IT Dollar Result in a Desired Business Outcome: Scott Hebner of IBM Rati

Scott Hebner, Vice President of Marketing and Strategy for IBM Rational, discusses a topic on the top of every company's mind today: getting the most from IT investments.

Listen Now

Jessica Ann Mola: Where Will BI Fit In? Lyndsay Wise Explains

In BI, this tough economy and the increasing role of Web 2.0 and MDM are certainly topics on people's minds today. WiseAnalytics' Lyndsay Wise addresses each of them in this informative podcast.

Listen Now

Dennis Byron: Talking with...Deepak Singh of BPM Provider Adeptia

Deepak Singh, President and CTO of Adeptia, joins ebizQ's Dennis Byron in a podcast that gets its hand around the trend of industry-specific BPM.

Listen Now
More Podcasts
  • Most Popular
  • Quick Guide
  • Most Discussed

Quick Guide: What is BPM?

Learn More

Quick Guide: What is Event Processing?

Smart event processing can help your company run smarter and faster. This comprehensive guide helps you research the basics of complex event processing (CEP) and learn how to get started on the right foot with your CEP project using EDA, RFID, SOA, SCADA and other relevant technologies. Learn More

Quick Guide: What is Enterprise 2.0?

A lot of people are talking about Enterprise 2.0 as being the business application of Web 2.0 technology. However, there's still some debate on exactly what this technology entails, how it applies to today's business models, and which components bring true value. Some use the term Enterprise 2.0 exclusively to describe the use of social networking technologies in the enterprise, while others use it to describe a web economy platform, or the technological framework behind such a platform. Still others say that Enterprise 2.0 is all of these things. Learn More