Building An Analytical Platform
Reprint of an article published by SAP about a recent piece of work I have recently been asked to build an analytical platform for a project – but what is an analytical platform? The client (a retailer)…
Read MoreCategory: Articles
Building a Data Warehouse of Call Data Records (CDR): Solution Considerations
Source: Database Trends and Applications (http://www.dbta.com/) Reprint of a magazine article from May 2012 With many organisations having established data warehouse solutions there comes a point where the solution needs to be extended in an unusual…
Read MoreStruggling with Data Management ?
Re-print of a magazine article from August 2010 Those responsible for data management in your organisation are probably struggling. If you can find an individual or group responsible for everything then they have a lot on…
Read MoreA Linux/Mac OS X Command Line Interface to AffiliateWindow
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…
Read MoreData Warehousing – Change Management In A Challenging Environment
The way in which data warehouse developments and solutions are viewed is changing. The emphasis is less on the technological problems, many of which have been solved, and more on the day-to-day issues of living and…
Read MoreConspectus: Data Warehousing Appliances: Fad or Future
The original article for Conspectus magazine. Conspectus is the UK’s leading independent report which authoritatively addresses the key IT application areas. It is acknowledged as one of the most trusted journals in the IT industry and…
Read MoreKeySum – Using Checksum Keys
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…
Read MoreA Technical Architecture for the Data Warehouse
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…
Read MoreClient Server Very Large Databases
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…
Read More