Computer scienceFundamentalsSQL and DatabasesDB TheoryCommon DB topics

OLTP vs OLAP

The focus of an OLTP system

Report a typo

Suppose you are designing an OLTP system. What should be your focus?

Select one or more options from the list

Come up with complex analytical queries that involve huge amounts of data to get better insights

Set up regular backups to keep data safe

Optimize the system to process queries in milliseconds

Consider loading data from OLAP systems to this one

___

Create a free account to access the full topic