×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

@Las Vegas

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

  • 脑洞大开，突发奇想，用力来传播信息
  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论