Skip to content

Data

Data Warehouse

A central store optimised for analysing large volumes of data across an organisation, separate from the systems that run it.

A data warehouse is a database built for analysis rather than for running an application. It consolidates data from many sources into one place and is optimised for the kind of large, complex queries reporting and analytics need. The opposite of the fast, small transactions an application database is tuned for.

Keeping the two separate is deliberate: running heavy analytical queries against your live production database competes with the application for resources and slows both. The warehouse gives analysts a place to ask expensive questions without affecting the systems customers are using.

Related terms

Working out whether you need Data Warehouse?

Definitions are the easy part. If you are trying to decide whether Data Warehouse belongs in your system, describe what you are building and a senior engineer will give you a straight answer, including when the answer is that you do not need it.

  1. 01A senior engineer reads it. Not a form queue, and not an account manager.
  2. 02We reply either with questions or with a straight answer that we are not the right fit.
  3. 03If it looks like a fit, a technical call with the person who would actually run the delivery.
  4. 04Then scope, effort and risk in writing, before anyone signs anything.
Or book a free consultationPick a time that suits you. No pitch, no obligation.Prefer email? support@yarqat.com

Two fields required. We reply to real enquiries. No list, no sequence.