Effect of semantic distance on learning structured query language: An empirical study.

Area of Science:

• Computer Science Education
• Database Systems
• Cognitive Science

Background:

• Structured Query Language (SQL) is fundamental for database management but notoriously difficult for students to master.
• Existing pedagogical approaches have not fully resolved the persistent challenges in SQL learning.
• Understanding the cognitive underpinnings of SQL learning difficulties is crucial for developing effective teaching strategies.

Purpose of the Study:

• To analyze the difficulties in learning SQL through the lens of semantic distance, utilizing semantic network theory.
• To investigate the impact of semantic distance on student comprehension of SQL.
• To identify specific transformations in the SQL learning process that contribute most significantly to learning difficulties.

Main Methods:

• An experiment was conducted within a database course setting.
• Participants were tasked with a query-writing exercise to assess their SQL understanding.
• Semantic network theory was employed to analyze the semantic distance between different stages of SQL formulation.

Main Results:

• Learners demonstrated a better grasp of the formulation-to-planning transformation compared to the planning-to-coding transformation.
• The planning-to-coding transformation exhibits a greater semantic distance, primarily due to the shift from natural language to SQL.
• This significant semantic gap arises because natural language and SQL represent distinct linguistic and knowledge categories.

Conclusions:

• The primary obstacle in learning SQL is the substantial semantic distance within the planning-to-coding transformation.
• SQL teaching methods should prioritize emphasizing the semantic mapping from planning to code.
• Reducing the semantic distance in this transformation is key to improving SQL learning effectiveness and developing better pedagogical tools.