In the network, the database used by the server is generally Oracle or SQL.

What is SQL? MSSS?

If it's a general**, it's enough to use MySQL, and the oracle is too big, and the general** can't be used at all, unless it's that kind of portal**.

Generally, my friend uses mysql to learn the network, and the mysql syntax is basically the same as sql!

The main differences between the two are:

Server: is the main site that responds to the use of the Software, which provides the collection and processing of data by the Software. The server is usually composed of a computer (or computers) connected to the application software (client) through a network. It is a combination of hardware and software, and network.

Database: It is software that stores information and data, and there are many kinds of it. Large-scale MSSQL is placed on the server and needs to be operated by database software. A small one can be placed on a personal computer.

By nature, a database is software that can run on a server, while a server is hardware. A server can become a database server when a database application is installed.

2.From a functional point of view: the database is a warehouse that organizes, stores and manages data according to the data structure, while the server is the hardware used for data computing and processing. Hardware used to store and respond to customer requests.

Further information: A server, also known as a server, is a device that provides computing services. Since the server needs to respond to and process service requests, the server should generally have the ability to undertake and guarantee services.

The composition of the server includes processors, hard disks, memory, system buses, etc., which is similar to the general computer architecture, but due to the need to provide highly reliable services, it has high requirements in terms of processing power, stability, reliability, security, scalability, and manageability.

To put it simply, a server is a high-performance computer, and a database is an application that runs on the server.

The database is the software, and the server is the hardware.

The database is installed on the server. When we talk about a database server, we mean a server where the database is installed.

A database is a warehouse that organizes, stores, and manages data according to its data structure.

A server is hardware used for data computing and processing.

There are many differences, but there are almost no commonalities....

The simplest understanding is that the server, as the name suggests, is the place where the service is placed, that is, the host that publishes various services, such as ** and the like, such as a web server. In the case of a database, it is simply a system that manages data as a place to put it.

For example, if you publish a ** on the server (usually dynamic), this ** has data, the data is read from the database, and the database can be placed on the same host as these**, or it can be placed on another host.

If you put ** on a host and put the database on a host, in this way, the host that puts ** is called the web server, and the host that puts the database is called the database server.

I don't know what level you want to know.,I feel very, very, very shallow.,I don't know if it's right.,Just take a look.。。 Hehe..

1. Openness 1SQL Server can only run on Windows, without the slightest openness, and the stability of the operating system is very important to the database. The Windows 9X series products are focused on desktop applications, and NT Server is only suitable for small and medium-sized businesses.

And the reliability, security, and scalability of the Windows platform are very limited. It's not as tried and tested as Unix, especially when dealing with large databases. 2.

Oracle runs on all major platforms, including Windows. Full support for all industry standards. Adopt a fully open strategy.

It enables customers to choose the most suitable solution. Full support to the developer.

2. Scalability, parallelism 1SQL Server has an immature parallel implementation and coexistence model, which makes it difficult to handle the increasing number of users and data volumes, and has limited scalability. 2.

Oracle Parallel Server extends the capabilities of Windows by enabling a group of nodes to share work in the same cluster, providing a highly available and scalable cluster solution. If WindowsNT does not suffice, the user can move the database to UNIX. Oracle's parallel servers have a high level of integration with the clustering mechanism of various UNIX platforms.

3. Performance 1Poor performance when SQL Server is multi-user 2Oracle has the highest performance, holding the world record for TPC-D and TPC-C on an open platform.

4. Client Support and Application Mode 1SQL Server CS structure, only Windows customers, can be connected with ADO, DAO, OLEDB, ODBC. 2.

Oracle multi-level network computing supports a variety of industry standards and can be connected by network customers such as ODBC, JDBC, OCI, etc.

5. Easy to operate 1SQL Server is simple to use, but only has a graphical interface. 2.Oracle is more complex, provides both a GUI and a command line, and works the same under WindowsNT and UNIX.

VI. Risks of Use 1SQL Server is completely rewritten, has undergone long testing, constant delays, and many features take time to prove. Not very compatible.

2.Oracle's long development experience is fully backwards compatible. It is widely used.

No risk at all. Finally, Oracle is more expensive than SQLSRVER

In fact, the functions of sqlserver and oracle are similar to the land and data processing capabilities, but in recent years, Microsoft has been trying to fight a turnaround, but it has not succeeded, the NASDAQ in the United States ** uses sqlserver, sqlserver has been updated and improved in recent years, its performance has been very good. It's just that Oracle has been the hegemon of the database industry for many years.

Oracle and SQL Server have different structures. There is only one database in Oracle, which is divided into different partition tables and can be used by various users, while SqlServer creates different databases for customers to use, so the hierarchy of Oracle partitioned tables and SqlServer databases or the position in the database is the same, in terms of program development, SqlServer is TL SQL and Oracle is PL SQLIn fact, even if the development language is different, Shixun can actually return the corresponding functions.

When using cursors for two databases, SQL Server is not recommended because of the high overhead, while Oracle can use the cursor for operations such as queries. I don't know if you understand what I said.

A multi-table join is actually very simple, which is the condition of select *from Table 1 join Table 2 on (for example: Table 1Field = Table 2field) and the rest of the statements are normal query statements.

Oracle is more complex than SQL Server, and it is much more comprehensive than SQL Server, such as constraints, triggers, etc., which are much more difficult than SQL Server.

Any server, workstation, etc., even a PC is fine.