Skip to content

DBAzine.com

Sections
Personal tools
You are here: Home » Blogs » Craig Mullins Blog » Craig Mullins: Perspectives on Database Management » Challenges to Managing Metadata
DBAzine Updates
The best way for me to find out about site updates is:
RSS feeds
Browsing the site
Receiving email updates

[ Results | Polls ]
Votes : 120
 

Challenges to Managing Metadata Challenges to Managing Metadata

In this posting, as we continue to investigate the rebirth of metadata management, we examine some of the challenges of successful metadata management.
In recent postings we have looked at a possible resurgence in metadata management and we've also ruminated on the ways in which modeling can enhance metadata management. Let's take a little deeper look at metadata, this time investigating some of the challenges that complicate being successful with metadata.

Consider the following questions: How do you ensure that you are exploiting the metadata you are collecting to the fullest, possible extent? How do you make sure that your metadata is easily accessible and effectively used across your organization? How do you ensure that it is kept up-to-date so that new metadata about new data is incorporated? A few areas of focus help to meet the challenges of managing metadata, and address these questions.

Disparate information sources

The first challenge to leveraging your information is the wide variety of sources that make up the corporate data landscape. There is no escaping the fact that a significant portion of every organization’s vital data resides outside of its databases. In order to use metadata effectively, data managers must create a consistent and easy-to-understand format across everything from sophisticated, high-level ETL and BI repositories, down to rudimentary flat files.

Enforcing business rules for metadata

Creating a context of enforceable business rules around the metadata is an important aspect of maintaining data integrity and usability. While most repositories do an excellent job of collecting the metadata, they only provide a two-dimensional view; that is, they can help you understand the data lineage and attributes, but they do not help you understand the relationships around the data, a key piece of clarifying the dependencies associated with the data. For example, a bank would want to ensure that any time an “account” entity were created it would have to have an account type – such as “asset,” “liability,” or “equity” – associated with it.

Effective communication

Data architects and DBAs must effectively communicate with all of the internal stakeholders who have access to or are using data. As is evidenced in many different instances, if information about how to use data is hard to find or hard to use, it is likely that the data will be either misused or replicated with different standards and in a different format. Out-of-control application growth is at the root of data redundancy and inaccuracy. For this reason, clear communication is vital to leveraging metadata.

Hmmmm... These are indeed colossal challenges. But as data management professionals we must continue to push to enable more flexible IT organizations. Doing so is the only way to ensure that we meet business needs, even in the face of explosive data growth. And metadata coupled with modeling provides an important piece of the puzzle. Increased visibility into corporate data landscapes helps organizations lower costs, ensure data integrity, and re-use existing data assets. Data architects and managers should make sure that any system that they put in place is dynamic enough to continually incorporate changes, and accessible enough to work across the breadth of stakeholders.

To achieve success requires planning, architecture, and strategy. We'll talk more about these aspects of data management, metadata management, and administration in future postings. And please, feel free to sign in and share your thoughts with us in the space provided below.

Monday, October 24, 2005  |  Permalink |  Comments (0)
trackback URL:   http://www.dbazine.com/blogs/blog-cm/craigmullins/blogentry.2005-10-24.9472551018/sbtrackback
Craig Mullins
Data Management Specialist
Bio & Writings
Subscribe to my blog Subscribe to my blog
« January 2006 »
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31        
2006-01-04
10:52-10:52 Thoughts on Storage
2006-01-09
23:51-23:51 Database Performance and Row Size
2006-01-11
17:40-17:40 Predicting the Future? Don’t Believe a Word of it!
 
 

Powered by Plone