登陆注册
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.

同类推荐
  • 青春阅读-阅读七色阳光(下)(双语)

    青春阅读-阅读七色阳光(下)(双语)

    寻找主题句:主题句有时也出现在段落的中间,但不一定必须在中间。有时候第一句并非主题句,而是承上启下的过渡句。在这种情况下,第二句往往变成了主题句。此外,主题句也可能是段落的倒数第二句。这种段落是从支撑细节开始,发展到结论(出现主题句),当主题句出现后,又进一步用细节支撑说明,其安排顺序是:次要——重要——次要,主题句隐含在段意之中。有些段落无明显的主题句,其中心思想包含在各个句子中,这就要求我们依据已知的细节,归纳出段落的中心思想。
  • 有一种幸福叫守候

    有一种幸福叫守候

    在原汁原味的英文中,每天进步一点点。
  • Songs of a Savoyard

    Songs of a Savoyard

    本书为公版书,为不受著作权法限制的作家、艺术家及其它人士发布的作品,供广大读者阅读交流。
  • 英语PARTY——英美俚语演艺厅

    英语PARTY——英美俚语演艺厅

    本套书籍带你领略英语世界风景,感悟英语学习氛围,有助于英语学习。
  • 有些路,只能一个人走

    有些路,只能一个人走

    本书精选了众多励志小故事,让我们在这些美文中开始一段心灵的旅行,去发现最好的自己,屏弃内心的杂念,给灵魂喘息的机会。人生变幻,目前的困境只是暂时的,偶尔一两次的失败并不代表什么,挺起胸膛,还有更长的路要走。打破禁锢,开放自我,充分相信自己的未来充满阳光,不断超越自己,发现最好的自己,踏上更高、更广阔的舞台!
热门推荐
  • 我的父亲张行春

    我的父亲张行春

    我的父亲是1940年出生的,父亲一生很是坎坷,从一岁被亲生父母送给养父抚养,到50岁去世,匆匆的走完了自己的一声,现在听我讲讲父亲的故事
  • 无限之黑暗崛起

    无限之黑暗崛起

    穿梭在无穷的位面,追寻着空间在真谛,一个立志为成为最强者的男人,尽在无限之黑暗崛起。
  • 故事里有颗糖

    故事里有颗糖

    嘘,不要惊讶,那是他们的故事,也是你和我的故事[垃圾原创+一些关乎凹凸世界的同人/应援词原创不可搬运]
  • 银戒:血染苍穹

    银戒:血染苍穹

    一朝穿越,手上多了枚戒指是怎么回事?!原本普普通通小民工的他,却被人告知是世界未来主宰?!谁能解释一下?前面的这个九尾妖狐是神马?这些洪荒异兽又是什么东西?还有前面这些个美女为什么都用超级崇拜的眼神看他?啊啊套路深他要回家!“不好意思,你逃不掉了。”【每日保底三更】
  • 化天之神

    化天之神

    天下没我必灭亡!上神(神的师父)见我求帮忙!美女金钱多如毛!
  • 危机末

    危机末

    一所三流大学的大学生,一场全人类进化的契机。强者的天堂,弱者的地狱,未知存在造就出的全新世界,未来的路延伸至我们所看不见的地方。这里,死亡与生存,毁灭与新生,危险与机遇,并存!
  • EXO之惊蛰

    EXO之惊蛰

    勋鹿/玄幻/he本文是一篇架空王道文,绝对脑洞大开绝对雷得惊天动地泣鬼神!故事情节简单也不简单,总之作者表示第一次写这种文,大家就口下留情啦!
  • 天行

    天行

    号称“北辰骑神”的天才玩家以自创的“牧马冲锋流”战术击败了国服第一弓手北冥雪,被誉为天纵战榜第一骑士的他,却受到小人排挤,最终离开了效力已久的银狐俱乐部。是沉沦,还是再次崛起?恰逢其时,月恒集团第四款游戏“天行”正式上线,虚拟世界再起风云!
  • 命运的指引者

    命运的指引者

    人生走到尽头,当你躺在病床上闭上眼的那一刻,是否有过后悔,有过不甘,是否还有许多未完成的心愿,没见到的人。如果你忘却一切,给你再一次选择的机会你是否还会那么做,是违背良心的谴责,还是直面惨淡的人生。
  • 霸道恶少:别惹刁蛮公主

    霸道恶少:别惹刁蛮公主

    她,,是任性的刁蛮公主,,,,他是有权有势的霸道恶少,,,,他在不知不觉中爱她,,,,他们在冥冥中会是怎样的