Meta Data Silos Part 1

By David Marco

Meta data management and its use in enterprise information management has become one of the critical information technology (IT) focuses for both global 2000 corporations and large government agencies.  As these entities look to reduce their IT portfolio and control their escalating IT costs, they are turning to the technical functionality that a managed meta data environment (MME) can provide them.  The organizations that have built well-architected enterprise-wide MMEs have achieved a tremendous amount of success.  Unfortunately, like most popular IT trends, companies are making key mistakes in building and moving forward on their meta data management investments.  One of the chief problems is that they are not building one MME; rather, they are building lots of meta data repositories, none of which speak to each other and without an overall meta data management strategy.  In this month’s column I will discuss this proliferation of unarchitected and disjointed meta data repositories and the problems that they cause.

The problem of disparate initiatives is not unique to meta data management.  On the contrary, it is a common issue that has plagued many areas of IT.  Technologies like data warehousing, enterprise resource planning (ERP), supply chain management and all flavors of transactional systems have suffered with needless duplication and redundancy.  The four most common problems created by disparate meta data repositories are:

  • Missing Meta Data Relationships
  • Typically Built By Non-Meta Data Professionals
  • Costly Implementation and Maintenance
  • Poor Technology Selections

Missing Meta Data Relationships

In past columns I have discussed the different types of meta data (see Table 1: “Types of Meta Data”) that companies and government agencies need to properly manage and the importance of having these meta data objects linked together.  For example, it is very valuable for an IT developer to have the capability to go to the MME to look at the technical transformation rules (technical meta data) that are being applied to a particular physical field name on a report that is being analyzed.  Once the developer has reviewed this meta data they could then navigate through the MME to find the business rules defined by the business users for that field.  If a discrepancy between the transformation rules and the business rules exists then the developer could use the MME to contact the data steward who defined the specific business rules and resolve this discrepancy.  This is the true power of properly managing your meta data as it bridges the gap between our business and our IT systems, because in truth, our business is comprised of our IT systems.  When meta data is not managed from an enterprise perspective this type of click-through analysis is impossible as the relationships between the meta data (both business and technical) are not being captured or maintained.


Table 1: Types of Meta Data

Poor Technology Selections

At EWSolutions we work with a good number of large corporations and vast government agencies.  It is common to find many disparate MME or repository-like initiatives.  For example, we have one client that has over 14 separate MME initiatives (either in production or currently being developed) and another client that has over 25 disjointed repositories, most of which have significant monetary expenditures associated with them.  Disparate MME initiatives can come in many different flavors, sizes and shapes.  There are large repositories which utilize enterprise-level meta data integration tools or are even custom build (typically with Microsoft SQL Server or Oracle).  Also, there are lower technology meta data efforts that come in the form of Microsoft Excel spreadsheets, which, along with Microsoft Access are the most popular form of meta data repository technology.  Does this surprise you?  If so let’s consider this fact for a moment.  Neither Cognos nor Business Objects are the most popular form of data warehouse access.  Microsoft Excel is still the most popular data warehouse access technology.  This is one of the dirty secrets of data warehousing.  With this fact in mind it is not surprising that Microsoft Excel and Access are being improperly used for storing and retrieval of enterprise meta data.

In next month’s column I will examine the remaining two issues with disparate meta data repository environments.

For more information on this topic see Chapter 2 in “Building and Managing the Meta Data Repository”, David Marco, John Wiley & Sons.

About the Author

Mr. Marco is an internationally recognized expert in the fields of enterprise information management, data warehousing and business intelligence, and is the world’s foremost authority on meta data management.  He is the author of several widely acclaimed books including “Universal Meta Data Models” and “Building and Managing the Meta Data Repository: A Full Life-Cycle Guide”.  Mr. Marco has taught at the University of Chicago, DePaul University, and in 2004 he was selected to the prestigious Crain’s Chicago Business “Top 40 Under 40” and is the chairman of the Enterprise Information Management Institute ( He is the founder and President of EWSolutions, a GSA schedule and Chicago-headquartered strategic partner and systems integrator dedicated to providing companies and large government agencies with best-in-class solutions using data warehousing, enterprise architecture, data governance and managed meta data environment technologies (  He may be reached directly via email at

Free Expert Consultation