Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

How To Manage Meta Data Within a Data Warehouse

By Exforsys | on September 16, 2006 |
Data Warehousing

How To Manage Meta Data Within a Data Warehouse

Many large companies are now implementing data warehouses. They may use them to analyze specific areas such as customer service or financial issues. Many companies will create multiple goals that they will work towards by using data warehouses.

While this approach has worked well for some companies, this tactic is beginning to show a number of notable weaknesses. Both data and meta data are used with numerous data warehouses, and many of the technicians who manage these warehouses are trying to figure how to process and organize the meta data.

One of the main problems with contemporary data warehouse management strategies is that information changes rapidly. Because of this, it is difficult to be consistent when managing data warehouses. For example, what will a data warehouse manager do when the developer of an application decides to change definitions within the application? The impact that can be created by this and other issues has caused many organizations to rethink their data warehouse management strategies. Many of them are not placing an emphasis on the management of meta data. Being able to process meta data across a wide variety of different warehouses will make things easier.

One tool that can allow data warehouse managers to deal with meta data is called a repository. By using a repository, the meta data can be coordinated among different warehouses. By doing this, all the members of the organization would be able to share data structures and data definitions. The repository could act as a platform that would be capable of handling information from a number of different sources. This information could include programs from companies like Microsoft, IBM, or Oracle. In addition to this, the repository could also handle a wide variety of different tools.

One of the best advantages of using a repository is the consistency that will exist within the system. It will create a standard that can be understood among a number of different departments. If a new definition is created for a data mart implementation, a repository can support the change. A number of different departments would be able to share this information. In a nutshell, the transfer of information will become easier. It is important for the repository to function well over the lifecycle of the data warehouse. In order for this to occur, it is important to make sure the database and information is documented. A legacy model can help you in this area, and it can assist you in building a powerful data warehouse.

A repository can help data warehouse managers in a number of different ways. It can help you in the development phase, and it can also help lower the cost of maintenance. There are a number of things you will want to add to the repository to make it operate smoothly. One of the things you will want to add is a database management system. Using an industry standards tends to be better than a DBMS that was created by a vendor. You will have a number of advanced tools that can assist your in managing your database. In addition to this, it can also help you in the reporting process.

When you use an industry standard database management system, you can place an emphasis on the repository. If you decide to use a repository, it is important to make sure it is based on an entity/relationship structure. When you use an industry standard, it will be easier for your to customize information. There are a number of meta data extensions that should be supported by your repository. Some of these are adding an entity type, modifying an entity type, or modifying relationship characteristics. It will also be helpful if the vendor works with the Microsoft Open Information Model. Another thing that you can combine with a repository is API or application programming interface.



When an API is used, it will be easier for a company to custom build a meta data management system. The meta data will be separated from other tools, and this will make it easier to modify. Even if the data changes, there is no need to change the tools. By using these tools and strategies, a company can produce a data warehouse that is much more powerful and efficient.

« « The Difference Between Data Mart and Data Warehouse
Design Documents in Programming Methodology » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Ads

Free Training

RSSSubscribe 417 Followers
Ads
  • Popular
  • Recent
  • Federated Data Warehouse Architecture

    September 16, 2006 - 0 Comment
  • Crucial Requirements For Successful Data Warehouses

    February 7, 2007 - 0 Comment
  • Data Warehouse Overview

    August 14, 2006 - 0 Comment
  • Data Warehouses Non Technical Issues

    June 23, 2007 - 0 Comment
  • Maintaining Records Within a Data Warehouse

    September 15, 2006 - 0 Comment
  • Why Data Warehouses Can Be Useful

    February 8, 2007 - 0 Comment
  • Data Warehouse Tools

    August 18, 2006 - 0 Comment
  • Advantages and Disadvantages to Using a Data Warehouse

    September 15, 2006 - 0 Comment
  • Fundamental Themes For Your Data Warehouse

    February 8, 2007 - 0 Comment
  • Data Warehousing Methods

    August 22, 2006 - 0 Comment
  • Data Warehouses Non Technical Issues

    June 23, 2007 - 0 Comment
  • How To Evaluate The Software For your Data Warehouse

    February 15, 2007 - 0 Comment
  • Understanding The Challenges of Using Data Warehouses

    February 15, 2007 - 0 Comment
  • Understanding Quality Management For Data Warehouses

    February 13, 2007 - 0 Comment
  • Creating an Efficient Process for Data Warehouses

    February 13, 2007 - 0 Comment
  • How Does a Data Warehouse Differ From a Database

    February 11, 2007 - 0 Comment
  • How Data Is Stored Within a Data Warehouse

    February 11, 2007 - 0 Comment
  • How To Rate Your Data Warehouse

    February 10, 2007 - 0 Comment
  • What You Should Know About Building a Data Warehouse

    February 10, 2007 - 0 Comment
  • Fundamental Themes For Your Data Warehouse

    February 8, 2007 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • Data Warehouses Non Technical Issues
  • How To Evaluate The Software For your Data Warehouse
  • Understanding The Challenges of Using Data Warehouses
  • Understanding Quality Management For Data Warehouses
  • Creating an Efficient Process for Data Warehouses

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2021. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy
Necessary Always Enabled