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 data security during the extracting, cleansing, and loading processes?
The Solution to the Problem
Fitchwood’s data warehouse security
Fitchwood insurance company
The main work of Fitchwood insurance company is selling annuity products, which requires designing a data mart for its organization. Designing the data mart involves the data transaction process (involves files extraction) to move its data to the warehouse. The data transaction process has to deals with some security issues.
The security issues which are expected when building a data warehouse
Executing the program from unknown sources is a dangerous task. Thus, the self-extracting archives could be relatively dangerous as they could release various files and various directions. The extraction of the program thus could itself be a Trojan horse. Thus, based on the choice available, it is relatively better to obtain the archive's ordinary form files. Thus it could result in the extraction of trustworthy tools.
Security concern related to the data warehouse access
Although one essential concern might be that information was secure once the information warehouse was manufactured, the extraction and conversion transform likewise need to be secure.
It can’t be picked up to the information by unapproved clients and consequently modified before being stacked into the information warehouse. Maybe the greatest security hole in this entire methodology is FTP utilization (File Transfer Protocol). One approach to guarantee better information security might be to use a file transfer package with encryption or scramble the documents before the record exchange.
Post a Comment