Log In

Username

Password

Remember Me

---

New Account Signup
Forgot Your Password?

Main Menu

Quotes

"Make everything as simple as possible, but not simpler." --Albert Einstein

Data Warehousing Links

Science & Technolgy News

PC Security

All Articles

The Business Case for Business Intelligence
This white paper looks at the business case that should lie behind the decision to build a data warehouse and provide a business intelligence solution.

---

Detecting Changed Data
Description of a method to identify changes from one version of an extract file to the next.

---

CSV File Format
We all know that we should be writing file extracts as XML but if we really need to get a CSV file then here is how to do it

---

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

---

Continuous Data Quality Process Wallchart
A wallchart outlining the process required to develop continuous data quality within an organisation is available for download

---

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.

---

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.

---

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)

---

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.

---

Building Data Marts
This article descibes building data marts from a data warehouse or transaction repository. It discusses the merits of full and incremental loads for different data marts.

---

Bitwise calculations and Message Digests in Oracle
It is often useful to have bitwise and message digest algorithms for use in a data warehouse. But where can we get some from ?

---

Basic Data Quality Audit
This article looks at basic data quality audit that can be done within a database. Examples are given using Oracle syntax however the techniques can also be applied to other databases

---

Auditing Data Cleaning Updates
How to track what has been updated by data cleaning processes

---

Keysum - Using a checksum for a primary key
Description of a method to use checksums as keys

---

Key Design Decisions
KDD template for recording data warehouse design changes

---

Are you linked in ?

Twitter

Use Skype To Contact Us

RSS Feeds

Search Search the articles

Who's Online

Legal

Terms of Use
Privacy Policy