介绍了数据仓库优化和聚集优化的概念，以及数据仓库的建立。
This paper introduced the concepts of data warehouse optimization, aggregation optimization and data warehouse establishment.
本论文中论述了当前主要的数据库、数据仓库优化理论和决策支持系统的关键技术。
This thesis expounds current primary database, data warehouse optimization theory, decision trees and decision support systems critical technologies.
Design Advisor 非常适合为数据仓库优化数据库设计，因为除了关于索引的建议之外，它还可以提供关于MQT、MDC和DPF分区键的建议。
The Design Advisor is well suited for optimizing database design for data warehouses as it provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
维度建模的目标是优化数据仓库数据，以便业务用户轻松查询和分析。
The goal of dimensional modeling is to optimize warehouse data for easy queries and analysis by business users.
维度建模有助于优化数据仓库的查询与分析。
Dimensional modeling helps us optimize our warehouse data for queries and analysis.
本文所包含的信息可用于优化本质上类似TPC - h基准测试的决策支持工作负载和数据仓库工作负载。
The information contained in this article can be used to optimize decision-support and data-warehouse workloads that are similar in nature to the TPC-H benchmark.
在数据仓库之上部署一个强大的报告解决方案，从而管理供应链的业务绩效并进一步优化它。
To manage business performance of the supply chain and to further optimize it, a powerful reporting solution needs to sit on top of the data warehouse.
此外，通过使用行业标准的“星型模式”(star schema)而不是更规范化的表结构，数据仓库经过了优化以实现高效的查询和快速的响应时间。
In addition, by using an industry standard "star schema", rather than a more normalized table structure, the data warehouse is optimized for efficient queries and quick response times.
数据仓库存储大量历史数据，OLAP应用涉及到对大面积历史数据的复杂查询，查询优化是提高OLAP响应速度的关键。
Data warehouse stores volumes of historical data, and OLAP applications involve complex queries on these data. Queries optimization is the key of improving the speed of OLAP response.
数据仓库存储大量历史数据，OLAP应用涉及到对大面积历史数据的复杂查询，查询优化是提高OLAP响应速度的关键。
Data warehouses stores volumes of historical data, and OLAP applications involve complex queries on these data. Since response time should be small, query optimization is critical.
你也许不能事先知道数据仓库的工作量，所以一个数据仓库需要被优化使在面对多种可能性的查询操作时依然能运行良好。
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.
对数据仓库多维视图进行容量估计是数据立方体设计、数据仓库存储规划和实施查询优化的基础。
Size estimation of multidimensional views of data warehouse is a fundamental step for data cube design, warehouse storage planning, and query optimization.
通过对Oracle性能的主动和被动管理，以及优化工具SQLTrace、EXPLAINPLAN和优化器的使用，缩短了数据仓库用户查询响应的时间，提高了查询效率。
By using active and passive management for ORACLE and optimize tools like SQL TRACE EXPLAIN PLAN and ORACLE OPTIMIZER, the query response time is shortened and the efficiency is improved.
通过对Oracle性能的主动和被动管理，以及优化工具SQLTrace、EXPLAINPLAN和优化器的使用，缩短了数据仓库用户查询响应的时间，提高了查询效率。
By using active and passive management for ORACLE and optimize tools like SQL TRACE EXPLAIN PLAN and ORACLE OPTIMIZER, the query response time is shortened and the efficiency is improved.
应用推荐