data warehouse
Centralized business storage
A data warehouse is a large database designed to store and analyze historical data from multiple sources across an organization.
Unlike databases optimized for daily transactions, data warehouses are structured for querying and reporting—pulling together sales figures, customer records, and operational data to identify trends and support business decisions.
The marketing team pulled five years of campaign data from the warehouse.
Organized representational structure
- star schemaDenormalized analytical database structure
- repositoryPlace for storing things
- centralizedConcentrated in one location
- metadataDescriptive information about content
ETL · staging area · partitioning · indexing · normalization · denormalization · hub-and-spoke · federated
Source-to-destination data process
- extractConcentrated derived substance
- transformChange completely in form
- loadCarried weight or burden
- ELTInstructing non-native speakers
ingestion · batch processing · scheduling · orchestration · refresh · full load · CDC · validation
Data analysis for decisions
- BIData-driven decision support
- reportingConveying documented information
- dashboardVehicle control panel
- metricsStandards for assessment
KPIs · drill-down · aggregation · trends · forecasting · visualization · insights · descriptive
Wavelength increase from recession
- SnowflakeTech company or name
- petabytesHuge data measurement unit
- scalabilityCapacity for growth
- columnarShaped like a pillar
cloud · on-premises · retention · archive · partitioning · compression · lakehouse · cold storage
schema
Organized representational structure
- star schemaDenormalized analytical database structure
- repositoryPlace for storing things
- centralizedConcentrated in one location
metadata · ETL · staging area · partitioning · indexing · normalization · denormalization · hub-and-spoke · federated
ETL
Source-to-destination data process
ELT · ingestion · batch processing · scheduling · orchestration · refresh · full load · CDC · validation · reconciliation
business intelligence
Data analysis for decisions
- BIData-driven decision support
- reportingConveying documented information
- dashboardVehicle control panel
metrics · KPIs · drill-down · aggregation · trends · forecasting · visualization · insights · descriptive · predictive
Redshift
Wavelength increase from recession
- SnowflakeTech company or name
- petabytesHuge data measurement unit
- scalabilityCapacity for growth
columnar · cloud · on-premises · retention · archive · partitioning · compression · lakehouse · cold storage · appliance
- techsoftware, hardware, code, coding, programming
- data sciencealgorithm, machine learning, dataset, model, analytics
- data storagehard drive, hard drives, backup, gigabyte, flash drives
- IT Infrastructurecloud computing, virtual machine, server, VM, router
- IT systemssoftware, server, hardware, servers, databases
- Business TechnologyERP, CRM, SAP, Salesforce, databases
data warehousepoint-of-sale system
Retail transaction processing equipment
data, warehouse, database, warehousing, warehoused, databank, data analysis, warehouser, datasets