MS SQL Basics Tutorial: SQL Server2000 and the Internet: new features to support Web applications

In today's business world, the network is becoming more and more common, it permeates every corner of life, which has a great impact on the operation, organization and management of the enterprise. The network characteristic becomes the foundation which establishes the electronic commerce, the Internet, the enterprise internal network. SQL Server 2000 provides a significantly enhanced network capability to build a database solution. Using these network characteristics, users can use the enterprise data in a safe, fast and efficient way, through the Web page to the relevant departments or the distribution of customer groups. Therefore, this chapter focuses on the latest network features and their applications in SQL Server 2000.

SQL Server 2000 has complete Web functionality that enables organizations to store data either on a Web page or in an XML document, or store it in a database, which is perfectly suited to build business-to-business (business to business) or consumer (business to Customer) mode e-business. and provides a high degree of scalability and reliability for Web applications by supporting a client/server model with multi-tier architectures. SQL Server 2000 Works "harmoniously" with the Windows DNA 2000 platform, making it easy for businesses or organizations of all sizes to trade with customers and vendors on the web, and to integrate older systems into the next generation of business solutions. In addition, SQL Server 2000 helps companies better understand the behavior of customers or vendors on the Web site and quickly discovers new business opportunities offered by the digital economy. The new network features of SQL Server 2000 are mainly manifested in the following aspects:< SQL Server 2000 and BizTalk Server 2000 support an integrated XML structure that allows you to apply directly from a database via BizTalk Server 2000 Programs to manage and send documents, data mining can automatically filter through a large number of business information to help customers identify new opportunities that have not been discovered and predict strategies for success in business. Microsoft integrates the data mining engine into the Analysis Services of SQL Server 2000, the online analytical processing services in previous releases, which greatly reduces the complexity of this advanced and powerful tool. Analysis Services include clustering and decision tree algorithms for data mining, and can easily be extended by Third-party vendors through OLE DB for data Mining; SQL Server 2000 provides fully integrated, standards-based XML to support Web developers and database programmers Said to be flexible, efficient and easy to use. Unlike other similar database products, SQL Server 2000 provides powerful tools to handle XML elements in a database, allowing developers to write code and extract xml-based data directly from the database; SQL Server 2000 allows high on the web via HTTP protocol Performance, standards-based security access, and support for firewalls. Web-based clients have the complete ability to access relational data storage and access Analysis Services, so how do we use these new features to implement e-business? Obviously, the first is to choose a platform. SQL Server 2000 is part of Microsoft's Windows DNA 2000 platform, which not only enables online business, but also can realize multi-layer application. Together with products such as Commerce Server 2000, Microsoft Host Integration Server 2000, Microsoft BizTalk Server 2000, and Microsoft Application Center 2000, users can create a complete set of Complete, scalable, high reliability of E-commerce Web site solutions.

Another aspect of e-business solutions is their availability. One key technology that supports the high availability of SQL Server 2000 is the implementation of a recovery cluster. If the disk becomes corrupted or crashes, the user can switch to another computer, and if one CPU is corrupted, the user can switch to another CPU or a different computer in the cluster, allowing the system to continue to function. The recovery clustering feature has been significantly enhanced in SQL Server 2000, which provides integration of four nodes instead of the original two, which allows the system to convert arbitrarily between these four computers when an error occurs. The failover clustering technology, together with a scalable, distributed partitioned view, provides a robust solution for e-commerce sites that can be run consistently and stably.

Of course there are other important places, such as a rich set of programming interfaces. We talked earlier about XML features, and we've tried to make SQL Server XML support technology available to database and network developers. Other databases also have XML support, but most of the time they require an object-oriented programming language such as Java, which SQL Server does not require. In SQL Server 2000, the transaction SQL (T) language has been extended to include standards such as XPath, XML, XSL, and XSLT. It is recommended that developers engaged in this type of integrated development project take a look at the XML features in SQL Server and compare it to their competitors, believing that they will see SQL Server better and support the above important criteria to make the integrated development scenarios more efficient.

Instead of focusing on platform selection and discussing how to improve the high availability of electronic solutions, this chapter introduces a set of programming interfaces, such as XML, in a larger space.

See the full set of "MS SQL Basics Tutorials"