针对肌肉功能障碍患者的数据库研究与开发

建立标准数据库是临床研究病情变化的重要手段,建立适用于肌肉功能障碍患者的标准数据库模板更具有重要临床意义。本研究针对临床上所采集的具有肌肉功能障碍患者的肌力、肌电数据,通过ODBC连接方式,引入了统一建模语言(UML),使用VC++开发工具,设计和完成了Access数据库,以对获取到的大量的肌力、肌电数据进行管理和使用。数据库有效存储并管理肌力、肌电数据,同时能减少数据占有空间和数据冗余,它更好地满足了医院康复科的需求。     

SQL Server数据库在实际运用中的技巧探究

任何人在使用SQL Server数据库系统的时候,都希望自己能让SQL数据库发挥出他最佳的性能,但提供它性能的方法就是对其系统进行优化。本文主要通过笔者在日常工作生活中的经历和经验来简单讲述下SQL Server数据库在运用中的一些技巧。     

《数据库原理及应用——SQL SVRVER 2000》课程的实践探索

高职高专院校的课程(特别是计算机软件类的课程)教学中,常见问题及处理对策。以及开展的教学活动,主要采用项目驱动教学方法,通过具体的项目开发,培养学生综合实践能力。     

LabVIEW 7 Express平台上的液压测试系统

为了满足工程实践对先进液压测试技术的需要，研究了基于美国NI公司最新推出的LabVIEW 7 Express虚拟仪器开发平台的液压测试系统的软硬件结构，介绍了测试系统实现网络通讯、数据库链接和多种编程语言联合作业的方法，提出了现代液压测试系统的技术方案。     

水厂生产运行管理决策支持系统的开发

介绍了水厂生产管理决策支持系统的设计原理和方法，其中主要讲述了数据库和知识库的建立，并阐述了该系统的运行功能、管理和维护方法。     

Development of a Composite Knowledge Manipulation Tool: K-Expert

A goal of this study is to develop a Composite Knowledge Manipulation Tool (CKMT). Some of traditional medical activities are rely heavily on the oral transfer of knowledge, with the risk of losing important knowledge. Moreover, the activities differ according to the regions, traditions, experts’ experiences, etc. Therefore, it is necessary to develop an integrated and consistent knowledge manipulation tool. By using the tool, it will be possible to extract the tacit knowledge consistently, transform different types of knowledge into a composite knowledge base (KB), integrate disseminated and complex knowledge, and complement the lack of knowledge. For the reason above, I have developed the CKMT called as K-Expert and it has four advanced functionalities as follows. Firstly, it can extract/import logical rules from data mining (DM) with the minimum of effort. I expect that the function can complement the oral transfer of traditional knowledge. Secondly, it transforms the various types of logical rules into database (DB) tables after the syntax checking and/or transformation. In this situation, knowledge managers can refine, evaluate, and manage the huge-sized composite KB consistently with the support of the DB management systems (DBMS). Thirdly, it visualizes the transformed knowledge in the shape of decision tree (DT). With the function, the knowledge workers can evaluate the completeness of the KB and complement the lack of knowledge. Finally, it gives SQL-based backward chaining function to the knowledge users. It could reduce the inference time effectively since it is based on SQL query and searching not the sentence-by-sentence translation used in the traditional inference systems. The function will give the young researchers and their fellows in the field of knowledge management (KM) and expert systems (ES) more opportunities to follow up and validate their knowledge. Finally, I expect that the approach can present the advantages of mitigating knowledge loss and the burdens of knowledge transformation and complementation.     

Data-mining based SQL injection attack detection using internal query trees

Detecting SQL injection attacks (SQLIAs) is becoming increasingly important in database-driven web sites. Until now, most of the studies on SQLIA detection have focused on the structured query language (SQL) structure at the application level. Unfortunately, this approach inevitably fails to detect those attacks that use already stored procedure and data within the database system. In this paper, we propose a framework to detect SQLIAs at database level by using SVM classification and various kernel functions. The key issue of SQLIA detection framework is how to represent the internal query tree collected from database log suitable for SVM classification algorithm in order to acquire good performance in detecting SQLIAs. To solve the issue, we first propose a novel method to convert the query tree into an n-dimensional feature vector by using a multi-dimensional sequence as an intermediate representation. The reason that it is difficult to directly convert the query tree into an n-dimensional feature vector is the complexity and variability of the query tree structure. Second, we propose a method to extract the syntactic features, as well as the semantic features when generating feature vector. Third, we propose a method to transform string feature values into numeric feature values, combining multiple statistical models. The combined model maps one string value to one numeric value by containing the multiple characteristic of each string value. In order to demonstrate the feasibility of our proposals in practical environments, we implement the SQLIA detection system based on PostgreSQL, a popular open source database system, and we perform experiments. The experimental results using the internal query trees of PostgreSQL validate that our proposal is effective in detecting SQLIAs, with at least 99.6% of the probability that the probability for malicious queries to be correctly predicted as SQLIA is greater than the probability for normal queries to be incorrectly predicted as SQLIA. Finally, we perform additional experiments to compare our proposal with syntax-focused feature extraction and single statistical model based on feature transformation. The experimental results show that our proposal significantly increases the probability of correctly detecting SQLIAs for various SQL statements, when compared to the previous methods.     

塑料模具材料数据库系统的开发与应用

采用结构化程序和规范化数据库技术开发了塑料模具材料数据库系统，介绍了数据库系统的总体结构、主要模块功能及选材方法。该系统对材料数据信息进行了科学的分类管理，提供了高效的查询方法，实现了对塑料模具材料数据库系统的有效维护。     

异构数据库数据迁移的研究与实现

数据是业务运转的基础．是企业的宝贵资产。企业在系统升级过程中往往会遇到数据迁移问题,由于新系统与旧系统经常存在数据结构异构的情况．使数据迁移工作难以实现。开发一款异构数据库数据迁移工具,该工具通过框架程序在ODBC（Open Database Connectivity）开发平台以及XML技术的支持下实现数据结构异构的数据库数据迁移。