DATA WAREHOUSE Discussion Activity 4

Running head: DATA WAREHOUSE
Data warehouse
Name of the Student
Name of the University
Author Note:

2
DATA WAREHOUSING
Discussion activity 4
1. Spreadsheets have become quite powerful for data management. What can be done
with database management systems that cannot be done with spreadsheet
applications? Give 2 examples.
Isolation of data and the duplication of the data are the significant benefits of the database
management systems over the applications.
2. What does it mean to cleanse data before it is stored in a data warehouse?
The storage of the data coming from the different sources in separate applications is done
with the help of the concept of data cleansing. Data cleansing is very much important for the
data which are about to enter the data warehouse1. Data cleansing may be also termed as data
scrubbing, the database administrators of the data ware houses uses this process in order to avoid
any kinds of complexities as it may have a direct negative impact on the overall business.
3. What is a data warehouse? How is it different from a transactional database?
Data ware house is defined as the type of warehouses which stores large amount of structured
and unstructured data from a wide range of sources. The managerial decisions of an organization
can be impacted by the effectiveness of the data warehouses.
The data which are related with the transactions are managed with the help of the
transactional database, rolling back of the data is possible in the transactional databases which
are not followed in the data warehouses.
4. What is blogging, and what potential does it have for businesses?
1 "Internet, intranet, extranet". in , , 2019, <http://bpastudio.csudh.edu/fac/lpress/471/hout/apps/interintraextra.htm>
[accessed 17 January 2019].