Welcome to the InfoSci Platform
UML-Based Data Warehouse Design Using Temporal Dimensional Modelling

UML-Based Data Warehouse Design Using Temporal Dimensional Modelling

G. Sekhar Reddy, Chittineni Suneetha
Copyright: © 2020 |Volume: 12 |Issue: 3 |Pages: 19
ISSN: 2643-7937|EISSN: 2643-7945|EISBN13: 9781522598916|DOI: 10.4018/IJSPPC.2020070101
Cite Article Cite Article

MLA

Reddy, G. Sekhar, and Chittineni Suneetha. "UML-Based Data Warehouse Design Using Temporal Dimensional Modelling." IJSPPC vol.12, no.3 2020: pp.1-19. http://doi.org/10.4018/IJSPPC.2020070101

APA

Reddy, G. S. & Suneetha, C. (2020). UML-Based Data Warehouse Design Using Temporal Dimensional Modelling. International Journal of Security and Privacy in Pervasive Computing (IJSPPC), 12(3), 1-19. http://doi.org/10.4018/IJSPPC.2020070101

Chicago

Reddy, G. Sekhar, and Chittineni Suneetha. "UML-Based Data Warehouse Design Using Temporal Dimensional Modelling," International Journal of Security and Privacy in Pervasive Computing (IJSPPC) 12, no.3: 1-19. http://doi.org/10.4018/IJSPPC.2020070101

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

The design of a data warehouse system deals with tasks such as data source administration, ETL processing, multidimensional modelling, data mart specification, and end-user tool development. In the last decade, numerous techniques have been presented to cover all the aspects of DW. However, none of these techniques stated the recent necessities of DW like visualization, temporal dimensions, record keeping, and so on. To overcome these issues, this paper proposes a UML based DW with temporal dimensions. This framework designs time-dependent DW that allows end-users to store history of variations for long term. Besides, it authorizes to visualize the business goals of organizations in the form of attribute tree via UML, which is designed after receiving user necessities and later reconciling with temporal variables. The implementation of proposed technique is detailed with university education database for quality improvement. The proposed technique is found to be useful in terms of temporal dimension, long-term record keeping, and easy to make decision goals through attribute trees.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.