Databases

Databases, including various kinds, technology used in databases, etc. 100 cards.

Sample Cards

Database Management System

DBMS

Relational Database

RDBMS

Object-oriented Database

ODBMS

Hierarchical Database

HDBMS

Network Database

NDBMS

Structured Query Language

SQL

MySQL

Open-Source Relational Database Management System

Oracle Database

Multi-Model Database Management System

Databases Flashcards

Looking to expand your skills in Information Technology? Look no further! These flashcards are designed to help you learn and retain information in a fun and engaging way.

Study With Rememble

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!

What's in this deck?

Database Management System

DBMS

DBMS

Database Management System

Relational Database

RDBMS

RDBMS

Relational Database

Object-oriented Database

ODBMS

ODBMS

Object-oriented Database

Hierarchical Database

HDBMS

HDBMS

Hierarchical Database

Network Database

NDBMS

NDBMS

Network Database

Structured Query Language

SQL

SQL

Structured Query Language

MySQL

Open-Source Relational Database Management System

Open-Source Relational Database Management System

MySQL

Oracle Database

Multi-Model Database Management System

Multi-Model Database Management System

Oracle Database

Microsoft SQL Server

Relational Database Management System

Relational Database Management System

Microsoft SQL Server

PostgreSQL

Open-Source Object-Relational Database System

Open-Source Object-Relational Database System

PostgreSQL

MongoDB

Source-Available and NoSQL Database Program

Source-Available and NoSQL Database Program

MongoDB

Data Warehousing

Process of Constructing and Using a Data Warehouse

Process of Constructing and Using a Data Warehouse

Data Warehousing

Data Mining

Process of Discovering Patterns in Large Data Sets

Process of Discovering Patterns in Large Data Sets

Data Mining

Normalization

Process of Efficiently Organizing Data in a Database

Process of Efficiently Organizing Data in a Database

Normalization

Primary Key

Unique Identifier for a Record in a Database

Unique Identifier for a Record in a Database

Primary Key

Foreign Key

Key used to link two Database Tables

Key used to link two Database Tables

Foreign Key

Atomicity Consistency Isolation Durability

ACID

ACID

Atomicity Consistency Isolation Durability

Referential Integrity

Ensures Data Consistency

Ensures Data Consistency

Referential Integrity

Entity Relationship Diagram

ERD

ERD

Entity Relationship Diagram

Normalization

Process to Minimize Data Redundancy

Process to Minimize Data Redundancy

Normalization

Data Redundancy

Unnecessary Duplication of Data

Unnecessary Duplication of Data

Data Redundancy

Indexing

Data Structure Technique to Efficiently Retrieve Records

Data Structure Technique to Efficiently Retrieve Records

Indexing

Database Schema

Logical Configuration of a Database

Logical Configuration of a Database

Database Schema

Query Language

Used to Query Database Information

Used to Query Database Information

Query Language

Structured Query Language

SQL

SQL

Structured Query Language

Data Definition Language

DDL

DDL

Data Definition Language

Data Manipulation Language

DML

DML

Data Manipulation Language

Data Control Language

DCL

DCL

Data Control Language

Transaction Control Language

TCL

TCL

Transaction Control Language

Stored Procedure

Prepared SQL Code

Prepared SQL Code

Stored Procedure

Trigger

SQL Procedure that Initiates an Action

SQL Procedure that Initiates an Action

Trigger

Recovery

Process of Restoring a Database

Process of Restoring a Database

Recovery

Backup

Copy of Data that can be used to Restore a Database

Copy of Data that can be used to Restore a Database

Backup

Data Security

Measures Taken to Keep Data Protected

Measures Taken to Keep Data Protected

Data Security

Concurrency Control

Ensures Correctness of Transactions

Ensures Correctness of Transactions

Concurrency Control

Data Transaction

Single Unit of Work

Single Unit of Work

Data Transaction

NoSQL Database

Handles Large Data Store

Handles Large Data Store

NoSQL Database

Cloud Database

Database that runs on Cloud Computing Platform

Database that runs on Cloud Computing Platform

Cloud Database

Big Data

Extremely Large Data Sets

Extremely Large Data Sets

Big Data

Database Administrator

DBA

DBA

Database Administrator

Data Integrity

Accuracy of Data

Accuracy of Data

Data Integrity

Cluster

Grouping of Servers

Grouping of Servers

Cluster

Firewall

Security System

Security System

Firewall

Network Protocol

Rules in Network Communication

Rules in Network Communication

Network Protocol

Deadlock

Situation where two Transactions Unable to Proceed

Situation where two Transactions Unable to Proceed

Deadlock

Graph Database

NoSQL Database

NoSQL Database

Graph Database

Database Replication

Process of Sharing Information

Process of Sharing Information

Database Replication

Database Shard

Horizontal Partition of Data

Horizontal Partition of Data

Database Shard

Data Lake

Storage Repository

Storage Repository

Data Lake

Apache Cassandra

NoSQL Database

NoSQL Database

Apache Cassandra

DynamoDB

NoSQL Database

NoSQL Database

DynamoDB

Firebase Realtime Database

NoSQL Cloud Database

NoSQL Cloud Database

Firebase Realtime Database

Structured Data

Data which is Organized

Data which is Organized

Structured Data

Unstructured Data

Information that doesn't Reside in Fixed Locations

Information that doesn't Reside in Fixed Locations

Unstructured Data

Semi-Structured Data

Neither Raw Data nor Structured Data

Neither Raw Data nor Structured Data

Semi-Structured Data

Data Modeling

Process of Creating a Data Model

Process of Creating a Data Model

Data Modeling

Data Dictionary

Describes the Contents of a Database

Describes the Contents of a Database

Data Dictionary

Optimization

Process of Making Something Effective

Process of Making Something Effective

Optimization

Caching

Storing Copies of Files

Storing Copies of Files

Caching

Data Warehouse

System for Reporting and Data Analysis

System for Reporting and Data Analysis

Data Warehouse

ETL

Extract

Extract

ETL

Business Intelligence

BI

BI

Business Intelligence

Metabase

Open Source Business Intelligence

Open Source Business Intelligence

Metabase

Lookup Table

Used to Speed Up Data Retrieval

Used to Speed Up Data Retrieval

Lookup Table

Master Data Management

MDM

MDM

Master Data Management

Database Server

Server to Host a Database

Server to Host a Database

Database Server

In-memory Database

Stores Data in Main Memory

Stores Data in Main Memory

In-memory Database

Database Engine

Software Components of a Database

Software Components of a Database

Database Engine

Query Optimizer

Part of a Database Management System

Part of a Database Management System

Query Optimizer

Database Connection

Connection Between a Program and a Database

Connection Between a Program and a Database

Database Connection

Cursor

Database Object

Database Object

Cursor

Data Mart

Access Layer of a Data Warehouse

Access Layer of a Data Warehouse

Data Mart

Cube

Subset of a Data Warehouse

Subset of a Data Warehouse

Cube

Elasticsearch

Distributed

Distributed

Elasticsearch

Apache Hadoop

Open-Source Software for Reliable

Open-Source Software for Reliable

Apache Hadoop

Business Analytics

Process of Collating

Process of Collating

Business Analytics

Data Pipelines

Set of Data Processing Elements

Set of Data Processing Elements

Data Pipelines

OLAP

Online Analytical Processing

Online Analytical Processing

OLAP

OLTP

Online Transaction Processing

Online Transaction Processing

OLTP

Data Lakehouse

Merging Concepts of Data Lakes and Data Warehouses

Merging Concepts of Data Lakes and Data Warehouses

Data Lakehouse

Materialized View

Database Object that Contains the Results of a Query

Database Object that Contains the Results of a Query

Materialized View

Data Virtualization

Approach to Data Management

Approach to Data Management

Data Virtualization

Real-Time Database

Database Capable for Real-Time Responses

Database Capable for Real-Time Responses

Real-Time Database

Blockchain Database

Secure and Distributed Database

Secure and Distributed Database

Blockchain Database

Column Store Database

Database that Uses a Column-Oriented Model

Database that Uses a Column-Oriented Model

Column Store Database

InnoDB

Database Engine for MySQL

Database Engine for MySQL

InnoDB

Data Governance

Management of the Availability

Management of the Availability

Data Governance

API

Application Programming Interface

Application Programming Interface

API

Encryption

Process of Encoding Information

Process of Encoding Information

Encryption

Load Balancing

Process of Distributing Network Traffic Across Multiple Servers

Process of Distributing Network Traffic Across Multiple Servers

Load Balancing

Data Analytics

Process of Examining Data Sets

Process of Examining Data Sets

Data Analytics

Data Federation

Integration Technology

Integration Technology

Data Federation

Data Integration

Process of Combining Data from Different Sources

Process of Combining Data from Different Sources

Data Integration

Database Partitioning

Splitting a Database into Smaller Pieces

Splitting a Database into Smaller Pieces

Database Partitioning

Replica Set

Form of Data Replication in MongoDB

Form of Data Replication in MongoDB

Replica Set

Cluster Computing

Computing System Comprising of Interconnected Nodes

Computing System Comprising of Interconnected Nodes

Cluster Computing

Data Archiving

Process of Moving Data to Secondary Storage for Long-Term Retention

Process of Moving Data to Secondary Storage for Long-Term Retention

Data Archiving

Artificial Intelligence

AI

AI

Artificial Intelligence

Machine Learning

ML

ML

Machine Learning

Data Science

Interdisciplinary Field about Scientifically Extracting Knowledge and Insights from Data

Interdisciplinary Field about Scientifically Extracting Knowledge and Insights from Data

Data Science

Predictive Analytics

Statistical Techniques from Modeling

Statistical Techniques from Modeling

Predictive Analytics

Fuzzy Logic

System of Logic

System of Logic

Fuzzy Logic

Multidimensional Databases

Databases optimized for Data Warehouse and Online Analytical Processing

Databases optimized for Data Warehouse and Online Analytical Processing

Multidimensional Databases

Business Process Modelling

BPM

BPM

Business Process Modelling

Object-oriented programming

OOP

OOP

Object-oriented programming

Functional programming

Programming Paradigm

Programming Paradigm

Functional programming

Parallel Processing

Simultaneous Data Processing

Simultaneous Data Processing

Parallel Processing

Data Dictionary

Centralized Repository of Information about Data

Centralized Repository of Information about Data

Data Dictionary

Python

High-Level Programming Language

High-Level Programming Language

Python

Java

General-Purpose Programming Language

General-Purpose Programming Language

Java

Cloud Computing

Delivery of Computing Services

Delivery of Computing Services

Cloud Computing

Distributed Systems

Collection of Independent Nodes

Collection of Independent Nodes

Distributed Systems

Data Visualisation

Representation of Data or Information

Representation of Data or Information

Data Visualisation

JavaScript

Programming Language

Programming Language

JavaScript

Related Flashcards

Continue your spaced-repetition or comprehensible input learning with these other flashcard decks related to Information Technology.