How does Oracle Database leverage advanced compression techniques, such as Hybrid Columnar Compression (HCC) and Advanced Row Compression, to minimize storage footprint, enhance data retrieval performance, and optimize resource utilization in data warehousing and archival scenarios?