DBM 384 All Discussions

The Latest Version A+ Study Guide

**********************************************

DBM 384 All Discussions Link

https://hwsell.com/category/dbm-384/

**********************************************

DBM 384 Wk 1 Discussion – General vs. Special-Purpose Databases

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:

Identify a general purpose and a special purpose database of your choice. Research and compare the general and special purpose databases that you have selected. Describe differences between the two databases.

Due Monday

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

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.

DBM 384 Wk 3 Discussion – Spatial Database Indexing

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:

Part of a Database Administrator’s job is to ensure appropriate information retrieval performance of their databases. End users do not and in many cases can’t wait for databases that perform slowly. This is true for many spatial databases. Consider Google Maps and the spatial data that this application stores and provides to its users. If it performs slowly, it would not provide useful driving directions. It has to perform well to be used. Slow database performance would make this application ineffective and could be dangerous or life threatening for the people who rely on it for driving directions.

From the perspective of a Database Administrator who is concerned about database performance, explain why indexing is so important when working with a spatial database.

Due Monday

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

DBM 384 Wk 4 Discussion – NoSQL

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:

A mid-sized financial services company is considering implementing a NoSQL database. From the perspective of an IT Manager in this financial services company, describe how NoSQL databases could be used in the organization. Under what circumstances might it be an appropriate implementation choice for a financial services business?

Due Monday

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

DBM 384 Wk 5 Discussion – Strengths and Weaknesses of Information Retrieval

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:

Select a website from the Internet that provides information to its stakeholders; examples of websites to consider are SEC.gov or USA.gov. Describe the strengths and weaknesses of the information retrieval processes used on this website from an end-user perspective.

Due Monday

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