Software Engineering for Data Warehouse Systems Presentation 2022

SOFTWARE
ENGINEERING
FOR
DATA
WAREHOUSE
SYSTEMS

Software Engineering
Methodologies
The different methods or approaches by which a software is developed and
delivered for the users are:
 ‘Waterfall Development’
 ‘Rapid Application Development’
 ‘Prototyping-Oriented Software Development’
 ‘Spiral Software Development’
 ‘Model-Driven Architecture’
 ‘Component-Based Software Engineering’
 ‘Agile Software Development’

Data Warehouse Systems
 A model of Business Intelligence Systems
 Helps in generating reports on business
entities on a regular data.
 Does not incorporate the same
performance on real-time basis.
 Provides for a central repository to store all
data (Mercado
et al. 2018).
 Incorporates two-way communication with
all operations in a business.
 Adheres to all types of changes in a
business.

Data Warehouse Constituents
 Database- Foundation for the
warehouse environment, provides the
framework to store data.
 ETL Tools- Use to extract data,
transform them and load it back in the
database, removes duplicate data and
deletes unwanted data.
 Metadata- The data that defines the
warehouse and contains the technical
specifications about it.
 Query Tools- Allows to interact with
the database systems, can be classified
into reporting tools, data mining tools,
OLAP tools and app development tools.
 Data Marts- Provides as a subsidiary
of warehouse and an access layer by
which users can access data.