Data Management & Warehousing

Tag: Linux

  • Our Toolbox – Essential Software

    —

    by

    macleanwalker
    in

    A data warehouse project will usually involve many pieces of software. These can be broken into two categories – architectural software and supporting tools. The architectural software will include the database, ETL tool, reporting tools, etc. but in this post I am going to look at the supporting tools we use. I should say from…

  • Installing R and RStudio on Redhat/CentOS Linux

    —

    by

    macleanwalker
    in

    As part of our forthcoming magazine article “Building an Analytical Platform” for SAP we described the need to install both R and RStudio. Our test system is an older CentOs 5.8 Linux box and so needs to use the Extra Packages for Enterprise Linux (EPEL) packages As ‘root’ on your system perform the following four…

  • Our Software

    —

    by

    macleanwalker
    in

    Over the years we have produced several utilities and open source projects. List list provides some information about their status GROUT – ETL tool including DAP & SQLUnload written in Korn Shell, C & PL/SQL – superseded by JST – code available on request JST – ETL tool written in Bash Shell – superseded by…

  • Storage Characteristics of Call Data Records in Column Store Databases

    —

    by

    macleanwalker
    in

    A presentation from an internal training session about the storage characteristics of call data records in Column Store Databases such as InfoBright, Sybase IQ and Actian Vectorwise It describes: What a Call Data Record is What a Column Store Database is The test environment we built to test the storage The results of our testing…

  • A Linux/Mac OS X Command Line Interface to AffiliateWindow

    —

    by

    macleanwalker
    in

    This article was written for a client due to the fact that we were unable to test the Affiliate Window API with the documentation available at the time Introduction Affiliate Window offer a tracking and management solutions for maintaining an affiliate program. This works by directing sales to a merchant from an affiliates’ website. In…

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