Data Management & Warehousing

Author: macleanwalker

  • Information Delivery: The Change In Data Management at Network Rail

    —

    by

    macleanwalker
    in

    In September 2004 we presented at the Oracle OpenWorld conference on the successful initial stages on rolling out an enterprise wide information and reporting portal built on the Oracle tool set. Rail privatisation and RailTrack was failing and Network Rail was created to take over the management of the different aspects of the railways. This…

  • Installing CVS on Windows

    —

    by

    macleanwalker
    in

    Installing CVS on Windows To access and work with the the CVS repositories you must install a CVS client on your Windows PC that can talk to the CVS servers. There are scores of CVS clients available, but at a minimum you must install the CVS command line client. This document also includes the instructions…

  • Configuring SSH Keys

    —

    by

    macleanwalker
    in

    Overview Once you have installed PuTTY but before you can connect to the CVS server, you must create your SSH authentication keys. SSH authentication keys are a more secure way of controlling access to the CVS server. Once configured they will allow you to connect to the CVS server without entering a log-on name and…

  • Installing the PuTTY SSH Client for Windows

    —

    by

    macleanwalker
    in

    Overview PuTTY is a GUI Windows client that makes it easy to use the SSH (secure shell) protocol to connect your Windows PC to a Linux server hosting a CVS repository Installing an SSH client and generating your personal SSH keys must be done before you can be given a user account to connect to…

  • CVS – A Basic Introduction

    —

    by

    macleanwalker
    in

    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 CVS from a Windows or Linux PC. These instructions are written for developers who need CVS access for the…

  • Beatles Songs for Linux Administrators

    —

    by

    macleanwalker
    in

    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 over me The system crashed so suddenly. I pushed something wrong. What it was I could not say. Now…

  • Configuration Management & Issue Tracking

    —

    by

    macleanwalker
    in

    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 Bugzilla to Trac and CVS to SVN and integrated in in our Project Services Introduction ETL tool transformations, data…

  • CSV File Format

    —

    by

    macleanwalker
    in

    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 been used since data first had to be exchanged between two applications. CSV files are an imperfect format that…

  • Building Data Marts

    —

    by

    macleanwalker
    in

    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 our transaction repository or data warehouse the next job is to build our data marts. The design of data…

  • Oracle DBA Crib Sheet

    —

    by

    macleanwalker
    in

    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 have them written down any where else. It features the commands that we have been asked to put in…