Large scale data warehouses are considered in addition to single service data marts, and the unique data requirements are mapped out. 除了单个服务数据集市,还考虑了大规模的数据仓库,并制定了惟一性数据需求。
Up until this point we have looked at methods of disparate database reporting other than data marts or warehouses. 到目前为止,我们已经检查了不同数据库报告的各种方法,但专用数据栈和数据仓库除外。
Data about what source systems were used to populate the data warehouse, marts, and cubes 用来填充数据仓库、数据集市和多维数据集的源系统的相关信息
This pattern is different from standard information integration patterns used to build data warehouses or data marts. 此模式与用于构建数据仓库或数据集市的标准信息集成模式不同。
According to the JOLAP API specification, you would use the classes in the resource package of the API to connect to JOLAP-enabled services such as business intelligence servers and data marts. 根据JOLAPAPI规范,可以使用该APIresource包中的类连接到支持JOLAP的服务,例如商业智能服务器和数据集市。
Since the late1990s, data federation has emerged as a distinct approach from the centralized approach that data marts and warehouses had been using. 自20世纪90年代后期,数据联合已经作为与集中方法截然不同的一种方法而出现了。在分散方法中,使用了数据市场(mart)和仓库。
In this model, the business data warehouse is the collection of data repository databases ( module), and the data marts are the databases from the data mart tier. 在该模型中,业务数据仓库是数据存储库数据库(模块)的集合,而数据集市则是数据集市层中的数据库。
The library of Design Studio SQL operators provides data flow and control flow designs to cover data operations that are typically needed to move data from data sources to populate tables in OLAP data marts. DesignStudioSQLoperators的库提供了数据流和控制流设计,可以控制将数据从数据源移动到OLAP数据市场中的表所需的数据操作。
Design data flow process to populate OLAP data marts. 设计数据流过程来填充OLAP数据市场。
Design and implement OLAP data marts. 设计和实现OLAP数据市场。
The warehouse architecture will determine or be determined by the locations of the data warehouses and data marts themselves, and where the control resides. 仓库架构将决定数据仓库和数据集市本身的位置,以及控制所驻留的位置,或者反之。
The data mart tier contains all the data marts, which are subsets of the data repository module, made simple enough for specific groups of end users to use in their data analysis activities. 数据集市层包含所有的数据集市,这些数据集市是数据存储库模块的子集,以便特定的终端用户组在其数据分析活动中使用起来足够简单。
Otherwise, the interconnected data marts and business-wide distributed data warehouse are more practical choices for businesses with a wide geographic distribution. 否则,对于在地理上广泛分布的业务而言,互连的数据集市和业务范围的分布式数据仓库就是更加实用的选择。
Included inside this pattern are the SQL Warehousing tools for creating and modifying physical models, control flows, and data flows of the target data marts. 此模式中包含用于创建和修改目标数据集市的物理模式、控制流和数据流的SQL仓库工具。
In a well structured BI system, the data warehouse serves as a single source for multiple data marts. 在结构良好的BI系统中,数据仓库充当多个数据集市的一个源。
This pattern describes the integration between MDM systems and data warehouses and data marts, where these systems are downstream systems and are not providing updates back to the MDM system. 此模式描述MDM系统与数据仓库和数据集市之间的集成,这些系统是下游系统而且不向MDM系统返回更新。
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逻辑将数据从一个数据仓库转移和转换到更小的一些数据集市。
A typical data integration architecture involves data from various source systems being extracted, transformed, and loaded ( ETL) into data warehouses, marts, and cubes. 典型的数据集成架构把来自各个源系统的数据提取、转换和装载(ETL)到数据仓库、数据集市和多维数据集中。
Historical reports: These reports use historical data pulled from the data marts to identify trends and aggregate information. 历史报告:这些报告使用来自数据仓库的历史数据,以识别趋势并收集信息。
Since warehouse end users interact directly with data marts, the data mart modeling is one of the most effective tools in capturing end-user business requirements. 因为仓库终端用户直接与数据集市进行交互,所以数据集市的建模是捕获终端用户业务需求的最有效工具之一。
However, many data marts in a data warehouse do not necessarily need that much historical data. 但是,数据仓库中的许多数据集市都不一定需要那么多的历史数据。
A typical OLAP service usually starts from one or more specifically designed data marts. 典型的OLAP服务常常源自一个或多个专门设计的数据市场。
As the tulip trades increased, regular marts were set up on the Stock Exchange of Amsterdam and other towns. 当郁金香交易开始频繁,大家就在阿姆斯特丹股票交易所和一些城镇设立了固定的市场进行买卖。
Such data is often stored in data warehouses and data marts specifically intended for management decision support. 这些资料通常被储存于资料仓储和资料超市中,并特别准备为管理决策提供支援。
The pattern for data marts is similar. 数据集市的模式都是相似的。
Data Deliveryis the set of processes that enable end users and their supporting IS group to build and manage views of the data warehouse within their data marts. 数据交付是一套能够保证终端用户和决策支持群组构建和管理数据仓库视图的过程。
Aberdeen Group in Boston called data marts "a kind of best practice of data warehousing". 波士顿的Aberdeen集团将数据集市叫做数据仓库一种最佳的实践。
They should welcome the opportunity that data marts offer to become more directly involved in data manipulation activities. 他们应欢迎数据集市在数据管理层活动中提供更直接参与的机会。
The experiences of international trade marts in Dallas and Taipei are among those considered. 美国达拉斯和台湾省台北发展国际商品展销交易中心的经验值得我们思考。