Page 226 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Data Warehousing and Data Mining

notes Oki Data’s color and monochrome LED page printers are the hallmark of its technology
leadership. Providing results comparable to a laser printer’s, Oki Data’s LED printers are
faster and have fewer moving parts. Over 29 years customers have relied on Oki Data’s
proven, reliable products. Oki Data’s five-year warranty on its LED printhead is a testament
to its ability to meet these customer expectations. Oki Data has created a unified customer
view.

rapid roi
Oki Data has wrought substantial value across the business from its investment in the
Trillium Software System. ROI indicators include:
1. Fewer shipping and mailing errors due to verified and corrected addresses

2. Less time spent by users correcting data errors
3. Improved customer service based on more complete customer views
a Bright future
Oki Data’s process has underscored the importance of data quality and impelled the
company to consider data quality as an enterprise-wide issue. The Trillium Software
System’s enterprisewide compatibility and real-time online processing capabilities make it
a candidate for further initiatives within Oki Data. One such initiative is online data quality
processing in conjunction with Oki Data’s e-commerce website.

The data analyst noted, “We keep finding areas beyond the scope of the original project
where a Trillium Software application will solve a new and evolving business need. Going
forward, we see other potential uses of the Trillium Software System to help us better our
data quality.

11.6 summary

l z In this unit you have study query processing and evaluation.
l z A query in a DBMS is a very important operation, as it needs to be efficient.
l z Query processing involves query parsing, representing query in alternative forms, finding
the best plan of evaluation of a query and then actually evaluating it.
l z The major query evaluation cost is the disk access time.

11.7 keywords

Index Scan: Search algorithms that use an index are restricted because the selection condition
must be on the search-key of the index.

Indexing: A database index is a data structure that improves the speed of operations on a database
table.
Join: Join operation is considered as the real power behind the relational database
implementations.
Query Cost: Cost is generally measured as total elapsed time for answering the query.

220 LoveLy professionaL university