Wulan Stau Fana, Rini Sovia, Randi Permana, Ataul Islam
{"title":"基于ETL方法(提取、转换和加载)的公司信息中心数据仓库设计","authors":"Wulan Stau Fana, Rini Sovia, Randi Permana, Ataul Islam","doi":"10.29099/ijair.v5i2.215","DOIUrl":null,"url":null,"abstract":"Data Warehouse is a technology use to analyze, extract and evaluate data into information which produce knownledge in the form of analysis to provide an advice in decision making process. Designing a Data Warehouse using ETL (Extract, Transformation and Load) process serves as the collection of data from different data sources into a multitude of integrated data sets. By using snowflake scheme for the design of the data warehouse make data prepare well and ready for analyze on Data Warehouse. The result of this reseach is to applied Data Warehouse that use to support company decision making progress make easier and has a good decision since its come from Data Warehouse","PeriodicalId":334856,"journal":{"name":"International Journal of Artificial Intelligence Research","volume":"44 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2021-06-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"4","resultStr":"{\"title\":\"Data Warehouse Design With ETL Method (Extract, Transform, And Load) for Company Information Centre\",\"authors\":\"Wulan Stau Fana, Rini Sovia, Randi Permana, Ataul Islam\",\"doi\":\"10.29099/ijair.v5i2.215\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Data Warehouse is a technology use to analyze, extract and evaluate data into information which produce knownledge in the form of analysis to provide an advice in decision making process. Designing a Data Warehouse using ETL (Extract, Transformation and Load) process serves as the collection of data from different data sources into a multitude of integrated data sets. By using snowflake scheme for the design of the data warehouse make data prepare well and ready for analyze on Data Warehouse. The result of this reseach is to applied Data Warehouse that use to support company decision making progress make easier and has a good decision since its come from Data Warehouse\",\"PeriodicalId\":334856,\"journal\":{\"name\":\"International Journal of Artificial Intelligence Research\",\"volume\":\"44 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2021-06-30\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"4\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"International Journal of Artificial Intelligence Research\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.29099/ijair.v5i2.215\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"International Journal of Artificial Intelligence Research","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.29099/ijair.v5i2.215","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Data Warehouse Design With ETL Method (Extract, Transform, And Load) for Company Information Centre
Data Warehouse is a technology use to analyze, extract and evaluate data into information which produce knownledge in the form of analysis to provide an advice in decision making process. Designing a Data Warehouse using ETL (Extract, Transformation and Load) process serves as the collection of data from different data sources into a multitude of integrated data sets. By using snowflake scheme for the design of the data warehouse make data prepare well and ready for analyze on Data Warehouse. The result of this reseach is to applied Data Warehouse that use to support company decision making progress make easier and has a good decision since its come from Data Warehouse