文档章节

Data Warehouse Definition

我是彩笔
 我是彩笔
发布于 2015/04/14 11:15
字数 285
阅读 19
收藏 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

共有 人打赏支持
我是彩笔
粉丝 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
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
359
0
FAILED: SemanticException [Error 10041]: No partition predicate found for

FAILED: SemanticException [Error 10041]: No partition predicate found for Alias “average_sale_num_per_7d_query:temp1” Table “procurement_forecast_warehouse_stock_daily” 2018......

drdongshiye
04/25
0
0

没有更多内容

加载失败,请刷新页面

加载更多

下一页

arts-week5

Algorithm 824. Goat Latin - LeetCode 152. Maximum Product Subarray - LeetCode 110. Balanced Binary Tree - LeetCode 67. Two Sum II - Input array is sorted - LeetCode 665. Non-dec......

yysue
11分钟前
0
0
iOS开发之AddressBook框架详解

iOS开发之AddressBook框架详解 一、写在前面 首先,AddressBook框架是一个已经过时的框架,iOS9之后官方提供了Contacts框架来进行用户通讯录相关操作。尽管如此,AddressBook框架依然是一个非...

珲少
41分钟前
1
0
两年摸爬滚打 Spring Boot,总结了这 16 条最佳实践

Spring Boot是最流行的用于开发微服务的Java框架。在本文中,我将与你分享自2016年以来我在专业开发中使用Spring Boot所采用的最佳实践。这些内容是基于我的个人经验和一些熟知的Spring Boot...

Java填坑之路
今天
3
0
《Spring5学习》04 - 面向切面编程

一、Spring面向切面编程的基本概念 面向切面编程(即AOP):把项目中需要再多处使用的功能比如日志、安全和事务等集中到一个类中处理,而不用在每个需要用到该功能的地方显式调用。 横切关注...

老韭菜
今天
2
0
day61-20180819-流利阅读笔记

跑道没了,它们还在跑:澳门赛狗业的遗孤 Daniel 2018-08-19 1.今日导读 相信你早就知道香港有个赛马会,可是你听说过香港的邻居澳门原本有个赛狗会吗?其实,对于澳门人来说,赛狗这项活动历...

aibinxiao
今天
15
0

没有更多内容

加载失败,请刷新页面

加载更多

下一页

返回顶部
顶部