Page 225 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Unit 11: Query Processing and Optimization

Based on the Table 11.8, you learnt that full scan technique and scanning with index techniques notes
are not good for small selected attributes.



Case Study oki Data americas, inc.
Better Data extends value
How can you extend the value of a new software implementation? Follow the example
of Oki Data Americas, Inc. A year after the company implemented SAP R/3 business
software, it realized low data quality was limiting the value of its new data solution. Oki
Data used the Trillium Software System® to consolidate data from legacy systems within
its SAP database, increasing both the value of its data solution and the resolution of its
customer view.
Oki Data needed to create a single, comprehensive data source by:
1. Identifying and deduplicating customer records in its SAP and legacy systems.
2. Identifying unique customer records in the legacy systems and loading them into the
SAP database.
3. Consolidating legacy systems and SAP data to ensure completeness of customer
records.
Manually consolidating the data was an unappealing prospect. Oki Data would have
had to match records and make data conversions manually. In addition to being time-
consuming, manual consolidation would provide virtually no improvement in the quality
of name and address data.
It became clear to Oki Data that it needed a data quality solution that could instill higher
quality in diverse data from across the enterprise.
three Months from concept to remedy
Oki Data quickly identified Trillium Software as its data quality solution provider. The
Trillium Software System met more of Oki Data’s 30 solution criteria than other solution
candidates.
Oki Data needed a data quality solution that functioned within a heterogeneous
environment. The platform-independent architecture of the Trillium Software System
ensured compatibility across all past and present systems.
The Trillium Software solution cleansed, standardized, deduplicated and matched Oki
Data’s US and Canadian customer data. Oki Data particularly liked the software’s ability
to correct (geocode) addresses according to US postal directories. During the evaluation
process, Trillium Software was the only vendor to provide Oki Data with a knowledge
transfer that demonstrated the process and results of its data quality process using Oki
Data’s unique information.
Breadth of functionality was another area in which the Trillium Software System excelled.
The solution let Oki Data standardize and correct postal records for US and Canadian
customers. Moreover, it could process business data—such as marketing codes—included
in customer records.
The systems analyst at Oki Data said, “It is clear that data quality is an important issue,
and the Trillium Software System is a good tool for helping us ensure quality data. On-site
training and consulting that came with the software solution resulted in faster solution
implementation.” Contd...

LoveLy professionaL university 219