The schema of a data warehouse is not identical to the transactional schema.
数据仓库的模式与事务性模式不同。
An OLAP solution is sometimes misleadingly called a data warehouse solution.
OLAP解决方案有时候被错误地称为数据仓库解决方案。
Consider a company with the head office in New York and a data warehouse in San Jose.
考虑一家公司的总部在纽约,而数据仓库在圣何塞。
This is a list of roles; one person can have multiple roles in a data warehouse project.
这是一个角色列表;一个人在数据仓库项目中可以具有多重角色。
Unlike single-subject data marts, a data warehouse encourages deeper levels of analysis.
有别于单一目的的datamarts数据仓库支持更深层次的分析。
The data in a data warehouse is cleansed and scrubbed during the data transformation processes.
在数据转换过程中,清洗并清理了数据仓库中的数据。
This article is written for it professionals who want to know how to deliver a data warehouse solution.
本文是为需要知道如何交付数据仓库解决方案的IT专业人士撰写的。
Matching up grain levels when building comparisons is a critical concept in designing a data warehouse.
在构建比较时匹配粒度级别是数据仓库设计中的关键概念。
Stay tuned for Part 2, when we’ll look at how to use the Design Advisor in a data warehouse environment.
请继续关注第 2部分,到时候我们将研究如何在数据仓库环境中使用Design Advisor。
To succeed at building a data warehouse we must work closely with the owners of the legacy data sources.
要成功地构建数据仓库,我们必须与遗留数据源的所有者密切协作。
The set of combined business objectives in a data warehouse project can help determine the project scope.
数据仓库项目中的联合业务对象集可以帮助确定项目范围。
My last column discussed why and how we use dimensional modeling to organize the data in a data warehouse.
我在上一专栏中讨论了为何以及怎样利用维度建模,在数据仓库中组织数据。
There is often a huge amount of data that needs to be processed regularly in a data warehouse environment.
数据仓库环境通常要定期处理大量数据。
Understanding the customer? S data environment is one of the most important tasks in a data warehouse project.
理解客户的数据环境是数据仓库项目中最重要的任务之一。
An IBM customer in the industrial sector implemented a data warehouse without employing data quality analysis.
工业领域的一家IBM客户实现了一个数据仓库,但是没有进行数据质量分析。
My last two columns discussed why and how we use dimensional modeling to organize the data in a data warehouse.
我的上两个专栏讨论了我们使用维度建模来组织数据仓库中的数据的原因和方式。
For the purpose of this discussion, let's assume that you're building a data warehouse for the entire enterprise.
出于本文的目的,让我们假设您将为整个企业构建一个数据仓库。
Data Volume: There is often a huge amount of data that needs to be processed regularly for a data warehouse environment.
数据量:对于一个数据仓库环境,常常需要对巨量的数据进行常规性的处理。
The Informix warehouse Accelerator really raises the performance level that we can get and expect from a data warehouse.
InformixWarehouse Accelerator提高了我们可以得到的性能水平以及我们期待从数据仓库中获得的性能水平。
It doesn't matter whether you use a data warehouse, a cube data structure, or a data mart in your information architecture.
您在信息架构中是使用数据仓库、多维数据结构还是数据集市并不重要。
The approach generally fits well with a data warehouse system since all data is in one table without the need for table joins.
这种方法通常比较适合数据仓库系统,因为所有数据都在一张表里,不需要做表连接。
One interesting example is called Hive, which is a data warehouse infrastructure with its own query language (called Hive QL).
一个有趣的示例称为Hive,它是一个具有自己特定查询语言(称为HiveQL)的数据仓库基础结构。
Once a data warehouse is implemented and your customers begin using it, they will often generate new requests and requirements.
一旦实现了数据仓库,且客户开始使用它,他们就常常会生成新的请求和需求。
By definition, a data mart is a subset of a data warehouse designed for a specific group of users or a particular subject area.
根据定义,数据市场是数据仓库的一个子集,是专门针对特定的用户群或特定的主题领域设计的。
Summary tables are required in a data warehouse for fast query processing and to allow users to drill up and down into the facts.
在数据仓库中需要汇总表,来实现快速查询,并允许用户在事实表中钻入钻出。
The recent transactions table represents a table in an operational data store, essentially a data warehouse with only recent data.
Recenttransactions表代表运营数据存储中的一个表,这种数据存储实际上是只有最近数据的一个数据仓库。
Because of the iterative nature of a data warehouse project, the project scope may only cover the most important or urgent subject areas.
由于数据仓库项目的重复本质,项目范围可能仅仅包含最重要或紧急的主题领域。
Informix 11.7 contains an exciting new release of this feature for those of us who have been implementing Informix as a data warehouse server.
Informix 11.7包含一个新版本,其中的特性令我们这些将Informix作为一个数据仓库服务器实现的用户很兴奋。
Jazz provides a data warehouse, as well as an extensible mechanism for gathering information to store in the data warehouse at periodic times.
Jazz提供了数据仓库,以及用于收集信息以按定期时间在数据仓库中进行存储的可扩展机制。
StockCheck is a fairly typical data mart population job, using ETL logic to move and transform data from a data warehouse to smaller data marts.
StockCheck是一个相当典型的数据集市填充作业,它使用ETL逻辑将数据从一个数据仓库转移和转换到更小的一些数据集市。
应用推荐