AI Dictionary › Fondamenti AI
A data warehouse is a centralized database built for analysis: it gathers historical, consolidated data from all company systems and organizes it into structures optimized for complex queries. If the operational database keeps the business running minute by minute, the warehouse helps you understand it: sales by quarter, trends, comparisons.
A data warehouse is a centralized database built for analysis: it gathers historical, consolidated data from all company systems and organizes it into structures optimized for complex queries. If the operational database keeps the business running minute by minute, the warehouse helps you understand it: sales by quarter, trends, comparisons.
Data arrives through ETL or ELT processes, gets modeled in analysis-friendly schemas (like the star schema, with fact and dimension tables) and is stored in columnar format, which makes aggregations over millions of rows extremely fast. Modern cloud warehouses, Snowflake, BigQuery, Redshift, separate storage from compute and scale on demand.
In AI the warehouse is the source of quality tabular data: it feeds predictive models, provides the business metrics used to evaluate the impact of AI systems and, with text-to-SQL, becomes queryable in natural language through LLMs that translate questions into queries. Beyond AI it has been the heart of business intelligence and reporting for over thirty years.
The concept was articulated by Barry Devlin and Paul Murphy in a 1988 IBM paper describing the business data warehouse; Bill Inmon turned it into a discipline with his 1992 book Building the Data Warehouse, followed by Ralph Kimball with an alternative modeling approach in 1996. The name says it all: a warehouse where data is stored in orderly fashion, ready to be picked.
Un data warehouse è un database centralizzato progettato per l'analisi: raccoglie dati storici e consolidati da tutti i sistemi aziendali e li organizza in strutture ottimizzate per interrogazioni complesse. Se il database operativo serve a far funzionare il business minuto per minuto, il warehouse serve a capirlo: vendite per trimestre, trend, confronti.
I dati arrivano tramite processi ETL o ELT, vengono modellati in schemi pensati per l'analisi (come lo schema a stella, con tabelle dei fatti e delle dimensioni) e conservati in formato colonnare, che rende velocissime le aggregazioni su milioni di righe. I warehouse cloud moderni, Snowflake, BigQuery, Redshift, separano storage e calcolo e scalano su richiesta.
Nell'AI il warehouse è la fonte dei dati tabellari di qualità: alimenta i modelli predittivi, fornisce le metriche di business con cui valutare l'impatto dei sistemi AI e, con la text-to-SQL, diventa interrogabile in linguaggio naturale tramite LLM che traducono le domande in query. Fuori dall'AI è il cuore della business intelligence e del reporting da oltre trent'anni.
Il concetto fu articolato da Barry Devlin e Paul Murphy in un paper IBM del 1988 che descriveva il business data warehouse; a renderlo disciplina fu Bill Inmon con il libro Building the Data Warehouse del 1992, seguito da Ralph Kimball con un approccio alternativo alla modellazione nel 1996. Il nome dice tutto: un magazzino (warehouse) dove i dati vengono immagazzinati ordinatamente, pronti per essere prelevati.
From our network
Magellano GPS — Fleet Tracking Made Simple
Real-time GPS tracking, remote engine lock, fuel and CO₂ reporting for your fleet.
Visit magellanogps.com →From the Agora Intelligence blog
📱 Download the Android app (beta) iOS coming soon
Say what you mean. Get what you need.
Grace Certified — the AI coach that trains and certifies your prompt engineering — by Agora Intelligence.