What is database management system?
Database management system (DBMS) is a software that allows creating databases for different applications and controlling all access to those databases. That is, the database management system allows defining (defining type, structure, binding data), creating (storing data on memory devices) and manipulating (querying, updating, rendering). , …) databases for different applications. For example: MS. Access, MS. SQL Server, ORACLE, IBM DB2, …
– Department of Storage Management
- Store and retrieve data on memory devices.
- Organization of optimal data on memory devices.
- Interact effectively with the file manager.
– Question processor
- Search the response data for a query request.
- Converts high-level queries into requests that can be understood by the database system.
- Choose the best plan to answer this query.
– Ministry of Transaction Administration
- Transaction definition: a set of operations treated as an indivisible unit.
- Ensure the correctness and consistency of data.
- Control concurrency control.
- Error detection and database recovery
Some database management systems
1. MySQL
- MySQL is the world’s most popular free and open source database management system and is very popular among developers during application development. Because MySQL is a fast, stable and easy-to-use, high-speed database that works across multiple operating systems providing a large system of powerful utility functions. With high speed and security, MySQL is suitable for applications with database access on the internet. It has many versions for different operating systems: Win32 version for Windows, Linux, Mac OS X, Unix, FreeBSD, NetBSD, Novell NetWare, SGI Irix, Solaris, SunOS, …
- MySQL is used for the addition of PHP, Perl, and many other programming languages, which are used to store information of websites written in PHP or Perl.
- MySQL currently has 2 versions (version): free (MySQL Community Server) and paid (Enterprise Server).
– Some characteristics of MySQL
- MySQL manages data through databases, each database can have many relational tables, containing data.
- MySQL has its own user authorization mechanism, each user can manage one or more different databases, each user has a corresponding username and password to access. CSDL.
- When we query the MySQL database, we must provide the username and password of the account that has permission to use that database. If not, we will not do anything like user authentication in SQL Server.
2. SQL Server
Microsoft SQL Server is a database management system, providing a way to organize data by saving it to tables. Relational data is stored in tables and those relationships are defined between tables. Users access data on the server through the application. Database administrators access the server directly to perform the configuration, administration and maintenance functions of the database. In addition, SQL Server is a scalable database, meaning that they can store large amounts of data and support features that allow multiple users to access data simultaneously. The popular versions of SQL Server currently on the market are SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, …
SQL Server editions include the following 6 main versions:
- Enterpise Manager: A full version of SQL Server that can run on 32CPU and 64GB of RAM. There are Analysis Services data analysis services.
- Standard: Like Enterprise but limited with some advanced features, can run on 2CPU, 4GB RAM.
- Personal: This version is mainly for PC, so it can run on Windows 9x, Windows XP, Windows 2000, Windows 2003 …
- It is similar to Enterprise version but limited by the number of users connected to.
- Desktop Engine: A version of the engine that runs only on the desktop and has no user interface (GUI), the database size is limited by 2GB.
- Win CE: Use for applications running on Windows CE.
- Trial: Trial version, limited by time.
- SQL Client: The client version, when performing the exploit, it will make a connection to the SQL Server version, this version provides the GUI interface for users to exploit.
- SQL Connectivity only: The version used only for applications to connect to SQL Server, this version does not provide GUI tools for users exploiting SQL Server.
3. DB2
DB2 is one of the IBM relational database management software lines. It was first released in 1982 and is currently available for a wide range of operating systems, used primarily on Unix (commonly called AIX), Linux, IBM i (formerly OS / 400), z / OS and Windows Servers. DB2 uses the SQL language to read and write information into data.
DB2 versions:
- DB2 for Z / OS: provides DB2 features for server systems.
- DB2 Personal Edition: provided to individual users on a personal computer.
- DB2 Enterprise Server Edition (ESE) is a complete RDBMS with client / server setup (client / server setup)
- The DB2 Workgroup Server Editon (WSE) is primarily aimed at small to medium-sized businesses with all the features of DB2 ESE, except for connecting to mainframes.
4. Oracle
Not surprisingly, Oracle is considered the most popular database management system in the world. Oracle has been leading the way for many years since its inception in 1979. What can be said about Oracle is “a complex but powerful system”. Oracle is developing towards a cloud data model in version 12c, allowing companies to consolidate and manage databases as cloud services.
Versions:
- Version 1 (1977), Version 2 (1979)
- Version 3 (1983), Version 4 (1984)
- Version 5 was released in 1985 (SQLNet: client / server system).
- Version 6 was released in 1988 (Sequence, late recording operation).
- Oracle7 was released in 1992 (SQL * DBA).
- In 1999 Oracle introduced Oracle8i (i: internet).
- 2001-2002: 2 versions of Oracle9i (Release 1 & 2).
- 2004-2005: 2 versions of Oracle10g (g: Grid) (Release 1 & 2).
- 2007 – 2009: 2 versions of 11g (Release 1 & 2)
- 2013 – 2017: 2 versions 12c (Release 1 & 2)
- 2018: Version 18c
The current popular releases (10g, 11g, 12c) have the following 5 versions:
- Oracle Database Express Edition (Oracle Database XE): is the simplest version, quick download, simple installation and management, free for programming, deployment and expansion.
- Oracle Database Standard Edition One
- Oracle Database Standard Edition
- Oracle Database Enterprise Edition: is the most powerful version, providing many advanced security features, helping companies manage their access to resources and data more effectively and conveniently.
- Oracle Database Personal Edition: is a special product, containing most features of Enterprise Edition (except for Oracle Real Application Clusters), suitable for the development and deployment environment of a user that requires compatibility. Fully compatible with other versions of Oracle.