Database and OLTP
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is a database, in the simplest definition?
2. Why can a database not be linked to any one data modelling solution?
3. What does OLTP (Online Transaction Processing) do?
4. Under which term do data warehouses and data marts normally fall?
5. Which statement about Big Data and Data Lakes in relation to OLTP and OLAP is correct?
6. Why are databases called RDBMS (relational database management systems)?
7. What is the purpose of the normalisation concept in the OLTP world?
8. In Third Normal Form (3NF), data modellers keep breaking tables until what condition is met?
9. Before the 1990s, why did organisations offload OLTP data to tape drives, and what challenge did this bring?
10. Why did the normalised (3NF) extraction copy of OLTP become a bottleneck for decision-support queries?