摘要
针对数据库能力测评,提出了一种基于存储过程的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.
出处
《电子设计工程》
2017年第11期65-69,共5页
Electronic Design Engineering
基金
2014年西安邮电大学青年教师科研基金(ZL2014-41)
2016年西安电子科技大学教育教学改革研究项目(B1611)
关键词
存储过程
SQL
自动评判
黑盒测试
事务
store procedure
SQL
automated assessment
black box testing
transaction
