1. Workload
    工作量
Data warehouses are designed to accommodate ad hoc queries.
数据仓库被设计用来适应即席查询。
You might not know the workload of your data warehouse in advance, so a data warehouse should be optimized to perform well for a wide variety of possible query operations.
你也许不能事先知道数据仓库的工作量,所以一个数据仓库需要被优化使在面对多种可能性的查询操作时依然能运行良好。
OLTP systems support only predefined operations.
OLTP系统仅仅支持预先定义好的操作。
Your applications might be specifically tuned or designed to support only these operations.
你的应用程序可能已经被特定地调整过或者设计成仅支持这些操作。
2.Data modifications
   数据更新
A data warehouse is updated on a regular basis by the ETL process (run nightly or weekly) using bulk data modification techniques.
数据仓库定期地通过ETL过程(每个晚上或者每周运行)来更新,ETL过程使用大块的数据更新技术。
The end users of a data warehouse do not directly update the data warehouse.
仓库的最终用户并不直接更改数据仓库。
In OLTP systems, end users routinely issue individual data modification statements to the database.
在OLTP系统中,最终用户日常性地向数据库发布个人数据更新的语句。
The OLTP database is always up to date, and reflects the current state of each business transaction.
OLTP数据库总是在更新中,并且反映了每个商业事务的当前状态。
3. Schema design
    模式设计
Data warehouses often use denormalized or partially denormalized schemas (such as a star schema) to optimize query performance.
数据仓库通常使用非规范化或者部分非规范化模式(比如星型模型)来优化查询性能。
OLTP systems often use fully normalized schemas to optimize update/insert/delete performance, and to guarantee data consistency.
OLTP系统通常使用完全的规范化的模式来优化更新/插入/删除操作的性能,并且保证数据的一致性。
4. Typical operations
    典型操作
A typical data warehouse query scans thousands or millions of rows.
典型的数据仓库查询会浏览成千上万的数据行。
For example, "Find the total sales for all customers last month."
比如,“查找针对上个月所有消费者的销售总额”。
A typical OLTP operation accesses only a handful of records.
典型的OLTP操作仅访问少数的记录
For example, "Retrieve the current order for this customer."
比如,“检索某位顾客当前的订单”
5. Historical data
    历史数据
Data warehouses usually store many months or years of data.
数据仓库通常存储大量月份或年份的数据。
This is to support historical analysis.
这是用来支持历史分析
OLTP systems usually store data from only a few weeks or months.
OLTP系统通常存储几个星期或月的数据。
The OLTP system stores only historical data as needed to successfully meet the requirements of the current transaction.
OLTP系统存仅当需要的时候才存储历史数据来成功的实现当前事务的需求。