Data Management & Warehousing - Specialist Consultants in helping you and your Data Warehousing projects
 
 Data Management & Warehousing
 
 • Home • Knowledge Base • Hints & Tips • About Us • Contact Us • Bookmark Us • 
Log In

Username

Password

Remember Me



Main Menu


Quotes

"That which today calls itself science gives us more and more information, an indigestible glut of information, and less and less understanding. " --Edward Abbey

Data Warehousing Links


Science & Technolgy News


PC Security


Welcome

Data Warehousing, Data Marts, Business Intelligence, OLAP, Data Management, Balanced Scorecard - our Knowledge Base has free publicly available hints and tips written by our consultants


We also offer a complete consultancy service that will ensure the success of your data warehouse project. If you are interested in our services please contact us

Created on 12/25/2003 01:09 PM by datamgmt
Updated on 08/03/2007 09:27 AM by datamgmt
 Printable Version

The Data Management & Warehousing Knowledge Base provides information and techniques about the design, build and implementation of data warehousing solutions that we as a company use and hope that you will also find useful.

How Data Works
How business store and manage their data can have critical effect on data quality and consistency as well as performance and development times. This paper examines how data works and explores techniques exploited from understanding how data works
Updated:
Continuous Data Quality Process Wallchart
A wallchart outlining the process required to develop continuous data quality within an organisation is available for download
Updated:
Data Warehouse Documentation Roadmap
All projects need documentation and many companies provide templates as part of a methodology. This document describes the templates, tools and source documents used by Data Management & Warehousing. It serves two purposes:

* For projects using other methodologies or creating their own set of documents to use as a checklist. This allows the project to ensure that the documentation covers the essential areas for describing the data warehouse.
* To demonstrate our approach to our clients by describing the templates and deliverables that are produced.
Updated:
Data Warehouse Governance
An organisation that is embarking on a data warehousing project is undertaking a long-term development and maintenance programme of a computer system. This system will be critical to the organisation and cost a significant amount of money, therefore control of the system is vital. Governance defines the model the organisation will use to ensure optimal use and re-use of the data warehouse and enforcement of corporate policies (e.g. business design, technical design, and application security) and ultimately derive value for money.
Updated:
Job scheduling - fixed and relative timing
This article looks at the relatve merits of two types of processing schedule, once based on a fixed times (similar to 'cron' on a unix system) and onebased on relative times (similar to 'at' on a unix system)
Updated:
Data Transformation - Procedural and Non-Procedural Solutions
This paper looks at a somewhat awkward data transformation, and at solutions written in SQL and in a procedural language. It describes some techniques which can be used to develop the solution in both languages. It also compares the solutions in terms of ease of development, performance and cost of maintenance.
Updated:
Building Data Marts
This article descibes building data marts from a data warehouse or transaction repository. It discusses the merits of full and incremental loads for different data marts.
Updated:

Category: Data Warehousing

More Feeds


Brian Hartlen, Varicent
Brian Hartlen explains how Varicent sales performance management delivers a single application that allows sales organizations to see how they are performing and being compensated - quickly, efficiently and accurately.

Book Review of The Data Model Resource Book
Steve Hoberman reviews Volume 3 of The Data Model Resource Book series.

CSC Announces Global Agreement to Resell the Microsoft Business Productivity Online Suite
CSC will offer a compelling choice of private cloud customer-managed and public cloud services combined with Microsoft Online Services.

Progress Software Introduces FUSE to Support Open Source Integration
Progress Software launches FUSE Forge to simplify the development of open source integration projects.

SAP AG Introduces New Capabilities in Two SAP BusinessObjects Governance, Risk and Compliance Solutions
New versions of the SAP BusinessObjects Risk Management and SAP BusinessObjects Process Control applications give customers the clarity required to help ensure that the right controls are in place.

expressor software Signs Sila Solutions Group as a US Systems Integration Partner
As an expressor partner, Sila will help its Fortune 500 customers implement the expressor semantic data integration system to maintain the customer's competitive advantage while lowering their total cost of ownership.

University System of Georgia Selects iStrategy HigherEd Analytics Suite for Statewide Deployment
Selected in a competitive bid process, the HigherEd Analytics Suite will provide financial data warehousing and business intelligence at 32 of USG's colleges and universities.

ParAccel Introduces Version 2.0 of the ParAccel Analytic Database
PADB 2.0 tackles the most complex business questions even faster by leveraging dozens of new features and enhancements, including patent-pending innovations in query optimization and SAN integration.

ASG Software Solutions Announces the Immediate Availability of ASG's BSP Virtualisation Management
ASG's BSP Virtualisation Management is a new solution that monitors the real-time performance, health, and efficiency of both virtual and physical IT environments.

Introducing Principles-Based Data Governance
A principles-based data governance approach will seek to replace poor existing principles with better ones and empower stakeholders to implement them without prescribing how it should be done. Malcolm Chisholm explains how this will avoid creating bureaucratic overhead and give the enterprise a reasonable way to implement effective data governance.

Data Governance and Playing Whack-a-Mole
Taking inspiration and lessons from the recent Data Governance Conference, Steve Palmer describes a few critical things that can be done to transform the data "mess" that exists in many organizations.

Oracle Insurance Announces the Availability of Oracle Insurance Insight 6.0
The new release enables insurance companies to conduct comprehensive and flexible policy, claims and customer analysis without the need for costly customized integrations.

SwiftKnowledge Announces SwiftKnowledge for ISVs
With SwiftKnowledge, ISVs gain a significant and tangible advantage over their competitors by easily embedding robust reporting and analytics, predictive modeling, data mining and trend analysis capabilities into their solutions.

Joydeep Das, Sybase
Joydeep Das discusses how Sybase IQ is a highly optimized analytics server designed specifically to deliver faster results for mission-critical business intelligence, data warehouse and reporting solutions on any standard hardware and operating systems.

Orange Leap Selects Jaspersoft
Orange Leap provides open source software solutions for nonprofit organizations that need to manage the entire lifecycle of relationships with donors and constituents.

Category: Uncategorized

More Feeds


ETIS

We are an associate member of
ETIS

Are you linked in ?

See David Walker's
View David Walker's profile on LinkedIn
Profile

Use Skype To Contact Us

Skype Me!

RSS Feeds


googlesvcs from Data Management & Warehousing, the Data Warehousing knowledgebase and consultancy

WWW   Site


Mailing Lists

Choose a list:


Email Address:

HTML Text


London Weather


Who's Online

There are currently
1 guest(s) and
0 member(s) online.
You are an
Anonymous user.
You can register for
free by clicking here

No Members are currently logged in.

Your IP address :
38.103.63.55

Your country is :
Unknown
Unknown

Legal



Valid RSS!
The content of this site is Copyright (©) 1995-2007 Data Management & Warehousing Ltd
Valid XHTML 1.0! Valid CSS!
Registered Office: 138, Finchampstead Road, Wokingham, Berkshire, RG41 2NU, United Kingdom
Registered in England and Wales; Registration Number: 3526504; VAT Registration Number: GB 724 4482 36
This site is powered by phpWebSite © The Web Technology Group, Appalachian State University and licensed under the GNU LGPL