Database server
A database server can by divided into dedicated and non-dedicated server. Dedicated database server means that it is self-standing hardware where is loaded some database application. Non-dedicated database server isn’t mostly self-standing device but only loaded application on a shared device
(for example, you can have application and database server together in one server – it is distinguished via virtual servers).
Anyway database server is a computer program that provides database services to other computer programs, as defined by the Client/Server architecture. Database management systems frequently provide database server functionality, and some DBMSs (MySQL) rely exclusively on the Client/Server architecture for database access. Typically, client applications access database servers over a network.
A database server divides an application into a front end and a back end, in accordance with the Client/Server architecture. The front end runs on the user’s computer and displays requested data. The back end runs on the server and handles tasks such as data analysis and storage.
Implementation of a database server
A database server can be implemented in a straightforward manner as separate node (on a network) dedicated to running database-management software. This node provides an interface to client nodes such that the same data is accessible to all nodes. The interface allows users to submit requests to the database server and retrieve information. These requests are typically made using a high-level query language such as SQL (standard query language).
The server manages the any processor-intensive work such as data manipulation, compilation, and optimization, and sends only the final results back to the client. Database servers are typically made to run on a UNIX operating system.
Advantages of using a database server
- A database server allows users to store data in one central location.
- It performs complex functions such as searching, sorting, and indexing on the server itself. This reduces network traffic because fewer items need to be transferred between the client and the server.
- Because data is stored centrally, there is enhanced security.
- A database server uses its own processing power to find requested data, rather than sending the complete data to the client so that the client searches for the data, as is done in a file server.
- A database server allows concurrent access to data.
Database languages
Database languages are important if you are building or working with database. There are many database languages and are divided into many groups in accordance to the database type or kind of usage. For example SQL language is designed for relational databases, CODASYL was designed for hierarchical databases and DMX is determined for Data Mining models.
Database languages are important if you are building or working with database. There are many database languages and are divided into many groups in accordance to the database type or kind of usage. For example SQL language is designed for relational databases, CODASYL was designed for hierarchical databases and DMX is determined for Data Mining models.
All these mentioned languages are so called Query Languages, which are used to make queries into databases and information systems.
Comments (0)
Write comment
