This database tutorial is for beginners. It explains basic concepts and assumes no prior knowledge of databases.
You don’t need to follow along – there aren’t any exercises. But there are plenty of screenshots and a few diagrams. The purpose of the tutorial is to introduce you to the basic concepts of databases.
An MPP database is a massively parallel processing database (MPP stands for Massively Parallel Processing).
Massively parallel processing refers to the use of a large number of processors (or separate computers) to perform a set of coordinated computations in parallel (simultaneously).
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.
A database management system is an application that enables the creation and administration of databases. Database management system is a broad term that includes any system that performs that function.
The most common type of DBMS is an RDBMS (Relational Database Management System). RDBMSs allow you to create relational databases – databases that have multiple tables that contain related data.
Different database management systems define schema in their own way. This can make it difficult for database developers to work out exactly what a schema is – especially when switching between different DBMSs.
This article provides definitions used by the three leading database systems.
In database terms, a schema (pronounced “skee-muh” or “skee-mah”) is the organisation and structure of a database. Both schemas and schemata can be used as plural forms.
A database schema can be represented in a visual diagram, which shows the database objects and their relationship with each other.
Above is a simple example of a schema diagram. It shows three tables, along with their data types, relationships between the tables, as well as their primary keys and foreign keys.