文档章节

Data Warehouse Definition

我是彩笔
 我是彩笔
发布于 2015/04/14 11:15
字数 285
阅读 20
收藏 0

Data Warehouse Definition

Different people have different definitions for a data warehouse. The most popular definition came from Bill Inmon, who provided the following:

A data warehouse is a subject-oriented(面向主题), integrated(集成的), time-variant(随时间变化的) and non-volatile(稳定的) collection of data in support of management's decision making process.

Subject-Oriented: A data warehouse can be used to analyze a particular subject area. For example, "sales" can be a particular subject.

Integrated: A data warehouse integrates data from multiple data sources. For example, source A and source B may have different ways of identifying a product, but in a data warehouse, there will be only a single way of identifying a product.

Time-Variant: Historical data is kept in a data warehouse. For example, one can retrieve data from 3 months, 6 months, 12 months, or even older data from a data warehouse. This contrasts with a transactions system, where often only the most recent data is kept. For example, a transaction system may hold the most recent address of a customer, where a data warehouse can hold all addresses associated with a customer.

Non-volatile: Once data is in the data warehouse, it will not change. So, historical data in a data warehouse should never be altered.

Ralph Kimball provided a more concise definition of a data warehouse:

A data warehouse is a copy of transaction data specifically structured for query and analysis.

This is a functional view of a data warehouse. Kimball did not address how the data warehouse is built like Inmon did; rather he focused on the functionality of a data warehouse.


本文转载自:http://www.1keydata.com/datawarehousing/data-warehouse-definition.html

共有 人打赏支持
上一篇: Factless Fact Table
下一篇: MapR Hadoop
我是彩笔
粉丝 7
博文 23
码字总数 1936
作品 0
浦东
私信 提问
大数据三分钟不入门之三:海纳百川Data Warehouse 与 Data Lake

前两篇聊到了大数据的编程语言python和计算框架Apache Spark,有了它们就可以写程序跑应用了,当然花点时间入门是必须的。如果你已经读完前两篇的话,那么不妨再继续聊聊数据仓库(Data Wareh...

北美枫叶
2017/12/11
0
0
数据仓库中的DWD DWB DWS

DW :data warehouse 翻译成数据仓库 DW数据分层,由下到上为 DWD,DWB,DWS DWD:data warehouse detail 细节数据层,有的也称为 ODS层,是业务层与数据仓库的隔离层 DWB:data warehouse ba...

张欢19933
2016/09/09
364
0
资料整理——Oracle基本概念、术语(Glossary from Oracle Concepts)——第四部分

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/hpdlzu80100/article/details/84857743 这些概念都是很基础、很重要的概念。...

预见未来to50
2018/12/06
0
0
Introduction to Modern Data Warehousing in the Cloud - Part 1

Introduction This short series is aimed at those who are new to data warehousing and those who are used to the more traditional approaches but who are looking to the cloud with ......

Jack Vanlightly
2017/12/18
0
0
微软披露SQL Server 2008 R2 预览版

在11月3日的Professional Association for SQL Server(PASS)社区高峰会上,微软发布了多项与SQL Server有关的消息,包括即将在11月发布的SQL Server 2008 R2社区预览版(CTP),发布两个新的数据库...

红薯
2009/11/05
363
0

没有更多内容

加载失败,请刷新页面

加载更多

Jmeter参数的AES加密使用

在Jmeter日常实践中,大家应该都遇到过接口传参需要加密的情况。以登陆为例,用户名和密码一般都需要进行加密传输,在服务端再进行解密,这样安全系数会更高,但在使用jmeter进行接口测试的时...

程序猿拿Q
23分钟前
2
0
MYSQL 日期函数 Date and Time Functions

Table 12.13 Date and Time Functions Name Description ADDDATE() Add time values (intervals) to a date value ADDTIME() Add time CONVERT_TZ() Convert from one time zone to another ......

_liucui_
29分钟前
2
0
Android代码混淆ProGuard工作原理简介

ProGuard能够对Java类中的代码进行压缩(Shrink),优化(Optimize),混淆(Obfuscate),预检(Preveirfy)。    1. 压缩(Shrink): 在压缩处理这一步中,用于检测和删除没有使用的类,字段...

SuShine
32分钟前
1
0
Idea 2018激活

教程地址: https://www.52pojie.cn/thread-781394-1-1.html 亲测可用

一个不正经的程序员
37分钟前
1
0
Android组件化开发实践和案例分享

目录介绍 1.为什么要组件化 1.1 为什么要组件化 1.2 现阶段遇到的问题 2.组件化的概念 2.1 什么是组件化 2.2 区分模块化与组件化 2.3 组件化优势好处 2.4 区分组件化和插件化 2.5 applicatio...

潇湘剑雨
38分钟前
0
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部