Database Management System . A Database Management System (SGBD, in English DBMS: DataBase Management System) is a software system that allows the definition of databases ; as well as the choice of the data structures necessary for the storage and search of the data, either interactively or through a programming language. A relational DBMS is a data model that makes it easy for users to describe the data that will be stored in the database along with a group of operations to handle the data.
Relational DBMS are an effective tool that allows multiple users to access data at the same time. They provide efficient facilities and a group of functions with the objective of guaranteeing the confidentiality, quality, security and integrity of the data they contain, as well as easy and efficient access to them.
Summary
[ hide ]
- 1 MySQL
- 2 Microsoft SQL Server
- 3 PostgreSQL
- 4 See Also
- 5 Sources
MySQL
MySQL is a fast, robust and flexible relational database management system. It is ideal for creating databases with access from dynamic web pages, as well as for the creation of any other solution that involves data storage, allowing multiple and quick queries. It is developed in C and C ++, facilitating its integration into other applications also developed in those languages.
It is a client / server system, so it allows working as a multi-user and multi-threaded server, that is, each time a connection is created with the server, the server program establishes a process to handle the client’s request, thus controlling the simultaneous access of a large number of users to the data and ensuring access to authorized users only. It is one of the most widely used database management systems today, used by large corporations such as Yahoo! Finance, Google, Motorola, among others.
Microsoft SQL Server
SQL Server is a relational database management system produced by Microsoft. It is a client / server system that works as a natural extension of the Windows operating system. Among other features, it provides data integrity, query optimization, concurrency control, and backup and recovery.
It is relatively easy to administer through the use of a graphical environment for almost all database administration and system tasks. It uses Windows operating system services to offer new capabilities or expand the database, such as sending and receiving messages and managing connection security. It is easy to use and provides data warehousing features that were only available in Oracle and other more expensive database management systems.
PostgreSQL
PostgreSQL is an Object-Oriented Relational Database Management System, derived from Postgres, developed at the University of California, at the Berkeley Department of Computer Science. It is an open source database manager, it offers a multi-version concurrency control (MVCC) that allows working with large volumes of data; it supports a large part of the SQL syntax and has an extensive group of links with programming languages.
It has significant characteristics of the data engine, which can include subqueries, default values, constraints on values in fields (constraints) and triggers. It offers functionality in line with the SQL92 standard, including primary keys, quoted identifiers, type conversion, and input of binary and hexadecimal integers.
The source code is available to everyone at no cost. It is available for 34 platforms with the latest stable version. It is fully ACID compliant (acronym for Atomicity, Consistency, Isolation and Durability; in Spanish: Atomicity, Consistency, Isolation and Durability).
It has a referential integrity and native interfaces for languages like ODBC, JDBC, C, C ++, PHP, PERL, TCL, ECPG; PYTHON and RUBY. Works on all Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows operating systems.
Due to the license release, PostgreSQL can be used, modified and distributed free of charge for any purpose, be it private, commercial or academic.
