登陆注册
27082000000027

第27章 Database System(6)

A DBMS can organize, process, and present selected data elements from the database. This capability enables decision makers to search, probe, and query database contents in order to extract answers to nonrecurring and unplanned questions that aren't available in regular reports. These questions might initially be vague and/or poorly defined, but people can "browse" through the database until they have the needed information. In short, the DBMS will "manage" the stored data items and assemble the needed items from the common database in response to the queries of those who aren't programmers. In a file-oriented system, users needing special information may communicate their needs to a programmer, who, when time permits, will write one or more programs to extract the data and prepare the information. The availability of a DBMS, however, offers users a much faster alternative communications path.

The management information system (MIS) concept has been defined in dozens of ways. Since one organization's model of an MIS is likely to differ from that of another, it's not surprising that their MIS definitions would also vary in scope and breadth. For our purposes, an MIS can be defined as a network of computer based data processing procedures developed in an organization and integrated as necessary with manual and other procedures for the purpose of providing timely and effective information to support decision-****** and other necessary management functions.

【Vocabulary】

logically

adv. 伦理上地,逻辑上地

scroll

n. 卷轴,名册 v. 成卷形

handle

n. 柄,把手 vt. 处理,操作

access

vt. 存取,接近 n. 通路,入门

retrieval

n. 取回,恢复,挽救

linkage

n. 连接

probe

vt. 探查,查明 n. 探针,探测器

query

n. 质问,询问,怀疑

nonrecurring

adj. 不重现的

vague

adj. 含糊的,茫然的

definition

n. 定义,解说,精确度

scope

n. 范围,机会,余地

breadth

n. 宽度,幅宽

based

v. 基于,以…为基础

【参考译文】

数据库管理系统和管理信息系统

众所周知,数据库是汇集逻辑上相关数据元的集合。这些数据元可以按照不同的结构组织起来,以满足单位和个人的多种处理和检索功能的需要。数据库本身并不是什么新鲜的事物——早期的数据刻在石头上,记在名册上,或是写在索引卡中。然而现在数据库普遍记录在可磁化的介质上,并且需要用计算机程序来执行必需的存储和检索操作。

如下所述,所有数据库中(最简单的除外)都有复杂的数据关系及其链接。处理、创建、访问及维护数据库来记录有关的复杂任务的系统软件包叫做数据库管理系统(DBMS)。DBMS软件包中的程序在数据库与它的用户之间建立接口。(这些用户包括应用程序员、管理员,以及其他需要信息的人员和各种操作系统程序。)

DBMS可以组织、处理和表示从数据库中选出的数据元。这种功能使决策者能够搜索、探查和查询数据库的内容,从而对在正规报告中没有的、不再出现的而且无法预料的问题做出回答。这些问题最初可能是模糊的或者定义是不确切的,但是人们可以浏览数据库直到获得所需要的信息。简单地说,就是DBMS将“管理”存储的数据,并且从公共数据库中汇集所需要的数据以回答非程序员的提问。在面向文件的系统中,需要特定信息的用户应该将他们的要求传送给程序员。该程序员在时间的允许下,将会编写一个或多个程序来提取数据和准备信息。然而DBMS的可用性为用户提供了一个更加快速的替代通信通道。

管理信息系统(MIS)已经用多达数十次的概念定义过。因为MIS的组织模型可能各不相同,所以 MIS 的定义随应用范围的扩大而变化就不值得奇怪了。本文以为,MIS系统可以定义为基于计算机的数据处理过程的网络系统,它是一个为了支持决策和其他必需的管理功能提供及时有效的信息而开发的机构,并且可以按照需要把人工和其他过程结合在一起。

【Reading Material】

Decision Support Introduction

Database management systems are widely used by organizations for maintaining data that documents their everyday operations. In applications that update such operational data, transactions typically make small changes (for example, adding a reservation or depositing a check) and a large number of transactions must be reliably and efficiently processed, Such On-Line Transaction Processing(OLTP), applications have driven the growth of the DBMS industry in the past three decades, and will doubtless continue to be important. DBMS have traditionally been optimized extensively to perform well in such applications.

Recently, however, organizations have increasingly emphasized applications in which current and historical data are comprehensively analyzed and explored, identifying useful trends and creating summaries of the data, in order to support high-level decision ******. Such applications are referred to as decision support. Decision support has rapidly grown into a multibillion-dollar industry, and further growth is expected. There are a number of vendors offering database systems and tools to facilitate decision support. Industry organizations are emerging to set standards and create consensus on issues like language and architecture design. In this chapter our goal is to provide an introduction to the major new issues, and to place decision support systems in the broader context of database management systems.

Organizational decision ****** requires a comprehensive view of all aspects of an enterprise, and many organizations have therefore created consolidated data warehouses that contain data drawn from several databases maintained by different business units, together with historical and summary information.

The trend towards data warehousing is complemented by an increased emphasis on powerful analysis tools. Three broad classes of analysis tools are emerging. First, there ate DBMS that support traditional SQL-style queries, but designed to support complex queries efficiently. Such systems can be regarded as relational DBMS6 optimized for decision support applications.

Second, there are systems that support a class of stylized queries that typically involve group-by and aggregation operators. Applications dominated by such queries are called On-Line Analytic Processing, or OLAP. These systems support a querying style in which the data is best thought of as a multidimensional array, and are influenced by end-user tools such as spreadsheets, in addition to database query languages.

同类推荐
  • 俄语通用国家概况

    俄语通用国家概况

    20世纪90年代初苏联解体后,形成完全独立的15个主权国家。独立后的各共和国主要将自己民族的语言定为国语,但俄语仍作为广泛使用的共同交际语言,有的国家还将俄语法定为该国使用的两种官方语言之一。
  • 魅力英文ⅲ:不爱也是一种爱

    魅力英文ⅲ:不爱也是一种爱

    本书收录的百则经典美文,围绕着爱的主题,或婉转或浪漫,或温和或充满激情,洋溢着浓浓的爱意,让心灵为之震撼;有的灵气十足,宛如一线罅隙中奔涌而出的清泉,悄然渗入心田,融语言美、意境美于一体;有的语言凝炼、言简意赅;有的叙述详尽、丝丝入扣。
  • 大学英语六级听力训练

    大学英语六级听力训练

    本书针对听力的每种题型进行了详细的分析,让考生透彻地了解听力考试的测试方向、命题规律。同时,还提供了相应的应试技巧,帮助考生正确理解和解答听力题。本书将练习和测试相结合,一步一个台阶地提高听力水平。
  • 英语PARTY——趣味拼盘

    英语PARTY——趣味拼盘

    本套书籍带你领略英语世界风景,感悟英语学习氛围,有助于英语学习。
  • 看古希腊神话故事学英语

    看古希腊神话故事学英语

    神话是远古人类思想与生活的反映,是原始信仰的产物。希腊神话故事经历了丰富的时代变迁和历史风云,几乎成为希腊乃至欧洲一切文学和艺术活动的基本素材。马克思曾说:“希腊神话不只是希腊艺术的宝库,而且是它的土壤”。希腊神话也是欧美文艺取之不尽的艺术源泉。希腊神话具有无穷的认识价值和永久的审美魅力。希腊神话还为现代奥林匹克运动会的形成奠定了基础。在古希腊这个神话王国中,优美动人的神话故事和曲折离奇的民间传说为古奥运会的起源蒙上一层神秘的色彩。那些经久不衰的神话故事让我们着迷,那些如雷贯耳的名字至今仍被我们尊为“大师”。时隔千年,希腊神话还对我们产生影响。
热门推荐
  • 九转剑尊

    九转剑尊

    生死大道,彼岸花开。自创九转,以剑破天。丹王成帝,留言世间。天元世界,我已斩天。三十六帝座,世人皆奉文天。这是一个轮回九世的剑修,手持一把长剑,斩天问道的故事,还请各位读者耐心看下去,这里面有着不一样的精彩。
  • 三生三世噬骨花

    三生三世噬骨花

    她生于黑暗,噬骨伴生。天生异眸,无情无欲,俯视苍生。“我等你千年,淌过忘川,抚过一朵朵噬骨花,只为在在轮回中再看你一眼。”他伸手,眼底的执念似要将她吞没。“而我们,终是错过了。”“不,你逃不掉的……我的肋骨。”
  • 谢谢老板

    谢谢老板

    当一个人的出生是原罪时,无可奈何,无能为力,会使人在崩溃与不能崩溃之间,有种被撕裂的感觉。当美貌生错了时代,它也等同于原罪。
  • 残余伤爱

    残余伤爱

    在青春的年华里,他却在不对的时间遇上对的她,可惜的是,最美的遇见却成为最痛的伤害,一切都还没发生,爱也被代替,当曾经的美好却已经开始逐渐走向灭亡…………多年后的命运又会怎么样呢?爱能否回到身边?
  • 死神之至尊王座

    死神之至尊王座

    将任何物体实体化,最后一招一式中,赋予灵魂,创造生命。死亡不代表终结,力量决定一切。想要变强,那就赋予无尽的战斗。与人斗,与地斗,与天斗,与命斗,与己斗。生与死中充满机遇,情与痛中坚定本心。为爱,为友,为己。若说男人的征途是星辰大海,那么主角的征途将是无尽的宇宙。一切尽在死神之至尊王座境界:无魂、魂灵、魂兵、魂将、魂帅、魂王、魂帝、魂圣、魂神
  • 长生玉

    长生玉

    长生玉蕴含无尽的生命能量,是神彝族的圣地至宝,也是神彝族最大的秘密。无意之中这一秘密泄露了出去,给神彝族带来了灭顶之灾,方英没落的神彝族少年,从此变踏上了保护长生玉的征途。
  • 不是人间的太子殿下

    不是人间的太子殿下

    天庭之中,玉皇大帝有一个儿子,人人见了都要称一声太子殿下。有一天,这名太子殿下突然失踪,去到了人间界的蔚蓝星。而听到太子失踪的消息,天庭的所有人都沉默了,然后就是狂喜,还放假三天三夜!
  • 混沌圣尸

    混沌圣尸

    讲一只僵尸如何成为宇宙中的王者,打败无数高手的故事。这里没有种马,没有YY,只有感天动地的爱情故事。看僵尸如何成就不朽的传奇,征服天下。
  • 暇光耀眼却只见一轮月

    暇光耀眼却只见一轮月

    一个带着光的女孩,为何在别人看来是夜晚里那高高挂着的那一轮月。清冷中又带着对第二天的期望。
  • 现世浮尘录

    现世浮尘录

    一本作者已经练了葵花宝典的垃圾小说,千万不要点进来看,洗眼睛要花很多钱的。