数据库 毕业论文外文翻译

数据库 毕业论文外文翻译 英文原文及中文翻译 DATABASE 一、DATABASE MANAGEMENT SYSTEMS (DBMS) ANDMANAGEMENT INFORMATION SYSTEM (MIS) You know that a database is a collection of logically related data elements that may be structured in various ways to meet the multiple processing and retrieval needs of organizations and individuals. There's nothing new about databases--early ones were chiseled in stone, penned on scrolls, and written on index cards. But now databases are commonly recorded on magnetically media, and computer programs are required to perform the necessary storage and retrieval operations. You'll see in the following pages that complex data relationships and linkages may be found in all but the simplest databases. The system software package that handles the difficult tasks associated with creating, accessing, and maintaining database records is called a database management system (DBMS). The programs in a DBMS package establish an interface between the database itself and the users of the database. (These users may be applications programmers, managers and others with information needs, and various OS programs. ) 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 informationc4]. The availability of a DBMS, however, offers users a much faster alternative communications path (see Fig. 7-1). 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 making and other necessary management functions. Although MIS models differ, most of them recognize the concepts shown in Fig. 7-2. In addition to what might be termed the horizontal management structure shown in Fig. 7-2(a), an organization is also divided vertically into different specialities and functions which require separate information flows (see Fig. 7-2 (b)). Combining the horizontal managerial levels with the vertical specialities produces the complex organizational structure shown in Fig. 7-2(e). Underlying this structure is a database consisting, ideally, of internally and externally produced data relating to past, present, and predicted furture events. The formidable task of the MIS designer is to develop the information flow needed to support decision making (see Fig. 7-3) Generally speaking, much of the information needed by managers who occupy different levels and who have different responsibilities is obtained from a collection of existing information systems (or subsystems) . These systems may be tied together very closely in an MIS. More often, however, they are more loosely coupled. 二、SQL AND SQL SERVER IBM invented a computer language back in the 1970s designed specifically for database queries called SEQUEI.; those letters stand for Structured English Query Language. Over time, the language has been added to so that it is not just a language for queries, but can also build databases and manage the database engine's security. IBM released SEQUEl. into the public domain, where it became known as SQL. Because of this heritage you can pronounce it "sequel" or spell it out "S-Q-I.." There are various versions of SQL used in today's database engines. Microsoft SQL Server uses a version called Transact-SQL, or T-SQL, which stands for Transaction SQL. What Is SQL Server? 1. SQL Server is a client/server relational database management system (RDBMS) that uses Transact-SQl. to send requests between a client and SQl. Server. 2. Client/Server Architecture The terms client, server, and client/server can be used to refer to very general concepts or to specific items of hardware or software. At the most general level, a client is any component of a system that requests services or resources from other components of a system. A server is any component of a system that provides services or resources to other components of a system. For example, when you print a document from your workstation on a network, the workstation is the client and the machine that does the print spooling is the server, Any client/server data-based system consists of the following components: ,The server--A collection of data items and supporting objects organized and presented to facilitate services, such as searching, sorting, recombining, retrieving, updating, and analyzing data. The database consists of the physical storage of data and the database services. All data access occurs through the server; the physical data is never accessed directly by the client. ,The client--A software program that might be used interactively by a person or that could be an automated process. This includes all software that interacts with the server, either requesting data from or sending data to the database. Examples are management utilities (those that are part of the SQL Server product as well as those bought separately), ad hoc query and reporting software, custom applications, off-the-shelf applications, and Web server-based applications. ,The communication between the client and the server--The communication between the client and the server depends largely on how the client and server are implemented. Both physical and logical layers of communication can be identified. When you communicate with someone using the telephone, the telephone system is the physical layer and a spoken natural language is the logical layer of communication. For a data-based system, the physical layer can be a network if the server and the client are on different computers. It can be inter process communication if the server and the client are on the same computer. The logical communication structure of the physical layer may be low-level operating system calls, a proprietary data access language, or the open structured query language (SQL). 3. SQL Server Platforms SQL. Server runs on the operating systems shown in Fig. 7-4. The SQL. Server version 7 server software runs only on the Windows 32-bit AH-based operating systems, but you can use all of the operating system platforms to create and execute client applications. 三、DATA WAREHOUSE It is often said, the age of the Industrial Revolution has finally been completed and the world has entered the age of the Information Technology revolution(see Fig. 7-5). It is our belief that the need for data warehouse applications is one of the manifestations of this Information Technology age. A data warehouse is becoming more of a necessity than an accessory for a progressive, competitive, and focused organization. It provides the right foundation for building decision support and executive information system tools that are often built to measure and provide a feel for how well an organization is progressing toward its goals. 1. COLLECTING OPERATIONAL DATA Advances in computer and networking technology have led to the introduction of very powerful hardware and software platforms that can collect, manage, and distrihute large amounts of pertinent data. In the case of a business application, detailed transactions are often generated during product-or service-related interactions. These transactions are not limited to commercial sectors. They are also found in sectors such as, government, health care, insurance, manufacturing, finance, distribution, education, and so on. Any enterprise that has some computerized record keeping systems and is interested in deducting or drawing logical conclusions from their voluminous, granular, and detailed information pool should consider building an enterprise-level data warehouse application. These enterprises will then be capable of improving their insights into the trends in their operations and eventually increase the accuracy of their forecasts and plans. The effectiveness of the data warehouse application intensifies especially when the operational data resides in distributed, nonhomogenous systems and replace manual data gathering and reconciliation procedures. Operational data is the highly structured sets of information that support the ongoing and day-to-day operation o{ an organization. In case of a decentralized organization, operational data is generated at remote locations sometimes in no homogeneous distributed systems (see Fig. 7-6). Distributed systems can span many different geographical locations and time zones. They are configured to provide scalability, visibility, and tracking capabilities of business processes. For instance, the order is entered by a customer representative in one site. The financial state of the order is verified at another site. Once approved, it is forwarded to manufacturing to be assembled. Finally, the shipping staff is alerted to fulfill the order that was booked at the remote sitecs3. Standard reports or ad hoc queries that inquire about the details of these events are typical examples of operational reports. They are generated on a regular basis. Any delay in their processing will have a significant disruption to the normal operation of that business. 2. CONVERGENCE OF MANY COMPUTER TECHNOLOGIES The infrastructure that supports the data warehouse application relies on the same technologies that most other applications are dependent upon. The difference is in the variety and specialization at the product level that can greatly improve the quality of the data warehouse infrastructure. Below are some technologies that have made their mark in the data warehouse marketplace. In order to produce a data warehouse that best meets users needs, these underlining technologies have to be evaluated as part of the periodic resource capacity planning. Depending upon the requirements and resources available, the best combination can be selected and configured. ,Server technology. , Client technology. , Database Management System (DBMS) technology. ,Networking technology. , Mass storage technology. , Data presentation and publication requirements. ,Software engineering methodology and tools. COMMON CHARACTERISTICS OF A DATA WAREHOUSE (1) Data is divided into three categories. (a) Reference and Transaction Data. ,Includes lists, charts, and transaction data from source systems. , Originally generated in the source systems. , Can be kept in the data warehouse or an operational data store system. ,Is loaded into the data warehouse on a regular basis. ,Should never change once in the data warehouse (data correction and refresh are exceptions). , May be purged from the source. ,Is archived in the data warehouse if purged from the source. (b) Derived Data. , Is based on the reference data and certain business rules. ,Can always be re-created. , Business rules must be approved by end-users. (c) Denormalized Data. , Is based on the detailed reference data. , Is prepared periodically. ,Is the foundation for OLAP tools. (2) Enhancements are done in an iterative approach. (3) Enhancements should be based on the overall architecture. (4) One end-user tool may not be adequate for all analytical needs. Depending on the amount of data and type of queries, different end-user tools must be selected. (5) Transaction-level database recovery is not necessary. (6) Data warehouse platform should be tuned for performance rather than quick recovery purposes. 数 据 库 一、 数据库管理系统(DBMS)和管理信息系统(MIS) 众所周知，数据库是逻辑上相关的数据元的汇集。这些数据元可以按不同的结构组织起来，以满足单位和个人的多种处理和检索的需要。数据库本身不是什么新鲜事——早期的数据库凿在石头上，记在名册上，以及写在索引卡中。而现在，数据库普遍记录在可磁化的介质上，并且需要用计算机程序来执行必需的存储和检索操作。 如下所述，所有数据库(最简单的除外)中都有复杂的数据关系及其链接。处理与创建、访问以及维护数据库记录有关的复杂任务的系统软件包叫做数据库管理系统(DBMS)。DBMS软件包中的程序在数据库与其用户间建立接口。(这些用户可以是应用程序员、管理员、及其他需要信息的人员和各种操作系统程序)。 DBMS可组织、处理和表示从数据库中选出的数据元。该功能使决策者能搜索、探查和查询数据库的内容，从而对在正规 报告 软件系统测试报告下载sgs报告如何下载关于路面塌陷情况报告535n,sgs报告怎么下载竣工报告下载 中没有的、不再出现的且无法预料的问 题 快递公司问题件快递公司问题件货款处理关于圆的周长面积重点题型关于解方程组的题及答案关于南海问题 作出回答。这些问题最初可能是模糊的并且(或者)是定义不恰当的，但是人们可以浏览数据库直到获得所需的信息。简言之，DBMS将“管理”存 储的数据项，并从公共数据库中汇集所需的数据项以回答非程序员的询问。在面向文件的系统中，需要特定信息的用户应将他们的要求传送给程序员。该程序员在时间允许时，将编写一个或多个程序以提取数据和准备信息。然而，DBMS的可用性为用户提供了一个更快的替代通信通道(如图7—1所示)。 管理信息系统(MIS)的概念已经用数十种方式定义过。因为MIS的组织模型可能各不相同，所以MIS的定义随应用范围和广度而变化就不奇怪了。本文认为，MIS系统可定义为基于计算机的数据处理过程的网络系统，它是一个机构为了支持决策及其他必需的管理功能提供及时有效的信息而开发的，并且可按需要把人工和其他过程结合在一起。 尽管MIS模型不同，但其中大多数都认可如图?—2所示的概念。除图7—2(a)中所示的横向管理结 构如何命名之外，一个机构从纵向也可分成需要独立 信息流的不同职能部门(见图7—2(b))。综合横向管理级和纵向特长产生了如图7—2(c)所示的复杂组织结构。这个结构的基础是数据库，该数据库理想的方式是由内部和外部产生的，与过去、现在及预见到的将来事件相关的数据组成。 MIS设计者的一个棘手的问题是开发支持决策所需的信息流(见图7—3)。一般而言，不同级别与不同职责的管理者所需的信息大多来自现有信息系统(或子系统)的汇集，这些系统在MIS中可紧密地结合在一起，但是，更经常的情况是松散耦合的。 二、 SQL和SQL服务器 IBM在20世纪70年代，设计了一种专门处理数据库查询的计算机语言SEQUEI,这几个字母是结构化英语查询语言的缩写。随着时间的推移，它增加了许多功能，就不仅是一个查询语言了，还可以创建数据库，管理数据库引擎的安全。IBM把它公开发行，于是就变成了现在为大家所知的SQL由于历史的原因SQL可以读成sequel，也可以逐字段拼成S—Q—L。在现在的数据库引擎里，已经有了好多种SQI。版本。微软SQL server使用的是T-SQL，它代表的是事务SQI?。 1(什么是SQL Server? SQL Server是一个客户机,g艮务器关系型数据库管理系统(RDBMS)，它使用事务SQL在客户机和SQL服务器间传送请求。 2(客户机?服务器体系结构 术语客户机、服务器和客户机—服务器可以是非常广的概念或专指硬件、软件。按最一般的概念。客户机是从系统其他部件请求服务或资源的系统的任何部件;服务器是向系统其他部件提供服务或资源的任何部件。 例如，当用户从网络上的工作站打印一个文件时，工作站是客户机，用作假脱机打印的机器是服务器。 任何基于数据的客户机、服务器系统都由下列部件组成。 ?服务器——数据项和支持对象的汇集，其中这些对象是有组织的(并随时准备提交，以便为数据的搜索、分类、重组、检索、更新和分析之类的服务提供便利。数据库由数据的物理存储器和数据库服务组成。所有的数据访问都通过服务器进行，客户机一概不能直接访问物理数据。 ?客户机—一一个软件程序，该程序应该由个人交互使用或可能是一个自动进程。其中包括从数据库请求数据，或向数据库送数的与服务器交互作用的所有 软件，例如管理实用程序(这些是SQL服务器产品的一部分并且是单独购买的)、特别查询和报告软件、客户应用程序、现货应用程序和基于Web服务器的应用程序。 ?客户机和服务器之间的通信’——客户机和服务器之间的通信在很大程度上取决于客户和服务器是如何实现的。通信的物理层和逻辑层可能是一样的。 ，电话系统是物理层，所讲的自然语言是通信的逻当你用电话与某人通信时 辑层。对于基于数据的系统，如果服务器和客户在不同的计算机:，则物理层可以是网络。如果服务器和客户在同一台计算机上，则通信可在进程之间进行。物理层逻辑通信结构可以是低层操作系统调用，一种专用数据访问语言或开放的结构化查询语言(SQL)。 3(SQL Server平台 SQL服务器运行在如图7—4所示的操作系统上。SQL Server第7版服务器软件只运行在32位的基于APl的Windows操作系统上，但可以便用所有的操作系统平台去创建和执行客户应用程序。 下表给出了操作系统及它们如何支持或不支持SQLServer 7的更多细节。 三、 数据仓库 人们常说工业革命时代已最终完成，世界进入了信息技术革命时代(参见图7—5)。我们相信数据仓库应用的需求就是信息技术时代的标志之一。数据仓库对于不断进取的、具有竞争力的、成为关注焦点的组织来说不只是一个附属物，而是不可缺少的。它提供建立决策支持和执行信息系统工具的基础，这些常常是用于衡量和评价某个单位是否正在向预定目标前进的标志。 1(操作数据的收集 计算机和网络技术的进步已经导致功能非常强大的，能收集、管理和分发大量有关数据的硬件和软件平台出现。在商业应用中，与产品和服务相关的交往经常会涉及繁琐的事务处理，这些事务不限于商业方面，它们也会在政府、保健、保险、制造、财经、分销、教育等方面出现。任何企业，如果有了某些计算机化记录保存系统，并且很希望从大量松散详细的信息池中演绎或作出逻辑结论，就应考虑建立一个企业级数据仓库应用系统。之后，这些企业就能够提高洞察运营趋势的能力，最终提高其预测和 计划 项目进度计划表范例计划下载计划下载计划下载课程教学计划下载 的精确性。尤其是操作数据分布在多个异构系统上，并可取代人工数据收集和调节过程时，数据仓库应用系统能提高效率。 操作数据是高度结构化的、支持一个单位开展日常工作以及持续发展的信息 集。如果一个单位的各部门是分散的，则操作数据有时是在远程的分布式异构系统中产生的(如图7—6所示)。分布式系统可以跨不同的地域和时区。分布式系统可以配置成使商业过程具有伸缩性、可视性和跟踪的能力。 例如，由客户代表在一个地方输入订单，而订货人的财经状况在另一个地方进行验证。一经批准，则订单传向加工厂装配。最后，由于是在远端站点预订的，因而要提醒装运人员完成订单规定的工作。标准报告或特别询问是上述事件细节的查询操作报告的典型实例，报告是正规的。这一过程中的任何延误都会对正常的运作造成很大的损害。 (聚集了多种计算机技术 2 支持数据仓库应用的基础设施与其他大多数应用所依靠的是相同的基础设施。不同的是产品层次上的种类和专用性方面，这在很大程度上提高了数据仓库基础设施的质量。下面是在数据仓库市场上最具代表性的一些技术。为了产生能最好地满足用户需求的数据仓库，作为周期性资源能力计划的一部分须对这些重要技术进行评价。根据需要和可用的资源，可以选择和配置最佳组合。 ?服务器技术。 ?客户技术。 ?数据库管理系统(DBMS)技术。 ?联网技术。 ?海量存储技术。 ?数据表示和发布需求。 ?软件 工程 路基工程安全技术交底工程项目施工成本控制工程量增项单年度零星工程技术标正投影法基本原理 方法 快递客服问题件处理详细方法山木方法pdf计算方法pdf华与华方法下载八字理论方法下载 学和工具。 3(数据仓库的一般特性 (1)数据分为3种类型。 ?基准和事务数据。 ?包括出自源系统的列表、图表和事务数据。 ?源系统产生的原始数据。 ?可以保存在数据仓库或在操作数据存储系统中的数据。 ?按正规格式装入到数据仓库的数据。 ?数据仓库中从未更改的数据(数据校正或刷新除外)。 ?可从源系统清除的数据。 ?从源系统清除而又在数据仓库中存档的数据。 ?导出数据。 ?基于基准数据和一定业务规则的数据。 ?总能再生成的数据。 ?必须由最终用户认可的业务规则。 ?非正规化数据。 ?基于详细的基准数据的数据。 ?周期性准备的数据。 ?用于OLAP工具的基础数据。 (2)加强了迭代方法。 (3)增强应基于整个体系结构。 (4)一种最终用户工具不一定适应所有的分析需求。应根据所查询的数 据和类型，选择不同的终端用户工具。 (5)不必有事务级数据库恢复。 (6)数据仓库平台应以性能而不是以快速恢复为目标进行调试。