Database Application Direction | Data Warehouse


Added on  2022-08-16

5 Pages799 Words22 Views
Name of the Student:
Name of the University:
Author Note:
Database Application Direction | Data Warehouse_1

Data Warehouse
It is system that is used to report and analysis of data. It could be considered business
intelligence’s core component. Data warehouse is integrated data’s central repositories from
several disparate sources. Data warehouse stores historical and current data at one place which
are used to create analytical reports throughout enterprise for the workers (Visscher, et al., 2017).
Data stored within data warehouse could be uploaded form operational systems. Data might pass
by operational data store. It might also need data cleansing.
Data Mart
Data mart is access pattern or structure specific with environments of data warehouse,
which are used for retrieving data of client. It is data warehouse’s subset and usually is oriented
to specific business team or line. These are built by the organizations as information is in
unorganized form inside the database which makes this readily accessible. Response time of end
user could be improved by using data marts by allowing the users in having access to specific
data type which are required by them.
Data Mining
Data mining is process to discover pattern within huge data sets, which involved methods
at intersection of statistics, database systems and machine learning. It is interdisciplinary subfield
for statistics and computer science with overall goal to extract the information from set of data as
well as transforms the information in understandable structure (Tan, Steinbach & Kumar, 2016).
Database Application Direction | Data Warehouse_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Software Engineering for Data Warehouse Systems Presentation 2022

CS5504: Business Intelligence Systems, Infrastructures and Technologies Assignment 2022

ICTDBS601 Assessment 1 - Written Test

Climate Data Analysis and Modeling

Knowledge Management and KM Tools

Information Technology - Database