Effective Building Data Warehouse Infrastructure by Code in Cloud Platform

Effective Building Data Warehouse Infrastructure by Code in Cloud Platform

연구 분야: Databases

학회: 2022 International Electronics Symposium (IES)

Over time the data generated by a market is getting bigger and more diverse. So, it takes a larger container to store the data. The solution is to use a data warehouse. On the other hand, network infrastructure is needed to handle data collection. Improper infrastructure can potentially stop the storage system and cause data loss. So, we need a method to build a network infrastructure that can handle this. Considering the availability of infrastructure (high availability) and the ease of construction. This study aims to build a network infrastructure with code to improve consistency and speed until it is ready to be used for Business Intelligence needs. BIAPP is an application that is used to process network infrastructure development using code. In addition, this application can immediately be used for Business Intelligence needs when the infrastructure has been created. Speed results are obtained when building network infrastructure using code and conventional. An average of 207.63% of code usage was obtained faster than the conventional method. In addition to getting results from infrastructure speed, the results of this application can already carry out Business Intelligence processes. One of the results obtained is the number of products repurchased by customers. The data can be used to determine the number of products to be purchased on the next purchase.