Automatic Marking of SQL Server Based on SQL-DMO

2013 ◽  
Vol 303-306 ◽  
pp. 2369-2372
Author(s):  
Yao Fei Chen ◽  
Wei Zheng ◽  
Huan Tong Chen

SQL Server skill assessment is deficient. This article describes the SQL Server object model SQL-DMO. Propose the process of SQL Server skill assessment: test paper generation, Skill assessment and Automatic marking. Analysis two key techniques of skill assessment based on SQL-DMO. One is getting operating information based on SQL-DMO. The other is automatic marking for Skill and Operation. Besides, automatic marking rules for database object creating, modifying and deleting are focused on. The author uses SQL-DMO method to realize database object information acquisition, and implement automatic marking for SQL Server database skill assessment.

2014 ◽  
Vol 538 ◽  
pp. 520-523
Author(s):  
Feng Liu ◽  
Xing Wu ◽  
Nan Pan ◽  
Jun Zhou ◽  
Yi Liu

Based on the LabVIEW platform and SQL server database, the intelligent management system of physical evidence is developed, which implements the intellectualization and networking and makes the staff in the public security organization manage the evidence more conveniently, safely and efficiently. The key techniques including the design of evidence room, the hardware design and form controls of browsing information were introduced in detail. Finally, reliability, availability and stability of the system were proved through testing by the public security department for a period of time.


2012 ◽  
Vol 468-471 ◽  
pp. 2878-2881
Author(s):  
Wei Zheng ◽  
Ya Ping Wu ◽  
Yao Fei Chen

This article describes the SQL Server object model SQL-DMO. Through the object model all information of SQL Server's internal objects can be obtained, including databases, data tables, stored procedures and triggers and so on. Analysis the method of the object’s information extraction. Get the child object by analyzing the parent object’s collection property and get internal information by analyzing the object’s properties. A visual basic procedure is designed to achieve the table’s structure information for all user tables in specified SQL Server database. This method is more complete and simple than the method based on system table.


Games ◽  
2021 ◽  
Vol 12 (3) ◽  
pp. 53
Author(s):  
Roberto Rozzi

We consider an evolutionary model of social coordination in a 2 × 2 game where two groups of players prefer to coordinate on different actions. Players can pay a cost to learn their opponent’s group: if they pay it, they can condition their actions concerning the groups. We assess the stability of outcomes in the long run using stochastic stability analysis. We find that three elements matter for the equilibrium selection: the group size, the strength of preferences, and the information’s cost. If the cost is too high, players never learn the group of their opponents in the long run. If one group is stronger in preferences for its favorite action than the other, or its size is sufficiently large compared to the other group, every player plays that group’s favorite action. If both groups are strong enough in preferences, or if none of the groups’ sizes is large enough, players play their favorite actions and miscoordinate in inter-group interactions. Lower levels of the cost favor coordination. Indeed, when the cost is low, in inside-group interactions, players always coordinate on their favorite action, while in inter-group interactions, they coordinate on the favorite action of the group that is stronger in preferences or large enough.


2020 ◽  
Author(s):  
Andrew P. Tarko ◽  
Jose Thomaz ◽  
Mario Romero

A systemic approach to identifying road locations that exhibit safety problems was provided by the Safety Needs Identification Program (SNIP and SNIP2) developed by the Purdue University Center for Road Safety (CRS). The new version SNIP Light has been developed to provide other uses with planning level traffic safety analysis capability for a wider range of uses including Metropolitan Planning Agencies (MPOs) who want the tool for planning cost-effective safety programs in their metropolitan areas. The SNIP Light reduces the demand of computing and data storage resources and replaces the SQL server database system an integrated module coded in-house which is considerably faster than the original component. Furthermore, certain proficiency required to install and use the old version is no longer needed thanks to the intuitive single-window interface and executing file operations in the background without the user’s involvement. Some operations, such as optimizing funding of safety projects, are removed to simplify the tool.


2014 ◽  
Vol 1039 ◽  
pp. 197-202
Author(s):  
Chuan Hong Zhou ◽  
Jin Jie Xiao ◽  
Wei Ren

Currently,some problems exist in the process of using standby generators, such as low efficiency,high cost and late service of artificial overhaul and maintenance.In order to overcome these problems, PC remote monitoring system is designed.This paper mainly introduces the structure composition,function,interface design and SQL Server database design of the system.In addition, the function of communication between the PC remote server and signal monitoring device was tested and the effect was desired


The author, having observed that in some states of disease there occurs in the urine a great excess of the earthy phosphates, was in­ duced to investigate the subject; and as a preliminary inquiry, to ascertain the variations in the amount of these phosphates at differ­ent times in the same person in a state of health, and to trace the causes which determine an excess or a deficiency of these salts in the urine; noting, at the same time, the variations in the quantity of the alkaline phosphates contained in it, with a view of discovering whether these variations are influenced by the same, or by different causes. The principal results to which his experiments have con­ducted him are the following. The quantity of the earthy phos­phates in the urine voided soon after taking food is considerably greater than in that voided at other times ; and this happens whether the meal consists of animal food or of bread only. After long fast­ing, the proportion of earthy phosphates is considerably diminished. On the other hand, the alkaline phosphates are present in greatest quantity when the food consists of bread alone : when meat alone is taken, the deficiency in those salts is still more marked than the excess in the former case. Exercise occasions no change in the quantity of the earthy phosphates, but causes an increase of nearly one-third in the amount of alkaline phosphates ; but its influence is, on the whole, less than that of diet. The earthy phosphates are in­ creased in quantity by chloride of calcium, sulphate of magnesia, and calcined magnesia taken into the stomach. The author next examines the conditions in which the urine is alkalescent, and which he considers to be of two kinds ; the one, long known as ammoniacal , and arising from the presence of carbonate of ammonia; and the other, which has not hitherto been distinctly re­cognised, arising from fixed alkali, and appearing most frequently in urine secreted during a period of from two to four hours after breakfast, in persons suffering only from defective digestion. Under these circumstances, it may be, when voided, either turbid from amorphous sediment, or clear and alkaline when tested, or free from deposit and slightly acid. If in either of these last cases it be heated, an amorphous precipitate falls down, which is soluble in dilute hy­drochloric acid, or in a solution of biphosphate of soda. Healthy urine may at any time be made to yield a precipitate of earthy phos­phates by heat, even though it be acid, by having a portion of this acid neutralised by any alkali, or by phosphate of soda, the fluid becoming more acid when boiled. A solution of earthy phosphates in biphosphate of soda also gives a precipitate on boiling, if some of its acid reaction is removed by any alkali. The fluid when boiled becomes more acid to test-paper, indicating the formation of a more basic earthy phosphate. A result precisely similar is obtained when common phosphate of soda, phosphate of lime, and a little biphos­phate of soda exist together in solution ; and by varying the quan­tities of each of these substances, the various phenomena which the urine occasionally presents may be imitated. The time at which the alkalescence of the urine from fixed alkali generally occurs, indi­cates the existence of some alkaline phosphate, or of some carbonated alkali in the food.


2011 ◽  
Vol 403-408 ◽  
pp. 1692-1695
Author(s):  
Zhi Qiu ◽  
Shou Miao Yu ◽  
Zheng Wang

An direction expert system for aircraft maintain with expert knowledge graphical building, three layers distributed web service, distance fault diagnosis and gather experience ability is introduced here. It is developed based on Delphi 6.0 utilizing multilayer web service, CLIPS expert system and SQL SERVER database technology.


Author(s):  
Qiang Zhang ◽  
Peng Wang ◽  
Shanshan Li ◽  
Yonghao Jing

Since electroencephalogram (EEG) signals contain a variety of physiological and pathological information, they are widely used in medical diagnosis, brain machine interface and other fields. The existing EEG apparatus are not perfect due to big size, high power consumption and using cables to transmit data. In this paper, a portable real-time EEG signal acquisition and tele-medicine system is developed in order to improve performance of EEG apparatus. The weak EEG signals are induced to the pre-processing circuits via a noninvasive method with bipolar leads. After multi-level amplifying and filtering, these signals are transmitted to DSP (TMS320C5509) to conduct digital filtering. Then, the EEG signals are displayed on the LCD screen and stored in the SD card so that they can be uploaded to the server through the internet. The server employs SQL Server database to manage patients’ information and to store data in disk. Doctors can download, look up and analyze patients’ EEG data using the doctor client. Experimental results demonstrate that the system can acquire weak EEG signals in real time, display the processed results, save data and carry out tele-medicine. The system can meet the requirement of the EEG signals’ quality, and are easy to use and carry.


2014 ◽  
Vol 535 ◽  
pp. 26-31
Author(s):  
Zhi Zhong Li ◽  
Shi Chun Yang ◽  
Zi Tao Liu

This paper analyzed the practical needs of remote monitoring of electric vehicle and illustrates the overall architecture of a remote monitoring system, and further developed a remote monitoring system of the Server and client application with the ASP.NET and Microsoft SQL Server database language, basically can meet the electric cars remote monitoring of the Server and client needs.


Sign in / Sign up

Export Citation Format

Share Document