Databases

Study With Rememble

Rememble is a free flashcard app that helps you learn and retain information in a fun and engaging way. With Rememble, you can create your own flashcards or choose from thousands of pre-made decks in a variety of subjects.

Whether you're studying for a test, learning a new language, or just want to expand your knowledge, Rememble has you covered. Sign up today and start learning!

Database

An organized collection of structured information or data, typically stored electronically

An organized collection of structured information or data, typically stored electronically

Database

SQL (Structured Query Language)

A language used to manage and manipulate databases

A language used to manage and manipulate databases

SQL (Structured Query Language)

Relational Database

A type of database that stores data in tables with rows and columns

A type of database that stores data in tables with rows and columns

Relational Database

Data Integrity

The process of ensuring that a database remains accurate and consistent over time

The process of ensuring that a database remains accurate and consistent over time

Data Integrity

Graph Database

A database model that uses a graph structure to represent relationships between data points

A database model that uses a graph structure to represent relationships between data points

Graph Database

Non-Relational Database

A type of database that doesn't use a traditional table-based structure

A type of database that doesn't use a traditional table-based structure

Non-Relational Database

Data Normalization

The process of organizing data to minimize redundancy and improve data integrity

The process of organizing data to minimize redundancy and improve data integrity

Data Normalization

Primary Key

A unique identifier for each record in an SQL database

A unique identifier for each record in an SQL database

Primary Key

Foreign Key

A key used to link two tables together in a database

A key used to link two tables together in a database

Foreign Key

Index

A performance optimization method that makes data retrieval faster in a database

A performance optimization method that makes data retrieval faster in a database

Index

Transaction

A unit of work performed within a database management system

A unit of work performed within a database management system

Transaction

ACID (Atomicity, Consistency, Isolation, Durability)

A set of properties that guarantee database transactions are processed reliably

A set of properties that guarantee database transactions are processed reliably

ACID (Atomicity, Consistency, Isolation, Durability)

Database Management Systems (DBMS)

Software used for managing databases

Software used for managing databases

Database Management Systems (DBMS)

Backup and Recovery

The process of creating and storing copies of data for protection against data loss

The process of creating and storing copies of data for protection against data loss

Backup and Recovery

NoSQL Database

A database used for handling large amounts of unstructured data, and does not require a fixed schema

A database used for handling large amounts of unstructured data, and does not require a fixed schema

NoSQL Database

Data Warehousing

The process of constructing and using a data warehouse

The process of constructing and using a data warehouse

Data Warehousing

Object-Relational Mapping (ORM)

A programming technique for converting between incompatible type systems using object-oriented programming languages

A programming technique for converting between incompatible type systems using object-oriented programming languages

Object-Relational Mapping (ORM)

Cloud Database

A database that typically runs on a cloud computing platform, users can run databases without the need for hardware, software, or a DBA

A database that typically runs on a cloud computing platform, users can run databases without the need for hardware, software, or a DBA

Cloud Database

Database Security

Measures used to protect databases from harm, theft and unauthorized access

Measures used to protect databases from harm, theft and unauthorized access

Database Security

Database Schema

The structure of a database described in a formal language supported by the database management system

The structure of a database described in a formal language supported by the database management system

Database Schema

Stored Procedures

Subroutines available to applications that access a relational database system

Subroutines available to applications that access a relational database system

Stored Procedures

Triggers

Procedures that are stored in the database and activated ("fired") when specific conditions occur

Procedures that are stored in the database and activated ("fired") when specific conditions occur

Triggers

Query Optimization

The process of improving the speed and efficiency of database queries

The process of improving the speed and efficiency of database queries

Query Optimization

Data Migration

The process of moving data from one system to another

The process of moving data from one system to another

Data Migration

Distributed Databases

Databases which consists of multiple databases on different machines, interconnected by a network

Databases which consists of multiple databases on different machines, interconnected by a network

Distributed Databases

NewSQL

A class of modern relational database management systems that seek to provide the scalability of NoSQL systems for online transaction processing workloads while maintaining the ACID guarantees of a traditional database system.

A class of modern relational database management systems that seek to provide the scalability of NoSQL systems for online transaction processing workloads while maintaining the ACID guarantees of a traditional database system.

NewSQL