Page 177 - DCAP405_SOFTWARE_ENGINEERING

Software Engineering

Notes events. Related to the proposal is the AXAF user who submitted it and for whom there is an
entry in the AXAF user table. An AXAF user may have a subscription to the AXAF newsletter.
An activity that translates the data model developed during analysis into implementable data
structures.
Data design translates data objects defined during analysis model into data structures at the
software component level and, when necessary, a database architecture at the application level.
There are small and large businesses that contain lot of data. There are dozens of databases that
serve many applications comprising of lots of data. The aim is to extract useful information
from data environment especially when the information desired is cross functional.
Techniques like data mining are used to extract useful information from raw data. However,
data mining becomes difficult because of some factors:
Existence of multiple databases.
Different structures.

Degree of detail contained with databases. Alternative solution is concept of data
warehousing which adds an additional layer to data architecture. Data warehouse
encompasses all data used by a business.

Did u know? What is data warehouse?

A data warehouse is a large, independent database that serves the set of applications
required by a business. Data warehouse is a separate data environment.

Self Assessment

Fill in the blanks:
1. A level of ……………………. between the data and users is desirable for security,
performance and ease of administration.
2. A good architecture design partitions the …………………….. requirements of a software
system into a manageable set of interacting components.
3. ……………….. about the files, extracted from file headers or supplied by the archiving
process, is stored in databases.
4. Techniques like …………………….. are used to extract useful information from raw data.
5. Data mining tools predict future trends and behaviors, allowing businesses to make
proactive, …………………….. decisions.
6. A data warehouse is a ……………………….. database that is designed for query and analysis
rather than for transaction processing.

7. Data warehouses are designed to help you …………………….. data.
8. Data warehouses must put data from disparate sources into a ……………………. format.

10.2 Data Design at Component Level

It focuses on representation of data structures that are directly accessed by one or more software
components. Set of principles applicable to data design are:

170 LOVELY PROFESSIONAL UNIVERSITY