Chapter 19
Skill Builders
- Page 545
A Internet bank with more than 10 million customers has asked for your advice on developing procedures for protecting the existence of its data. What would you recommend?
Some of the precautions it should consider are:
- Creating a second site from which the bank's entire operations can run. This site should be in another region
- Mirroring to enable fast recovery if data are lost or a disk cannot be read
- Establishing backup and recovery procedures that are regularly tested
- Developing a physical security plan to prevent unauthorized access to its data center
- Developing a system security plan to prevent unauthorized remote access to its servers
1. A consumer electronics company with a well-respected brand offers a wide range of products. For example, it offers nine world band radios and seven televisions. What data quality strategy would you recommend?
Recommendation because customers might be uncertain as to what features will meet their needs.
2. What data quality focus would you recommend for a regulated natural gas utility?
Confirmation because customers should be certain of their needs (e.g., turn on or off gas), and firm performance variation should be small.
3. A telephone company has problems in estimating how long it takes to install DSL in homes. Sometimes it takes less than an hour and other times much longer. Customers are given a scheduled appointment and many have to make special arrangements so they are home when the installation person arrives. What data might these customers expect from the telephone company and how would they judge data quality?
Performance deviation because customers should be certain of their needs, but the firm has probelms in consistent performance.
1. What level of granularity of sales data would you recommend for an online retailer?
Hourly granularity because business volue will typically vary during the day and also differnt types of customers might shop at different times.
2. What level of data quality completeness might you expect for a university’s student table?
You could expect the student table to have an identifier, full name details, and demographic data. Address, major(s), classes, and so forther will be stored in related tables.
- Page 556
A university has decided that it will e-mail students their results at the end of each semester. What procedures would you establish to ensure that only the designated student opened and viewed the e-mail?
All students should be required to provide an email address, which can only be altered by confirming any change via the prior email address, and a public key encryption system. Each student would have to generate their key pair and notify the university of the public key.
|
This page is part of the promotional and support material for Data Management (fifth edition) by Richard T. Watson
For questions and comments please contact the author
|
Revised: Mon, Sep 5, 2005
