Design and analysis on data warehouse of personnel administration system using time series algorithm

Alviana, Sopian; Kurniawan, Bobi

doi:10.1088/1757-899x/407/1/012092

Cited by 2 publications

(1 citation statement)

References 7 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…A systematic data warehouse consists of fact and dimension tables. Fact tables refer to critical processes and hold the data to be analyzed (Alviana and Kurniawan 2018 ; Parmanto et al 2005 ). These are central tables and store quantitative data.…”

Section: Introductionmentioning

confidence: 99%

A multidimensional data warehouse design to combat the health pandemics

Turcan

Peker

2022

J. of Data, Inf. and Manag.

View full text Add to dashboard Cite

The Covid-19 pandemic has brought about a new lifestyle for across the globe. Throughout this period, the use of holistic methods has become indispensable to deal with the enormous amount of data in this regard. It appears that the simplest way to tackle this issue is to spread the digitalization efforts concerning all data-based applications. Given the significance of pandemic data management, it is essential to have a data warehouse that collects, associates, and communicates these data. Containing a significant volume of structured data, warehousing can provide the necessary foundation for data mining and the development of analytical tools. To this end, the present paper proposes a data warehouse for combatting and managing pandemics, with the possibility to be enhanced for other personal or public health-related initiatives. In this research, the bottom-up data warehouse building methodology is used to construct a warehouse. A fact constellation schema model is utilized to accommodate the information ranging from citizen demographics to physician-prescribed drugs and laboratory tests. Sample queries are executed based on the proposed data warehouse for different purposes, and desired query results are obtained within proper response times. The proposed data warehouse contributes to countrywide implementation of pandemic practices and illuminates research on faster, less expensive, and safer management of citywide, nationwide, or worldwide health emergencies within a robust technical framework by governments.

show abstract

Section: Introductionmentioning

confidence: 99%