Database Design and Implementation of Game Management System for Rescue Robot Contest

Abstract

The Rescue Robot Contest is one of the robot contests concerning lifesaving in urban disasters. In this contest, loads of rescue dummies simulating disaster victims, and contest progression status are presented to audiences, and team members operating robots. This presentation is important for both robot activity evaluation and production effect. For these purposes, a game management system for Rescue Robot Contest is originally constructed and operated. In this system, a database system is employed as base system. And this system's role is for both recording all data and events, and real-time processing for the presentation. In this paper, design and implementation of the tables and built-in functions of the database which is foundation of this system are presented. For real-time processing, embedded functions and trigger functions are implemented. These functions generate unique latest records into specific tables which stores only latest data for quick access.