12-51)

Referring to the Fitchwood Insurance Company case study at the end of Chapter 9, what types of security issues would you expect to encounter when building a data warehouse? Would there be just one set of security concerns related to user access to the data warehouse, or would you also need to be concerned with security of data during the extracting, cleansing, and loading processes? How would Fitchwood's security have to be different if the data mart were made available to customers via the Internet? Examine the two applications shown in Figures 8-9a and 8-9b. Identify the various security considerations that are relevant to each environment? Research available data quality software. Describe in detail at least one technique employed by one of these tools (e.g., an expert system). Visit some Web sites for open source databases, such as www. postgresql.org and www.mysql.com. What do you see as major differences in administration between open source databases, such as MySQL, and commercial database products, such as Oracle? How might these differences come into play when choosing a database platform? Summarize the DBA functions of MySQL versus PostgreSQL. Compare the concurrency issues that must be dealt with when developing an OLTP system versus a data warehouse. Visit the Web sites of one or more popular cloud service providers that provide cloud database services. Use the table below to map the features listed on the Web site to the major concepts covered in this chapter, you are not sure where to start, try aws.amazon.com or cloud. oracle.com