![](https://csdnimg.cn/release/download_crawler_static/7737591/bg10.jpg)
xvi
Part VI Oracle Database Administration and Development
17 Topics for Database Administrators and Developers
Overview of Database Security .......................................................................................................... 17-1
User Accounts.................................................................................................................................. 17-1
Privilege and Role Authorization.......................................................................................... 17-1
Profiles....................................................................................................................................... 17-3
Authentication................................................................................................................................. 17-3
Encryption........................................................................................................................................ 17-4
Network Encryption................................................................................................................ 17-4
Transparent Data Encryption................................................................................................. 17-4
Oracle Data Redaction.................................................................................................................... 17-4
Access Control ................................................................................................................................. 17-5
Oracle Database Vault............................................................................................................. 17-5
Virtual Private Database (VPD)............................................................................................. 17-6
Oracle Label Security (OLS) ................................................................................................... 17-6
Monitoring ....................................................................................................................................... 17-6
Database Auditing................................................................................................................... 17-6
Oracle Audit Vault and Database Firewall .......................................................................... 17-7
Enterprise Manager Auditing Support................................................................................. 17-7
Overview of High Availability........................................................................................................... 17-7
High Availability and Unplanned Downtime............................................................................ 17-7
Site Failures............................................................................................................................... 17-8
Computer Failures ................................................................................................................... 17-8
Storage Failures........................................................................................................................ 17-9
Data Corruption....................................................................................................................... 17-9
Human Errors......................................................................................................................... 17-10
High Availability and Planned Downtime ............................................................................... 17-11
System and Database Changes ............................................................................................ 17-11
Data Changes.......................................................................................................................... 17-11
Application Changes............................................................................................................. 17-12
Overview of Grid Computing........................................................................................................... 17-12
Database Server Grid.................................................................................................................... 17-13
Scalability ................................................................................................................................ 17-14
Fault Tolerance....................................................................................................................... 17-14
Services.................................................................................................................................... 17-15
Database Storage Grid.................................................................................................................. 17-15
Overview of Data Warehousing and Business Intelligence ....................................................... 17-15
Data Warehousing and OLTP ..................................................................................................... 17-16
Data Warehouse Architecture..................................................................................................... 17-17
Data Warehouse Architecture (Basic) ................................................................................. 17-17
Data Warehouse Architecture (with a Staging Area) ....................................................... 17-17
Data Warehouse Architecture (with a Staging Area and Data Marts)........................... 17-18
Overview of Extraction, Transformation, and Loading (ETL) ............................................... 17-19
Business Intelligence..................................................................................................................... 17-20
Analytic SQL........................................................................................................................... 17-20
OLAP ....................................................................................................................................... 17-20