Requirement Engineering Framework for Target-Driven Data Warehouse Design and Optimization.
Saved in:
| Title: | Requirement Engineering Framework for Target-Driven Data Warehouse Design and Optimization. |
|---|---|
| Authors: | Sharma, Vishal1 kksharma_socsa@iimtindia.net, Sharma, K. K.1 |
| Source: | International Journal of Performability Engineering. Feb2026, Vol. 22 Issue 2, p99-109. 11p. |
| Subjects: | Requirements engineering, Data warehousing, Optimization algorithms, Comparative studies, Key performance indicators (Management), Stakeholder analysis, Goal (Psychology), Natural language processing |
| Abstract: | The strategic alignment with the primary commercial purposes of data warehouse (DW) systems are a continuous challenge of data management. Conventional requirement engineering (RE) approaches do not tend to achieve success in translating high-level business requirements into unambiguous and implementable specifications needed to produce the best DW design, creating such systems that are functional but strategically uncomfortable and strategically inadmissible. The current paper eliminates this major distinction by the introduction of a new target-driven requirement engineering (TDRE) structure. The structure offers a methodical role to extract, break up and execute purposeful business aims and significant performance measures (KPI) in verification DW specifications. This encompasses the systematic breakdown model, semi-automatic natural language processing (NLP) need analysis, and a modified failure mode and impact analysis (FMA) rooted on the risk-inconstant preference determination mechanism. At the core of the structure are the suggested target-run requirement decomposition and adequacy (TDRD-T) algorithms, which articulately render the process of transforming business goals into a tragic requirement list. The efficiency of this framework is presented in the form of a comparative case study in the organizational setting of the real world. The findings imply that the TDRE framework reduces the need to 71.9% and covers a greater part of trackability by 98%. Moreover, the DW created with the help of this framework outperformed and achieved the key objectives of query response time and data innovation; it was rated 40 percent higher by users. Both the theoretical input to the DW design approach and the practical, tested instrument that is offered in this research enables practitioners to ensure that DW investments achieve their desired business value. [ABSTRACT FROM AUTHOR] |
| Copyright of International Journal of Performability Engineering is the property of Totem Publisher, Inc. and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) | |
| Database: | Engineering Source |
| FullText | Links: – Type: pdflink Text: Availability: 0 |
|---|---|
| Header | DbId: egs DbLabel: Engineering Source An: 191342999 AccessLevel: 6 PubType: Academic Journal PubTypeId: academicJournal PreciseRelevancyScore: 0 |
| IllustrationInfo | |
| Items | – Name: Title Label: Title Group: Ti Data: Requirement Engineering Framework for Target-Driven Data Warehouse Design and Optimization. – Name: Author Label: Authors Group: Au Data: <searchLink fieldCode="AR" term="%22Sharma%2C+Vishal%22">Sharma, Vishal</searchLink><relatesTo>1</relatesTo><i> kksharma_socsa@iimtindia.net</i><br /><searchLink fieldCode="AR" term="%22Sharma%2C+K%2E+K%2E%22">Sharma, K. K.</searchLink><relatesTo>1</relatesTo> – Name: TitleSource Label: Source Group: Src Data: <searchLink fieldCode="JN" term="%22International+Journal+of+Performability+Engineering%22">International Journal of Performability Engineering</searchLink>. Feb2026, Vol. 22 Issue 2, p99-109. 11p. – Name: Subject Label: Subjects Group: Su Data: <searchLink fieldCode="DE" term="%22Requirements+engineering%22">Requirements engineering</searchLink><br /><searchLink fieldCode="DE" term="%22Data+warehousing%22">Data warehousing</searchLink><br /><searchLink fieldCode="DE" term="%22Optimization+algorithms%22">Optimization algorithms</searchLink><br /><searchLink fieldCode="DE" term="%22Comparative+studies%22">Comparative studies</searchLink><br /><searchLink fieldCode="DE" term="%22Key+performance+indicators+%28Management%29%22">Key performance indicators (Management)</searchLink><br /><searchLink fieldCode="DE" term="%22Stakeholder+analysis%22">Stakeholder analysis</searchLink><br /><searchLink fieldCode="DE" term="%22Goal+%28Psychology%29%22">Goal (Psychology)</searchLink><br /><searchLink fieldCode="DE" term="%22Natural+language+processing%22">Natural language processing</searchLink> – Name: Abstract Label: Abstract Group: Ab Data: The strategic alignment with the primary commercial purposes of data warehouse (DW) systems are a continuous challenge of data management. Conventional requirement engineering (RE) approaches do not tend to achieve success in translating high-level business requirements into unambiguous and implementable specifications needed to produce the best DW design, creating such systems that are functional but strategically uncomfortable and strategically inadmissible. The current paper eliminates this major distinction by the introduction of a new target-driven requirement engineering (TDRE) structure. The structure offers a methodical role to extract, break up and execute purposeful business aims and significant performance measures (KPI) in verification DW specifications. This encompasses the systematic breakdown model, semi-automatic natural language processing (NLP) need analysis, and a modified failure mode and impact analysis (FMA) rooted on the risk-inconstant preference determination mechanism. At the core of the structure are the suggested target-run requirement decomposition and adequacy (TDRD-T) algorithms, which articulately render the process of transforming business goals into a tragic requirement list. The efficiency of this framework is presented in the form of a comparative case study in the organizational setting of the real world. The findings imply that the TDRE framework reduces the need to 71.9% and covers a greater part of trackability by 98%. Moreover, the DW created with the help of this framework outperformed and achieved the key objectives of query response time and data innovation; it was rated 40 percent higher by users. Both the theoretical input to the DW design approach and the practical, tested instrument that is offered in this research enables practitioners to ensure that DW investments achieve their desired business value. [ABSTRACT FROM AUTHOR] – Name: AbstractSuppliedCopyright Label: Group: Ab Data: <i>Copyright of International Journal of Performability Engineering is the property of Totem Publisher, Inc. and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract.</i> (Copyright applies to all Abstracts.) |
| PLink | https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=egs&AN=191342999 |
| RecordInfo | BibRecord: BibEntity: Identifiers: – Type: doi Value: 10.23940/ijpe.26.02.p5.99109 Languages: – Code: eng Text: English PhysicalDescription: Pagination: PageCount: 11 StartPage: 99 Subjects: – SubjectFull: Requirements engineering Type: general – SubjectFull: Data warehousing Type: general – SubjectFull: Optimization algorithms Type: general – SubjectFull: Comparative studies Type: general – SubjectFull: Key performance indicators (Management) Type: general – SubjectFull: Stakeholder analysis Type: general – SubjectFull: Goal (Psychology) Type: general – SubjectFull: Natural language processing Type: general Titles: – TitleFull: Requirement Engineering Framework for Target-Driven Data Warehouse Design and Optimization. Type: main BibRelationships: HasContributorRelationships: – PersonEntity: Name: NameFull: Sharma, Vishal – PersonEntity: Name: NameFull: Sharma, K. K. IsPartOfRelationships: – BibEntity: Dates: – D: 01 M: 02 Text: Feb2026 Type: published Y: 2026 Identifiers: – Type: issn-print Value: 09731318 Numbering: – Type: volume Value: 22 – Type: issue Value: 2 Titles: – TitleFull: International Journal of Performability Engineering Type: main |
| ResultId | 1 |
