基于存储过程的SQL自动评判系统

摘要

针对数据库能力测评,提出了一种基于存储过程的SQL自动评判系统实现方案.该方案以SQL Server中的存储过程为核心,使用基本的SQL语句与黑盒测试,实现了数据查询、增加、更新以及删除的自动评判.为避免系统在分布式运行环境中读写脏数据,设置了事务隔离级别并划分了事务.实际应用表明,该系统具有高效、易实施的特点,达到了设计要求.%An implementation scheme of automated assessment systems for SQL based on stored procedures is presented for database ability assessing.It is based on stored procedures in SQL Server,with fundamental SQL statements and black box testing used for automated assessing data select,insert,update and delete.Transaction isolation levels are set in transactions to avoid accessing dirty data in distributed platforms.The applications show that this system is characterized by high efficiency and easy implementation,thus achieving the design requirement.