What is the expected frequency of the data updates in the data warehouse?
数据仓库中数据更新的期望频率是多少?
These logical models are one of the centerpieces of the data warehouse metadata.
这些逻辑模型是数据仓库元数据的核心之一。
Their reports and queries produced by the data warehouse reflected these defects.
这个数据仓库产生的报告和查询反映出了这些缺陷。
The data model plays the role of a guideline, or plan, to implement the data warehouse.
数据模型起到了指导或计划数据仓库的实现的作用。
Data about what source systems were used to populate the data warehouse, marts, and cubes.
用来填充数据仓库、数据集市和多维数据集的源系统的相关信息。
There are two main parts of the reports component: the data warehouse and the reports engine.
报表组件存在两个主要部分:数据仓库和报表引擎。
Give a detailed definition of the reports that you expect to build based on the data warehouse.
给定您期望基于数据仓库所构建的报表的详细定义。
For example, the data warehouse architecture could be physically distributed or centrally managed.
例如,数据仓库架构可以在物理上分布或集中管理。
In a well structured BI system, the data warehouse serves as a single source for multiple data marts.
在结构良好的BI系统中,数据仓库充当多个数据集市的一个源。
You'll see how the data warehouse is effectively deployed into production during the transition phase.
您将会看到在移交阶段,怎样有效地将数据仓库部署到产品环境中。
The data model for the data warehouse was based on the attributes identified during the requirements phase.
这个数据仓库的数据模型基于在需求阶段识别出的属性。
You'll learn more about the operational data and the data warehouse design as you step through each scenario.
学习这些场景时,您将更多地了解运营数据和数据仓库设计。
During the Jazz server install, the data warehouse is initialized, and the pre-defined snapshots are installed.
在Jazz服务器安装期间,将初始化数据仓库,并安装预定义的快照。
Thus, if the data warehouse is used for data mining, a low level of detailed data should be included in the model.
因此,如果数据仓库是用于数据挖掘的,就应该在模型中包含较低细节级(levelof detail)的数据。
Stay tuned for the next article in this series, which covers the data warehouse design and implementation stages.
继续本系列中的下一篇文章,其中将介绍数据仓库的设计和实现阶段。
Ideally, the structure of the data warehouse offers a summary table for any question that business users want to ask.
理想情况下,数据仓库的结构提供一个针对业务用户想问的所有问题的汇总表。
You can use Design Studio's data modeling wizards to create this table (as well as the data warehouse target tables).
可以使用DesignStudio的数据建模向导创建这个表(以及数据仓库目标表)。
Instead of a DataStage job, the data warehouse is now populated by stored procedures STG_TO_DWH, as shown in Figure 2.
与DataStage任务不同的是,数据仓库现在由存储过程STG_TO_DWH填充,如图2所示。
That provides the flexibility we need as new data sources will be added to the data warehouse along with new locales.
这样,在将新数据源与新的地区一起添加到数据仓库时,我们便有了所需的灵活性。
When you use data models to capture business requirements, you are already doing some part of the data warehouse design work.
当使用数据模型捕获业务需求时,您就已经完成了数据仓库设计中的部分工作。
Part 2 covers additional details related to MQTs, MDCs, and DPF partitioning keys, focusing on the data warehouse environment.
第2部分将介绍关于MQT、MDC和DPF分区键的更多细节,重点分析数据仓库环境。
This will start another cycle of development, continuing the iterative and evolutionary process of building the data warehouse.
这将启动另一开发周期,继续数据仓库构建的迭代和进化过程。
No matter which data analysis approach you take, the data warehouse remains a vital foundation for leveraging information assets.
无论采用哪种数据分析方法,数据仓库都仍然是利用信息资产的重要基础。
A less disruptive way to accommodate such changing business needs is to use one or more XML columns in the data warehouse schema.
对于适应业务需求的变化,一种破坏性比较低的方法是在数据仓库模式中使用一个或多个xml列。
The end users might not be the decision makers, but they provide valuable information about the usability of the data warehouse.
终端用户可能不是决策人,但他们提供关于数据仓库可用性的宝贵信息。
Most of the information required to generate queries against the data warehouse tables is stored in the cube model-related objects.
生成针对数据仓库表的查询所需的大多数信息存储在多维数据集模型相关对象中。
(Note that by "read-only", we mean that once data is written to the data warehouse, that data is not modified by subsequent readers).
(请注意,这里所说的“只读”是指数据一经写入数据仓库,后续的读取者就不能修改它)。
So when information from the staging database is moved to the data warehouse through stored procedures, there is a gap in the lineage.
因此当来自临时数据库的信息通过存储过程被转移到数据仓库中时,这个沿袭出现了一个断点。
Solution planning: In this step, you plan the solution and identify the data warehouse infrastructure, personnel, and resources needed.
解决方案计划(Solution planning):本步中,您计划解决方案,并指定所需的数据仓库基础设施、人员和资源。
Jazz provides a data warehouse, as well as an extensible mechanism for gathering information to store in the data warehouse at periodic times.
Jazz提供了数据仓库,以及用于收集信息以按定期时间在数据仓库中进行存储的可扩展机制。
应用推荐