基于SQL Server的硬件控制系统设计与实现  

Design and Implementation of Hardware Control System Based on SQL Server

作　　者：刘凌宇[1] 李晓风[1] 谭海波[1] 许金林[1] 

机构地区：[1]中国科学院合肥物质科学研究院信息中心,安徽合肥230031

出　　处：《计算机技术与发展》2011年第10期47-50,共4页Computer Technology and Development

基　　金：中科院合肥物质科学研究院院地合作项目(1183010571F1)

摘　　要：针对目前主流商业数据库引擎并不具有工业总线通讯和硬件控制的功能,由此造成了工业现场部署的困难和复杂度问题,文中提出一种基于SQL Server进行硬件控制的方法。本方法利用SQL Server扩展存储过程的特性,通过在存储过程中封装对CAN总线系统中驱动程序接口的调用,来实现SQL Server对硬件系统的访问控制,把SQL Server从传统的关系数据库应用领域拓展到了数据库管理和硬件控制应用相结合的场合。工程实践表明,本方法为使用单位节约了大量硬件开销,减少了控制总线的设计和部署的困难。Focuses on the leading commercial database engines lack the abilities of hardware control and industrial bus communication, resulting in difficulties and complexity of database deployment in the industrial fields. Proposed a new method to handle hardware control based on SQL Server. By using the feature of extended-stored-procedure of SQL Server and encapsulation of calling driver interface of CAN-bus system, an example of implementing the CAN-bus communication between the database engine and hardware control units has been given, and the SQL Server has been extended from the traditional relational database applications to the combination of database management and hardware control areas. The project shows that this method saves a lot of hardware costs, reducing system complexity and difficulties of deployment.

关 键 词：CAN总线 SQL SERVER 扩展存储过程 硬件控制 

分 类 号：TP39[自动化与计算机技术—计算机应用技术]