毕业设计翻译原文.doc

南京师范大学泰州学院英文翻译原文年 级： 07级 学 号： 09070131 姓 名： 赵晓红 系 部： 强化部 专 业： 计算机科学与技术 （师范） 题 目： 基于B/S结构的商品管理系统 指导教师： 倪红军 2011 年5 月8日Database OverviewA database consists of a file or a set of files. The information in these files may be broken down 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, rearrange, group, and select the fields in many records to retrieve or create reports on particular aggregates of data.Database records and files must be organized to allow retrieval of the information. Early systems were arranged sequentially (i.e., alphabetically, numerically, or chronologically); the development of direct-access storage devices made possible random access to data via indexes. Queries are the main way users retrieve database information. Typically, the user provides a string of characters, and the computer searches the database for a corresponding sequence and provides the source materials in which those characters appear. A user can request, for example, all records in which the content of the field for a persons last name is the word Smith.In flat databases 2, records are organized according to a simple list of entities; many simple databases for personal computers are flat in structure. The records in hierarchical databases are organized in a treelike structure, with each level of records branching off into a set of smaller categories. Unlike hierarchical databases, which provide single links between sets of records at different levels, network databases create multiple linkages between sets by placing links, or pointers, to one set of records in another; the speed and versatility of network databases have led to their wide use in business.Relational databases are used where associations among files or records cannot be expressed by links; a simple flat list becomes one table, or “relation”, and multiple relations can be mathematically associated to yield desired information. Object-oriented databases store and manipulate more complex data structures, called “objects”, which are organized into hierarchical classes that may inherit properties from classes higher in the chain; this database structure is the most flexible and adaptable.SQL Server as the network of small and medium-sized enterprises oriented database service system, provides with numerous senior database manager the same performance to traditional database vendors, launched a strong challenge. In the design process sequence: SQL Server adopted key and novel symmetric structure, so as to simplify the program design, and Microsoft in its Visual Basic Visual programming language for programmers provides good control; Daniel: in database tube in a SQL Server easy administration ways of dealing with many Server business management, provides a SQL Server system extension and beyond a single computer ability method.SQL Server mainly has the following functions: Comprehensive data integrity protection, whether complicated affairs support and advanced security, or user-oriented database implicit parts, and data integrity protection is applicable; With Windows NT integration, allow the symmetric multiprocessing (SMP) system to completely multithreading and symmetric multiprocessing, and can be integrated into the distributed management environment; In the low cost has outstanding performance platform; For the system administrator provide first-class management tool; On multiprocessor distributed affairs inner support. The following introduces a kind of how to use Microsoft SQL Server on Windows NT Server constructing the development environment, complete general client/Server applications. 1. On the SQL SERVER in creating a data equipment (create database for this database before must create a storage device) (1) from Microsoft SQL Server program group Utilties within the SQL EM open. (2) in the Server Manager window, the option to create the database Server. If HFNM. (3) Manage menu item choice, then select Database Device options. Manage Database Device window appears. (4) choose New Device button (first). New Database Device window appears. (5) Name: for to create device Name; Location: can choose to create device site (such as: c: databas e); (MB) : do the Size of setting this equipment used for database (usually the 1.25 times normal). (6), click the Create button, Create this device is empty. Note: please create database in before must first create two storage devices, is a database of physical equipment, the other is a database of logical device. 2. In SQL SERVER create a database (1) from Microsoft SQL Server 6.5 Utilties program in the group opened SQL EM. (2) in the Server Manager window, the option to create the database Server. If HFNM. (3) Manage menu item choice, then select Database options. Appear Manage Database window. (4) choose New Database button (first). Appear New Database window. (5) Name campaign for the database Name, physical equipment Data Device for database Name, do physical equipment is the distribution of storage space for database (MB); Questions for database Device logical Device name, is this Logic devices do for database distribution of storage space (MB). Please dont check Default Device options. (6) according to Create Now button, the official Create database.3. On the existing database creating tables (1) from Microsoft SQL Server program group Utilties within the SQL EM open. (2) in the Server Manager window, choose Server. Click to create the database tables by plus. Click on the database and Group/Users its components. (3) click next. Plus it components Server Manager will open, and shows it projects can operation of all database Objects. (4) choose Table is object. Then click Manager menu items, and select players project. Will appear in Manager (management form window. (5) now keep Table is for new combo box (if in combo box chose other tables, that yao can modify it). Name: field name on Datatype: field types Do: Nulls: whether to allow the length of the field a null value Default: Default value (6) press, Save form brings a button. 4. The data table created for the Lord keyword (1) started Microsoft SQL Server EM, selecting the appropriate servers and databases. Click on the plus side, Server database Manager will begin database, citing out all components. (2) click next to it, Server project Manager are listed plus symbol can operation of database Objects. (3) click the plus sign players folders beside. Right-click on the corresponding data table objects from the popup menu, then choose intended command. Choose Then players window Manage will appear on the screen. (4) click on the toolbar Features (Advanced Features on the button. Then will appear and form the more detailed information about. (5) in the first card (ask Identity), Key specific/main keyword can be set. Click on ask the window frame Key specific Names (listing) combo box. Will show did not set for a series of Nulls column name. Please select the appropriate column, has primarily keyword. (6) on the key word, it should be defined as (index type non - clustered). Click the Add button in the chart Add, Add the Lord keyword information. Note: (1) the definition of main key word for a data sheet, it was very important, if no main keyword, then this data sheet is read-only. (2) the main keyword in the definition of data table must be preserved, because the data table before in the preservation, adds field will not allow for the NULL type. 5. Create clustered index for form (1) start SQL EM, choose corresponding database. (2) Manage the menu from Indexes options. (3) in the Table is combo box, select the appropriate data tables. In the Index combo box, select , in order to create a new new Index. Inside the new index name input. (4) In Columns In Table is Available within the (forms Available column) list, choose proper column within and press the Add press button. This column name will be moved to the Columns In Index (Key specific) list box. Still can choose multicolumn. (5) in Attribute Index (Index properties), within the Clustered (choose window swarm) check box. (6) in the two radio button beside Clustered in duplicate, both rows says Allow repeat line. (7) according to Build button to begin creating the index. 6. In SQL Server for database open user (1) started Microsoft S