RAS Finder and Monitor solutions
often result in the identification of high volumes of corrupt data.
In many instances the scale of the issues a manual approach to the
correction of such data to effort, time and cost intensive, and
being manual rarely offers a guarantee of effectiveness. RAS Rectifier
solutions provide a means to automate such remedial work, reducing
the time, cost, effort and risk involved.
Issue Addressed
It is not uncommon for RAS Audits to identify significant
issues in the data audited, otherwise termed as mass corruption
of data. In many instances the scale of the corruption
can make manual rectification prohibitive in terms of
time, cost and operational implications. Furthermore,
to many organisations, the potential for human error in
the rectification of such records is too high risk to
be considered seriously.
What it is and does
RAS Rectifier is a solution to rectifying or cleansing
high volumes of data in a batch mode. Using commercially
available packages, RAS can address a wide range of issues
including the following:
De-duplication - Duplicates are often created
as a result of minor differences between records. For
example, a record recording an abbreviated forename or
misspelling of a surname could be created when an existing
record using the full forename or correctly spelt surname
already exists.
Value Correction
- Data corruption is often a result of computer or user
error, RAS Rectifier can correct the corrupt data providing
a file containing the corrected records to be restored to
the affected system.
Standardisation of Data - It is not uncommon to
find the same information is held as different values. This
is often as a result of data being consolidated from different
systems, as is common as a result of merger and acquisition
or operational reorganisation. This has a similar effect
as duplicated records and can have significant effects on
resource planning and management, for example where the
same physical item is ordered and stored under two different
descriptions.
Correcting Address Data - Address data is frequent
and easily incorrectly recorded. For example where postcodes
that are wrongly transcribed, resulting in post being misrouted
or where the format of a foreign address is wrongly recorded.
Benefits
RAS Rectifier offers an organisation to minimise the
effects of common data errors. This might result in reduced
cost or improved planning, budgeting and decision making;
it all depends on the nature, scale and implications of
the problems identified