Site LogoSite Logo
  • 🗃️ read_me
  • backend
    • api
    • canal
    • data-systems
      • compute_storage_separation_architecture
      • data_compute_platform
      • data_federation
      • data_lakehouse
      • data_lakes
      • data_models
      • data_processing_architectures
      • data_skew
      • data_warehouse_naming_conventions
      • data_warehouses
      • databricks_cluster_config
      • ddia_chapter_1
      • delta_lake
      • extract_transform_load
      • gemini_state_backend
      • hot_cold_storage
      • htap
      • materialization
      • materialized_view
      • olap
      • olap_operations
      • oltp
      • oltp_vs_olap
      • pangu
      • snowflake_schema
      • star_schema
      • storage_computing_architectures
      • storage_disaggregation_architecture
      • time_series_database
      • view
    • databases
    • frameworks
    • hologres
    • integration
    • languages
    • media
    • os
    • sql
    • streaming
  • concepts
  • dump
  • finance
  • frontend
  • infrastructure
  • skating
  • backend
  • data-systems
  • data_warehouses

🗓️ 06032025 1752

DATA WAREHOUSES

pros​

  • Business intelligence (BI)
  • Analytics
  • Structured & clean data
  • Predefined schemas

cons​

  • No support for semi / unstructured data
  • Inflexible schemas
  • Struggled with volume / velocity upticks
  • Long processing times

References​

  • https://www.youtube.com/watch?v=myLiFw9AUKY&t
Previous
data_warehouse_naming_conventions
Next
databricks_cluster_config
  • pros
  • cons
  • References