An approach to engineering the requirements of data warehouses

Authors:
Naveen Prakash;Anjana Gosain
Affiliations:
GCET, 1 Knowledge Park Phase II, 201306, Greater Noida, Uttar Pradesh, India;GGSIP University, SIT, Kashmiri Gate, 201306, Delhi, Uttar Pradesh, India
Venue:
Requirements Engineering
Year:
2008

Citing 0
Cited 7

Agent oriented requirements engineering for a data warehouse

ACM SIGSOFT Software Engineering Notes
Modeling of security requirements for decision information systems

ACM SIGSOFT Software Engineering Notes
Quality-oriented requirements engineering for a data warehouse

ACM SIGSOFT Software Engineering Notes
Middleware non-repudiation service for the data warehouse

Annales UMCS, Informatica
A hybrid approach for data mart schema design from NL-OLAP requirements

NLDB'09 Proceedings of the 14th international conference on Applications of Natural Language to Information Systems
An MDA Approach and QVT Transformations for the Integrated Development of Goal-Oriented Data Warehouses and Data Marts

Journal of Database Management
Adding semantic modules to improve goal-oriented analysis of data warehouses using I-star

Journal of Systems and Software

Quantified Score

Hi-index	0.00

Visualization

Abstract

We focus exclusively on the issue of Requirements engineering for Data Warehouses (DW). Our position is that the information content of a DW is found in the larger context of the goals of an organization. We refer to this context as the organizational perspective. Goals identify the set of decisions that are relevant which in turn help in determining the information needed to support these. The organizational perspective is converted into the technical perspective, which deals with the set of decisions to be supported and the information required. The latter defines Data warehouse contents. To elicit the technical perspective, we use the notion of an informational scenario. It is a typical interaction between a DW system and the decision maker and consists of a sequence of pairs of the form, . We formulate an information request as a statement in an adapted form of SQL called Specification SQL. The proposals here are implemented in the form of an Informational Scenario Engine that processes informational scenarios and determines Data Warehouse Information Contents.