没有合适的资源?快使用搜索试试~ 我知道了~
计算机专业 英文文献 数据仓库
4星 · 超过85%的资源 需积分: 10 31 下载量 63 浏览量
2011-05-24
20:52:58
上传
评论 1
收藏 54KB DOC 举报
温馨提示
试读
9页
和计算机专业相关的英文文献 主要是关于 数据仓库 数据查询在商务中的应用。使用数据仓库 可以有很多方便的地方。
资源推荐
资源详情
资源评论
DATA WAREHOUSE
Data warehousing provides architectures and tools for business executives to
systematically organize, understand, and use their data to make strategic decisions. A
large number of organizations have found that data warehouse systems are valuable tools
in today's competitive, fast evolving world. In the last several years, many firms have
spent millions of dollars in building enterprise-wide data warehouses. Many people feel
that with competition mounting in every industry, data warehousing is the latest must-
have marketing weapon —— a way to keep customers by learning more about their
needs.
“So", you may ask, full of intrigue, “what exactly is a data warehouse?"
Data warehouses have been defined in many ways, making it difficult to formulate a
rigorous definition. Loosely speaking, a data warehouse refers to a database that is
maintained separately from an organization's operational databases. Data warehouse
systems allow for the integration of a variety of application systems. They support
information processing by providing a solid platform of consolidated, historical data for
analysis.
According to W. H. Inman, a leading architect in the construction of data warehouse
systems, “a data warehouse is a subject-oriented, integrated, time-variant, and nonvolatile
collection of data in support of management's decision making process." This short, but
comprehensive definition presents the major features of a data warehouse. The four
keywords, subject-oriented, integrated, time-variant, and nonvolatile, distinguish data
warehouses from other data repository systems, such as relational database systems,
transaction processing systems, and file systems. Let's take a closer look at each of these
key features.
(1)Subject-oriented: A data warehouse is organized around major subjects, such as
customer, vendor, product, and sales. Rather than concentrating on the day-to-day
operations and transaction processing of an organization, a data warehouse focuses on the
modeling and analysis of data for decision makers. Hence, data warehouses typically
provide a simple and concise view around particular subject issues by excluding data that
are not useful in the decision support process.
(2)Integrated: A data warehouse is usually constructed by integrating multiple
heterogeneous sources, such as relational databases, flat files, and on-line transaction
records. Data cleaning and data integration techniques are applied to ensure consistency
in naming conventions, encoding structures, attribute measures, and so on..
(3)Time-variant: Data are stored to provide information from a historical perspective
(e.g., the past 5-10 years). Every key structure in the data warehouse contains, either
implicitly or explicitly, an element of time.
(4)Nonvolatile: A data warehouse is always a physically separate store of data
transformed from the application data found in the operational environment. Due to this
separation, a data warehouse does not require transaction processing, recovery, and
concurrency control mechanisms. It usually requires only two operations in data
accessing: initial loading of data and access of data..
In sum, a data warehouse is a semantically consistent data store that serves as a
physical implementation of a decision support data model and stores the information on
which an enterprise needs to make strategic decisions. A data warehouse is also often
1
资源评论
- realmanlxc2013-01-24非常经典和准确!
- panccc1112013-12-17内容不错挺准确,但未注明出处和作者姓名。
- 道2014-05-19就是比较少
- dongyongok2014-03-28还可以,有一定参考价值
- chen7791388892013-04-17内容不错。。。但不是我想要的。。。
mubaitu123
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功