in create data warehouse there are 4 types of securitys .
(1) Physical security. The system equipment and related facilities are in normal operation and the service is timely. its specific
Including the safety of the environment, equipment, computer room, electromagnetic radiation and data media.
(2) Data security. Refers to system-owned and generated data or information, such as underlying information sources
The data in the program, the data obtained when the program is running, etc. are complete, valid, legal to use and not destroyed
or leaked. Specifically, it includes data input, output, access control, encryption, backup and recovery, etc.
(3) Software security. Software is the main platform for data warehouse system work, its security is
Important Contents of Data Warehouse Security . Including operating system , database management system , network software
The integrity and security of software, application software and related materials.
(4) Safe operation. Legal use of system resources, including power, data and media management, machine
Room management, operation management and maintenance.
----
Please provide 2 “best practices” for each of them