Requirement Engineering for DataWarehouse

By


Every organization deals with vast amounts of data which is stored in different formats or patterns developed on different platforms by different developers and further form different database structures. This brings hurdles on the path of analysts or users with respect to its access. Thus, organizations have to write and maintain perhaps hundreds of programs that extract, prepare, and consolidate data for its use. All this process is done with respect to Data Warehouse.
Thus ,we can define a data warehouse as “A data warehouse is a subject oriented, integrated, non-volatile and time-variant collection of data in support of management’s decision.”
Building of efficient Data Warehouse and its maintenance involves extraction, cleaning and filtering of data etc. It is a costly and time consuming process, as this is performed before requirements are gathere-d. To overcome this problem, we should use such a technique that helps in exploring and clarifying each requirement in detail which can be considered while constructing the Data Warehouse at an early phase.
Data Warehouse must be designed keeping in mind the requirements for decision making which is often derived from the data sources.
While working towards the solution i.e. Building an efficient Data Warehouse we have a number of techniques available. The technique ‘Requirement Analysis’ of ‘Requirement Engineering’ can be combined with the Requirement gathering techniques of Data Warehouse i.e. ‘Interview’ and ‘Survey Method’ in order to build an effective data warehouse.
The “Interview Technique” can be regarded as one of the best suitable technique for solving this problem. Key facts that should be considered while applying this technique is that the questions used in the interview should not reflect the interviewer’s preconceived ideas, as it can influence the responses. During the Interview, closed questions should not be asked and stressed upon because it limits the input with respect to the subject.

Renu Yadav
Assistant Professor
BBA

Comments

Post a Comment

Popular posts from this blog

Teacher As: Critical Pedagogue

By
Education is not only a process of cognitive development. It is a process of overall development of the child. The whole teaching learning process consist with three important components i.e student, teacher and curriculum. In the process of curriculum construction, evaluation and feedbacks are an important aspect to redesign the curriculum. Evaluation cannot be made on the basis of academic achievement of the students. Teacher should play an important role in the construction of curriculum as well as transaction of curriculum. Thus there is a need that teacher should take initiative to evaluate the whole education system as a Critical pedagogue. It is an ability to evaluate our teaching and the practices prevailing in existing education system critically in relation to methods and practices adopted by the teacher to teach concern pedagogical subjects. Ira Shor defines “ Critical pedagogy is habits of thought, reading, writing and speaking which go beneath surface meaning, first impr...
Read more

ROLE CONFLICT PROBLEM AMONG WORKING WOMEN

By
Women of India have marked their significant presence in the world in various fields. They have been given the status of power and prestige in India.    Indian women has got much more significance in today’s developing times. Where until lately, they were shadowed by patriarchal dominance, the contemporary women in India have moved beyond all social boundaries to emerge as triumphant leaders of tomorrow. Not only has She taken up courageous roles in society, her own individuality as a ‘woman’ has now got an improvised meaning. The world has changed for females in India now. The daughters are pursuing successful ambitions in the male dominated corporate scenario and mothers are taking up flextime jobs to showcase their exceptional managerial talent. Today, our women have stepped out to become bread earners of the family. Although the trend is yet developing in India, The IT-BPO sector is becoming a female dominated industry in India with a significant number of capable a...
Read more

Rights and obligations of Issuer, Participant and Beneficial owner under the Depository Act, 1996

By
As per section 17 of depository Act the rights and obligations of the depositories, participants and the issuers whose securities are dealt with by a depository shall be specified by the regulations. Under the Depository Act, 1996 depository means a company formed and registered under the Companies Act, 1956, and which has been granted a certificate of registration by SEBI under sub-section (1A) of Section 12 of the Securities and Exchange Board of India Act, 1992 ). (Section 2(1) (e)) Work of Depository- The word ‘depositary’ is defined as “the party of the institution (company) receiving a deposit. A depository holds securities (like shares, debentures, bonds, Government Securities, units etc.) of investors in electronic form. Besides holding securities, a depository also provides services related to transactions in securities. It acts as a trustee of the owner since the securities are entrusted with him in trust. He is also the agent of the owner of the securities. Thus...
Read more