Databases introduction

What is CRUD in the context of databases?

CRUD stands for Create, Read, Update, Delete, representing the four basic operations performed on data.

Define a Database.

A collection of organized data stored electronically and managed for easy access, retrieval, and manipulation.

What does OLTP stand for?

Online Transaction Processing.

Characteristics of OLTP databases?

Live/temporary data, real-time data, online transaction processing, and real-time results.

Give examples of OLTP systems.

Banking transactions, ATM systems, and e-commerce orders.

What is a Data Warehouse (DW)?

A database designed for reporting and data analysis, containing historical data.

Name characteristics of Data Warehouses.

Large data storage, used for reporting and analysis, and handles historical data.

List types of database objects.

Tables, Views, Functions, Stored Procedures.

What are Tables used for in a database?

To store, organize, and manipulate data.

What are the main differences between OLTP and Data Warehouses?

OLTP is for real-time transaction processing with fast inserts/updates, while Data Warehouses are for large-scale historical data storage used in reporting and analytics.