Data Warehouses typically represent data being integrated from multiple source systems. There are inherent data quality problems when data is being consolidated in terms of data semantics, master data integration, cross functional business rule conflicts, data cleansing, etc. This paper demonstrates how multiple Object Role Models were successfully used in establishing a data quality firewall architecture to define an Advanced Generation Data Warehouse. The ORM models realized the 100% Principle in ISO TR9007 Report on Conceptual Schemas, and were transformed into attribute-based models to generate SQL DBMS schemas. These were subsequently used in RDBMS code generation for a 100% automated implementation for the data quality firewall checks based on the described architecture. This same Data Quality Firewall approach has also been successfully used in implementing multiple web based applications, characteristically yielding 35-40% savings in development costs.
Weitere Kapitel dieses Buchs durch Wischen aufrufen
Bitte loggen Sie sich ein, um Zugang zu diesem Inhalt zu erhalten
Sie möchten Zugang zu diesem Inhalt erhalten? Dann informieren Sie sich jetzt über unsere Produkte:
- Using ORM-Based Models as a Foundation for a Data Quality Firewall in an Advanced Generation Data Warehouse
- Springer Berlin Heidelberg