ACID (atomicity, consistency, isolation, and durability)

ACID (atomicity, consistency, isolation, and durability) ACID (atomicity, consistency, isolation, and durability) is an acronym and mnemonicdevice for learning and remembering the four primary attributes ensured to any transaction by a transaction manager (which is also called a transaction monitor). These attributes are: Atomicity. In a transaction involving two or more discrete pieces of information, either all of the pieces are committed or none are. Consistency. A transaction either c...
Read More

SQL (Structured Query Language)

SQL (Structured Query Language) SQL (Structured Query Language) is a standardized programming language used for managing relational databases and performing various operations on the data in them. Initially created in the 1970s, SQL is regularly used by database administrators, as well as by developers writing data integration scripts and data analysts looking to set up and run analytical queries. The uses of SQL include modifying database table and index structures; adding, updating and...
Read More

Database Management System (DBMS)

Database Management System (DBMS) A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data. A DBMS makes it possible for end users to create, read, update and delete data in a database. The DBMS essentially serves as an interface between the database and end users or application programs, ensuring that data is consistently organized and remains easily a...
Read More

Oracle Definition

Oracle is one of the largest vendors in the enterprise IT market and the shorthand name of its flagship product, a relational database management system (RDBMS) that's formally called Oracle Database. The database software sits at the center of many corporate IT environments, supporting a mix of transaction processing, business intelligence and analytics applications. In 1979, Oracle Corp. was the first company to commercialize an RDBMS platform, and it's still the leading database vendor by ...
Read More

Microsoft Azure Cosmos DB Definition

Microsoft Azure Cosmos DB Definition Azure Cosmos DB is a Microsoft cloud database that supports multiple ways of storing and processing data. As such, it is classified as a multimodel database.   In multimodel databases, various database engines are natively supported and accessible via common APIs. They are not restricted to a single data model as is the case with, for example, dedicated graph, key-value or document stores. Azure Cosmos DB vs. DocumentDB Azure Cosmos DB aro...
Read More

MariaDB Definition

MariaDB Definition MariaDB is an open source relational database management system (DBMS) that is a compatible drop-in replacement for the widely used MySQL database technology. It was created as a software fork of MySQL by developers who played key roles in building the original database; they devised MariaDB in 2009 in response to Oracle Corp.'s acquisition of MySQL. MariaDB is based on SQL and supports ACID-style data processing with guaranteed atomicity, consistency, isolation and durabi...
Read More