Consider your local video rental store. It certainly has an operational database to support its online transaction processing (OLTP). The operational database supports such things as adding new customers, renting videos (obviously), ordering videos, and a host of other activities. Now, assume that the video rental store also uses that same database for online analytical processing (OLAP) in the form of creating queries to extract meaningful information. If you were the manager of the video rental store, what kinds of queries would you build? What answers are you hoping to find?"

Answer rating: 100% (QA)

As the manager of a local video rental store I would use the operational database for online analytical processing OLAP to gather valuable insights an... View the full answer