 |
Data Quality |
| |
The IT industry has spent years and years claiming that data captured/stored in the (enterprise) data warehouse must have all these qualities: accuracy, completeness, consistency, uniqueness and timeliness. But now it is becoming acceptable to be more realistic, feasible and practical:
|
| |
|
Business Intelligence and Data Warehousing |
| |
Business Intelligence
Links
Articles
Books
- Larry P. English: Improving Data Warehouse and Business Information Quality
(Methods for Reducing Costs and Increasing Profits)
April 1999
Buy it at Amazon.co.uk
CeDeT Rating: 
Usefulness: [not evaluated]
Total Quality data Management
Teamwork for Business Information Quality
Cleansing and Reengineering for Data Warehousing, p. 239-241:
The success of the data warehouse is dependent on collecting, managing, and disseminating quality information products that support the strategic and tactical business processes of the enterprise. Without quality information, the data warehouse will fail. With quality information, the data warehouse can be used for competitive advantage in ways not currently envisioned. ...
Data [in the data warehouse database] must have completeness, nonduplication, accuracy, precision to the right degree, derivation consistency, and timeliness ...
...[the presented information must] easily communicate the meaning and significance of the information...
...meet data warehouse customer needs.
- William H. Inmon: Building the Data Warehouse
3rd Edition
April 2002
Buy it at Amazon.co.uk
CeDeT Rating:
Usefulness:
- Ralph Kimball, Margy Ross: The Data Warehouse Toolkit
(The Complete Guide to Dimensional Modeling)
2nd Edition
April 2002
Buy it at Amazon.co.uk
CeDeT Rating:
Usefulness:
- Ralph Kimball, Laura Reeves, Margy Ross, Warren Thornthwaite: The Data Warehouse Lifecycle Toolkit
(Expert Methods for Designing, Developing, and Deploying Data Warehouses)
July 1998
Buy it at Amazon.co.uk
CeDeT Rating:
Usefulness:
Data Quality and Cleansing (Data Staging), p. 653-654:
... the characteristics of quality data:
- Accurate ...
- Complete ...
- Consistent ...
- Unique ...
- Timely ...
In sum, quality data is "the thruth, the whole thruth, and nothing but the thruth." [in due time]
- Ralph Kimball, Joe Caserta: The Data Warehouse ETL Toolkit
(Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data)
September 2004
Buy it at Amazon.co.uk
CeDeT Rating:
Usefulness:
- Christopher Adamson, Michael Venerable: Data Warehouse Design Solutions
July 1998
Buy it at Amazon.co.uk
CeDeT Rating: [not rated]
Usefulness: [not evaluated]
|
| |
|
Oracle Business Intelligence and Data Warehousing |
| |
Oracle Warehouse Builder (OWB) and Oracle Data Integrator (ODI)
Oracle Discoverer
Documentation
White Papers
Articles
Links
Books
- Robert Stackowiak, Joseph Rayman, Rick Greenwald: Oracle Data Warehousing and Business Intelligence Solutions
January 2007
Buy it at Amazon.co.uk
CeDeT Rating:
Usefulness:
- Bert Scalzo: Oracle DBA Guide to Data Warehousing and Star Schemas
(Successful Star Schemas for Oracle Data Warehouse)
June 2003
Buy it at Amazon.co.uk
CeDeT Rating:
Usefulness: [not evaluated]
- Gary Dodge, Tim Gorman: Essential Oracle8i Data Warehousing
(Designing, Building, and Managing Oracle Data Warehouses)
2nd Edition
October 2000
Buy it at Amazon.co.uk
CeDeT Rating:
Usefulness:
What Is A Data Warehouse (Data Warehousing), p. 2-16:
Data Warehousing Is Not a Project...
...Rather, Data Warehousing Is a Process
A Data Warehouse Is Not a Product...
...Rather, Data Warehousing Is a New Way of Thinking about Data
A Data Warehouse Is Not a Place...
...Rather, Data Warehousing Is a Supplement to Traditional Data Processing
- Lilian Hobs, Susan Hillson, Shilpa Lawande: Oracle9iR2 Data Warehousing
February 2003
Buy it at Amazon.co.uk
CeDeT Rating:
Usefulness:
A newer version is available - see below!
- Lilian Hobs, Susan Hillson, Shilpa Lawande, Pete Smith: Oracle Database 10g Data Warehousing
November 2004
Buy it at Amazon.co.uk
CeDeT Rating: [not rated]
Usefulness: [not evaluated]
- Darlene Armstrong-Smith, Michael Armstrong-Smith: Oracle Discoverer 10g Handbook
May 2006
Buy it at Amazon.co.uk
CeDeT Rating: [not rated]
Usefulness: [not evaluated]
|
|
![CeDeT [se'de']](../../CeDeTsmall.gif){kind=small}