毕业设计(论文)外文资料翻译
学院：信息工程学院
专业：计算机科学与技术
姓名： XXXXXX 学号： XXXXXXXXXX 外文出处： https://www.doczj.com/doc/7b12239307.html,/lwzl_info.
(用外文写)
asp?ztId=467&page=1 附件： 1.外文资料翻译译文；2.外文原文。
指导教师评语：
签名：
2011年04月25日
附件1：外文资料翻译译文
数据库开发过程
基于信息工程的信息系统规划是数据库开发项目的一个来源。这些开发新数据库的项目通常是为了满足组织的战略需求，例如改善客户支持、提高产品和库存管理或进行更精确的销售预测。然而许多数据库开发项目更多的是以自底向上的方式出现的，例如信息系统的用户需要特定的信息来完成他们的工作，从而请求开始一个项目，又如其他信息系统的专家发现组织需要改进数据管理而开始新的项目。即使在自底向上的情况下，建立企业数据模型也是必须的，以便理解现有的数据库是否可以提供所需的数据，否则，新的数据库、数据实体和属性都应该加到当前的组织数据资源中去。
无论是战略需求还是操作信息的需求，每个数据库开发项目通常集中在一个数据库上。一些数据库项目仅仅集中在定义、设计和实现一个数据库，以作为后续信息系统开发的基础。然而在大多数情况下，数据库及其相关信息处理功能是作为一个完整的信息系统开发项目的一部分而被开发的。
一. 系统开发生命周期
指导管理信息系统开发项目的传统过程是系统开发生命周期(SDLC)。系统开发生命周期是指一个组织中由数据库设计人员和程序员组成的信息系统专家小组详细说明、开发、维护和替换信息系统的全部步骤。这个过程比作瀑布是因为每一步都流到相邻的下一步，即信息系统的规格说明是一块一块地开发出来的，每一块的输出是下一块的输入。然而如图所示，这些步骤并不是纯线性的，每个步骤在时间上有所重叠（因此可以并行地管理步骤），而且当需要重新考虑先前的决策时，还可以回滚到前面某些步骤。（因而水可以在瀑布中倒流！）系统开发生命周期的每一阶段都包括与数据库开发相关的活动，所以，数据库管理的问题遍布整个系统开发过程。请注意，系统开发生命周期的阶段和数据库开发步骤之间不存在一一对应的关系，概念数据建模发生在两个系统开发生命周期阶段之间。
1.1 企业建模
数据库开发过程从企业建模（系统开发生命周期中项目论证和选择阶段的一部
分）开始，设定组织数据库的范围和一般内容。企业建模发生在信息系统规划和其他活动期间，这些活动确定信息系统的哪个部分需要改变和加强并概述出全部组织数据的范围。在这一步中，检查当前数据库和信息系统，分析作为开发项目主体的业务领域的本质，用非常一般的术语描述每个信息系统在开发时所需要的数据。每个项目只有当它达到组织的预期目标时才可以进行下一步。
1.2 概念数据建模
对一个已经开始的信息系统项目而言，概念数据建模阶段分析信息系统的全部数据需求。它分为两个阶段。首先，它在项目开始和规划阶段建立一张图。同时建立其他文档来概述不考虑现存数据库的情况下特定开发项目中所需的数据范围。此时仅仅包括高层类别的数据（实体）和主要联系。然后在系统开发生命周期的分析阶段产生确定信息系统必须管理的全部组织数据的详细数据模型，定义所有数据属性，列出全部数据类别，表示数据实体间所有的业务联系，确定描述数据完整性的全部规则。在分析阶段，还要检查概念数据模型（在后面也称作概念模式）与用来解释目标信息系统其他方面的模型类别的一致性，例如处理步骤、处理数据的规则以及时间的时序。然而，即使是这样详细的概念数据模型也只是初步的，因为后续的信息系统生命周期中的活动在设计事务、报表、显示和查询时可能会发现遗漏的元素或错误。因此，经常说到的概念数据建模是以一种自顶向下的方式完成的，它由业务领域的一般理解所驱动，而不是由特定的信息处理活动所驱动。
1.3 逻辑数据库设计
逻辑数据库设计从两个角度进行数据库开发。首先，将概念数据模型变换成基于关系数据库理论的标准表示方法——关系。然后像设计信息系统的每个计算机程序（包括程序的输入和输出格式）那样，对数据库支持的事务、报表、显示和查询进行详细的检查。在这个所谓的自底向上的分析中，精确地验证数据库中需要维护的数据和在每个事务、报表等等中需要的那些数据的性质。
对于每个单独的报表、事务等等的分析都要考虑一个特定的、有限制的但是完全的数据库视图。当报表、事务等被分析时有可能根据需要而改变概念数据模型。尤其在大型的项目中，不同的分析人员和系统开发者的团队可以独立地工作在不同的程序或程序集中，他们所有工作的细节直到逻辑设计阶段才可能会显示出来。在这种情况下，逻辑数据库设计阶段必须将原始的概念数据模型和这些独立的用户视图合并或集成到一个全面的设计中。在进行逻辑信息系统设计时也可以确定额外的
信息处理需求，此时这些新的需求必须集成到前面确定的逻辑数据库设计中。
逻辑数据库设计的最后一步是根据为生成结构良好的数据规格说明而确定的规则，将组合的、协商后的数据规格说明转换成基本的或原子的元素。对当今的大部分数据库而言，这些规则来自关系数据库理论和称作规范化的过程。这一步的结果是产生管理这些数据的、不引用任何数据库管理系统的完整的数据库描述图。在完成逻辑数据库设计后，开始确定详细的计算机程序的逻辑和维护、报告数据库内容所需的查询。
1.4 物理数据库设计和定义
物理数据库设计和定义阶段决定计算机存储器（通常是磁盘）中数据库的组织，定义数据库管理系统的物理结构，概述处理事务的程序，产生期望的管理信息和决策支持的报表。本阶段的目标是设计能够有效、安全地管理所有数据处理的数据库，因此物理数据库设计需紧密结合物理信息系统其他方面的设计，包括程序、计算机硬件、操作系统和数据通信网络。
1.5 数据库实现
数据库实现阶段编写、测试和安装处理数据库的程序。设计人员可以使用标准的编程语言（如COBOL、C或Visual Basic）、专用的数据库处理语言（如SQL），或专用的非过程化语言来编程，以产生固定格式的报表、显示结果，可能还包括图表。在实现阶段，还要完成所有的数据库文档，培训用户，为信息系统（和数据库）的用户安装程序。最后一步是利用现存的信息源（遗留应用中的文件和数据库以及现在需要的新数据）加载数据。加载数据的第一步经常是将数据从现存的文件和数据库中转到一种中间的格式（如二进制或文本文件），然后再将这些中间数据加载到新的数据库中。最后，运行数据库以及相关的应用以供实际的用户维护和检索数据。在运转期间，定期备份数据库，并当数据库损坏或受到影响时恢复数据库。1.6 数据库维护
数据库在数据库维护期间逐渐发展。在这一步，为了满足变化的业务条件，为了改正数据库设计的错误，或数据库应用的处理速度而增加、删除或改变数据库的结构特征。当一个程序或计算机发生故障而使数据库受到影响或损坏时也可能应该重建数据库。这一步通常是数据库开发过程中最长的一步，因为它持续数据库及相关应用的整个生命周期，每次数据库的发展都可看作一个简略的数据库开发过程，其中会出现概念数据建模、逻辑和物理数据库设计以及数据库实现以处理提出的变
化。
二. 信息系统开发的其他方法
系统开发生命周期法或其稍作变化的变体经常用于指导信息系统和数据库的开发。信息系统生命周期是一种方法学，它是高度结构化的方法，它包括许多检查和权衡以确保每一步产生精确的结果，而且新的或替代的信息系统与它必须通信的或数据定义需要一致的现存系统保持一致。系统开发生命周期法经常由于产生一个工作系统需要很长的时间而受到批评，因为工作系统仅仅在整个过程结束时才产生。现在组织越来越多的使用快速应用开发法，它是一个包含分析、设计和实现步骤的快速重复的迭代过程，直到汇聚到用户所需的系统为止。快速应用开发法在所需的数据库已经存在、增强系统主要是为了检索数据的应用中适用，而不适用于那些生成和修改数据库的应用。
使用最广泛的快速应用开发法之一是原型法。原型法是一个系统开发的迭代过程，通过分析员和用户的紧密配合，持续地修改系统而最终将所有需求转换成一个工作系统。在此图中我们包含了注释，概略地描述了每个原型法阶段的数据库开发活动。一般来说，当信息系统的问题被确定时，仅仅粗略地尝试概念数据建模。在开发最初的原型时，设计用户想要的显示和报表，同时理解任何新的数据库需求并定义一个用语原型的数据库。这通常是一个新的数据库，它复制现存系统的一部分，还可能增加了一些新的内容。当需要新的内容时，这些内容通常来自外部数据源，如市场研究数据、一般的经济指标或行业标准。
当产生原型新的版本时重复数据库的实现和维护活动。通常仅进行最低限度的安全性和完整性控制，因为此时的重点是尽可能快地产生可以使用的原型版本。而且文档管理也延迟到项目的最后，在交付使用时才进行用户培训。最后，一旦构建了一个可接受的原型，开发者和用户将决定最后的原型和数据库是否能交付使用。如果系统（包括数据库）效率很低，那么系统和数据库将被重新编程和重新组织以达到期望的性能。
随着可视化编程工具（如Visual Basic、Java、Visual C++和第四代语言）越来越流行，利用可视化编程工具可以很方便地修改用户与系统间的界面，原型法正成为可供选择的系统开发方法。使用原型法改变用户报表和显示的内容和布局是相当容易的。在这个过程中，新的数据库需求被确定，因此被发展中的应用使用的现存的数据库应该进行修改。甚至有可能为一个需要新的数据库的系统使用原型法，
在这种情况下，当系统需求在迭代的开发过程中不断变化时需要获取样本数据以建造或重建数据库原型。
附件2：外文原文
Database Development Process
Based on information engineering information systems planning database is a source of development projects. These new database development projects is usually in order to meet the strategic needs of organizations, such as improving customer support, improve product and inventory management, or a more accurate sales forecast. However, many more database development project is the bottom-up approach emerging, such as information system user needs specific information to complete their work, thus beginning a project request, and as other information systems experts found that organizations need to improve data management and begin new projects. Bottom-up even in the circumstances, to set up an enterprise data model is also necessary to understand the existing database can provide the necessary data, otherwise, the new database, data entities and attributes can be added to the current data resources to the organization.
Both the strategic needs or operational information needs of each database development projects normally concentrated in a database. Some projects only concentrated in the database definition, design and implementation of a database, as a follow-up to the basis of the development of information systems. However, in most cases, the database and associated information processing function as a complete information systems development project was part of the development.
one. System Development Life Cycle
Guide management information system development projects is the traditional process of system development life cycle (SDLC). System development life cycle is an organization of the database designers and programmers information system composed of the Panel of Experts detailed description, development, maintenance and replacement of the entire information system steps. This process is because Waterfall than for every step into the adjacent the next step, that is, the information system is a specification developed by a piece of land, every piece of the output is under an input. However shown in the figure, these steps are not purely linear, each of the steps overlap in time (and thus
can manage parallel steps), but when the need to reconsider previous decisions, but also to roll back some steps ahead. (And therefore water can be put back in the waterfall!) The system development life cycle including each stage and database development-related activities, therefore, the question of database management systems throughout the entire development process. In Figure 5 we repeat of the system development life cycle stage of the seven, and outlines the common database at each stage of development activities. Please note that the systems development life cycle stages and database development steps exists between the relationship between the concept of modeling data in both systems development life cycle stages between.
1.1 Enterprise Modeling
Database development process from the enterprise modeling (system development life cycle stage of the project feasibility studies, and to choose a part)
Organizations set the scope and general database content. Enterprise modeling in information systems planning and other activities, these activities determine which part of information systems need to change and strengthen the entire organization and outlines the scope of data. In this step, check the current database and information systems, development of the project as the main areas of the nature of the business, with a very general description of each term in the development of information systems when needed data. Each item only when it achieved the expected goals of organizations can be when the next step.
1.2 Conceptual Data Modeling
One has already begun on the Information System project, the concept of data modeling phase of the information systems needs of all the data. It is divided into two stages. First, it began the project in the planning stage. At the same time outlining the establishment of other documents to the existing database without considering the circumstances specific development projects in the scope of the required data. This category only includes high-level data (entities), and main contact. Then in the system development life-cycle analysis stage must have a management information system set the entire organization Details of the data model definition of all data attributes, listing all data types that all data inter-entity business linkages, defining description of the full data
integrity rules. In the analysis phase, but also the concept of inspection data model (also called the concept behind the model) and the goal of information systems used to explain other aspects of the model of consistency categories, such as processing steps, rules and data processing time of timing. However, even if the concept is such detailed data model is only preliminary, because follow-up information system life cycle activities in the design of services, statements, display and inquiries may find that missing element or mistakes. Therefore, the concept of data often said that modeling is a top-down manner, its areas of operation from the general understanding of the driver, rather than the specific information processing activities by the driver.
1.3 Logical Database Design
Logical database design from two perspectives database development. First, the concept of data model transform into relational database theory based on the criteria that means - between. Then, as the design of information systems, every computer procedures (including procedures for the input and output format), database support services, statements, and inquiries revealed that a detailed examination. In this so-called Bottom-up analysis, accurate verification of the need to maintain the database and the data in each affairs, statements and so on the needs of those in the nature of the data. For each separate statements, services, and so on the analysis must take into account a specific, limited but complete database view. When statements, services, and other analysis might be necessary to change the concept of data model. Especially in large-scale projects, the different analytical systems development staff and the team can work independently in different procedures or in a centralized, the details of their work until all the logic design stage may be displayed. In these circumstances, logic database design stage must be the original concept of data model and user view these independent or merged into a comprehensive design. In logic design information systems also identify additional information processing needs of these new demands at this time must be integrated into the logic of earlier identified in the database design.Logical database design is based on the final step for the formation of good data specifications and determine the rules, the combination, the data after consultation specifications or converted into basic atomic element. Most of today's database, these rules from the
relational database theory and the process known as standardization, #. This step is the result of management of these data have not cited any database management system for a complete description of the database map. Logical database design completed, we began to identify in detail the logic of the computer program and maintenance, the report contents of the database for inquiries.
1.4 Physical database design and definition
Physical database design and definition phase decisions computer memory (usually disk) database in the organization, definition of According to the library management system for physical structure, the procedures outlined processing services, produce the desired management information and decision support statements. The objective of this stage is to design an effective and safe management of all data-processing database, the physical database design to closely integrate the information systems of other physical aspects of the design, including procedures, computer hardware, operating systems and data communications networks.
1.5 Database Implementation
The database prepared by the realization stage, testing and installation procedures for handling databases. Designers can use the standard programming language (such as COBOL, C or Visual Basic), the dedicated database processing languages (such as SQL), or the process of the non-exclusive language programming in order to produce a statement of the fixed format, the result will be displayed, and may also include charts. In achieving stage, but also the completion of all the database files, training users for information systems (database) user setup program. The final step is to use existing sources of information (documents legacy applications and databases and now needs new data) loading data. Loading data is often the first step in data from existing files and databases to an intermediate format (such as binary or text files) and then to turn intermediate loading data to a new database. Finally, running databases and related applications for the actual user maintenance and retrieval of data. In operation, the regular backup database and the database when damaged or affected resume database.
1.6 Database maintenance
During the database in the progressive development of database maintenance. In this
step, in order to meet changing business conditions, in order to correct the erroneous database design, database applications or processing speed increase, delete or change the structure of the database. When a procedure or failure of the computer database affect or damage the database may also be reconstruction. This step usually is the longest in the database development process step, as it continued to databases and related applications throughout the life cycle, the development of each database can be seen as a brief database development process and data modeling concepts arise, logical and physical database design and database to achieve dealing with the changes.
two. Information System developed by other means
System Development Life Cycle minor changes in law or its variant of the often used to guide information systems and database development. Information System is a life-cycle methodology, it is highly structured approach, which includes many checks and balances to ensure that every step of produce accurate results, and new or alternative information system and it must communications or data definitions consistent existing system needs consistency. System development life cycle because of the regular need to have a working system for a long time been criticized because only work in the system until the end of the whole process generated. More and more organizations now use rapid application development method, it is a includes analysis, design and implementation of steps to repeat the rapid iterative process until convergence to users the system so far. Rapid Application Development Act required the database has been in existence, and enhance system is mainly to the application of data retrieval application, but not to those who generate and modify database applications.
The most widely used method of rapid application development is one of the prototype. The prototype system is a method of iterative development process, analysts and users through close co-operation, continuing to revise the system will eventually convert all the needs of a working system. In this diagram we contains notes, briefly describes each stage of the prototype of the database development activities. Normally, when information systems problems were identified, tried only a rough concept of data modeling. In the development of the initial prototype, the design of the user wants to display and statements, and that any new database needs and define a term prototype
database. This is usually a new database, copy the part of the existing system, but might also added some new content. When the need for new content, these elements are usually from external data sources, such as market research data, the general economic indicators or industry standards. When a prototype of a new version to repeat the achievement and maintenance of database activities. Usually only a minimum level of security and integrity control, because at this time the focus is as soon as possible to produce a prototype version can be used. But document management project also deferred to the final, only be used in the delivery of user training. Finally, once constructed an acceptable prototype, developers, and users will be the final decision of whether to prototype delivery and the use of the database. If the system (including database) efficiency is very low, then the system and database will be re-programming and re-organization in order to achieve the desired performance.
Along with visual programming tools (such as Visual Basic, Java, Visual C + + and fourth generation language) increasingly popular use of visual programming tools can easily change the user interface with the system, the prototype is becoming the choice o f system development methodology. Customers using the prototype method statements and show changes to the content and layout is quite easy. In the process, the new database needs were identified, so it is the development of the use of the existing database should be amended. There is even the possibility of a need for a new database system prototype method, in such circumstances, when the system demand in the iterative process of development in the ever-changing needs access to sample data, the construction or reconstruction of the database prototype.
Database Management System Source：Database and Network Journal Author：David Anderson You know that a data is a collection of logically related data elements that may be structured in various ways to meet the multiple processing and retrieval needs of orga nizations and individuals. There’s nothing new about data base-early ones were chiseled in stone, penned on scrolls, and written on index cards. But now database are commonly recorded on magnetically media, and computer programs are required to perform the necessary storage and retrieval operations. The system software package that handles the difficult tasks associated with created, accessing, and maintaining database records is 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 programmers.) A DBMS can organize, process, and present selected data elements from the database. This capability enables decision makers to search. Probe, and query data 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 programmers, who, when time permits, will information. The availability of a DBMS, however, offers users a much faster alternative communications patch (see figure). Special, direct, and other file processing approaches ate used to organize and structure data in single files. But a DBMS is able to integrate data elements from several files to answer specific user inquiries fir information. This means that the DBMS is able to structure and tie together the logically related data from several large files. Logical structures. Identifying these logical relationships is a job of the data administrator. A data definition language is used for this purpose. The DBMS may
Working with Databases This chapter describes how to use SQL statements in embedded applications to control databases. There are three database statements that set up and open databases for access: SET DATABASE declares a database handle, associates the handle with an actual database file, and optionally assigns operational parameters for the database. SET NAMES optionally specifies the character set a client application uses for CHAR, VARCHAR, and text Blob data. The server uses this information to transli terate from a database?s default character set to the client?s character set on SELECT operations, and to transliterate from a client application?s character set to the database character set on INSERT and UPDATE operations. g CONNECT opens a database, allocates system resources for it, and optionally assigns operational parameters for the database.All databases must be closed before a program ends. A database can be closed by using DISCONNECT, or by appending the RELEASE option to the final COMMIT or ROLLBACK in a program. Declaring a database Before a database can be opened and used in a program, it must first be declared with SET DATABASE to: CHAPTER 3 WORKING WITH DATABASES. Establish a database handle. Associate the database handle with a database file stored on a local or remote node.A database handle is a unique, abbreviated alias for an actual database name. Database handles are used in subsequent CONNECT, COMMIT RELEASE, and ROLLBACK RELEASE statements to specify which databases they should affect. Except in dynamic SQL (DSQL) applications, database handles can also be used inside transaction blocks to qualify, or differentiate, table names when two or more open databases contain identically named tables. Each database handle must be unique among all variables used in a program. Database handles cannot duplicate host-language reserved words, and cannot be InterBase reserved words.The following statement illustrates a simple database declaration:
管理信息系统外文翻译-标准化文件发布号：（9456-EUATWK-MWUB-WUNN-INNUL-DDQTY-KII
英文文献翻译 二〇年月日
科技文章摘译 Definition of a Management Information System There is no consensus of the definition of the term "management information system". Some writers prefer alternative terminology such as "information processing system", "information and decision system", "organizational information system", or simply "information system" to refer to the computer-based information processing system which supports the operations, management, and decision-making functions of an organization. This text uses “MIS” because it is descriptive and generally understood; it also frequently uses “information system” instead of “MIS” to refer to an organizational information system. A definition of a management information system, as the term is generally understood, is an integrated, user-machine system for providing information to support operations, management, and decision-making functions in an organization. The system utilizes computer hardware and software; manual procedures; models for analysis planning, control and decision making; and a database. The fact that it is an integrated system does not mean that it is a single, monolithic structure; rather, it means that the parts fit into an overall design. The elements of the definition are highlighted below. 1 Computer-based user-machine system Conceptually, management information can exist without computer, but it is the power of the computer which makes MIS feasible. The question is not whether computers should be used in management information system, but the extent to which information use should be computerized. The concept of a user-machine system implies that some tasks are best performed by humans, while others are best done by machine. The user of an MIS is any person responsible for entering input data, instructing the system, or utilizing the information output of the system. For many problems, the user and the computer form a combined system with results obtained through a set of interactions between the computer and the user. User-machine interaction is facilitated by operation in which the user’s input-output device (usually a visual display terminal) is connected to the computer. The computer can be a personal computer serving only one user or a large computer that
企业数据建模外文翻译文献 (文档含中英文对照即英文原文和中文翻译) 翻译： 信息系统开发和数据库开发 在许多组织中，数据库开发是从企业数据建模开始的，企业数据建模确定了组织数据库的范围和一般内容。这一步骤通常发生在一个组织进行信息系统规划的过程中，它的目的是为组织数据创建一个整体的描述或解释，而不是设计一个特定的数据库。一个特定的数据库为一个或多个信息系统提供数据，而企业数据模型（可能包含许多数据库）描述了由组织维护的数据的范围。在企业数据建模时，你审查当前的系统，分析需要支持的业务领域的本质，描述需要进一步抽象的数据，并且规划一个或多个数据库开发项目。图1显示松谷家具公司的企业数据模型的一个部分。 1.1 信息系统体系结构 如图1所示，高级的数据模型仅仅是总体信息系统体系结构(ISA)一个部分或一个组
织信息系统的蓝图。在信息系统规划期间，你可以建立一个企业数据模型作为整个信息系统体系结构的一部分。根据Zachman(1987)、Sowa和Zachman（1992）的观点，一个信息系统体系结构由以下6个关键部分组成: 数据（如图1所示，但是也有其他的表示方法）。 操纵数据的处理（着系可以用数据流图、带方法的对象模型或者其他符号表示）。 网络，它在组织内并在组织与它的主要业务伙伴之间传输数据（它可以通过网络连接和拓扑图来显示）。 人，人执行处理并且是数据和信息的来源和接收者（人在过程模型中显示为数据的发送者和接收者）。 执行过程的事件和时间点（它们可以用状态转换图和其他的方式来显示）。 事件的原因和数据处理的规则（经常以文本形式显示，但是也存在一些用于规划的图表工具，如决策表）。 1.2 信息工程 信息系统的规划者按照信息系统规划的特定方法开发出信息系统的体系结构。信息工程是一种正式的和流行的方法。信息工程是一种面向数据的创建和维护信息系统的方法。因为信息工程是面向数据的，所以当你开始理解数据库是怎样被标识和定义时，信息工程的一种简洁的解释是非常有帮助的。信息工程遵循自顶向下规划的方法，其中，特定的信息系统从对信息需求的广泛理解中推导出来（例如，我们需要关于顾客、产品、供应商、销售员和加工中心的数据），而不是合并许多详尽的信息请求（如一个订单输入屏幕或按照地域报告的销售汇总）。自顶向下规划可使开发人员更全面地规划信息系统，提供一种考虑系统组件集成的方法，增进对信息系统与业务目标的关系的理解，加深对信息系统在整个组织中的影响的理解。 信息工程包括四个步骤:规划、分析、设计和实现。信息工程的规划阶段产生信息系统体系结构，包括企业数据模型。 1.3 信息系统规划 信息系统规划的目标是使信息技术与组织的业务策略紧密结合，这种结合对于从信息系统和技术的投资中获取最大利益是非常重要的。正如表1所描述的那样，信息工程方法的规划阶段包括3个步骤，我们在后续的3个小节中讨论它们。 1.确定关键性的规划因素
数据库外文参考文献及翻译 数据库外文参考文献及翻译数据库管理系统——实施数据完整性一个数据库，只有用户对它特别有信心的时候。这就是为什么服务器必须实施数据完整性规则和商业政策的原因。执行SQL Server的数据完整性的数据库本身，保证了复杂的业务政策得以遵循，以及强制性数据元素之间的关系得到遵守。因为SQL Server的客户机/服务器体系结构允许你使用各种不同的前端应用程序去操纵和从服务器上呈现同样的数据，这把一切必要的完整性约束，安全权限，业务规则编码成每个应用，是非常繁琐的。如果企业的所有政策都在前端应用程序中被编码，那么各种应用程序都将随着每一次业务的政策的改变而改变。即使您试图把业务规则编码为每个客户端应用程序，其应用程序失常的危险性也将依然存在。大多数应用程序都是不能完全信任的，只有当服务器可以作为最后仲裁者，并且服务器不能为一个很差的书面或恶意程序去破坏其完整性而提供一个后门。SQL Server使用了先进的数据完整性功能，如存储过程，声明引用完整性（DRI），数据类型，限制，规则，默认和触发器来执行数据的完整性。所有这些功能在数据库里都有各自的用途;通过这些完整性功能的结合，可以实现您的数据库的灵活性和易于管理，而且还安全。声明数据完整性声明数据完整原文请找腾讯3249114六,维-论'文.网 https://www.doczj.com/doc/7b12239307.html, 定义一个表时指定构成的主键的列。这就是所谓的主键约束。SQL Server使用主键约束以保证所有值的唯一性在指定的列从未侵犯。通过确保这个表有一个主键来实现这个表的实体完整性。有时，在一个表中一个以上的列（或列的组合）可以唯一标志一行，例如，雇员表可能有员工编号（ emp_id ）列和社会安全号码（ soc_sec_num ）列，两者的值都被认为是唯一的。这种列经常被称为替代键或候选键。这些项也必须是唯一的。虽然一个表只能有一个主键，但是它可以有多个候选键。 SQL Server的支持多个候选键概念进入唯一性约束。当一列或列的组合被声明是唯一的， SQL Server 会阻止任何行因为违反这个唯一性而进行的添加或更新操作。在没有故指的或者合适的键存在时，指定一个任意的唯一的数字作为主键，往往是最有效的。例如，企业普遍使用的客户号码或账户号码作为唯一识别码或主键。通过允许一个表中的一个列拥有身份属性，SQL Server可以更容易有效地产生唯一数字。您使用的身份属性可以确保每个列中的值是唯一的，并且值将从你指定的起点开始，以你指定的数量进行递增（或递减）。（拥有特定属性的列通常也有一个主键或唯一约束，但这不是必需的。）第二种类型的数据完整性是参照完整性。 SQL Server实现了表和外键约束之间的逻辑关系。外键是一个表中的列或列的组合，连接着另一个表的主键（或着也可能是替代键）。这两个表之间的逻辑关系是关系模型的基础;参照完整性意味着这种关系是从来没有被违反的。例如，一个包括出版商表和标题表的简单的select例子。在标题表中，列title_id （标题编号）是主键。在出版商表，列pub_id （出版者ID ）是主键。 titles表还包括一个pub_id列，这不是主键，因为出版商可以发布多个标题。相反， pub_id是一个外键，它对应着出版商表的主键。如果你在定义表的时候声明了这个关系， SQL Server由双方执行它。首先，它确保标题不能进入titles表，或在titles表中现有的pub_id无法被修改，除非有效的出版商ID作为新pub_id出现在出版商表中。其次，它确保在不考虑titles表中对应值的情况下，出版商表中的pub_id的值不做任何改变。以下两种方法可
Enterprise Human Resources Management System Design And Implementation Abstract: Human resource management system is the core content of modern enterprise management. With the rapid development of the computer information technology and unprecedented prevalence of electronic commerce mode，the competition between enterprises is turning from visible economic markets to the network. Developing the human resource management system supported by computer technology，network technology and information technology can not only improve the skill of human resource management and the efficiency of the enterprises but also make human resource management modern and decision sciencefic,Modern human resource management uses B/S mode to avoid C/S modes short coming of difficult in maintdning and reusing.According to the functional requirements of the actual project,this article specificly state the analysis of system,the general desigin of the system,the detail design of system and the practice of the system. The development of the system is the practice of MVC design ideas, maing using the Jsp+Servlet+JavaBean form of development.Jsp is the practice of MVC design ideas’view,in charge of receiving/responding the request of the customer.Servlet mainly responsible for the core business control of the whole system is the practice of the vontroller of MVC design idea to take charge of the statistics and rules of the whole system. In the practice of the system, somr open-source projrcts,such as the Ajax technique,JfreChart statements,fileupload technology,has been used. Using the modern human resource management theropy and analysising the actual situation, comparing the current situation of human resource management system, a huaman resource contents of management system basied on the Internet/Intranet has been designed. The main management,attendance management training more efficient statistics. Keywords:human resource management; B/S mode; Open-source projects; MVC mode. 摘要 人力资源管理系统是现代企业管理的核心内容。随着计算机信息技术的高速发展，电子商务模式的空前盛行，企业之间的竞争也从有形的经济市场转向了网络。开发以计算机技术、网络技术、信息技术支持的现代人力资源管理系统，既能提高企业人力资源管理的技术含量和企业的办事效率，也能使人力资源管理能够进入现代化、决策科学化的进程。现代人力资源管理系统采用了B/S模式，可以避免C/S模式的重用性差、维护难度高的缺点和
英文翻译 数据库管理系统的介绍 Raghu Ramakrishnan 数据库（database,有时被拼作data base）又称为电子数据库，是专门组织起来的一组数据或信息，其目的是为了便于计算机快速查询及检索。数据库的结构是专门设计的，在各种数据处理操作命令的支持下，可以简化数据的存储、检索、修改和删除。数据库可以存储在磁盘、磁带、光盘或其他辅助存储设备上。 数据库由一个或一套文件组成，其中的信息可以分解为记录，每一条记录又包含一个或多个字段（或称为域）。字段是数据存取的基本单位。数据库用于描述实体，其中的一个字段通常表示与实体的某一属性相关的信息。通过关键字以及各种分类（排序）命令，用户可以对多条记录的字段进行查询，重新整理，分组或选择，以实体对某一类数据的检索，也可以生成报表。 所有数据库（除最简单的）中都有复杂的数据关系及其链接。处理与创建，访问以及维护数据库记录有关的复杂任务的系统软件包叫做数据库管理系统（DBMS）。DBMS软件包中的程序在数据库与其用户间建立接口。（这些用户可以是应用程序员，管理员及其他需要信息的人员和各种操作系统程序）DBMS可组织、处理和表示从数据库中选出的数据元。该功能使决策者能搜索、探查和查询数据库的内容，从而对正规报告中没有的，不再出现的且无法预料的问题做出回答。这些问题最初可能是模糊的并且（或者）是定义不恰当的，但是人们可以浏览数据库直到获得所需的信息。简言之，DBMS将“管理”存储的数据项和从公共数据库中汇集所需的数据项用以回答非程序员的询问。 DBMS由3个主要部分组成：（1）存储子系统，用来存储和检索文件中的数据；（2）建模和操作子系统，提供组织数据以及添加、删除、维护、更新数据的方法；（3）用户和DBMS之间的接口。在提高数据库管理系统的价值和有效性方面正在展现以下一些重要发展趋势： 1.管理人员需要最新的信息以做出有效的决策。 2.客户需要越来越复杂的信息服务以及更多的有关其订单，发票和账号的当前信息。
外文翻译： 索引 原文来源：Thomas Kyte．Expert Oracle Database Architecture ．2nd Edition． 译文正文： 什么情况下使用B*树索引? 我并不盲目地相信“法则”（任何法则都有例外），对于什么时候该用B*索引，我没有经验可以告诉你。为了证明为什么这个方面我无法提供任何经验，下面给出两种等效作法：?使用B*树索引，如果你想通过索引的方式去获得表中所占比例很小的那些行。 ?使用B *树索引，如果你要处理的表和索引许多可以代替表中使用的行。 这些规则似乎提供相互矛盾的意见，但在现实中，他们不是这样的，他们只是涉及两个极为不同的情况。有两种方式使用上述意见给予索引： ?作为获取表中某些行的手段。你将读取索引去获得表中的某一行。在这里你想获得表中所占比例很小的行。 ?作为获取查询结果的手段。这个索引包含足够信息来回复整个查询，我们将不用去查询全表。这个索引将作为该表的一个瘦版本。 还有其他方式—例如，我们使用索引去检索表的所有行，包括那些没有建索引的列。这似乎违背了刚提出的两个规则。这种方式获得将是一个真正的交互式应用程序。该应用中，其中你将获取其中的某些行，并展示它们，等等。你想获取的是针对初始响应时间的查询优化，而不是针对整个查询吞吐量的。 在第一种情况（也就是你想通过索引获得表中一小部分的行）预示着如果你有一个表T （使用与早些时候使用过的相一致的表T）,然后你获得一个像这样查询的执行计划： ops$tkyte%ORA11GR2> set autotrace traceonly explain ops$tkyte%ORA11GR2> select owner, status 2 from t 3 where owner = USER; Execution Plan ---------------------------------------------------------- Plan hash value: 1049179052 ------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes | ------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 2120 | 23320 | | 1 | TABLE ACCESS BY INDEX ROWID |T | 2120 | 23320 | | *2 | INDEX RANGE SCAN | DESC_T_IDX | 8 | | ------------------------------------------------------------------ Predicate Information (identified by operation id): --------------------------------------------------- 2 - access(SYS_OP_DESCEND("OWNER")=SYS_OP_DESCEND(USER@!)) filter(SYS_OP_UNDESCEND(SYS_OP_DESCEND("OWNER"))=USER@!) 你应该访问到该表的一小部分。这个问题在这里看是INDEX (RANGE SCAN) 紧跟在
餐饮管理系统外文翻译文献(文档含中英文对照即英文原文和中文翻译) 英文： 1、China food industry development prospects analysis The catering industry in China as the tertiary industry is a traditional service industries, experienced reforming and opening starts, quantitative expansion, scale chain development and brand promotion strategy of 4phase, made make a spurt of progress in the development of. At present, the country has4 millions catering outlets. 2005/2006annual Chinese top 100 catering enterprises with total assets of about thirty-two billion yuan, total profit of about six billion yuan, employees about eight hundred thousand people, respectively, over the same period last year increased40.38%,28.84% and33.33% higher than that of the whole society, the catering industry average growth level. China's reform and opening up has gone through ups and downs in the30year, in the30 years of reforming and opening of China's catering industry along with the tide of reform has undergone three leap type development. In the past 30 years, China has experienced from fast food restaurants grabs beach China market to SARS impact, then to food safety ( tonyred event, apple events ), Chinese food and beverage industry in the impact, achieve sales growth.
河北工程大学毕业论文（设计）英文参考文献原文复印件及译文 数据仓库 数据仓库为商务运作提供结构与工具，以便系统地组织、理解和使用数据进行决策。大量组织机构已经发现，在当今这个充满竞争、快速发展的世界，数据仓库是一个有价值的工具。在过去的几年中，许多公司已花费数百万美元，建立企业范围的数据仓库。许多人感到，随着工业竞争的加剧，数据仓库成了必备的最新营销武器——通过更多地了解客户需求而保住客户的途 径。“那么”，你可能会充满神秘地问，“到底什么是数据仓库？” 数据仓库已被多种方式定义，使得很难严格地定义它。宽松地讲，数据仓库是一个数据库，它与组织机构的操作数据库分别维护。数据仓库系统允许将各种应用系统集成在一起，为统一的历史数据分析提供坚实的平台，对信息处理提供支持。 按照W. H. Inmon，一位数据仓库系统构造方面的领头建筑师的说法，“数 (1) 视图。 (2)
般文件和联机事务处理记录，集成在一起。使用数据清理和数据集成技术，确保命名约定、编码结构、属性度量的一致性等。 (3)时变的：数据存储从历史的角度（例如，过去5-10 年）提供信息。数据仓库中的关键结构，隐式或显式地包含时间元素。 (4) 非易失的：数据仓库总是物理地分离存放数据；这些数据源于操作环境下的应用数据。由于这种分离，数据仓库不需要事务处理、恢复和并行控制机制。通常，它只需要两种数据访问：数据的初始化装入和数据访问。 概言之，数据仓库是一种语义上一致的数据存储，它充当决策支持数据模型的物理实现，并存放企业决策所需信息。数据仓库也常常被看作一种体系结构，通过将异种数据源中的数据集成在一起而构造，支持结构化和启发式查询、分析报告和决策制定。 “好”，你现在问，“那么，什么是建立数据仓库？” 根据上面的讨论，我们把建立数据仓库看作构造和使用数据仓库的过程。数据仓库的构造需要数据集成、数据清理、和数据统一。利用数据仓库常常需要一些决策支持技术。这使得“知识工人”（例如，经理、分析人员和主管）能够使用数据仓库，快捷、方便地得到数据的总体视图，根据数据仓库中的信息做出准确的决策。有些作者使用术语“建立数据仓库”表示构造数据仓库的过程，而用术语“仓库DBMS”表示管理和使用数据仓库。我们将不区分二者。 “组织机构如何使用数据仓库中的信息？”许多组织机构正在使用这些信息支持商务决策活动，包括: (1)、增加顾客关注，包括分析顾客购买模式（如，喜爱买什么、购买时间、预算周期、消费习惯）； (2)、根据季度、年、地区的营销情况比较，重新配置产品和管理投资，调整生产策略； (3)、分析运作和查找利润源； (4)、管理顾客关系、进行环境调整、管理合股人的资产开销。 从异种数据库集成的角度看，数据仓库也是十分有用的。许多组织收集了形形色色数据，并由多个异种的、自治的、分布的数据源维护大型数据库。集成这些数据，并提供简便、有效的访问是非常希望的，并且也是一种挑战。数据库工业界和研究界都正朝着实现这一目标竭尽全力。 对于异种数据库的集成，传统的数据库做法是：在多个异种数据库上，建立一个包装程序和一个集成程序（或仲裁程序）。这方面的例子包括IBM 的数据连接程序和Informix的数据刀。当一个查询提交客户站点，首先使用元数据字典对查询进行转换，将它转换成相应异种站点上的查询。然后，将这些查询
毕业设计(论文)外文资料翻译设计(论文)题目图书管理系统 院系计算机工程系 专业计算机科学与技术 年级 学生学号1040520007 学生姓名bianhaiwei 外文出处CHINA-USA Business Review
Combining JSP and Servlets The technology of JSP and Servlet is the most important technology which use Java technology to exploit request of server, and it is also the standard which exploit business application .Java developers prefer to use it for a variety of reasons, one of which is already familiar with the Java language for the development of this technology are easy to learn Java to the other is "a preparation, run everywhere" to bring the concept of Web applications, To achieve a "one-prepared everywhere realized." And more importantly, if followed some of the principles of good design, it can be said of separating and content to create high-quality, reusable, easy to maintain and modify the application. For example, if the document in HTML embedded Java code too much (script), will lead the developed application is extremely complex, difficult to read, it is not easy reuse, but also for future maintenance and modification will also cause difficulties. In fact, CSDN the JSP / Servlet forum, can often see some questions, the code is very long, can logic is not very clear, a large number of HTML and Java code mixed together. This is the random development of the defects. Early dynamic pages mainly CGI (Common Gateway Interface, public Gateway Interface) technology, you can use different languages of the CGI programs, such as VB, C / C + + or Delphi, and so on. Though the technology of CGI is developed and powerful, because of difficulties in programming, and low efficiency, modify complex shortcomings,