contains both detailed and summarized data for a number of years and is used for analysis rather than in real time
very large databases containing detailed and summarized data for a number of years that are used for analysis
separate from production database, included historical and summarized data, control risk: data isn't the same as production data; update periodically rather than in real time