Data Management & Warehousing

Tag: Oracle

  • Data Warehouse Appliances – Fad or Future?

    —

    by

    macleanwalker
    in

    This article was originally written for Conspectus Magazine in December 2006 and has been updated in November 2009 by the original author Despite all the hype from vendors the basics of data warehousing have remained fundamentally unchanged – extract data from multiple source systems, reformat the information into an easy to query structure, load it into a…

  • From Volume to Value

    —

    by

    macleanwalker
    in

    A presentation given to the Oracle Business Intelligence forum for Telcos that discussed how businesses should move from collecting volume of data to using the value of the data. It sets the context about what issues businesses are facing and then suggests five actions that can be used to help address the issues. These are:…

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

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

  • 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

  • Client Server Very Large Databases

    —

    by

    macleanwalker
    in ,

    In 1993 I was still working for Sequent Computer Systems as the Technical Leader for Databases. We won a contract to build a then massive 1000 user Unix system using Oracle 7.1 with ten 16 processor system and up to 50Gb of data in a client-server arrangement. Building this system that run Perot/Europcar car rental administration…