1、 附 录 The development process of the SQL Server The SQL Server is a relation database management system of the Microsoft company, but speak of its history, have to start from the Sybase.The SQL Server from expect to start develop after 80s for 20 centuries, originated Sybase SQL Server for 1987 years
2、 at the earliest stage.The SQL Server at the beginning from Microsoft,Sybase and Ashton-Tate three companies develop together of, 1988, the Microsoft company,the Sybase company and the Aston-Tate company transplant that product to the OS/2.Afterwards the Aston-Tate company withdrew the development o
3、f that product, but the Microsoft company,the Sybase company then signed a common development agreement, the common development result of these two companies is the SQL Server that released to used for the operate system of Windows NT, 1992, transplanted the SQL Server to the platform of Windows NT
4、up. After the SQL Server 4 editions publish, the Microsoft company and the Sybase company develop aspect to go by different roads in the SQL Server, canceling contract, each from develop an own SQL Server.The Microsoft company is absorbed in the SQL Server development of the platform of Windows NT,
5、but the Sybase company then concentrate on the development of the SQL Server of the UNIX platform.In this text introduction of is the Microsoft SQL Server to will call for the SQL Server or the MS SQL Server hereafter. SQL Server6.0 versions are the first complete from the edition of the Microsoft c
6、ompany development.In 1996, the Microsoft companys releasing the SQL Server was 6.5 editions, releasing to have 7.0 versions of the huge variety again in 1998 immediately after, this edition was saving to take place the variety ofwith root with database- powered aspect in the data.Again through the
7、diligent development of two years, the Microsoft company cloth in September of 2000 the SQL Server 2000, include a business enterprise version,standardversion,the development version,personal editions with four version among them.From the SQL Server 7.0 arrive the SQL Server 2000 of the variety ente
8、r gradually, have no from 6.5-7.0 variety so big, just in the SQL Server 7.0 of the foundation go forward to go to build up. The SQL Server 2000 of characteristic 1. The Internet is integrated The SQL Server 2000 database engines provide the XML support of the integrity.It still has a data of consti
9、tute the biggest Web station point saving flexible need by module and can use sex and safe function.The SQL Server 2000 program design model and the Windows DNA frame integration, develop the Web application procedure in order to, and the SQL Server 2000 support English Query and Microsoft search a
10、service etc. function, included customer the search of the amity in the Web the applied procedure with search function strongly. 2. Flexible with can use sex The same of database engine can usage on the different platform, from circulate Microsoft Windows? 98 Of then the hold type computer, arrive t
11、o circulate the Microsoft Windows 2000 much more large processor server of the data center versions.The SQL Server 2000 business enterprise version support consociation the server,index see functions, such as diagram and the large memory support.etc., can make it get stripe to the function Class tha
12、t the biggest Web station need when order. 3. Business enterprise class database function The function that the data processing environment that the SQL Server 2000 relation database engine supports engraves nowadays need.The database engine protects the data integrity well, will manage in the meant
13、ime up to thousand erupt the expense of the customer of the modification database to reduce to the least.The SQL Server 2000 distribute type searches can make you quote from a data of come from the different data source, good elephant these datas is the SQL Server is 2000 a part of the databases, th
14、e distribute type business support protects the integrity ofwith any distribute type data renewal well in the meantime.The replication can make you support many pieces equally according to the copy, insuring lone data copy to keep synchronous in the meantime.Can make duplicate a set of data to many
15、to move of take off and connect customer, make these customers work independently, then returns the modification merger that they do to release a server. 4. Be easy to the gearing,deployment and usage The SQL Server 2000 win include a series management and develop tool, these tools can improve in se
16、veral stations to order up install,deploy,manage with use the SQL Server of process.The SQL Server 2000 still support according to the standard of,and the program design model of the Windows DNA integration, make the usage of the database of SQL Server and the data warehouse become born and strong f
17、lexible system of do not sew part.These functions can make you consign the SQL Server application procedure quickly, making customer need the minimal gearing and the management expense can immediately carry out these applied procedures. 5. Data warehouse The SQL Server 2000 win to include the tool t
18、hat the takes to gather a data with analysis to carry on the machine analysis processing(OLAP).Still include some tools in the SQL Server, can use to keep the view ground a design database and pass the English Query to the analysis data. SQL Server released from 1989 Microsoft company 1.0 have alrea
19、dy had fully 15 years to now, within this 15 years the SQL Server from have no to have, experience time and time again since the childhood of legend.It encroaches upon the market quota of the IBM,the Oracle database not only, and the SQL Server of the new generation have already graduallied start be
20、coming future core of the Windows operate system.But visit Bill of the ?The core that covers continuously repeateddid not sew a calculation in the mouth is a Yukon, the next generation database of this codeYukon will bring in us a what kind of world? 6. Internet ofsoft pay pillar In nowadays of the
21、network ages, the data checks to look for,the data is saving,the data classification etc. all alltheses have already become to constitute the Internet network ofsoft pay pillar, but the database system then this pays pillar in the most decisive of.If have no the support of database, our root impossi
22、bly checks to seek in the Google perhaps 100 degrees oneself demand of information, also impossibly use fast and convenient electronics mailbox, but say, the network world finish completely whole is what a big database constitute. IDC the latest data indicate that the global database software market
23、 seems to great waves to rise again, the gross earnings of 2003 comes to an USD 13,600,000,000, comparing USD 12,600,000,000 of 2002 and having a growth.The oracle-bone scripture,IBM and Microsoft control 75% market quotas currently.The market quota of oracle-bone scripture last year is 39.8%, the I
24、BM is 31.3%, Microsoft is 12.1%. So what is a database?In the calculator textbook of the university, the database is explained so:The database is the system of a kind of specialized management data resources in the calculator application system.The data contain various forms, such as writing,figures,sign,sketch,picture and voice etc.The data is the object that all
