Tag: Sybase
-
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) described it as a database where they could store data, a front end where they could do statistical work…
-
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 direction. This challenge was given to us by one of our clients a European Mobile Virtual Network Operator (MVNO)…
-
Storage Characteristics of Call Data Records in Column Store Databases
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…
-
Data Warehouse Appliances – Fad or Future?
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…
-
Data 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 working with a data warehouse. These issues include: • Configuration/Change Management • Managing and Improving Data Quality • Engagement…
Data Management & Warehousing 