一种适用于多学科电子题库的数据库设计方案

A design of database for multi-disciplinary examination databases

针对单一数据库设计多学科电子题库管理系统时数据库太大的问题,论述了运用多个SQL Server数据库构建题库管理系统的设计方法,分析了题库数据库的结构与关系,阐述了利用SQL语句动态增加数据库的技巧.实际运行表明,此设计能大大改观多学科题库试题量巨大时单个数据库的大小,并且提高了系统的运行效率.

This paper discusses a design which uses many SQL Server databases to build test-paper database management system because of the problem that the database is too large to design multi-disciplinary test-paper database management system using only one database. The relationship and the structure of the databases are analysed. The skills of using SQL script to dynamically add databases are demonstrated. Actual operation indicates that the design is able to greatly change single database size when multi-disciplinary test-paper databases are huge, and improve systematic operation more effectively.