A Broadband and ADSL forum. BroadbanterBanter

Welcome to BroadbanterBanter.

You are currently viewing as a guest which gives you limited access to view most discussions and other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today.

Go Back   Home » BroadbanterBanter forum » Newsgroup Discussions » uk.comp.home-networking (UK home networking)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

uk.comp.home-networking (UK home networking) (uk.comp.home-networking) Discussion of all aspects of computer networking in the home, regardless of the platforms, software, topologies and protocols used. Examples of topics include recommendations for hardware or suppliers (e.g. NICs and cabling), protocols, servers, and specific network software. Advertising is not allowed.

re work

Thread Tools Display Modes
Old June 16th 05, 01:07 AM posted to uk.comp.home-networking
external usenet poster
Posts: 1
Default re work

If the main reason you are considering a data warehousing is to get around
the difficulties caused by a dysfunctional transaction processing system, do
the work of costing how much it will fix the transaction processing system
before you make the data warehouse decisionIt may not be surprising that the
primary motivation for the construction of many data warehouses is to get
around the difficulties caused by a problematic transaction processing
system. Immediately deciding upon a data warehouse as a "fix" can be an
expensive mistake. If you don't do the work of costing how much it will cost
to fix the transaction processing systems, you may never understand what is
really causing the problems. And then you're setting yourself up for a
situation where the same problems recur in the data warehouse and you end up
supporting both a dysfunctional transaction processing system and a
dysfunctional data warehouse.
If most of your business needs are to report on data in one transaction
processing system and/or all the historical data you need are in that system
and/or the data in the system are clean and/or your hardware can support
reporting against the live system data and/or the structure of the system
data is relatively simple and/or your firm does not have much interest in
end user ad hoc query/report tools, you may not NEED a data warehouse
Sometimes a good report generator will do just fine.

Question whether you really will benefit from certain categories of tools
For some data warehouse implementations, certain types of tools just do not
make good business sense. For example, if you have no need for the
slice-and-dice or modeling capabilities of OLAP tools, a report and query
tool may meet your reporting needs more than adequately. If you have to
perform fairly complex data transformations and/or you have relatively few
data sources and targets, you may be better off coding by hand than using a
so called "data mart" tool. The database you use for transaction processing
may do just fine based on the number of users, amount of data, and time you
have to load the database. Before buying data mining tools do your best to
assess whether they will yield "actionable" insights worth the effort in
making the data mining tool work.

Accept that data warehousing is going to be technically messy
If someone were ever to write "The Zen Of Data Warehousing" (perish the
thought - please), one of the concepts would probably be that at some point,
the more technically elegant you try to make these systems, the messier (and
more costly and less beneficial) they end up being. There are no rules for
determining where this point is. Use your judgment and intuition to make the


The mortgage and savings arm of a large European mutual life assurance
company put a retention strategy in place with Quadstone that identified
customers at risk months ahead of their existing processes. Prior to the
initiative early redemption was not well understood. Business and analysis
groups worked together to explore the factors affecting this problem and
calculated the lost revenue impact. Being able to move more quickly using
Quadstone delivered significant incremental profit as well as providing
insight into customer behavior leading to redemption


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
can't work out how to do it news.ntlworld.com uk.telecom.voip (UK VOIP) 10 June 24th 05 05:07 PM
will this work? oO uk.comp.home-networking (UK home networking) 1 April 20th 05 01:51 AM
Will it work? Malcolm Loades uk.telecom.broadband (UK broadband) 6 July 3rd 04 04:24 PM
Does this really work ? Dave uk.telecom.broadband (UK broadband) 3 February 27th 04 07:02 AM
ICS - why can't I get it to work? selective override uk.comp.home-networking (UK home networking) 2 July 6th 03 12:38 AM

All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.Content Relevant URLs by vBSEO 2.4.0
Copyright 2004-2020 BroadbanterBanter.
The comments are property of their posters.