CVS – A Basic Introduction
CVS – Getting Started Use this document to get started using CVS. It contains a very short intro to CVS and points you to the more detailed installation and configuration procedures you must follow to use…
Read MoreAuthor: datamgmt
Beatles Songs for Linux Administrators
Yesterday Yesterday, All those backups seemed a waste of pay. Now my database has gone away. Oh I believe in yesterday. Suddenly, There’s not half the files there used to be, And there’s a milestone hanging…
Read MoreConfiguration Management & Issue Tracking
One commonly overlooked side of building a data warehouse is the need for configuration management and issue tracking. This article looks at a way to do this. Since this article was written we have upgraded from…
Read MoreCSV 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 Introduction Comma Separated Values (CSV) files have…
Read MoreBuilding 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. The types of data marts to load Having built…
Read MoreOracle DBA Crib Sheet
Introduction The Oracle DBA Crib Sheet is not an exhastive list of what a DBA has to do, instead it has been written for a particular client whose support team occasionally need dba commands and don’t…
Read MoreData Transformation – Procedural & 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…
Read MoreBasic Data Quality Checks
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 Introduction The following article…
Read MoreDetecting Changed Data
Introduction When loading data warehouses, it is usually possible to decreases the load time very significantly by processing only changes since the last load, rather than completely refreshing all the data every time. This article describes…
Read MoreJob 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…
Read More