计算机专业外文翻译+原文-数据库管理系统介绍.pdf

《计算机专业外文翻译+原文-数据库管理系统介绍.pdf》由会员分享，可在线阅读，更多相关《计算机专业外文翻译+原文-数据库管理系统介绍.pdf（11页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、扬州大学计算机专业毕业设计(外文翻译)1 外文资料Database Management SystemsA database(sometimes spelled data base)is also called an electronic database,referring to any collection of data,or information,that is specially organized for rapid search and retrieval by a computer.Databases are structured to facilitate the stor

2、age,retrieval,modification,and deletion of data in conjunction with various data-processing operations.Databases can be stored on magnetic disk or tape,optical disk,or some other secondary storage device.A database consists of a file or a set of files.The information in these files may be broken dow

3、n into records,each of which consists of one or more fields.Fields are the basic units of data storage,and each field typically contains information pertaining to one aspect or attribute of the entity described by the database.Using keywords and various sorting commands,users can rapidly search,rear

4、range,group,and select the fields in many records to retrieve or create reports on particular aggregate of data.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 m

5、aintaining 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

6、DBMS can organize,process,and present selected data elements form 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 initia

7、lly 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.A database manage

8、ment system(DBMS)is composed of three major parts:(1)a storage subsystem that stores and retrieves data in files;(2)a modeling and manipulation subsystem that provides the means with which to organize the data and to add,delete,maintain,and update the data;(3)and an interface between the DBMS and it

9、s users.Several major trends are emerging that enhance the value and usefulness of database management systems;扬州大学计算机专业毕业设计(外文翻译)2 Managers:who require more up-to-data information to make effective decision Customers:who demand increasingly sophisticated information services and more current inform

10、ation about the status of their orders,invoices,and accounts.Users:who find that they can develop custom applications with database systems in a fraction of the time it takes to use traditional programming languages.Organizations:that discover information has a strategic value;they utilize their dat

11、abase systems to gain an edge over their competitors.The Database Model A data model describes a way to structure and manipulate the data in a database.The structural part of the model specifies how data should be represented(such as tree,tables,and so on).The manipulative part of the model specifie

12、s the operation with which to add,delete,display,maintain,print,search,select,sort and update the data.Hierarchical ModelThe first database management systems used a hierarchical model-that is-they arranged records into a tree structure.Some records are root records and all others have unique parent

13、 records.The structure of the tree is designed to reflect the order in which the data will be used that is,the record at the root of a tree will be accessed first,then records one level below the root,and so on.The hierarchical model was developed because hierarchical relationships are commonly foun

14、d in business applications.As you have known,an organization char often describes a hierarchical relationship:top management is at the highest level,middle management at lower levels,and operational employees at the lowest levels.Note that within a strict hierarchy,each level of management may have

15、many employees or levels of employees beneath it,but each employee has only one manager.Hierarchical data are characterized by this one-to-many relationship among data.In the hierarchical approach,each relationship must be explicitly defined when the database is created.Each record in a hierarchical

16、 database can contain only one key field and only one relationship is allowed between any two fields.This can create a problem because data do not always conform to such a strict hierarchy.Relational Model A major breakthrough in database research occurred in 1970 when E.F.Codd proposed a fundamenta

17、lly different approach to database management called relational model,which uses a table as its data structure.The relational database is the most widely used database structure.Data is organized into related tables.Each table is made up of rows called and columns called fields.Each record contains

18、fields of data about some specific item.For example,in a table containing information on employees,a record 扬州大学计算机专业毕业设计(外文翻译)3 would contain fields of data such as a person s last name,first name,and street address.Structured query language(SQL)is a query language for manipulating data in a relati

19、onal database.It is nonprocedural or declarative,in which the user need only specify an English-like description that specifies the operation and the described record or combination of records.A query optimizer translates the description into a procedure to perform the database manipulation.Network

20、Model The network model creates relationships among data through a linked-list structure in which subordinate records can be linked to more than one parent record.This approach combines records with links,which are called pointers.The pointers are addresses that indicate the location of a record.Wit

21、h the network approach,a subordinate record can be linked to a key record and at the same time itself be a key record linked to other sets of subordinate records.The network mode historically has had a performance advantage over other database models.Today,such performance characteristics are only i

22、mportant in high-volume,high-speed transaction processing such as automatic teller machine networks or airline reservation system.Both hierarchical and network databases are application specific.If a new application is developed,maintaining the consistency of databases in different applications can

23、be very difficult.For example,suppose a new pension application is developed.The data are the same,but a new database must be created.Object Model The newest approach to database management uses an object model,in which records are represented by entities called objects that can both store data and

24、provide methods or procedures to perform specific tasks.The query language used for the object model is the same object-oriented programming language used to develop the database application.This can create problems because there is no simple,uniform query language such as SQL.The object model is re

25、latively new,and only a few examples of object-oriented database exist.It has attracted attention because developers who choose an object-oriented programming language want a database based on an object-oriented model.Distributed Database Similarly,a distributed database is one in which different pa

26、rts of the database reside on physically separated computers.One goal of distributed databases is the access of information without regard to where the data might be stored.Keeping in mind that once the users and their data are separated,the communication and networking concepts come into play.Distr

27、ibuted databases require software that resides partially in the larger computer.This software bridges the gap between personal and large computers and resolves the problems of incompatible data 扬州大学计算机专业毕业设计(外文翻译)4 formats.Ideally,it would make the mainframe databases appear to be large libraries of

28、 information,with most of the processing accomplished on the personal computer.A drawback to some distributed systems is that they are often based on what is called a mainframe-entire model,in which the larger host computer is seen as the master and the terminal or personal computer is seen as a sla

29、ve.There are some advantages to this approach.With databases under centralized control,many of the problems of data integrity that we mentioned earlier are solved.But today s personal computers,departmental computers,and distributed processing require computers and their applications to communicate

30、with each other on a more equal or peer-to-peer basis.In a database,the client/server model provides the framework for distributing databases.One way to take advantage of many connected computers running database applications is to distribute the application into cooperating parts that are independe

31、nt of one anther.A client is an end user or computer program that requests resources across a network.A server is a computer running software that fulfills those requests across a network.When the resources are data in a database,the client/server model provides the framework for distributing databa

32、se.A file serve is software that provides access to files across a network.A dedicated file server is a single computer dedicated to being a file server.This is useful,for example,if the files are large and require fast access.In such cases,a minicomputer or mainframe would be used as a file server.

33、A distributed file server spreads the files around on individual computers instead of placing them on one dedicated computer.Advantages of the latter server include the ability to store and retrieve files on other computers and the elimination of duplicate files on each computer.A major disadvantage

34、,however,is that individual read/write requests are being moved across the network and problems can arise when updating files.Suppose a user requests a record from a file and changes it while another user requests the same record and changes it too.The solution to this problems called record locking

35、,which means that the first request makes others requests wait until the first request is satisfied.Other users may be able to read the record,but they will not be able to change it.A database server is software that services requests to a database across a network.For example,suppose a user types i

36、n a query for data on his or her personal computer.If the application is designed with the client/server model in mind,the query language part on the personal computer simple sends the query across the network to the database server and requests to be notified when the data are found.Examples of dis

37、tributed database systems can be found in the engineering world.Sun s Network Filing System(NFS),for example,is used in computer-aided engineering applications to distribute data among the hard disks in a network of Sun workstation.Distributing databases is an evolutionary step because it is logical

38、 that data should exist at the 扬州大学计算机专业毕业设计(外文翻译)5 location where they are being used.Departmental computers within a large corporation,for example,should have data reside locally,yet those data should be accessible by authorized corporate management when they want to consolidate departmental data.

39、DBMS software will protect the security and integrity of the database,and the distributed database will appear to its users as no different from the non-distributed database.In this information age,the data server has become the heart of a company.This one piece of software controls the rhythm of mo

40、st organizations and is used to pump information lifeblood through the arteries of the network.Because of the critical nature of this application,the data server is also the one of the most popular targets for hackers.If a hacker owns this application,he can cause the companys heart to suffer a fata

41、l arrest.Ironically,although most users are now aware of hackers,they still do not realize how susceptible their database servers are to hack attacks.Thus,this article presents a description of the primary methods of attacking database servers(also known as SQL servers)and shows you how to protect y

42、ourself from these attacks.You should note this information is not new.Many technical white papers go into great detail about how to perform SQL attacks,and numerous vulnerabilities have been posted to security lists that describe exactly how certain database applications can be exploited.This artic

43、le was written for the curious non-SQL experts who do not care to know the details,and as a review to those who do use SQL regularly.What Is a SQL Server?A database application is a program that provides clients with access to data.There are many variations of this type of application,ranging from t

44、he expensive enterprise-level Microsoft SQL Server to the free and open source mySQL.Regardless of the flavor,most database server applications have several things in common.First,database applications use the same general programming language known as SQL,or Structured Query Language.This language,

45、also known as a fourth-level language due to its simplistic syntax,is at the core of how a client communicates its requests to the server.Using SQL in its simplest form,a programmer can select,add,update,and delete information in a database.However,SQL can also be used to create and design entire da

46、tabases,perform various functions on the returned information,and even execute other programs.To illustrate how SQL can be used,the following is an example of a simple standard SQL query and a more powerful SQL query:Simple:Select*from dbFurniture.tblChair This returns all information in the table t

47、blChair from the database dbFurniture.扬州大学计算机专业毕业设计(外文翻译)6 Complex:EXEC master.xp_cmdshell dir c:This short SQL command returns to the client the list of files and folders under the c:directory of the SQL server.Note that this example uses an extended stored procedure that is exclusive to MS SQL Ser

48、ver.The second function that database server applications share is that they all require some form of authenticated connection between client and host.Although the SQL language is fairly easy to use,at least in its basic form,any client that wants to perform queries must first provide some form of c

49、redentials that will authorize the client;the client also must define the format of the request and response.This connection is defined by several attributes,depending on the relative location of the client and what operating systems are in use.We could spend a whole article discussing various techn

50、ologies such as DSN connections,DSN-less connections,RDO,ADO,and more,but these subjects are outside the scope of this article.If you want to learn more about them,a little Googleing will provide you with more than enough information.However,the following is a list of the more common items included