The approach generally fits well with a data warehouse system since all data is in one table without the need for table joins.
这种方法通常比较适合数据仓库系统，因为所有数据都在一张表里，不需要做表连接。
This requires that the data from the transactional system be transformed before being loading into the warehouse table.
这需要在将来自事务系统的数据加载到数据仓库表中之前，对其进行转换。
System management: data management, data warehouse security, system and database backup and recovery, and so on.
系统管理：数据管理、数据仓库安全性、系统和数据库的备份和恢复，等等。
The physical data model is tightly related to the database system and data warehouse tools that you will use.
物理数据模型是与数据库系统以及您将使用的数据仓库工具紧密相关的。
Are the server system and network robust enough to handle the expected warehouse data flow?
服务器系统和网络是否健壮得足以处理期望的仓库数据流？
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.
有许多主题未在本文中进行介绍，但它们同样是交付良好数据仓库解决方案的基础，包括系统和数据库设计、管理、性能调优等。
ETL is often used to extract data from the source system, transform data into a compatible format with the target system, and then load into a target system, such as a data warehouse or data mart.
etl常用于从源系统中提取数据，将数据转换为与目标系统相兼容的格式，然后将其装载到目标系统中，例如数据仓库或者数据市场。
If you're working on a multi-terabyte data warehouse, the test system may need to be smaller.
如果您使用的是几千兆的数据仓库，则测试系统可能需要小一些。
These attributes were mapped to source system logical data models in order to ensure that attributes were available in the source systems that were to feed the data warehouse.
这些属性被映射到源系统的逻辑数据模型，从而确保能够在源系统中找到提供给数据仓库的属性。
Analytics integration with data warehouses: First, an MDM System provides master data to the data warehouse for accuracy improvements in the data warehouse environment.
与数据仓库的分析集成：首先，MDM系统把主数据提供给数据仓库，提高数据仓库环境的精确性。
In a well structured BI system, the data warehouse serves as a single source for multiple data marts.
在结构良好的BI系统中，数据仓库充当多个数据集市的一个源。
Until now, the organization's transactional system has had to convert XML data to relational data or simply delete it from the warehouse.
以前，组织的事务系统必须把XML数据转换为关系数据，或者从数据仓库中删除它们。
In a second step in this sub-type of the analytical method of use, insight gained in the data warehouse is made actionable by feeding it back to the MDM System for use in the IT landscape.
在这种分析性使用方法的子类型的第二步中，把在数据仓库中发现的信息反馈给MDM系统，以便在IT 领域中使用这些信息。
ETL services support the initial and incremental extract, transform, and load of data from one or more source systems to meet the needs of one or more targets, such as a data Warehouse and MDM system.
ETL服务支持从一个或多个源系统提取、转换和装载数据，从而满足一个或多个目标系统(比如数据仓库或MDM系统)的需要。
They anoint one data warehouse as the system of record or build a new enterprise data warehouse (EDW) from scratch.
企业选择一个数据仓库或者从头创建一个新的企业级数据仓库。
For nearly every data warehouse system I build, I start with a spreadsheet and enter days for the next 10-20 years and the past 10-20 years, depending on how far back data will be loaded.
对于我所构建的每个数据仓库，我都以电子表格开始，然后再依据所需加载的历史数据，来填入下一个10 -20年和过去的10 - 20年的天数。
The system is used for both OLTP and a data warehouse.
该系统可用于OLTP和数据仓库。
Rather than "throwing hardware at the problem" of scaling a system, TwinFin is designed in-balance from the ground up to provide scalable performance for data warehouse and analytics applications.
相比在扩展一个系统时“通过硬件解决问题”，TwinFin旨在从头到尾实现平衡，为数据仓库和分析应用程序提供可扩展性能。
The system, including the schema of the data warehouse, will evolve throughout the project. The implication is that we need to adopt several evolutionary development techniques.
系统，包括数据仓库的方案，将在项目过程中演进。
They could consist of warehouse management systems (WMS), Electronic Data Interchange (EDI), or an enterprise resource planning system.
这些系统可能包含仓库管理系统(WMS)、ElectronicDataInterchange (EDI)或企业资源规划系统。
There are also system actors, external systems that your system interacts with, which in the case of data warehouse projects, would be the legacy data sources that you extract data from.
还有一些系统参与者，它们是与您的系统进行交互的外部系统，在数据仓库项目的例子中，将是您要从中提取数据的遗留数据源。
Consider a situation where data from your transactional system must be moved into the warehouse.
考虑来自事务系统的数据必须移动到数据仓库中的情形。
Just about every business system database and data warehouse has a large number of frequently accessed small tables that would fit on USB jump drives.
每个业务系统数据库和数据仓库经常访问许多非常小的表(往往不超过u盘的容量)。
This is especially important for a data warehouse versus a data conversion to an ERP system.
与向ERP系统进行数据转换相比，这对于数据仓库更重要。
Metadata and its management are the kernel parts of data warehouse system.
元数据及其管理是数据仓库系统的核心部件。
The data model is the nuclear part of the data warehouse system, its quality influences the systematic application result directly and expands performance in the future.
数据建模。数据模型是数据仓库系统的核心部分，它的好坏直接影响到系统的应用效果以及未来扩展性能。
Metadata management system is the core of construction and management and maintenance and use data warehouse system.
元数据管理系统是构建、管理、维护和使用数据仓库系统的核心部件。
This research has the important meaning for newspapering ERP construction, ERP programming, the establishment of newspapering data warehouse system and decision information system.
本研究对报业ERP建设，ERP规划，报业数据仓库系统乃至决策信息系统的建立都有着指导性的意义。
The comprehensive integrated DSS, which composed of data warehouse and OLAP, data mining, model base and knowledge base system, is a more sophisticated form of DSS.
将数据仓库、OLAP、数据挖掘、模型库、知识库系统结合起来形成的综合集成决策支持系统是更高形式的决策支持系统。
The comprehensive integrated DSS, which composed of data warehouse and OLAP, data mining, model base and knowledge base system, is a more sophisticated form of DSS.
将数据仓库、OLAP、数据挖掘、模型库、知识库系统结合起来形成的综合集成决策支持系统是更高形式的决策支持系统。
应用推荐