Sunday 4 November 2012

Database Server

Database Server
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.
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 the database servers.
[edit]See also

Database replication
[hide] v t e
Database
Main
Requirements Theory Models Database management system Machine Server Application Connection datasource DSN Administrator Lock Types Tools
Languages
Data definition Data manipulation Query information retrieval
Security
Activity monitoring Audit Forensics Negative database
Design
Entities and relationships (and Enhanced notation) Normalization Refactoring
Programming
Abstraction layer Object-relational mapping
Management
Virtualization Tuning caching  Migration Preservation Integrity
See also
Database-centric architecture Intelligent database Two-phase locking Locks with ordered sharing Load file Publishing Halloween Problem Log shipping
Images
Images
Images
Images
Images
Images
Images
Images
Images
Images
Images
Images

No comments:

Post a Comment