Databases

This article deals with the characteristics of document databases, how they differ from relational databases, and their pros and cons. Read on to see examples of document databases.

The OLTP database system is used to manage and process everyday transactions of a business or company. Learn about OLTP and its difference from OLAP in this article.

Distributed databases are a solution for various issues that arise when using a centralized database. Learn about distributed databases and their advantages and disadvantages.

Multi-model databases combine different database models into a single backend system. Learn about the use-cases and what the best multi-model databases are currently available on the market in this article.

MySQL events run on a schedule defined by the user. They automate database maintenance and execute tasks periodically. Learn how to use them in this simple tutorial.

Graph databases are NoSQL systems created for exploring correlation within complexly interconnected entities. Learn when and how to use them.

This tutorial explains what MySQL JOINS are and how to use them to combine information located in multiple tables, producing a unified result.

Object databases integrate seamlessly with object-oriented programming languages. The object-oriented approach to database modeling makes it easier to model complex real-world problems. Learn about how they work and what they can bring to the table in this article.

MySQL stored procedures group multiple tasks into one and save the task on the server for future use. Stored procedures simplify database management and reduce network traffic. Learn how to use stored procedures in this tutorial.

MySQL triggers provide control over data validation when inserting, updating or deleting data from a database. Learn how to use triggers through an example database and when to use each type of trigger.