Database Management Systems
This article lists the SQL SELECT syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
This article lists the SQL ALTER TABLE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
This article lists the SQL DROP DATABASE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
This article contains the SQL ALTER DATABASE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
This article contains the SQL CREATE TABLE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
This article contains the SQL CREATE DATABASE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
Graph databases use a graphical model to store and represent data, which makes them highly suitable for storing connected data.
Below is an alphabetical list of graph database management systems.
A graph database is a database that uses a graphical model to represent and store the data.
The graph database model is an alternative to the relational model.
In a relational database, data is stored in tables using a rigid structure with a predefined schema.
In a graph database, there is no predefined schema as such. Rather, any schema is simply a reflection of the data that has been entered. As more varied data is entered, the schema grows accordingly.
ORDBMS stands for Object-Relational Database Management System.
An ORDBMS is a database management system that is a hybrid between the object-oriented model (OODBMS) and the relational model (RDBMS).
Each of those two models has their strengths and weaknesses. By combining the two models, a DBMS can take advantage of various strengths from each model.
OODBMS stands for Object-Oriented Database Management System.
An object-oriented database management system (also known simply as an object database) is a DBMS where data is represented in the form of objects, as used in object-oriented programming.
In contrast to relational database management systems (RDBMSs), where data is stored in tables with rows and columns, an object-oriented database stores complex data and relationships between data directly, without mapping to relational rows and columns.