Data Quality Firewall
Encyclopedia
A Data Quality Firewall is the use of software to protect a computer system from the entry of erroneous, duplicated or poor quality data. Gartner
estimates that poor quality data causes failure in up to 50% of Customer relationship management
systems. Older technology required the tight integration of data quality
software, whereas this can now be accomplished by loosely coupling technology in a service-oriented architecture
.
and high quality data enter the system, which means that it obliquely protects the database from damage; this is
extremely important since database integrity and security are absolutely essential. A Data Quality Firewall
provides real time feedback information about the quality of the data submitted to the system.
The main goal of a data quality process consists in capturing erroneous and invalid data, processing them and
eliminating duplicates and, lastly, exporting valid data to the user without failing to store a back-up copy into
the database. A Data Quality Firewall acts similarly to a network security firewall. It enables packets to
pass through specified ports by filtering out data that present quality issues and allowing the remaining, valid data to be
stored in the database. In other words, the firewall sits between the data source and the database and works
throughout the extraction, processing and loading of data.
It is necessary that data streams be subject to accurate validity checks before they can be considered as being
correct or trustworthy. Such checks are of a temporal, formal, logic, and forecasting kind.
Gartner
Gartner, Inc. is an information technology research and advisory firm headquartered in Stamford, Connecticut, United States. It was known as GartnerGroup until 2001....
estimates that poor quality data causes failure in up to 50% of Customer relationship management
Customer relationship management
Customer relationship management is a widely implemented strategy for managing a company’s interactions with customers, clients and sales prospects. It involves using technology to organize, automate, and synchronize business processes—principally sales activities, but also those for marketing,...
systems. Older technology required the tight integration of data quality
Data quality
Data are of high quality "if they are fit for their intended uses in operations, decision making and planning" . Alternatively, the data are deemed of high quality if they correctly represent the real-world construct to which they refer...
software, whereas this can now be accomplished by loosely coupling technology in a service-oriented architecture
Service-oriented architecture
In software engineering, a Service-Oriented Architecture is a set of principles and methodologies for designing and developing software in the form of interoperable services. These services are well-defined business functionalities that are built as software components that can be reused for...
.
Features and functionality
A Data Quality Firewall guarantees database accuracy and consistency. This application ensures that only validand high quality data enter the system, which means that it obliquely protects the database from damage; this is
extremely important since database integrity and security are absolutely essential. A Data Quality Firewall
provides real time feedback information about the quality of the data submitted to the system.
The main goal of a data quality process consists in capturing erroneous and invalid data, processing them and
eliminating duplicates and, lastly, exporting valid data to the user without failing to store a back-up copy into
the database. A Data Quality Firewall acts similarly to a network security firewall. It enables packets to
pass through specified ports by filtering out data that present quality issues and allowing the remaining, valid data to be
stored in the database. In other words, the firewall sits between the data source and the database and works
throughout the extraction, processing and loading of data.
It is necessary that data streams be subject to accurate validity checks before they can be considered as being
correct or trustworthy. Such checks are of a temporal, formal, logic, and forecasting kind.