Key Technology Research In SQL Server Application Skills Assessment Based On XML

Skills operating assessment is a key research direction in the field of CAA. Present study is relatively weak, especially lack of general theories and methods. SQL Server Database is widely used in education, examination and engineering application. Therefore the study of SQL Server database skills assessment is great significance.The technology of databases skills is complex and low efficiency. Research of xml formal expression is based on CAA theory. realized database skills assessment automatic marking based on xml. The method can effectively overcome the defects of existing method. The main work and the results are as follows:1. Aim at the defects of traditional skills operating method in database,Propose formal expression method based on xml. Focus on the principles of xml Formal and key technologies, the XML description of operation, validation of test and Item conversion. XML Formal expression have advantages of Level clarity, semantic clear, markers convenient etc..2. According to the SQL Server database features, analysis three extraction methods of operational information: system table, ADOX and SQL-DMO. SQL-DMO method is used with achieve simple and without conversion.3. Aim at the defects of automatica marking villi Access database and VFP database. Propose the programme of automatica marking with SQL Server based on xml. Reference SQL-DMO object model designed SQL Server database objects formal expression of XML structure. Analysis the XML Formal markers principle and method. Using XML DOM technology realized automatica marking by the formal operation of database objects.4. Considering the traditional method of subject question marking is only judged on results. According to the SQL query syntax rules, design SQL query object XML structure. Unity the method of SQL query and database objects in the formal expression. Similarity compare is used in subject question automatic marking.The method of SQL Server technology skills assessment based on xml is practical and simple. The technology can be applied to other similar operational skills assessment.