數(shù)據(jù)庫開發(fā)過程外文翻譯

1、<p>　　畢業(yè)設(shè)計(jì)(論文)外文資料翻譯</p><p>　　學(xué) 院： 信息工程學(xué)院 </p><p>　　專 業(yè)： 計(jì)算機(jī)科學(xué)與技術(shù) </p><p>　　姓 名： XXXXXX </p><p>

2、;　　學(xué) 號： XXXXXXXXXX </p><p>　　外文出處： http://www.181w.com/lwzl_info. </p><p>　　asp?ztId=467&page=1 </p><p>　　附 件： 1.外文資料翻譯譯文；2.外文原文。</p&g

3、t;<p>　　附件1：外文資料翻譯譯文</p><p><b>　　數(shù)據(jù)庫開發(fā)過程</b></p><p>　　基于信息工程的信息系統(tǒng)規(guī)劃是數(shù)據(jù)庫開發(fā)項(xiàng)目的一個來源。這些開發(fā)新數(shù)據(jù)庫的項(xiàng)目通常是為了滿足組織的戰(zhàn)略需求，例如改善客戶支持、提高產(chǎn)品和庫存管理或進(jìn)行更精確的銷售預(yù)測。然而許多數(shù)據(jù)庫開發(fā)項(xiàng)目更多的是以自底向上的方式出現(xiàn)的，例如信息系統(tǒng)的用戶需要

4、特定的信息來完成他們的工作，從而請求開始一個項(xiàng)目，又如其他信息系統(tǒng)的專家發(fā)現(xiàn)組織需要改進(jìn)數(shù)據(jù)管理而開始新的項(xiàng)目。即使在自底向上的情況下，建立企業(yè)數(shù)據(jù)模型也是必須的，以便理解現(xiàn)有的數(shù)據(jù)庫是否可以提供所需的數(shù)據(jù)，否則，新的數(shù)據(jù)庫、數(shù)據(jù)實(shí)體和屬性都應(yīng)該加到當(dāng)前的組織數(shù)據(jù)資源中去。</p><p>　　無論是戰(zhàn)略需求還是操作信息的需求，每個數(shù)據(jù)庫開發(fā)項(xiàng)目通常集中在一個數(shù)據(jù)庫上。一些數(shù)據(jù)庫項(xiàng)目僅僅集中在定義、設(shè)計(jì)和實(shí)現(xiàn)一個

5、數(shù)據(jù)庫，以作為后續(xù)信息系統(tǒng)開發(fā)的基礎(chǔ)。然而在大多數(shù)情況下，數(shù)據(jù)庫及其相關(guān)信息處理功能是作為一個完整的信息系統(tǒng)開發(fā)項(xiàng)目的一部分而被開發(fā)的。</p><p>　　一. 系統(tǒng)開發(fā)生命周期</p><p>　　指導(dǎo)管理信息系統(tǒng)開發(fā)項(xiàng)目的傳統(tǒng)過程是系統(tǒng)開發(fā)生命周期(SDLC)。系統(tǒng)開發(fā)生命周期是指一個組織中由數(shù)據(jù)庫設(shè)計(jì)人員和程序員組成的信息系統(tǒng)專家小組詳細(xì)說明、開發(fā)、維護(hù)和替換信息系統(tǒng)的全部步驟。這

6、個過程比作瀑布是因?yàn)槊恳徊蕉剂鞯较噜彽南乱徊?，即信息系統(tǒng)的規(guī)格說明是一塊一塊地開發(fā)出來的，每一塊的輸出是下一塊的輸入。然而如圖所示，這些步驟并不是純線性的，每個步驟在時(shí)間上有所重疊（因此可以并行地管理步驟），而且當(dāng)需要重新考慮先前的決策時(shí)，還可以回滾到前面某些步驟。（因而水可以在瀑布中倒流?。┫到y(tǒng)開發(fā)生命周期的每一階段都包括與數(shù)據(jù)庫開發(fā)相關(guān)的活動，所以，數(shù)據(jù)庫管理的問題遍布整個系統(tǒng)開發(fā)過程。請注意，系統(tǒng)開發(fā)生命周期的階段和數(shù)據(jù)庫開發(fā)步驟

7、之間不存在一一對應(yīng)的關(guān)系，概念數(shù)據(jù)建模發(fā)生在兩個系統(tǒng)開發(fā)生命周期階段之間。</p><p><b>　　1.1 企業(yè)建模 </b></p><p>　　數(shù)據(jù)庫開發(fā)過程從企業(yè)建模（系統(tǒng)開發(fā)生命周期中項(xiàng)目論證和選擇階段的一部分）開始，設(shè)定組織數(shù)據(jù)庫的范圍和一般內(nèi)容。企業(yè)建模發(fā)生在信息系統(tǒng)規(guī)劃和其他活動期間，這些活動確定信息系統(tǒng)的哪個部分需要改變和加強(qiáng)并概述出全部組織數(shù)據(jù)的

8、范圍。在這一步中，檢查當(dāng)前數(shù)據(jù)庫和信息系統(tǒng)，分析作為開發(fā)項(xiàng)目主體的業(yè)務(wù)領(lǐng)域的本質(zhì)，用非常一般的術(shù)語描述每個信息系統(tǒng)在開發(fā)時(shí)所需要的數(shù)據(jù)。每個項(xiàng)目只有當(dāng)它達(dá)到組織的預(yù)期目標(biāo)時(shí)才可以進(jìn)行下一步。</p><p>　　1.2 概念數(shù)據(jù)建模 </p><p>　　對一個已經(jīng)開始的信息系統(tǒng)項(xiàng)目而言，概念數(shù)據(jù)建模階段分析信息系統(tǒng)的全部數(shù)據(jù)需求。它分為兩個階段。首先，它在項(xiàng)目開始和規(guī)劃階段建立一張圖。同

9、時(shí)建立其他文檔來概述不考慮現(xiàn)存數(shù)據(jù)庫的情況下特定開發(fā)項(xiàng)目中所需的數(shù)據(jù)范圍。此時(shí)僅僅包括高層類別的數(shù)據(jù)（實(shí)體）和主要聯(lián)系。然后在系統(tǒng)開發(fā)生命周期的分析階段產(chǎn)生確定信息系統(tǒng)必須管理的全部組織數(shù)據(jù)的詳細(xì)數(shù)據(jù)模型，定義所有數(shù)據(jù)屬性，列出全部數(shù)據(jù)類別，表示數(shù)據(jù)實(shí)體間所有的業(yè)務(wù)聯(lián)系，確定描述數(shù)據(jù)完整性的全部規(guī)則。在分析階段，還要檢查概念數(shù)據(jù)模型（在后面也稱作概念模式）與用來解釋目標(biāo)信息系統(tǒng)其他方面的模型類別的一致性，例如處理步驟、處理數(shù)據(jù)的規(guī)則以及

10、時(shí)間的時(shí)序。然而，即使是這樣詳細(xì)的概念數(shù)據(jù)模型也只是初步的，因?yàn)楹罄m(xù)的信息系統(tǒng)生命周期中的活動在設(shè)計(jì)事務(wù)、報(bào)表、顯示和查詢時(shí)可能會發(fā)現(xiàn)遺漏的元素或錯誤。因此，經(jīng)常說到的概念數(shù)據(jù)建模是以一種自頂向下的方式完成的，它由業(yè)務(wù)領(lǐng)域的一般理解所驅(qū)動，而不是由特定的信息處理活動所驅(qū)動。</p><p>　　1.3 邏輯數(shù)據(jù)庫設(shè)計(jì)</p><p>　　邏輯數(shù)據(jù)庫設(shè)計(jì)從兩個角度進(jìn)行數(shù)據(jù)庫開發(fā)。首先，將概念

11、數(shù)據(jù)模型變換成基于關(guān)系數(shù)據(jù)庫理論的標(biāo)準(zhǔn)表示方法——關(guān)系。然后像設(shè)計(jì)信息系統(tǒng)的每個計(jì)算機(jī)程序（包括程序的輸入和輸出格式）那樣，對數(shù)據(jù)庫支持的事務(wù)、報(bào)表、顯示和查詢進(jìn)行詳細(xì)的檢查。在這個所謂的自底向上的分析中，精確地驗(yàn)證數(shù)據(jù)庫中需要維護(hù)的數(shù)據(jù)和在每個事務(wù)、報(bào)表等等中需要的那些數(shù)據(jù)的性質(zhì)。</p><p>　　對于每個單獨(dú)的報(bào)表、事務(wù)等等的分析都要考慮一個特定的、有限制的但是完全的數(shù)據(jù)庫視圖。當(dāng)報(bào)表、事務(wù)等被分析時(shí)有可

12、能根據(jù)需要而改變概念數(shù)據(jù)模型。尤其在大型的項(xiàng)目中，不同的分析人員和系統(tǒng)開發(fā)者的團(tuán)隊(duì)可以獨(dú)立地工作在不同的程序或程序集中，他們所有工作的細(xì)節(jié)直到邏輯設(shè)計(jì)階段才可能會顯示出來。在這種情況下，邏輯數(shù)據(jù)庫設(shè)計(jì)階段必須將原始的概念數(shù)據(jù)模型和這些獨(dú)立的用戶視圖合并或集成到一個全面的設(shè)計(jì)中。在進(jìn)行邏輯信息系統(tǒng)設(shè)計(jì)時(shí)也可以確定額外的信息處理需求，此時(shí)這些新的需求必須集成到前面確定的邏輯數(shù)據(jù)庫設(shè)計(jì)中。</p><p>　　邏輯數(shù)據(jù)

13、庫設(shè)計(jì)的最后一步是根據(jù)為生成結(jié)構(gòu)良好的數(shù)據(jù)規(guī)格說明而確定的規(guī)則，將組合的、協(xié)商后的數(shù)據(jù)規(guī)格說明轉(zhuǎn)換成基本的或原子的元素。對當(dāng)今的大部分?jǐn)?shù)據(jù)庫而言，這些規(guī)則來自關(guān)系數(shù)據(jù)庫理論和稱作規(guī)范化的過程。這一步的結(jié)果是產(chǎn)生管理這些數(shù)據(jù)的、不引用任何數(shù)據(jù)庫管理系統(tǒng)的完整的數(shù)據(jù)庫描述圖。在完成邏輯數(shù)據(jù)庫設(shè)計(jì)后，開始確定詳細(xì)的計(jì)算機(jī)程序的邏輯和維護(hù)、報(bào)告數(shù)據(jù)庫內(nèi)容所需的查詢。</p><p>　　1.4 物理數(shù)據(jù)庫設(shè)計(jì)和定義<

14、;/p><p>　　物理數(shù)據(jù)庫設(shè)計(jì)和定義階段決定計(jì)算機(jī)存儲器（通常是磁盤）中數(shù)據(jù)庫的組織，定義數(shù)據(jù)庫管理系統(tǒng)的物理結(jié)構(gòu)，概述處理事務(wù)的程序，產(chǎn)生期望的管理信息和決策支持的報(bào)表。本階段的目標(biāo)是設(shè)計(jì)能夠有效、安全地管理所有數(shù)據(jù)處理的數(shù)據(jù)庫，因此物理數(shù)據(jù)庫設(shè)計(jì)需緊密結(jié)合物理信息系統(tǒng)其他方面的設(shè)計(jì)，包括程序、計(jì)算機(jī)硬件、操作系統(tǒng)和數(shù)據(jù)通信網(wǎng)絡(luò)。</p><p><b>　　1.5 數(shù)據(jù)庫實(shí)現(xiàn)

15、</b></p><p>　　數(shù)據(jù)庫實(shí)現(xiàn)階段編寫、測試和安裝處理數(shù)據(jù)庫的程序。設(shè)計(jì)人員可以使用標(biāo)準(zhǔn)的編程語言（如COBOL、C或Visual Basic）、專用的數(shù)據(jù)庫處理語言（如SQL），或?qū)Ｓ玫姆沁^程化語言來編程，以產(chǎn)生固定格式的報(bào)表、顯示結(jié)果，可能還包括圖表。在實(shí)現(xiàn)階段，還要完成所有的數(shù)據(jù)庫文檔，培訓(xùn)用戶，為信息系統(tǒng)（和數(shù)據(jù)庫）的用戶安裝程序。最后一步是利用現(xiàn)存的信息源（遺留應(yīng)用中的文件和數(shù)據(jù)庫

16、以及現(xiàn)在需要的新數(shù)據(jù)）加載數(shù)據(jù)。加載數(shù)據(jù)的第一步經(jīng)常是將數(shù)據(jù)從現(xiàn)存的文件和數(shù)據(jù)庫中轉(zhuǎn)到一種中間的格式（如二進(jìn)制或文本文件），然后再將這些中間數(shù)據(jù)加載到新的數(shù)據(jù)庫中。最后，運(yùn)行數(shù)據(jù)庫以及相關(guān)的應(yīng)用以供實(shí)際的用戶維護(hù)和檢索數(shù)據(jù)。在運(yùn)轉(zhuǎn)期間，定期備份數(shù)據(jù)庫，并當(dāng)數(shù)據(jù)庫損壞或受到影響時(shí)恢復(fù)數(shù)據(jù)庫。</p><p><b>　　1.6 數(shù)據(jù)庫維護(hù)</b></p><p>　　數(shù)

17、據(jù)庫在數(shù)據(jù)庫維護(hù)期間逐漸發(fā)展。在這一步，為了滿足變化的業(yè)務(wù)條件，為了改正數(shù)據(jù)庫設(shè)計(jì)的錯誤，或數(shù)據(jù)庫應(yīng)用的處理速度而增加、刪除或改變數(shù)據(jù)庫的結(jié)構(gòu)特征。當(dāng)一個程序或計(jì)算機(jī)發(fā)生故障而使數(shù)據(jù)庫受到影響或損壞時(shí)也可能應(yīng)該重建數(shù)據(jù)庫。這一步通常是數(shù)據(jù)庫開發(fā)過程中最長的一步，因?yàn)樗掷m(xù)數(shù)據(jù)庫及相關(guān)應(yīng)用的整個生命周期，每次數(shù)據(jù)庫的發(fā)展都可看作一個簡略的數(shù)據(jù)庫開發(fā)過程，其中會出現(xiàn)概念數(shù)據(jù)建模、邏輯和物理數(shù)據(jù)庫設(shè)計(jì)以及數(shù)據(jù)庫實(shí)現(xiàn)以處理提出的變化。</

18、p><p>　　二. 信息系統(tǒng)開發(fā)的其他方法</p><p>　　系統(tǒng)開發(fā)生命周期法或其稍作變化的變體經(jīng)常用于指導(dǎo)信息系統(tǒng)和數(shù)據(jù)庫的開發(fā)。信息系統(tǒng)生命周期是一種方法學(xué)，它是高度結(jié)構(gòu)化的方法，它包括許多檢查和權(quán)衡以確保每一步產(chǎn)生精確的結(jié)果，而且新的或替代的信息系統(tǒng)與它必須通信的或數(shù)據(jù)定義需要一致的現(xiàn)存系統(tǒng)保持一致。系統(tǒng)開發(fā)生命周期法經(jīng)常由于產(chǎn)生一個工作系統(tǒng)需要很長的時(shí)間而受到批評，因?yàn)楣ぷ飨到y(tǒng)僅

19、僅在整個過程結(jié)束時(shí)才產(chǎn)生?，F(xiàn)在組織越來越多的使用快速應(yīng)用開發(fā)法，它是一個包含分析、設(shè)計(jì)和實(shí)現(xiàn)步驟的快速重復(fù)的迭代過程，直到匯聚到用戶所需的系統(tǒng)為止?？焖賾?yīng)用開發(fā)法在所需的數(shù)據(jù)庫已經(jīng)存在、增強(qiáng)系統(tǒng)主要是為了檢索數(shù)據(jù)的應(yīng)用中適用，而不適用于那些生成和修改數(shù)據(jù)庫的應(yīng)用。</p><p>　　使用最廣泛的快速應(yīng)用開發(fā)法之一是原型法。原型法是一個系統(tǒng)開發(fā)的迭代過程，通過分析員和用戶的緊密配合，持續(xù)地修改系統(tǒng)而最終將所有需求

20、轉(zhuǎn)換成一個工作系統(tǒng)。在此圖中我們包含了注釋，概略地描述了每個原型法階段的數(shù)據(jù)庫開發(fā)活動。一般來說，當(dāng)信息系統(tǒng)的問題被確定時(shí)，僅僅粗略地嘗試概念數(shù)據(jù)建模。在開發(fā)最初的原型時(shí)，設(shè)計(jì)用戶想要的顯示和報(bào)表，同時(shí)理解任何新的數(shù)據(jù)庫需求并定義一個用語原型的數(shù)據(jù)庫。這通常是一個新的數(shù)據(jù)庫，它復(fù)制現(xiàn)存系統(tǒng)的一部分，還可能增加了一些新的內(nèi)容。當(dāng)需要新的內(nèi)容時(shí)，這些內(nèi)容通常來自外部數(shù)據(jù)源，如市場研究數(shù)據(jù)、一般的經(jīng)濟(jì)指標(biāo)或行業(yè)標(biāo)準(zhǔn)。</p>&

21、lt;p>　　當(dāng)產(chǎn)生原型新的版本時(shí)重復(fù)數(shù)據(jù)庫的實(shí)現(xiàn)和維護(hù)活動。通常僅進(jìn)行最低限度的安全性和完整性控制，因?yàn)榇藭r(shí)的重點(diǎn)是盡可能快地產(chǎn)生可以使用的原型版本。而且文檔管理也延遲到項(xiàng)目的最后，在交付使用時(shí)才進(jìn)行用戶培訓(xùn)。最后，一旦構(gòu)建了一個可接受的原型，開發(fā)者和用戶將決定最后的原型和數(shù)據(jù)庫是否能交付使用。如果系統(tǒng)（包括數(shù)據(jù)庫）效率很低，那么系統(tǒng)和數(shù)據(jù)庫將被重新編程和重新組織以達(dá)到期望的性能。</p><p>　　隨

22、著可視化編程工具（如Visual Basic、Java、Visual C++和第四代語言）越來越流行，利用可視化編程工具可以很方便地修改用戶與系統(tǒng)間的界面，原型法正成為可供選擇的系統(tǒng)開發(fā)方法。使用原型法改變用戶報(bào)表和顯示的內(nèi)容和布局是相當(dāng)容易的。在這個過程中，新的數(shù)據(jù)庫需求被確定，因此被發(fā)展中的應(yīng)用使用的現(xiàn)存的數(shù)據(jù)庫應(yīng)該進(jìn)行修改。甚至有可能為一個需要新的數(shù)據(jù)庫的系統(tǒng)使用原型法，在這種情況下，當(dāng)系統(tǒng)需求在迭代的開發(fā)過程中不斷變化時(shí)需要獲取

23、樣本數(shù)據(jù)以建造或重建數(shù)據(jù)庫原型。附件2：外文原文</p><p>　　Database Development Process</p><p>　　Based on information engineering information systems planning database is a source of development projects. These new data

24、base 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 m

25、ore database development project is the bottom-up approach emerging, such as information system user needs specific information to complete their work, thus b</p><p>　　Both the strategic needs or operational

26、 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 bas

27、is 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. </p&

28、gt;<p>　　one. System Development Life Cycle</p><p>　　Guide management information system development projects is the traditional process of system development life cycle (SDLC). System development lif

29、e 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 ste

30、ps. This process is because Waterfall than for every step into the adjacent the next step, that is, the information system is a speci</p><p>　　The system development life cycle including each stage and datab

31、ase 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 out

32、lines 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 mode<

33、/p><p>　　1.1 Enterprise Modeling </p><p>　　Database development process from the enterprise modeling (system development life cycle stage of the project feasibility studies, and to choose a part)&l

34、t;/p><p>　　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 t

35、o 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

36、, with a very general description of each term in the development of information </p><p>　　1.2 Conceptual Data Modeling </p><p>　　One has already begun on the Information System project, the con

37、cept 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 docume

38、nts 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 th<

39、/p><p>　　1.3 Logical Database Design </p><p>　　Logical database design from two perspectives database development. First, the concept of data model transform into relational database theory based o

40、n 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 reve

41、aled that a detailed examination. In this so-called Bottom-up analysis, accurate verification of the need to maintain the database</p><p>　　1.4 Physical database design and definition</p><p>　　P

42、hysical 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

43、 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 da

44、tabase design to closely integrate the information systems </p><p>　　1.5 Database Implementation </p><p>　　The database prepared by the realization stage, testing and installation procedures for

45、 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 program

46、ming 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, train</p><p>　　1.6

47、Database maintenance </p><p>　　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 datab

48、ase 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 reconstructio

49、n. This step usually is the longest in the database development process step, as it continued to databas</p><p>　　two. Information System developed by other means </p><p>　　System Development Li

50、fe 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

51、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 dev

52、elopment life cycle because of the regu</p><p>　　The most widely used method of rapid application development is one of the prototype. The prototype system is a method of iterative development process, analy

53、sts 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

54、 database development activities. Normally, when information systems problems were identified, tried only a rough concept </p><p>　　Along with visual programming tools (such as Visual Basic, Java, Visual C +

55、 + 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 of system development methodology. Custom