数据仓库教程

发布于 2024-08-17 06:39:09 字数 74 浏览 4 评论 0原文

我的老板发现了一本新杂志,其中提到了数据仓库。因此,我正在寻找有关数据仓库的优秀教程或书籍。我还将接受有关如何阻止我的老板阅读的建议。

My boss has discovered a new magazine which mentioned data warehousing. Thus I am in search of a good tutorial or book on data warehousing. I will also accept recommendations on ways to stop my boss reading.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(4

一百个冬季 2024-08-24 06:39:09

数据仓库方面有两位主要作者:

  • Bill Inmon - 主要撰写有关大型企业数据仓库的文章
  • Ralph Kimball - 主要撰写有关小型部门数据仓库的

文章 熟悉两者的想法是一个好主意。

数据仓库是一个成熟而复杂的领域,除非您在这方面拥有丰富的经验,或者有一个非常简单的项目,否则您不太可能在这个领域取得非常成功。这可以而且应该阻止大多数人直接参与这些项目。另一方面,我们现在正处于 IT 领域,用户和客户对数据仓库的集成和分析功能的需求越来越大。因此,对其提供的功能进行评估可能是个好主意。

There are two primary authors on data warehousing:

  • Bill Inmon - who mostly writes about large enterprise data warehouses
  • Ralph Kimball - who mostly writes about smaller, departmental data warehouses

It's a good idea to get familiar with the ideas of both.

Data warehousing is a mature and complex field, one that you're unlikely to be very successful with unless you've got a lot of experience in it, or have a very simple project. This can and should deter most people from just jumping into these projects. On the other hand, we're now at a point in IT in which the integration and analytical features of a data warehouse are becoming increasingly demanded by users and customers. So, it's probably a good idea to do an evaluation of what it offers.

末が日狂欢 2024-08-24 06:39:09

以下是阻止他的方法:

提及数据仓库的成本和风险:

  1. 现在您的竞争对手有一个工业间谍活动的单一目标!
  2. 您需要一堆昂贵的服务器($$$)和一个多层存储系统,在发生故障时具有冗余(更多$$$)
  3. 招聘:您需要雇用人员来管理和维护仓库。可能有很多。钱可能更好地花在你的核心业务上。
  4. 仓库可能无法让您执行以前无法执行的任何分析(尽管速度较慢)。只有当您的生产系统已经因报告和分析而陷入困境时,这才值得。

Here is how you stop him:

Mention the costs and risks of data warehousing:

  1. Now your competitors have a single target for industrial espionage!
  2. You need a bunch of expensive servers ($$$) and a multitier storage system with redundancy in case of failure (more $$$)
  3. Hires: you need to hire personnel to manage and maintain the warehouse. Lots of them, probably. Money that might be better spent on your core business.
  4. The warehouse may not enable you to do any analytics you couldn't do before (albeit more slowly). It's only worth it if your production system is already bogging down with reporting and analytics.
把人绕傻吧 2024-08-24 06:39:09

尝试看看 Bill Inmon 的内容,不要被他的一些书吓倒/文章已有 10 多年的历史,数据仓库的基础知识在当时并没有发生令人耳目一新的变化。

至于阻止你的老板阅读一套新蜡笔怎么样?

Try looking at the stuff from Bill Inmon, don't be put off by some of his books/articles being 10+ years old the basics of Datawarehousing are refreshingly unchanged in that time.

As for stopping your boss from reading how about a new set of crayons?

狼性发作 2024-08-24 06:39:09

哈哈,Kimball vs Inmon Flame 的时间到了:-)

我强烈推荐阅读实用数据仓库设计的“圣经”:

http://books.google.pl/books?q=data+warehouse+toolkit

haha, time for Kimball vs Inmon flame :-)

I highly recommend reading the "bible" of practical data warehouse design:

http://books.google.pl/books?q=data+warehouse+toolkit

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文