Los gestores de bases de datos más usados 📈 - Master Class INESEM
Database Management Systems Overview
Introduction to Database Management Systems (DBMS)
- A Database Management System (DBMS) is a software that facilitates the creation and management of databases, optimizing operations based on stored information.
- There are numerous DBMS available in the market, typically classified into two categories: Relational (USQL) and Non-relational (ONUSQL).
Relational Database Management Systems (RDBMS)
- The relational database model emerged in 1970 and has evolved to become the most widely used model today, focusing on establishing relationships between data.
- Commonly used RDBMS include:
- MySQL: Predominantly utilized across many websites and open-source applications.
- MariaDB: A fork of MySQL that retains its features while adding additional extensions following Oracle's acquisition of MySQL.
- SQL Elite: A library implemented in C for integrating database management systems without requiring a server or complex configurations. It is known for efficient searches and operations.
Additional RDBMS Examples
- Pogrid SQL: An object-oriented RDBMS published under the BSD license, featuring an intuitive administration tool called PGMIM.
- Paid RDBMS options include:
- Microsoft SQL Server: Supports multiple users accessing vast amounts of information simultaneously.
- Oracle: Renowned as one of the most comprehensive and robust RDBMS, widely used in enterprise environments with various pricing plans.
Non-relational Database Management Systems (NoSQL DBMS)
- NoSQL databases do not store information in traditional structures like tables; they excel at horizontal scaling and managing large volumes of data simultaneously, often referred to as big data.
- These systems are primarily employed in distributed environments that require constant availability and operational efficiency.
Popular NoSQL DBMS Examples
- MongoDB: File-oriented storage system widely adopted by major companies such as Google, Facebook, Cisco, and Adobe for its flexible structure.
- Redis: Key-value storage system ideal for session management or cache memory storage; utilized by companies like KITAP, Pinterest, Enacta, and Twitter.
- Cassandra: Another key-value storage system that is distributed; it includes its own query language called CQL (Cassandra Query Language), used by platforms like Facebook, Twitter, Instagram, Spotify, and Netflix.
Other Notable NoSQL DBMS
- Additional non-relational database systems include Azure Cosmos DB, RavenDB, OJTB, Apache Couchbase, Neo4j, Google Bigtable, and Amazon DynamoDB which cater to various needs within the industry.