System management: data management, data warehouse security, system and database backup and recovery, and so on.
系统管理：数据管理、数据仓库安全性、系统和数据库的备份和恢复，等等。
So when information from the staging database is moved to the data warehouse through stored procedures, there is a gap in the lineage.
因此当来自临时数据库的信息通过存储过程被转移到数据仓库中时，这个沿袭出现了一个断点。
Before investing a lot of time and effort in implementing your warehouse database, it is a good idea to validate your model with the user, especially data mart models.
在投入大量时间和精力实现仓库数据库之前，与用户一起验证模型是一个很好的想法，特别是数据集市模型。
The physical data model is tightly related to the database system and data warehouse tools that you will use.
物理数据模型是与数据库系统以及您将使用的数据仓库工具紧密相关的。
A data warehouse database — especially a data mart — is very near to the end user, and it usually does not have fixed queries.
数据仓库的数据库——特别是数据集市——与终端用户非常接近，它通常不具有固定的查询。
The following script can be edited and run on your warehouse database to generate a script to enable row compression across all AW created fact tables.
以下脚本可被编辑并在您的数据仓库数据库上运行，来生成一个脚本跨所有AW创建的事实表启动行压缩。
There are many topics not covered here that are also fundamental in delivering a good data warehouse solution, including system and database design, administration, performance tuning, and others.
有许多主题未在本文中进行介绍，但它们同样是交付良好数据仓库解决方案的基础，包括系统和数据库设计、管理、性能调优等。
Circular logging is typically used in data warehouse environments where the need to recover a database is just a matter of restoring a database image.
循环日志记录通常在数据仓库环境中使用，在该环境中，恢复数据库需要的只是恢复数据库映象的问题。
These orders, in the form of XML documents, are routed to the global warehouse, while customer information is maintained in a local database table called CUSTOMERS.
这些XML文档格式的订单被路由到全球仓库，而客户信息是在一个名为CUSTOMERS的本地数据库中维护的。
When automatic statistics profiling is enabled, information about database activity is collected and stored in a query feedback warehouse.
当启用自动统计信息配置时，数据库活动的有关信息被收集并存储在查询反馈仓库中。
To simplify the sample scenarios in this article, you'll use a single DB2 database to store both the operational data and warehouse data.
为了简化本文中的示例场景，您将使用单个DB2数据库来存储操作型数据和仓库数据。
Unfortunately, developing a detailed database design for such a warehouse can be challenging.
但糟糕的是，为这种数据仓库开发详细的数据库设计是很困难的。
The inventory system needs to be composed of a series of calls to existing backend databases, such as a local store database and a central warehouse database.
库存系统需要包含一系列对现有后端数据库(如本地商店数据库和中央仓库数据库)的调用。
The DB2 database server contains the structured and unstructured (most often text) warehouse data.
DB 2数据库服务器，其中存储结构化和非结构化(常常是文本)仓库数据。
With InfoSphere Warehouse you analyze the data from directly within the database.
通过InfoSphere Warehouse，您可以在数据库内直接分析数据。
With the InfoSphere Warehouse data Exploration view you can browse samples of database tables, browse the contents of large text columns, and determine the average length of text strings.
在InfoSphere Warehouse的Data Exploration视图中，可以浏览数据库表的示例、浏览大型文本列的内容和判断文本字符串的平均长度。
The report metadata from Cognos BI, ETL job metadata from DataStage, and the warehouse metadata from Database, need to be mapped to each other to enable traceability through lineage reports.
来自CognosBI的报告元数据、来自DataStage 的ETL作业元数据和来自 DataStage 的仓库元数据需要相互映射，以便能够通过沿袭报告跟踪它们。
InfoSphere Warehouse provides data mining functionality directly in the underlying DB2 database where the data resides.
InfoSphere Warehouse直接在存储数据的底层DB 2数据库中提供数据挖掘功能。
InfoSphere Warehouse does not pull any data out of the database, but rather USES built-in functions and stored procedures to do the analytics.
InfoSphereWarehouse并不从数据库中提取任何数据，而是使用内置功能和存储过程来进行分析。
For example, an Oracle database, either Online Transaction Processing (OLTP) or a data Warehouse application, can benefit when using large pages.
例如Oracle数据库，无论是联机事务处理(OLTP)或者数据仓库应用程序，都可以从大型页面的使用中获益。
Before you import the file containing your security model, import the file containing your cube model into the InfoSphere Warehouse control database using the Administration Console.
在导入包含安全模型的文件之前，使用Administration Console将包含多维数据集模型的文件导入InfoSphereWarehouse控制数据库。
The InfoSphere Warehouse installer sets up the configuration needed to connect to the control database.
InfoSphereWarehouse安装程序设置连接到控制数据库所需的配置。
This database is used as the metadata repository for the InfoSphere Warehouse applications where the metadata related to common configurations, SQL Warehousing, and Cubing Services are stored.
该数据库用作InfoSphereWarehouse应用程序的元数据存储库，其中存储通用配置、SQLWarehousing和CubingServices相关的元数据。
Warehouse data modeling vs. operational database modeling.
仓库数据的建模与操作数据库的建模。
Solution implementation cycle: the data warehouse implementation includes the target repository and the data mart database, as well as ETL process implementation.
解决方案实现周期(Solution implementation cycle)：数据仓库实现包括目标存储库和数据集市数据库，以及ETL过程实现。
The INVENTORY and WAREHOUSE tables on the same database are populated with data as follows.
同一数据库上的INVENTORY和warehouse表由以下数据填充。
The tables INVENTORY and WAREHOUSE are non-XML relational tables located in a DB2 9 database.
表inventory和WAREHOUSE是非xml关系表，位于DB 29数据库。
For testing simplicity, the target data warehouse database is also configured to be TPoX.
为简化测试，目标数据仓库数据库也配置为TPoX。
When this table is loaded into the target warehouse table customer, which is in the stores_demo database, the target table might have more or fewer columns than the customer_trans table.
当此表加载到目标数据仓库表customer中，该表位于数据库 stores_demo 中，目标表可能会具有比表 customer_trans更多或者更少的列。
IWA is an exciting breakthrough-combining new data warehouse technology with traditional Informix relational database servers-that results in very fast performance.
IWA是一个令人振奋的突破，它将新的数据仓库技术和传统的Informix关系数据库服务器相结合，产生一种非常快的性能。
应用推荐