×

Loading...
Ad by
  • 予人玫瑰，手有余香：加拿大新天地工作移民诚聘求职顾问&行业导师！
Ad by
  • 予人玫瑰，手有余香：加拿大新天地工作移民诚聘求职顾问&行业导师！

@Calgary

DATAWAREHOASE 是由DATABASE组成的，但它是DATABASE的一种应用OLAP。而另外一种是OLTP请看DATAWARHOUSE的定义

unix_oracle8idba(smart cow)
What is a Data Warehouse?
A data warehouse is a relational database that is designed for query and analysis
rather than transaction processing. It usually contains historical data that is derived
from transaction data, but it can include data from other sources. It separates
analysis workload from transaction workload and enables an organization to
consolidate data from several sources.
In addition to a relational database, a data warehouse environment often consists of
an Extraction, Transportation, and Transformation (ETT) solution, an online
analytical processing (OLAP) engine, client analysis tools, and other applications
that manage the process of gathering data and delivering it to business users. See
Chapter 10, "ETT Overview", for further information regarding the ETT process.
A common way of introducing data warehousing is to refer to Inmon’s
characteristics of a data warehouse, who says that they are:
n Subject Oriented
n Integrated
n Nonvolatile
n Time Variant
(#421558@0)
Last Updated: 2002-3-27
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / what difference between Data Warehouse and Database? -goodsolution(goodsolution); 2002-3-15 {52} (#405030@0)
    what difference between Data Warehouse and Database?
    • 这个话题大了。简单几个区别吧。warehouse是专门用来给公司决策用的。所以，它会存有很长时间的数据，而一般database因性能关系会定时清理数据的。而warehouse里的数据一般都是只读的，数据排序等都是以Query等的速度来设计的。 -mjs(臭豆腐-在痛苦中挣扎); 2002-3-15 (#405056@0)
      • Then how to create a data warehouse,and where is data stored? -goodsolution(goodsolution); 2002-3-15 {61} (#405124@0)
        Then how to create a data warehouse,and where is data stored?
        • 有现成的工具啊。比较通用的就是SQL SERVER了。关于具体怎么做，那可就是一门课了，MCDBA的一门考试就是warehouse的，你如果想学就得去买本书了。 -mjs(臭豆腐-在痛苦中挣扎); 2002-3-15 (#405188@0)
        • 有专门的data warehouse数据库.一般是关系型数据库+星型索引等功能. -antmm(沉默不语); 2002-3-15 (#405279@0)
    • Data Warehouse一般存储的是历史数据用来做分析决策用的,并发性能要求不高,但是检索性能要求比DATABASE高.Database主要处理实时数据,并发性能要求高. -antmm(沉默不语); 2002-3-15 (#405274@0)
      • 哇塞，原来蚂蚁大姐也是搞数据库的。久仰久仰！ -mjs(臭豆腐-在痛苦中挣扎); 2002-3-15 (#405298@0)
        • 哇,原来臭豆腐和我同行啊,9样9样:P -antmm(沉默不语); 2002-3-15 {20} (#405322@0)
          我要改行啦,呵呵.....
          • 哎哟，想改干什么呀？数据库挺好玩的呀。干么改行啊？呵呵，我还知道你是上海来的呢。嘿嘿。 -mjs(臭豆腐-在痛苦中挣扎); 2002-3-15 (#405332@0)
            • 我FAINT!!!你还知道什么?横横. 我知道你很臭,臭豆腐的臭,横横. -antmm(沉默不语); 2002-3-15 {16} (#405370@0)
              改行做LABOUR啊:P
              • 唉，这世道，说两句套套瓷被骂了个狗血喷头。唉，失败啊。 -mjs(臭豆腐-在痛苦中挣扎); 2002-3-15 (#405381@0)
                • 呵呵,谁让你说错话了,横横 -antmm(沉默不语); 2002-3-15 {44} (#405397@0)
                  我不是从上海来的呀:P
                  我知道你是啊,对不对呀?
                  • 呵呵，看来说错话了。道歉，道歉！ -mjs(臭豆腐-在痛苦中挣扎); 2002-3-15 (#405402@0)
                    • hehe. //hand -antmm(沉默不语); 2002-3-15 (#405409@0)
      • 不能笼统地拿datawarehouse去和Database比较。 -yangn(Raymond); 2002-3-15 {227} (#405365@0)
        前者是建立在后者基础上的一种solution.database根据用途和特点可以分为OLAP和OLTP两大系统。Datawarehousing 是专门用于解决有关OLAP SYSTEM的Analysis 和 Summerization的。也就是说Datawarehousing 作为一种service,其backend依然是database.
        • 呵呵,关于数据仓库,总的感觉是正在发展当中,和数据库有千丝万缕的关系.其实也可以算是数据库的一种.DX也是做数据仓库的? -antmm(沉默不语); 2002-3-15 (#405374@0)
          • DX不敢当，不过倒也是作这一行的。 -yangn(Raymond); 2002-3-15 (#405379@0)
            • 能不能来个不是什么IT的? 左一个数据库右一个数据仓库(瞧这名字!), 怎一个闷字了得 -patpat(乃胡侃而已); 2002-3-15 (#405386@0)
              • 你要是做这个的就没时间闷了 -hugefox(hugefox); 2002-3-16 (#405563@0)
          • 这世道，我在那给人家解释了半天，得到得评价就是臭，还是臭豆腐得臭，人家说了两句，就是DX。巨晕。 -mjs(臭豆腐-在痛苦中挣扎); 2002-3-15 (#405388@0)
            • 给臭豆腐熏的? :D -antmm(沉默不语); 2002-3-15 (#405398@0)
        • AGREE! -unix_oracle8idba(smart cow); 2002-3-27 (#421562@0)
      • DATAWAREHOASE 是由DATABASE组成的，但它是DATABASE的一种应用OLAP。而另外一种是OLTP请看DATAWARHOUSE的定义 -unix_oracle8idba(smart cow); 2002-3-27 {1004} (#421558@0)
        What is a Data Warehouse?
        A data warehouse is a relational database that is designed for query and analysis
        rather than transaction processing. It usually contains historical data that is derived
        from transaction data, but it can include data from other sources. It separates
        analysis workload from transaction workload and enables an organization to
        consolidate data from several sources.
        In addition to a relational database, a data warehouse environment often consists of
        an Extraction, Transportation, and Transformation (ETT) solution, an online
        analytical processing (OLAP) engine, client analysis tools, and other applications
        that manage the process of gathering data and delivering it to business users. See
        Chapter 10, "ETT Overview", for further information regarding the ETT process.
        A common way of introducing data warehousing is to refer to Inmon’s
        characteristics of a data warehouse, who says that they are:
        n Subject Oriented
        n Integrated
        n Nonvolatile
        n Time Variant

More Topics

  • 现在社区游泳池招救生员巡逻，过一会还要不停的点人头，这工作是否很快就被AI代替了，装一个摄像头后面是AI处理系统，这样只招一个等着救人就行了，人头沉下水一定时间立马强光照射，还可以分析水下人的状况来判断是否溺水等
  • 新冠疫苗引发心肌炎? 最新研究这样看
  • 这道几何题有解吗?
  • SAM 2 Demo
  • 如何在 AWS EC2 实例上构建 WordPress 应用程序?
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论