Design of Structured Query Language Online Judge Systems

The research described in this paper aims to implement a novel SQL query evaluation system, known as the SQL Online Judge (SQLOJ), and conduct mining and analysis on the relevant data obtained from SQLOJ. This system is intended to provide guidance and inspiration for student learning, teacher instruction, and course design. The paper focuses on introducing the technologies and system framework utilized by the system, and proposes a system availability tradeoff strategy to address the issue of excessive concurrent online users. The research results presented in this paper establish SQLOJ as a comprehensive platform and data resource for practical teaching in database courses, offering an innovative foundation that effectively complements traditional approaches to professional and course descriptions.