Metadata Professional Organization

Newsfeeds
Data Warehousing Knowledge Base
The Data Management & Warehousing Knowledge Base provides information and techniques about the design, build and implementation of data warehousing solutions that we as a company use and hope that you will also find useful.
How Data Works How business store and manage their data can have critical effect on data quality and consistency as well as performance and development times. This paper examines how data works and explores techniques exploited from understanding how data works Updated: Continuous Data Quality Process Wallchart A wallchart outlining the process required to develop continuous data quality within an organisation is available for download Updated: Data Warehouse Documentation Roadmap All projects need documentation and many companies provide templates as part of a methodology. This document describes the templates, tools and source documents used by Data Management & Warehousing. It serves two purposes: * For projects using other methodologies or creating their own set of documents to use as a checklist. This allows the project to ensure that the documentation covers the essential areas for describing the data warehouse. * To demonstrate our approach to our clients by describing the templates and deliverables that are produced. Updated: Data Warehouse Governance An organisation that is embarking on a data warehousing project is undertaking a long-term development and maintenance programme of a computer system. This system will be critical to the organisation and cost a significant amount of money, therefore control of the system is vital. Governance defines the model the organisation will use to ensure optimal use and re-use of the data warehouse and enforcement of corporate policies (e.g. business design, technical design, and application security) and ultimately derive value for money. Updated: Overview Architecture for Enterprise Data Warehouses This is the first of a series of papers published by Data Management & Warehousing to look at the implementation of Enterprise Data Warehouse solutions in large organisations using a design pattern approach. A design pattern provides a generic approach, rather than a specific solution. It describes the steps that architecture, design and build teams will have to go through in order to implement a data warehouse successfully within their business Updated: Job scheduling - fixed and relative timing This article looks at the relatve merits of two types of processing schedule, once based on a fixed times (similar to 'cron' on a unix system) and onebased on relative times (similar to 'at' on a unix system) Updated: Data Transformation - Procedural and Non-Procedural Solutions This paper looks at a somewhat awkward data transformation, and at solutions written in SQL and in a procedural language. It describes some techniques which can be used to develop the solution in both languages. It also compares the solutions in terms of ease of development, performance and cost of maintenance. Updated:

[ Back ]