外文翻譯----數(shù)據(jù)庫和數(shù)據(jù)倉(cāng)庫-文庫吧資料
2025-05-22 11:32本頁面
【正文】 means safeguarding the data against invalid alteration or destruction. In large online database system, data integrity bees a more server problem. Data Security Data security refers to the protection of a database against unauthorized or illegal access or modification. This usually involves one or more level of password protection that is specified in the data dictionary. For example, a highlevel password might allow a user to read from, write to, and modify the database structure, whereas a lowlevel password might only allow a user to read from the database. Usually an audit trail, the recorded history of the modifications to a database, can be used to identify where and when a database was tampered with and it can also be used to restore the file to its original condition. 畢業(yè)設(shè)計(jì)（論文）外文翻譯 7 數(shù)據(jù)庫和數(shù)據(jù)倉(cāng)庫 ？ 數(shù)據(jù)庫就是相關(guān)的數(shù)據(jù)項(xiàng)的集合。 these are the relational database, the hierarchical database, and the work database. Hierarchical, Network, and Relational Databases (three principal logical database models) The Hierarchical Model In a hierarchical database, data records are arranged in a strict parent child relationship. Each parent record may have many children, but each child record has exactly one parent. Figure 31 shows a simple hierarchical database, indicating the relationship between a customer and the orders it has placed with a pany. Searching a hierarchical database is rapid and convenient as long as it is searched from the top down. IBM’s IMS (Information 畢業(yè)設(shè)計(jì)（論文）外文翻譯 2 Management System) is the most widely used hierarchical DBMS. Hierarchical DBMS are best suited for problems that require a limited number of structure answers that can be specified in advance. Once data relationships have been specified, they cannot easily be changed without a major programming effort. Thus, the hierarchical model cannot respond flexibly to changing requests for information. The Network Model The work database model is best at representing manytomany relationship among data. In other words, a ”child” can have more than one “parent”, as Figure32 illustrates. Computer Associates ’IDMS is a work DBMS for puter mainframes. Network DBMS are more flexible than hierarchical DBMS, but access paths must still be specified in advance. There are practical limitations to the number of links, or relationships ,that can be established among records. If they are too numerous, the software will not work efficiently. Neither work no hierarchical database management models can easily create new relationships among data elements or new patterns of access without major programming efforts. The Relational Model In the early 1970s the relational database approach was developed to provide a much more userfriendly organization. Instead of using plex structures of pointers the relational database stores information simply as tables called relations. These tables are sometimes called flat because the rows of the table really are very much the same as the records of a file. Each row in a relation is called a record. Each column corresponds to a particular field within the record (fields are also called domains).The fields are headed by attributes, which describe the entries in the column. A relational database consists of one or more relations. A relational DBMS performs three primary operations on relations to form new relations: (1) Two relations may be joined (bined). (2) A relational may be projected (some of the columns are extracted form the relations and used to form the columns of the new relation). (3) Records may be selected accordi
畢業(yè)設(shè)計(jì)相關(guān)推薦
鄂ICP備17016276號(hào)-1