Design and optimization of multidimensional data models for enhanced OLAP query performance and data analysis

Applied and Computational Engineering, Год журнала: 2024, Номер 69(1), С. 161 - 166

Опубликована: Июль 25, 2024

This paper explores the design and optimization of multidimensional data models to enhance query performance analysis capabilities OLAP (Online Analytical Processing) systems. It delves into three prominent dimensional modeling techniques: Star Schema, Snowflake Galaxy analyzing their impact on complexity, redundancy, storage requirements, ease maintenance. Additionally, it examines aggregation strategiesPre-Aggregation, Dynamic Aggregation, Hybrid Aggregationfocusing effectiveness in balancing response time, efficiency, flexibility, computational cost. The study further investigates techniques, including optimization, partitioning, materialized views, providing case studies experimental illustrate benefits challenges. findings underscore importance tailored strategies systems meet varying business needs patterns, highlighting trade-offs between gains, implementation complexity

Язык: Английский

---

Exploring the Interplay Between Teaching Strategies and Digital Competencies Beliefs Among Pre-Service Teachers: A Longitudinal Study

Education Sciences, Год журнала: 2024, Номер 14(12), С. 1342 - 1342

Опубликована: Дек. 9, 2024

One goal of teacher education is to create learning environments where pre-service teachers can explore and enhance their digital competencies. We aim contribute knowledge on how these should be designed. First, our study focuses examining the changes in teachers’ Technological Pedagogical Knowledge (TPK) Content (TPACK) over one semester. Secondly, we evaluate impact various teaching strategies aimed at fostering professional competencies, as conceptualized by Synthesis Qualitative Evidence (SQD) model. Our sample comprised 308 (30% male students; x¯age = 23.29) from German University attending different seminars (N 40). Utilizing latent-change score models bi-factor exploratory structural equation models, indicated no significant overall change TPK TPACK across seminars. Taking into account SQD students’ satisfaction with these, not single but orchestration significantly positively impacted development within a These findings highlight importance employing TPACK.

Язык: Английский

---

The scale for adult education trainers’ digital technology use levels: a validity and reliability study

Education and Information Technologies, Год журнала: 2024, Номер unknown

Опубликована: Дек. 12, 2024

Язык: Английский

---

Alignment of the synthesis of qualitative data (SQD) model, technology self-efficacy and TPACK Core measures in preparing pre-service teachers to integrate technology

Routledge Open Research, Год журнала: 2023, Номер 1, С. 20 - 20

Опубликована: Фев. 13, 2023

Preparing pre-service teachers to integrate technology in their future classrooms is a complex endeavor. Several factors known affect the use of classroom include knowledge and skills, positive attitudes toward integrating technology, pedagogical expertise with content one or more disciplines. One strategy that has been used many educator preparation programs create course teaches how technology. Measuring impact these types courses important determining whether they are meeting needs pursuit meaningful effective way. This paper reports on measurement alignment three aspects integration - self-efficacy, strategies experiences provided by programs, intersection pedagogy. Pre-service participants semester-long focused gained significantly from pre post each scales, demonstrating an increase related during program confidence fusing In addition, measures different areas aligned show relationships attributes for using classrooms.

Язык: Английский

---

Validity and reliability of the questionnaire of academic knowledge of teachers of basic general education

F1000Research, Год журнала: 2023, Номер 12, С. 642 - 642

Опубликована: Июнь 12, 2023

Background: The concern and analysis about the knowledge possessed by teachers of basic general education persists in academic debate professional practice. It is noteworthy that studies consulted, there no precise evidence determines with accuracy configurations these factors function as basis teaching profession. Therefore, objective this study to establish construct validity reliability questionnaire on nature or origin education, adapted from Pedagogical Content Knowledge (PCK) Competence Model. Methods: A methodological was established applies a test processes internal consistency. performed through (n = 8) expert judges, using Cohen's Kappa. An exploratory factor following criteria Kaiser-Meyer-Olkin Coefficient (KMO), Bartlett sphericity principal components extraction method varimax rotation. sample consisted 27) Ibarra Canton. Results: results show for instrument obtained Cronbach’s alpha (α 0.901), estimated be an excellent level. Conclusions: relevant, valid reliable, adapting needs determine fast reliable manner.

Язык: Английский

---

Alignment of the synthesis of qualitative data (SQD) model, technology self-efficacy and TPACK Core measures in preparing pre-service teachers to integrate technology

Routledge Open Research, Год журнала: 2023, Номер 1, С. 20 - 20

Опубликована: Март 9, 2023

Preparing pre-service teachers to integrate technology in their future classrooms is a complex endeavor. Several factors known affect the use of classroom include knowledge and skills, positive attitudes toward integrating technology, pedagogical expertise with content one or more disciplines. One strategy that has been used many educator preparation programs create course teaches how technology. Measuring impact these types courses important determining whether they are meeting needs pursuit meaningful effective way. This paper reports on measurement alignment three aspects integration - self-efficacy, strategies experiences provided by programs, intersection pedagogy. Pre-service participants semester-long focused gained significantly from pre post each scales, demonstrating an increase related during program confidence fusing In addition, measures different areas aligned show relationships attributes for using classrooms.

Язык: Английский

---

Propuesta metodológica y arquitectónica para el desarrollo de juegos serios orientados a la formación de competencias tecnológicas

Опубликована: Июнь 15, 2023

En la actualidad, formación de competencias tecnológicas en el profesorado se ha vuelto un factor imprescindible ámbito educativo. este sentido, los juegos serios han sido utilizados para entrenamiento, formación, capacitación y adquisición habilidades diferentes áreas del conocimiento. Si bien existen investigaciones que hacen referencia a posibilidad ofrecen digitales, no evidencian diseñados o arquitecturas estos pensados exclusivamente potenciar nivel educación superior. Por tal razón y, marco Doctorado Ciencias Informáticas, realizó una investigación con objetivo brindar propuesta metodológica arquitectónica guíe paso diseño vinculados tecnológicas. consecuencia, planteó metodología arquitectura software diseñar prototipo funcional juego serio denominado SkillNet, cual permite profesorado; específicamente las relacionadas conocimientos básicos redes datos. Para llevar adelante cumplir propuesto, ejecutó indagación bajo enfoque metodológico cualitativo descriptivo, donde hizo primeramente revisión teórica acorde temas investigación; principalmente relacionados metodologías utilizadas serios, así como vinculadas prototipos. Posteriormente, diseña sugiere denominada INTEGRA+506 través siete etapas dieciséis pasos metodológicos guía orientados Seguido, tomando llamado está orientado formar área El consta tres conformadas por niveles, cada una, cuales jugador debe enfrentar diversos desafíos superarlos desbloquear siguiente nivel. Finalmente, concluye mostró efectividad guiar trabajo realizado SkillNet. Su aplicación ayudó ordenar todo proceso validación ejecutada panel expertos, revisó analizó tanto prototipo.

---

Teachers’ adaptations to COVID-19: perceived preparedness for distance education, frequency of teacher-student contact, and resources in ICT

European Journal of Teacher Education, Год журнала: 2023, Номер unknown, С. 1 - 26

Опубликована: Ноя. 30, 2023

ABSTRACTThe post-COVID The Great Online Transition requires more support for teaching with information and communications technology (ICT) than ever. present study investigated teachers’ psychological (perceived preparedness distance education) behavioural (frequency of teacher – student contact) adaptations to education in relation job (training, collaboration, equipment) personal (self-efficacy) resources the area ICT during first wave school closings 2020. We surveyed 1103 teachers German-speaking regions via newsletters X (formerly Twitter). Results from recursive path model showed that all were positively associated perceived preparedness, but actual frequency contact was only significantly related collaboration. Lastly, self-efficacy mediated associations between adaptations. Our findings highlighted policymaking administration applications which focus should be placed on fostering resources, particularly collaboration.KEYWORDS: In-service teacherremote teachingtechnologyschool closurecontinuing professional development AcknowledgmentsWe would like thank Jennifer Quast who supported data assessment decisively.Disclosure statementIn accordance Taylor & Francis policy our ethical obligations as researcher, we are reporting this research did not receive any specific grant funding agencies public, commercial, or not-for-profit sectors. No financial interest benefit has arisen direct research.Data availability statementSample dataset analysis script free openly available at project’s OSF page: https://osf.io/8b5gp/?view_only=b7f434b6b29d4de3bda18a9f5f51f662.Notes1. In Germany, Gymnasium is academic secondary grades 5 12 13.Additional informationFundingThis work by Deutsche Forschungsgemeinschaft [491466077].Notes contributorsYizhen HuangYizhen Huang a postdoctoral researcher Department Education University Potsdam Germany. She received her Ph.D. Psychology Michigan’s Combined Program Ann Arbor. Her interests include visual representation observational learning, expertise development, use eye-tracking virtual reality technologies educational settings.Rebecca LazaridesRebecca Lazarides professor School Instructional Research Potsdam, current focuses quality, motivation emotion, research, competencies, learning heterogeneous groups.Dirk RichterDirk Richter Educational Sciences His competencies teachers, collaboration training.

Язык: Английский

---

Digitization in teacher education—quality enhancement, status quo, and professionalization approaches

Unterrichtswissenschaft, Год журнала: 2023, Номер 51(4), С. 479 - 487

Опубликована: Дек. 1, 2023

Язык: Английский

---