OLAP是大多数数据仓库解决方案中使用的报告实现之一。
OLAP is one of the reporting implementations in most data warehouse solutions.
OLAP服务应该被看作数据仓库解决方案的一部分,参见图1。
OLAP services should be considered as a part of data warehousing solution as shown in figure 1.
OLAP解决方案有时候被错误地称为数据仓库解决方案。
An OLAP solution is sometimes misleadingly called a data warehouse solution.
本文是为需要知道如何交付数据仓库解决方案的IT专业人士撰写的。
This article is written for it professionals who want to know how to deliver a data warehouse solution.
OLAP报告在当今非常流行,它广泛地用作向顾客提供数据仓库解决方案的基础。
OLAP reporting is so popular today that it is widely used as the basis for presenting the power of data warehouse solutions to customers.
下图展示了作为数据仓库解决方案提供者的您在一个成功的项目期间与客户要进行的主要交互。
The following diagram shows the main interactions that you, as the provider of a data warehouse solution, will have with your customer over the course of a successful project.
数据仓库解决方案的客户互动过程与以某种方式进行的其他IT解决方案的相似。
The customer engagement process of a data warehouse solution is similar to that of other IT solutions in some ways.
这个模型提供了一个便捷的方式来衡量你的数据仓库解决方案,现在在哪,下一步该怎么做。
The model provides a quick way for you to gauge where your data warehousing initiative is now and where it needs to go next.
一个成功的数据仓库解决方案的基础就是灵活的设计,这种设计可以适应不断变化的业务数据。
The basis of a successful data warehousing solution is a flexible design which can adapt to changing business data.
解决方案部署(Solution deployment):将新的数据仓库解决方案移至生产环境中。
Solution deployment: The new data warehouse solution moves into a production environment.
然而,数据仓库解决方案具有一些重要的不同,包括强大的面向业务的数据、进程的多层迭代以及更多终端用户的涉及。
However, the data warehouse solution has some important differences, including: a strong orientation toward business data, multi-level iteration of the process, and more end-user involvement.
有许多主题未在本文中进行介绍,但它们同样是交付良好数据仓库解决方案的基础,包括系统和数据库设计、管理、性能调优等。
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数据清洗转换进行了介绍,主要阐述了数据质量问题在数据仓库解决方案中的重要地位、数据质量的分类,同时对本课题中的ETL的设计和实现进行了描述。
And introduce the ETL, illustrate the importance of data quality in this subject, and the classification of data quality, and also illustrate the design and implement of ETL.
对此问题的解决方案是数据仓库。
XQuery提供了一种解决方案,通过在多个数据仓库之间建立基于查询的连接来帮助OLAP。
XQuery offers a solution to assist OLAP by providing a query-based link between multiple data warehouses.
在数据仓库之上部署一个强大的报告解决方案,从而管理供应链的业务绩效并进一步优化它。
To manage business performance of the supply chain and to further optimize it, a powerful reporting solution needs to sit on top of the data warehouse.
一种更好的解决方案是将两种类型的数据加以分离:例如,可将常用、最近使用的信息库事务存储在数据仓库中,而将旧信息存储在磁带上。
A better solution is to separate the two types of data: frequently used, more recent credit card transactions are stored in a warehouse while older information is stored on tapes, for example.
清洁解决方案涉及的数据量通常很大,因此,清洁处理通常在数据仓库项目中进行,且最好用于ETL操作过程中。
The amount of data that is involved in a cleansing solution is usually large, so such an exercise is undertaken typically during data warehouse projects, and is best used during an ETL operation.
解决方案计划(Solution planning):本步中,您计划解决方案,并指定所需的数据仓库基础设施、人员和资源。
Solution planning: In this step, you plan the solution and identify the data warehouse infrastructure, personnel, and resources needed.
解决方案建议(Solution proposal):基于客户需求,您需要为数据仓库项目或解决方案提出建议。
Solution proposal: Based on the customer requirements, you create proposals for a data warehousing project or solution.
解决方案实现周期(Solution implementation cycle):数据仓库实现包括目标存储库和数据集市数据库,以及ETL过程实现。
Solution implementation cycle: the data warehouse implementation includes the target repository and the data mart database, as well as ETL process implementation.
介绍了数据仓库和联机分析处理,针对教育数据统计分析困难的现状提出了教育决策支持系统的一个解决方案。
Introduces technology about data warehouse and on-line analysis and supplies a solution of decision support system based on education.
从应用角度来看,数据仓库是一种解决方案,但不仅仅只是技术和产品。
As for application, DW is not only a technology and production, but a kind of project.
以包钢营销分析数据仓库的构建为背景,对其主题确定、数据结构、数据处理技术、元数据管理提出了解决方案。
Based on the construction of marketing decision analysis data warehouse, a solution of determining subjects, designing data structures, processing data and managing metadata is put forward.
本文主要研究基于数据仓库技术的决策支持系统的解决方案。
A scheme of DSS based on DW is mainly studied in this paper.
在为建立医院数据仓库而进行的数据预处理的过程中,发现了数据仓库预处理过程中存在的若干共性问题,提出了相应的解决方案,并进行了实际的应用。
This paper reveals some common issues of data preparation for building data warehouse during the practice of medical data warehouse, proposes corresponding solutions and carry on practice.
为了充分利用银行已有数据,提高内部监控水平,本文提出了一种基于数据仓库技术的银行非现场稽核监控解决方案。
A solution of bank non-spot audit system based on data warehouse is brought forward. The intention is to utilize the data from bank and increase the standard of bank inner audit.
同时对数据源的连接、数据的转换、数据仓库中数据定时更新等问题给出了具体的解决方案。
At the same time, gave readers some important means about data source link, data transformation and data timely update etc.
同时对数据源的连接、数据的转换、数据仓库中数据定时更新等问题给出了具体的解决方案。
At the same time, gave readers some important means about data source link, data transformation and data timely update etc.
应用推荐