Question

Discuss the security concerns involved in building a data warehouse.

(Subject: Business information System)

(The question should be well answered)

Answer 1

Some of the security concerns while building a Data Warehouse are:

• There can be biometric measures or other physical Access control mechanism to avoid unauthorized access.
• An employee could be used by intruders to gain access, but if the employee in question is ardently following the specified guidelines it makes a world of difference.
• There should be encryption mechanism for all Data, e.g. AES.
• Securing data in a single place and transit are two different ball games. Here data in transit means the one which is being relayed from transactional databases in real-time to the data warehouse. These transactional databases can be anywhere geographically, therefore using protective protocols, such as SSL or TSL is highly recommended.
• Implementing a trusted witness server is akin to hiring a watchdog that avidly and quite tenaciously keeps vigil on your data access points. It can detect an unwarranted and suspicious attempt at accessing data and generate an alert immediately. This allows the people responsible for the data warehouse security to stop the intruders dead in their tracks.