A game server (sometimes host or shard) is a server which is the authoritative source of events in a multiplayer video game.
The server transmits enough data about its internal state to allow its connected clients to maintain their own accurate version of the game world for display to players.
They also receive and process each player’s input.
A web server is a computer system that processes requests via HTTP, the basic network protocol used to distribute information on the World Wide Web. The term can refer either to the entire system, or specifically to the software that accepts and supervises the HTTP requests.
The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, or other web uses.
A database server is a computer program that provides database services to other computer programs or computers, as defined by the client–server model. The term may also refer to a computer dedicated to running such a program. Database management systems frequently provide database server functionality, and some DBMSs (e.g., MySQL) rely exclusively on the client–server model for database access.
Such a server is accessed either through a “front end” running on the user’s computer which displays requested data or the “back end” which runs on the server and handles tasks such as data analysis and storage.
In a master-slave model, database master servers are central and primary locations of data while database slave servers are synchronized backups of the master acting as proxies.
Most of the Database servers works with the base of Query language. Each Database understands its query language and converts it to Server readable form and executes it to retrieve the results.
Some examples of proprietary database servers are Oracle, DB2, Informix, and Microsoft SQL Server. Examples of GNU General Public Licence database servers are Ingres and MySQL. Every server uses its own query logic and structure. The SQL query language is more or less the same in all relational database servers. DB-Engines lists over 200 DBMSs in its ranking.
An application server can be either a software framework that provides a generalized approach to creating an application-server implementation, regard to what the application functions are,or the server portion of a specific implementation instance. In either case, the server’s function is dedicated to the efficient execution of procedures (programs, routines, scripts) for supporting its applied applications.
Most Application Server Frameworks contain a comprehensive service layer model. An application server acts as a set of components accessible to the software developer through an API defined by the platform itself. For Web applications, these components are usually performed in the same running environment as its web server(s), and their main job is to support the construction of dynamic pages. However, many application servers target much more than just Web page generation: they implement services like clustering, fail-over, and load-balancing, so developers can focus on implementing the business logic.
In the case of Java application servers, the server behaves like an extended virtual machine for running applications, transparently handling connections to the database on one side, and, often, connections to the Web client on the other.
Other uses of the term may refer to the services that a server makes available or the computer hardware on which the services run.