A data warehouse is characterized by four key properties: subject-oriented (organized by major subject areas), integrated (data from multiple sources unified), non-volatile (once loaded, data doesn't change), and time-variant (data reflects historical changes over time). These distinguish it from operational databases that are volatile and current-focused.