Information Technology - Database

Running head: INFORMATION TECHNOLOGY - DATABASE
Information Technology – Database
Name of the Student
Name of the University
Author’s note

1INFORMATION TECHNOLOGY - DATABASE
Table of Contents
1. Introduction..................................................................................................................................2
2. Discussion....................................................................................................................................2
2.1 Data Warehousing and Differences between Operational and Strategic Data Sets...............2
2.2 Data Mining and Comparison of OLAP with OLTP.............................................................5
2.3 Rise of ‘Big Data’ Technologies and Applications...............................................................8
2.4 ‘NoSQL’ Databases in Comparison with ‘ACID-Compliant’ Databases...........................10
2.5 Impact of ‘Open Data’ Movement.......................................................................................10
References......................................................................................................................................13

2INFORMATION TECHNOLOGY - DATABASE
1. Introduction
There is a growing need for organizations to integrate different kinds of changes within
the database into the process of development. This report helps in the discussing of different
types of topic such as Data Warehousing, Data Mining and many others. With the deployment of
database applications, there are different forms of security and legal concerns that would need to
be considered.
2. Discussion
2.1 Data Warehousing and Differences between Operational and Strategic Data Sets
Data Warehousing – This is defined as a process based on construction and using the
data warehouse. This form of warehouse is mainly constructed based on the integration of data
based on multiple heterogeneous sources, which supports ad hoc queries, analytical reporting and
making of decisions (Cuzzocrea, Bellatreche and Song 2013). The process of data warehousing
would involve the cleaning of data, integration of data and consolidations of data.
A data warehouse could be considered as a federated repository of data that would be
collected within the various operational systems of the enterprise. These type of data might be
logical or physical. The data warehousing would majorly emphasize on the capturing of data
based on diverse sources based on access and analysis rather than transaction processing
(Cuzzocrea 2013). The platforms based on data warehouses would be different from operational
databases because they would be able to store historical information and thus make the processes
easier for business leaders for analysing data within a specific period of time.

3INFORMATION TECHNOLOGY - DATABASE
(Fig 1: Benefits of a Data Warehouse)
(Source: Cuzzocrea 2013, pp. 482)
Differences between Operational and Strategic Data Sets
Remote data is considered as a strategic data that would include information based on
economy, political data, social statistics, ecology and technological advances. The strategic
manager make use of strategic data by collecting information related to industry in order to
create different kinds of standards (Chen et al. 2015). Other kinds of data based on economics
should be able to include the data based on the state of economy that includes recession, boom,
depression and different trends based on economy. Political data would include different kinds of
legal and regulatory information that includes employment and taxation laws.