Data Management & Warehousing

Tag: Data Warehousing

  • 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…

  • 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…

  • Detecting Changed Data

    —

    by

    macleanwalker
    in

    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 one approach for detecting changes, which has been used successfully in a number of data warehouse projects. Background There…

  • Template Solutions for Data Warehouses and Data Marts

    —

    by

    macleanwalker
    in

    A presentation given in 1998 to the Data Warehousing & Business Intelligence Conference on the value of using template solutions for data warehouses and data marts. It describes the types of reporting system and discusses the templates then available for them Download Template Solutions for Data Warehouses and Data Marts Now

  • KeySum – Using Checksum Keys

    —

    by

    macleanwalker
    in

    In 1997 we were working on a project for Swisscom Mobile and needed to innovate a way of using a checksum key on a database. Here is the solution we design: Introduction Keysum is a new and interesting technique (not a product) in the generation of keys within a database. It has particular application within…

  • A Technical Architecture for the Data Warehouse

    —

    by

    macleanwalker
    in ,

    In April 1995 I left Sequent Computer Systems to set up Data Management & Warehousing. Between the completion of the Perot/Europcar project and leaving I had worked with Ralph Kimball, who was training Sequent to develop a Data Warehousing practice and promoting his Red Brick technology (currently owned by IBM). This paper outlines the first two…