DBM 384 Wk 2 Discussion – OLTP and OLAP

0 items
DBM 384 Wk 2 Discussion - OLTP and OLAP
DBM 384 Wk 2 Discussion – OLTP and OLAP
$3.00
Go to the store page
  • Description

DBM 384 Wk 2 Discussion – OLTP and OLAP

Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to other students.

Due Thursday

Respond to the following in a minimum of 175 words:

Organizations use database technology to store data that they collect, analyze, measure, and monitor as they conduct business. Data that is captured during transactional processes, as organizations sell products and services to their customers, is best structured in an OLTP database. Data that is used to analyze trends, key metrics, summary data, and for data mining is best stored in an OLAP database. Database designers need to understand the differences between OLTP and OLAP data and how to best design and build databases to support OLTP or OLAP requirements.

From the perspective of a Database Designer, identify the differences between Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) databases. Explain when a company would choose one database over the other and why.

Due Monday

Reply to at least 2 of your classmates. Be constructive and professional in your responses.