Data warehouses are designed around major subject areas (like customers, sales, products) rather than business applications. They contain historical data in a consistent format and are read-optimized for analysis. They are not updated by end users, use consistent naming conventions, and contain historical data rather than just current data.