Improving OLTP data quality using data warehouse mechanisms

Research and products for the integration of heterogeneous legacy source databases in data warehousing have addressed numerous data quality problems in or between the sources. Such a solution is marketed by Team4 for the decision support of mobile sales representatives, using advanced view maintenan...

Full description

Saved in:
Bibliographic Details
Published in:Proceedings of the 1999 ACM SIGMOD International Conference on Management of Data 1999-06, Vol.28 (2), p.536-537
Main Authors: Jarke, Matthias, Quix, Christoph, Blees, Guido, Lehmann, Dirk, Michalk, Gunter, Stierl, Stefan
Format: Article
Language:English
Subjects:
Data management systems
Data warehouses
Decision support systems
Information integration
Information systems
Information systems applications
Citations: Items that this one cites
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Research and products for the integration of heterogeneous legacy source databases in data warehousing have addressed numerous data quality problems in or between the sources. Such a solution is marketed by Team4 for the decision support of mobile sales representatives, using advanced view maintenance and replication management techniques in an environment based on relational data warehouse technology and Lotus Notes-based client systems. However, considering total information supply chain management, the capture of poor operational data, to be cleaned later in the data warehouse, appears sub-optimal. Based on the observation that decision support clients are often closely linked to operational data entry, we have addressed the problem of mapping the data warehouse data quality techniques back to data quality measures for improving OLTP data. The solution requires a warehouse-to-OLTP workflow which employs a combination of view maintenance and view update techniques.
ISSN:0163-5808
1943-5835
DOI:10.1145/304181.304568