内容发布更新时间 : 2024/5/12 15:46:03星期一 下面是文章的全部内容请认真阅读。

SQL server database management and maintenance

To connect SQL Server database

First we introduce the basic knowledge of the database,be regarded as the warm-up exercise that study database weave distance front! 1.warm-up exercise

Needing first avowal is relation database that database knowledge that we here introduce all point. The so-called relation database is to mean data as that the form gather, passing to establish simple form an a kind of database for of relation to defining construction.

I ignore the watch at how saving way in physics in the document in database is,it can see to make an a line for with row, with electronics form is similar with the row.Inrelation database, the line were called the record, but the row then is called wordsegment.

This form inside each an all in formations for is a record, it including particular customer, but each record then included the same type with the word segment of the quantity:Customer's number, name etc.

Form is logic set that a kind of related information that press a line of arranging with row, similar in single form in work.

Each row of the word a database form inside calls a word segment. Watch isfrom every kind of word a definition of its containment of, each word a data for describing its implying. While creating to set up a database, the beard assign for each word segment a the piece belongs to the sex with the other according to the type,biggestlength.The word segment can include every kind of word sign,arithmetic figure even sketch.

An information of relevant customer deposits in the line of the form, is called record.By any large, arbitrarily two records for database form to create set up can't be same.

Key be a certain word segment( or several words segment) of the form inside, it() for fast inspect but drive index. The key can be unique, and also can then the rightand wrong is unique, being decided by it() whether admission repetition. Unique key can specify for main key, using each one that come to unique marking form.

The norm turns the database design of mission be method that the data of buildup,but the data of buildup, should can dissolve otiose repetition, and for have the necessary information offering to check to seek the path quickly. For attaining this kind of target but separate information to the process gone to in every kind of independent form, be called the norm turn.

It is complicated process to use many appointed rules to proceed the norm with the type of the different Class that norm turn. That process studies and discuss already beyond the reach of textual scope.But,the norm of the simple database in majority turn and can use the simple experience in underneath rule completes: include the form of the information of repetition must be divided into independent a few forms dissolve repetition.

If we have chosen to learn 12 curricular 1000 students, the each curricular elucidation will show with the teacher 100 many- to choose that curricular and

SQL server database management and maintenance

eachstudent repeat once.To avoid this kind of low efficiency, should to turn the dichotomous and independent form in form to the norm,an is used to mean the student,the another uses mean the course.

Now the form was turned by the norm, so, to changes the particular and curricular course describe or\data\long as change a record all right.Is a basic knowledge concerning database above,this is what study database plait distance must.Although the database technique is used as a course,its depth is not this space and can describe with the wide degree of,be used as the primer with simple database plait the distance should be all right already.Like,underneath we can start practicing.Weusually meet the database system is to registers the system,ignoring you are in the unit,or attend what buildup,the register is to cans not help of,and it of the construction is more simple,we take a register system as an example.The analysis is once a data for involving. 2. understanding the elements

For the register, want the on the trail of information include:name、sex、native place、age、date of birth、unit、address、postal service codes、telephone、FAX. Certainly,can create to set up a form in brief,make above each piece according to item to should a word segment.Need to point the form the main key in parties now, in order to unique marking each a record,increase register number conduct and actions unique key respectively in register form,guarantee a two records like this all different.To the database after making an above analysis,we can start establishing thedatabase.

3.set up the firm in camp

Here we study to establish the database how,needing to make sure the type that to establish the database first.Pass in Visual Basic the data interview control piece or data interview object ( DAO) can visit the following database:

1)The database of JET, namely Microsoft Access

2)The database of ISAM, such as: DBase, etc. of FoxPro

3)The database of ODBC,every follow the standard of ODBC customer/ server database. Such as: Microsoft SQL Server, Oracle

By any large, if develop the personal small scaled database system, use Access database comparison accommodation, to develop the big and medium-sized database system uses the database of ODBC fester. But dBase with the database of FoxProbecause of already dated,unless special circumstance,do not use otherwise.In our example, chose to use the database of Access certainly. Establish the database of Access contain two kinds of methods: While establishing the database in Microsoft Access. Click\new set up\button can establish the new form. Here we main introduction the second method: The usage can see to turn the data management machine, do not need to weave the distance and then can create to set up the database.Can see to turn the data management machine is the applied procedure of a great use,it is a VB business enterprise version is supplementary with the profession version, in the catalogue\\..\\ Devastation\\ vb\\ samples\\ the Visdata is next, its interface is as follows the diagram.Click the menu\set up\

SQL server database management and maintenance

new setting upthe name of the database in flick window way open\the underneath show the window way:Want the born and new form, the single shot in right key database window way flicks the menu open, then the choice\ordinaries,establishing in\for wanting segment. The every time faces to join in the form new word segment, single shot\increment word segment\button, will appear of\increment word segment\to word segment.In our the register database that establish, the type of the each word segment.Want to notice of is, because the word segment registers the number be used unique marking record of, therefore, it can't be inputted by customer. So while defining the word's segment need to be defined for Long data type, the \automatic born word segment\like this to input to record with other the different value every input a new record, system would on the word's segment automatically.

In ACCESS database, the key word realizes with the index of, conduct and actions plait distance personnel at gather to weave the distance to the record of the form type,needs to adjust to use index.Whilesearching,the technique of Rushmore uses the index information the excellent turning the search automatically. Aftercompleting the form definition, click\figure 5 show the window way.In window way the right side contain three optioned, its meaning, such as table,12.Increase the index dialog box options.After completing such as figure 6.Certainly, the academic association database establishes too not a dynasty the business of the one night, the reader no harm much practices once.

Visit databases design and the development of the application procedures of MS Visual Basics of the databases of the SQL Server. When design a system, the customer still needs to comprehend to use to come to visit the plait distance of ask the data of SQL Server to connect. The origin was detailed to elaborate that the usage open type database conjunction (the Open Database Connectivity, ODBC) adjusts to connect the objects to connect with the class, still having the data interviews object(the Data Access Objects, the DAO) and the long-range data objects.

Design and weave to write large and complicated and applied procedure's database design for the software developer is a challenge, need to choose to weave the distance language and tools, do an accommodation for the SQL Server, choose the calculate way and the data structures, still need to design the sketch customer interface and the application procedures to connect. The decision within the most important software design is applied fixed position of the procedure. In other words, design must specify the system of which parts are data, business rule, and the data entrance procedure and used for circulating the code of other part. The MS Visual Basic supports the plait distance that some databases manage the systems connect, especially SQL Server. Adjust to connect to include the ODBC and DB-Libraries to connect the, object to connect to include the data interview object (DAO), long range data object (the RDO), the OLE DB and the ActiveX Data Objects (ADO) with the class, the SQL that returns the capable SQL Server to manage the mission distributesto manage the object (the SQL Distributed management Objects, SQL-DMO) to connect.