What are the advantages of SQL Server?

Microsoft SQL Server 2000 can provide database services required by very large systems. A large server may have thousands of users connected to an instance of SQL Server 2000 at the same time. SQL Server 2000 provides comprehensive protection for these environments, preventing problems through security measures, such as preventing multiple users from trying to update the same data at the same time. SQL Server 2000 also effectively distributes available resources among multiple users, such as memory, network bandwidth and disk I/O. ..

A very large Internet website can store its data on multiple servers, so that the processing load can be distributed to multiple computers, and the website can provide services for thousands of concurrent users.

You can run multiple instances of SQL Server 2000 on a single computer. For example, an organization that provides database services to many other organizations can run a separate instance of SQL Server 2000 for each customer organization, and all instances can be centralized on one computer. In this way, the data of each customer organization is separated, and the service organization only needs to manage one server computer, thus reducing the cost.

SQL Server 2000 applications can be run on computers with SQL Server 2000 installed. This application connects to SQL Server 2000 through Windows interprocess communication (IPC) components, such as shared memory, instead of the network. This enables SQL Server 2000 to be used in small systems where applications must store data locally.

Large websites and enterprise-level data processing systems usually produce a lot of database processing, which is beyond the support capacity of computers. In these large-scale systems, database services are provided by a group of database servers, which constitute the database service layer. SQL Server 2000 does not support the establishment of database service layer in the form of load balancing aggregation, but supports the mechanism of storing data across autonomous servers. Although each server needs to be managed separately, all servers in the group can share the database processing load together. A group of autonomous servers sharing the same workload is called a server federation.

A. true client/server architecture;

In this architecture, there are many computers, among which the computers that handle applications and request services are called clients, and the computers that handle databases are called servers.

B graphical user interface makes system management and database management more intuitive and simple;

It provides a graphical interface of table, view and query definition, and uses SQL language in the graphical interface of query analysis and the graphical interface of server and database user configuration.

C. Rich programming interface tools provide users with more programming options;

SQLServer provides rich application program interfaces to access the server's data. The main access methods are ODBC API, OLE DB, Transact-SQL and DB-Library. Clients can use these APIs as dynamic connection libraries and communicate with SQLServer servers through the client's network libraries.

D.SQL Server is fully integrated with Windows NT, which makes use of many functions of NT, such as sending and receiving messages, managing login security, etc.

Integrate with the security system of NT, use the security mechanism of NT to serve the server, use the performance monitor of NT and use the MS index server; ; Integration with MS BackOffice products, such as MS IIS, MS Exchange Server, etc. SQLServer can be set to send and receive e-mails with Exchange, users can send query requests to SQLServer through e-mail information, and query results can be returned to users through e-mail.

E it has good scalability and can be used across various platforms, from notebook computers running Windows95/98 to large multiprocessors running Windows2000.

MS provides a single database engine, which can be used in various occasions of large byte symmetric multiprocessor clusters from Windows95 to Windows2000. NT and SQL not only support IntelCPU, but also support processors such as DEC Alpha CPU.

F. Support for network technology enables users to easily publish the data in the database to web pages;

In the Web Assistant, you can export data from database tables or import data from HTML into the database. The data of SQLServer can be automatically published to the web page; Users can query the information stored in SQLServer through ordinary browsers, so they can create dynamic web pages using the information stored in SQLServer.

G.SQL Server provides data warehouse function, which is only available in Oracle and other more expensive DBMS.

SQL Server2000 includes tools for on-line analytical processing (OLAP) to absorb and analyze summary data. Some tools can be used to intuitively design databases and analyze data through English queries. When using the same database to complete two tasks (input transaction and run query) at the same time, the function of the database will be greatly affected. In a large-scale query, it may take several hours to run and many records will be locked. At this time, data entry cannot be operated. In order to prevent this conflict, data is usually copied to a separate database, called data center or data warehouse. A data center usually includes a subset of all the data to be analyzed in an enterprise, and a data warehouse usually includes all the data that an organization wants to query.

Functions of SQL Server2000:

A. support XML (extensible markup language).

SQLServer2000 database engine provides complete XML support, accesses SQLServer through URL (Uniform Resource Locator), supports XML-Data mode, and uses HTTP, ADO or OLE DB to handle XML functions of SQL Server2000, such as defining XML views of the server 2000 database. You can manipulate, insert, update or delete data in database tables through XML, including modifying multiple rows in multiple tables in one operation.

B. strong web-based analysis

SQLServer2000 can analyze and link existing online analytical processing (OLAP) pipelines, even on the Web.

C. support OLE DB and multiple queries

SQLServer2000 includes a local OLE DB provider. When OLE DB is used with ADO object model, it can perform various query functions, and can freely access relational database data and non-relational data source databases, such as reading data from text files and reading data from forms or emails.

D. support distributed partition query

SQL Server2000 can fully meet the requirements of decision support system (DSS), and the distributed database partition view can divide the workload into several independent SQL Server servers, thus providing unlimited scalability for customers who implement e-commerce.