Logical errors in database SQL retrieval queries

SQL is often used to express questions imposed by users. It is well known that this process is not error-free in that it may result in syntactically or semantically incorrect SQL queries. This article is meant to probe deeper into SQL queries that are incorrect, due to delusion errors. A classification of natural language questions will be introduced. The purpose of this classification is two-fold. Firstly, it gives insight into possible errors and enables us to distinguish between types of errors. Secondly, it is a means of determining the influence of measures (for instance, SQL training) that can be taken to reduce the number of aforementioned errors. For discussion, several of these measures will be presented and related to the classification.Abbreviations RA Relational algebra - SQL structured query language     

线性规划模型的自动生成与求解

本文描述了《有色企业经济活动分析决策支持系统》模型库中线性规划模型的自动生成与求解系统的设计思想、方法及实现     

计算机网络安全体系的研究

首先,结合国内外同行的最新研究成果,我们将对网络系统中的不安全因素加以分析,并形式化地给出一个安全计算机网络系统的定义;然后将从理论上阐述一个基于OSI-RM体系的网络安全保护体系的模型,并讨论该安全保护体系在现有系统中的作用。     

预测控制算法的统一格式及其在电加热炉的应用

本文根据常用的两类预测控制算法推出一种新型预测控制算法。并将其应用于一双输入/双输出的力学持久机电加热炉的温度控制系统上,获得了满意的结果:控温精度为±1.5℃/300℃,且适用于非最小相位系统。     

基于混合遗传算法的树状注水管网拓扑优化

以投资最小为目标函数,以井间隶属关系的惟一性、连接注水井数量等限制为约束条件,建立了树状注水管网拓扑优化数学模型.根据模型特点,将优化问题分为分配层和几何层,分别采用遗传算法和非线性优化方法进行求解.并对遗传算法的操作过程进行了改进,调整了适应函数,采用随机多父辈适应函数值加权交叉和多种变异操作,结合了模拟退火算法,并给出了初温的确定方法,改进了选择复制操作,从而形成了混合遗传算法.该算法能够有效地提高收敛速度,避免早熟收敛.利用算例说明了该方法的有效性.     

强震区高拱坝抗震措施比较

在拱坝横缝中,设置跨横缝钢筋和阻尼器,可以在一定程度上控制高拱坝在强震作用下的横缝开度,增强拱坝整体性。以国内某高拱坝为例,基于在大型商业有限元分析软件ABAQUS平台上二次开发的拱坝有限元模型,结合已有的计算成果,系统比较了设置跨横缝钢筋和阻尼器的抗震效果,提出了两种措施组合的方案,可供工程应用参考。     

Manipulating Deformable Linear Objects: Fuzzy-Based Active Vibration Damping Skill

Human can handle a deformable object and damp its vibration with recognized skill. However, for an industrial robot, handling a deformable object with acute vibration is often a difficult task. This paper addresses the problem of active damping skill for handling deformable linear objects (DLOs) by using a strategy inspired from human manipulation skills. The strategy is illustrated by several rules, which are explained by a fuzzy and a P controller. A proportional-integral-derivative (PID) controller is also employed to explain the rules as a comparison. The interpretations from controllers are translated into high level commands in a robotic language V+. A standard industrial robot with a force/torque sensor mounted on the wrist was employed to demonstrate the skill. Experimental results showed the fuzzy based damping skill is quite effective and stable even without any previous acknowledge of the deformable linear objects.Category (5)     

Important features of Iris OSQL

OSQL is the object-oriented database language developed for the Iris object-oriented database management system at Hewlett-Packard Laboratories. Its three fundamental constructs are objects, types, and functions. This paper provides an overview of the underlying concepts and some important features of OSQL.     

Effect of partitioning on microstructure and properties of a medium carbon Ti Mo bearing high strength Q&P steel

In order to investigate the effect of partitioning procedures on microstructure and properties of a medium carbon Ti Mo bearing steel, the salt bath experiment, field emission SEM, TEM and tensile tests as well as wear tests were utilized to clarify the microstructural evolution and property changes treated by different partitioning parameters. The results show that the microstructures consist of tempered lath martensite, cementite and (Ti, Mo)C particles. With prolonging partitioning time or increasing partitioning temperature, the amount of laths martensite decreases and thicker martensite plates with blunt boundaries appear. In addition, with increasing partitioning temperature from 310℃ to 400℃, the tensile strength, hardness and low temperature toughness are simultaneously decreased, and the reduction reaches up to about 300MPa, 100HV and 20J, respectively. Finally, the wear performance of the samples partitioned below Ms is obviously better than that of samples partitioned above Ms. The morphology of worn surface of samples partitioned below Ms is characterized by plastic fatigue morphology, while the worn surfaces of samples partitioned above Ms are mainly dominated by grooves.