Implementing data warehouse infrastructure for an e-learning system

İhsan Güneş; Mustafa Kemal Birgin

Makale detayları

Implementing data warehouse infrastructure for an e-learning system

Yazarlar:

İhsan Güneş | Mustafa Kemal Birgin

Yayıncı:

Gumushane University

Ana Başlıklar:

Mühendislik

Dergi:

Gümüşhane Üniversitesi Fen Bilimleri Dergisi Vol.13 Issue 3, pp.750-766

Belge Tipi:

Makale

Yayın Tarihi:

7/2023

Belge Dili:

İngilizce

Document ID (Org No.):

2001293266

pISSN:

2146-538X

Anahtar kelimeler:

Özet:

 The use of a data warehouse DW in e-learning applications helps us evaluate students from different perspectives. Depending on user behavior, we may change the content or appearance of the e-learning platform to achieve the best results. The aim of this study is to build a data warehouse infrastructure, which is a central information system for Anadolu Universitys distance education system. Thanks to the data warehouse project, all learners activities in the Learning Management System ÖYS: Anadolum e-Kampüs will be recorded regularly. Various analytical reports were obtained about students study styles, preferred e-learning resources, and the time spent in the system. Additionally, the data warehouse system regularly pulls information from other information systems, such as the student information system related to the open education system. Data warehousing is designed to combine data from multiple sources into a single unified view, rather than performing operational operations like a database. Generally, data warehouses are used for analytical processing as opposed to transaction processing. They are used to analyze historical data and trends, as well as to identify patterns and insights that can aid in informing business decisions. When analysis and reporting is done in a different environment using data warehousing, there is no additional load on the database, which is already busy with daily operational processes. The data warehouse has made it easy to obtain student analytics for various periods, including daily, monthly, and yearly. The reports provided through this infrastructure are used in studies to increase the quality of the LMS system.

 The use of a data warehouse DW in e-learning applications helps us evaluate students from different perspectives. Depending on user behavior, we may change the content or appearance of the e-learning platform to achieve the best results. The aim of this study is to build a data warehouse infrastructure, which is a central information system for Anadolu Universitys distance education system. Thanks to the data warehouse project, all learners activities in the Learning Management System ÖYS: Anadolum e-Kampüs will be recorded regularly. Various analytical reports were obtained about students study styles, preferred e-learning resources, and the time spent in the system. Additionally, the data warehouse system regularly pulls information from other information systems, such as the student information system related to the open education system. Data warehousing is designed to combine data from multiple sources into a single unified view, rather than performing operational operations like a database. Generally, data warehouses are used for analytical processing as opposed to transaction processing. They are used to analyze historical data and trends, as well as to identify patterns and insights that can aid in informing business decisions. When analysis and reporting is done in a different environment using data warehousing, there is no additional load on the database, which is already busy with daily operational processes. The data warehouse has made it easy to obtain student analytics for various periods, including daily, monthly, and yearly. The reports provided through this infrastructure are used in studies to increase the quality of the LMS system.

 The use of a data warehouse DW in e-learning applications helps us evaluate students from different perspectives. Depending on user behavior, we may change the content or appearance of the e-learning platform to achieve the best results. The aim of this study is to build a data warehouse infrastructure, which is a central information system for Anadolu Universitys distance education system. Thanks to the data warehouse project, all learners activities in the Learning Management System ÖYS: Anadolum e-Kampüs will be recorded regularly. Various analytical reports were obtained about students study styles, preferred e-learning resources, and the time spent in the system. Additionally, the data warehouse system regularly pulls information from other information systems, such as the student information system related to the open education system. Data warehousing is designed to combine data from multiple sources into a single unified view, rather than performing operational operations like a database. Generally, data warehouses are used for analytical processing as opposed to transaction processing. They are used to analyze historical data and trends, as well as to identify patterns and insights that can aid in informing business decisions. When analysis and reporting is done in a different environment using data warehousing, there is no additional load on the database, which is already busy with daily operational processes. The data warehouse has made it easy to obtain student analytics for various periods, including daily, monthly, and yearly. The reports provided through this infrastructure are used in studies to increase the quality of the LMS system.

 E-öğrenme sistemlerinde veri ambarı DW kullanımı, öğrencilerin çeşitli açılardan değerlendirilmesine yardımcı olur. En iyi sonuçları elde etmek için, e-öğrenme platformunun içeriğini veya tasarımını kullanıcı davranışına göre değiştirebiliriz. Bu çalışmanın amacı, üniversitenin uzaktan eğitim programının ana bilgi sistemi olarak hizmet verecek bir veri ambarı altyapısı oluşturmaktır. Veri ambarı altyapısı sayesinde öğrencilerin öğrenim yönetim sistemindeki ÖYS: Anadolum e-Kampüs tüm etkinlikleri rutin olarak kayıt altına alınmaktadır. Öğrencilerin çalışma stilleri, tercih edilen e-öğrenme kaynakları ve sistemde harcanan zamanla ilgili çeşitli analitik raporlar almak mümkün olacaktır. Veri ambarı sistemi ayrıca açıköğretim sistemi ile ilgili öğrenci bilgi sistemi gibi diğer bilgi sistemlerinden de düzenli olarak veri çekmektedir. Veri ambarı, veritabanı gibi anlık operasyonel işlemleri yapmak yerine birden çok kaynaktan gelen verileri, tek bir birleşik görünümünde birleştirmek için tasarlanmıştır. Genel olarak, veri ambarları, işlem işleme yerine analitik işleme için kullanılır. Geçmiş verileri ve eğilimleri analiz etmenin yanı sıra iş kararlarını bilgilendirmeye yardımcı olabilecek modelleri ve görüşleri belirlemek için kullanılırlar. Veri ambarı kullanılarak analiz ve raporlama işlemleri farklı bir ortamda yapıldığında, günlük operasyonel işlemler ile meşgul olan veri tabanı üzerine daha fazla yük getirilmemiş olunur. Veri ambarı, günlük, aylık ve yıllık dahil olmak üzere çeşitli zaman dilimleri için öğrenci analitiği elde etmeyi kolaylaştıracaktır. Bu altyapı üzerinden sağlanan raporlar ÖYS sisteminin kalitesini artırmak amacıyla yapılan çalışmalarda kullanılmaktadır.

Makale detayları

Implementing data warehouse infrastructure for an e-learning system

Yazarlar:

İhsan Güneş | Mustafa Kemal Birgin

Yayıncı:

Gumushane University

Ana Başlıklar:

Mühendislik

Dergi:

Gümüşhane Üniversitesi Fen Bilimleri Dergisi Vol.13 Issue 3, pp.750-766

Belge Tipi:

Makale

Yayın Tarihi:

7/2023

Belge Dili:

İngilizce

Document ID (Org No.):

2001293266

pISSN:

2146-538X

Data analytics

Data mining

Data warehouse

Open and distance learningVeri analitiği

Veri madenciliği

Veri ambarı

Açık ve uzaktan eğitim sistemi

Sayı

Makale detayları

Yazarlar: İhsan Güneş | Mustafa Kemal Birgin

Yayıncı: Gumushane University

Ana Başlıklar: Mühendislik

Dergi: Gümüşhane Üniversitesi Fen Bilimleri Dergisi Vol.13 Issue 3, pp.750-766

Belge Tipi: Makale

Yayın Tarihi: 7/2023

Belge Dili: İngilizce

Document ID (Org No.): 2001293266

pISSN: 2146-538X

Sayı

Yazarlar:

İhsan Güneş | Mustafa Kemal Birgin

Yayıncı:

Gumushane University

Ana Başlıklar:

Mühendislik

Dergi:

Gümüşhane Üniversitesi Fen Bilimleri Dergisi Vol.13 Issue 3, pp.750-766

Belge Tipi:

Makale

Yayın Tarihi:

7/2023

Belge Dili:

İngilizce

Document ID (Org No.):

2001293266

pISSN:

2146-538X