RFID标签封装设备数据库系统设计与实现
|
摘要
射频识别技术(RFID,Radio Frequency Identification)是20世纪90年代开始兴起的一种自动识别技术。与传统技术相比,RFID电子标签具有使用距离远、信息量大、可重复利用等优点,然而,RFID电子标签的成本是制约其广泛应用的一个瓶颈。
RFID标签封装设备由卷料、点胶、翻转贴装、热压和检测五个模块组成。在日常生产中,RFID标签封装设备具有大量的数据需要收集和存储,原有的文件系统数据管理方式导致数据管理不规范,既不利于相关信息的存储和查询,也给设备的安全生产带来了隐患。为解决以上问题,针对RFID标签封装设备的特点,论文设计并实现了RFID标签封装设备数据库系统。
论文首先介绍了RFID标签封装设备数据库系统研发的背景和意义,阐述了分布式数据库技术在国内外的发展概况,又具体介绍了分布式数据库系统的相关概念和设计方法。
其次针对设备的硬件布局和现有软件系统中存在的问题,分析了RFID标签封装设备数据库系统的功能需求,并根据对等处理系统设计了数据库系统的总体结构和网络架构。
然后依照分布式数据库设计方法DATAID-D方法,完成了分布式数据库的概念结构设计、全局逻辑结构设计,分布设计和局部逻辑结构设计,并利用SQL SERVER 2005实现了数据库。
最后,依据设备的功能需求,完成了基于数据库的应用程序设计,包括用户管理模块、日志模块等。
Radio Frequency Identification (RFID) is a kind of automatic identification technology which has begun to rise since 1990s. Compared with traditional technology, RFID tags have a lot of advantages such as longer accessing distance, larger data memory, reuse of tags. However, the price is a bottleneck of the wide application of RFID tags.
RFID tag package equipment includes five modules, such as web conveyance module, dispensing module, flip-chip bonding module, heat-press module and testing module. There is a great deal of information to be collected and saved for the equipment in daily production. Existing data management method based on file system is going against the data collection, bringing hidden trouble for safety production and making the data management nonstandard. In order to solve these problems, this thesis designs the database system of RFID tag package equipment according to the characteristics of the equipment.
Firstly, the background and significance of the database system of RFID tag package equipment are introduced. Then the distributed database technology and its development are expounded.
Secondly, based on the hardware layout of the equipment and the problems of the software system, the function requirement of the database system is analyzed. The general structure and network architecture are designed according to peer-to-peer system.
Subsequently the conceptual structure, the global logical structure, distributed design and the local logical structure of the distributed database are designed based on DATAID-D method. At last, the database is implemented with SQL SERVER 2005.
Finally, the application program is designed according to the function requirement, for example, user management module and log module.
RFID标签封装设备由卷料、点胶、翻转贴装、热压和检测五个模块组成。在日常生产中,RFID标签封装设备具有大量的数据需要收集和存储,原有的文件系统数据管理方式导致数据管理不规范,既不利于相关信息的存储和查询,也给设备的安全生产带来了隐患。为解决以上问题,针对RFID标签封装设备的特点,论文设计并实现了RFID标签封装设备数据库系统。
论文首先介绍了RFID标签封装设备数据库系统研发的背景和意义,阐述了分布式数据库技术在国内外的发展概况,又具体介绍了分布式数据库系统的相关概念和设计方法。
其次针对设备的硬件布局和现有软件系统中存在的问题,分析了RFID标签封装设备数据库系统的功能需求,并根据对等处理系统设计了数据库系统的总体结构和网络架构。
然后依照分布式数据库设计方法DATAID-D方法,完成了分布式数据库的概念结构设计、全局逻辑结构设计,分布设计和局部逻辑结构设计,并利用SQL SERVER 2005实现了数据库。
最后,依据设备的功能需求,完成了基于数据库的应用程序设计,包括用户管理模块、日志模块等。
Radio Frequency Identification (RFID) is a kind of automatic identification technology which has begun to rise since 1990s. Compared with traditional technology, RFID tags have a lot of advantages such as longer accessing distance, larger data memory, reuse of tags. However, the price is a bottleneck of the wide application of RFID tags.
RFID tag package equipment includes five modules, such as web conveyance module, dispensing module, flip-chip bonding module, heat-press module and testing module. There is a great deal of information to be collected and saved for the equipment in daily production. Existing data management method based on file system is going against the data collection, bringing hidden trouble for safety production and making the data management nonstandard. In order to solve these problems, this thesis designs the database system of RFID tag package equipment according to the characteristics of the equipment.
Firstly, the background and significance of the database system of RFID tag package equipment are introduced. Then the distributed database technology and its development are expounded.
Secondly, based on the hardware layout of the equipment and the problems of the software system, the function requirement of the database system is analyzed. The general structure and network architecture are designed according to peer-to-peer system.
Subsequently the conceptual structure, the global logical structure, distributed design and the local logical structure of the distributed database are designed based on DATAID-D method. At last, the database is implemented with SQL SERVER 2005.
Finally, the application program is designed according to the function requirement, for example, user management module and log module.
引文
[1] Xingxin(Grace) Gao, Zhe(Alex) Xiang et al. An Approach to Security and Privacy of RFID System for Supply Chain[J]. IBM China Research Lab,1998.
[2]闫娜.低功耗低成本无源射频识别标签芯片的研究与设计.复旦大学博士论文, 2007.
[3]游战清,李苏剑.无线射频识别技术(RFID)理论与应用[M].北京.电子工业出版社, 2002. 87-92
[4]赵跃新.基于RIFD技术的考勤管理系统设计与实现.南昌大学硕士论文, 2007.
[5]陈建魁.面向RFID封装的柔性基板输送装置的研究与实现.华中科技大学硕士学位论文, 2006.
[6]李良.机器视觉在RFID标签封装设备中的应用.华中科技大学硕士学位论文, 2008.
[7]薛东剑.卷烟辅助配方系统数据库设计.成都理工大学硕士论文, 2007.
[8]王珊,萨师煊.数据库系统概论(第四版).高等教育出版社, 2006.335-336
[9]刘义理.分布式数据库安全框架研究.同济大学博士学位论文, 2006.
[10]陈争航.分布式数据库系统的研究和应用.西南交通大学, 2002.
[11]邵佩英.分布式数据库系统及其应用(第一版).科学出版社, 2000. 3-7
[12] C. J. Date. Distributed Database: A Closer Look. In: C. J. Date and H. Darwen, eds. Relational Database: Writings 1989-1991. Reading, MA: Addison-Wesley, 1992. 485-516
[13]郝瑞.智能大厦的分布式数据库应用研究.武汉理工大学硕士学位论文, 2005.
[14] T.KITAGAMA. Model and Architecture of Distributed Database Sharing Systems Associated With Knowledge information Processing Systems, Distributed Data Sharing System. North Holland Publishing Company. 1982. 295-307
[15] M. Tamer Ozsu, Patrick Valduriez. Principles of Distributed Database Systems. University of Alberta-Edmonton, Canada. 1998
[16] Thuraisingham, Bhvanai. Security of Distributed Datebases. Information security Technical Report Volume: 6, Issue: 2, June 1, 2001. 95~100
[17]郑振楣.分布式数据库.北京:科学出版社, 1998.
[18] Ceri S. Distributed databases principles and systems.关春英等(译).北京:水利电力出版社, 1989.
[19]陈建荣,严隽永,叶天荣.分布式数据库设计导论.北京:清华大学出版社, 1992.
[20] S. M. Deen. Distributed Database-An Introduction Distributed Data Base. North-Holland Publishing Company, 1979.
[21]李昭原.数据库技术新进展.北京.清华大学出版社, 1997.
[22] Stefano, Cerietal. Distributed Database Design Methodologies. Proceedings of the IEEE, 1987, 75(5): 533-546
[23]周龙骧.分布式数据库系统实现技术.北京:中国地质大学出版社, 1993.
[24] Simon Wiseman. Database Security: Rtospective and Way Forward. DERA, 2001.
[25] Stefano Ceri. Optimal Design of Distributed Database. 1987.
[26] D. Serain. Client/server: Why? What? How? in: Proceedings of the IEE Colloquium on International Seminar on Client/Server Computing. La Hulpe, Belgium. 1995. 1~7
[27]朱力军. RFID电子标签封装设备软件系统的设计和实现.华中科技大学硕士学位论文, 2008.
[28]张海藩.软件工程.北京:人民邮电出版社, 2002. 25-26
[29] Yao S B et al. Principles of Database Design: Local Organization. Vol.1, Prentice-Hall, 1985.
[30]Michael J. Hernandez. Database design for mere mortals : a hands-on guide to relational database design.范明,邱保志,职为梅(译).北京:电子工业出版社, 2005
[31] Michael V. Mannino. Database design, application development, & administration database design, application development, & administration Chi.韩宏志译.北京:清华大学出版社, 2007.
[32] Normalized Data Base Structure: A Brief Tutorial. Proc. of ACM SIGFIDET Workshop on Data Description, Access and Control. November 1971.
[33] Fagin R. Multivalued Dependencies and a New Normal Form for Relational Database. ACM TOPS, 2: 3, September 1977.
[34]李安平.分布式数据库系统概论.北京:科学出版社, 1992.
[35]王以和,涂小平.分布式数据库系统.北京,电子工业出版社, 1988.
[36]杨成忠,郑怀远.分布式数据库.哈尔滨,黑龙江科学技术出版社, 1990.
[37]王道祥.基于分布式数据库的综合信息系统关键技术研究.国防科学技术大学硕士学位论文, 2006.
[38]杨湖,李凤雷,王斌. SQL Server 2005数据库系统开发案例精选(第一版).北京.人民邮电出版社, 2007.
[39]孙明丽,王斌,刘莹. SQL Server 2005数据库系统开发完全手册(第一版).北京.人民邮电出版社, 2007.
[40]周亦武.港口装卸设备运行参数在线采集与记录系统研究.大连海事大学硕士论文, 2007.
[41]袁永林,宁义,汪海波等. SQL Server 2005中文版数据库管理与开发从入门到精通.北京:清华大学出版社, 2007.
[42]王晖.精通Visual C++ 6.0(第一版).北京:电子工业出版社, 1999. 304-306
[43]王立颖.光测设备检测数据库系统的建立和开发.中国科学院长春光学精密机械与物理研究所硕士学位论文, 2006.
[44]郑阿奇,丁有和,郑进. Visual C++使用教程(第一版).北京:电子工业出版社, 2000.
[2]闫娜.低功耗低成本无源射频识别标签芯片的研究与设计.复旦大学博士论文, 2007.
[3]游战清,李苏剑.无线射频识别技术(RFID)理论与应用[M].北京.电子工业出版社, 2002. 87-92
[4]赵跃新.基于RIFD技术的考勤管理系统设计与实现.南昌大学硕士论文, 2007.
[5]陈建魁.面向RFID封装的柔性基板输送装置的研究与实现.华中科技大学硕士学位论文, 2006.
[6]李良.机器视觉在RFID标签封装设备中的应用.华中科技大学硕士学位论文, 2008.
[7]薛东剑.卷烟辅助配方系统数据库设计.成都理工大学硕士论文, 2007.
[8]王珊,萨师煊.数据库系统概论(第四版).高等教育出版社, 2006.335-336
[9]刘义理.分布式数据库安全框架研究.同济大学博士学位论文, 2006.
[10]陈争航.分布式数据库系统的研究和应用.西南交通大学, 2002.
[11]邵佩英.分布式数据库系统及其应用(第一版).科学出版社, 2000. 3-7
[12] C. J. Date. Distributed Database: A Closer Look. In: C. J. Date and H. Darwen, eds. Relational Database: Writings 1989-1991. Reading, MA: Addison-Wesley, 1992. 485-516
[13]郝瑞.智能大厦的分布式数据库应用研究.武汉理工大学硕士学位论文, 2005.
[14] T.KITAGAMA. Model and Architecture of Distributed Database Sharing Systems Associated With Knowledge information Processing Systems, Distributed Data Sharing System. North Holland Publishing Company. 1982. 295-307
[15] M. Tamer Ozsu, Patrick Valduriez. Principles of Distributed Database Systems. University of Alberta-Edmonton, Canada. 1998
[16] Thuraisingham, Bhvanai. Security of Distributed Datebases. Information security Technical Report Volume: 6, Issue: 2, June 1, 2001. 95~100
[17]郑振楣.分布式数据库.北京:科学出版社, 1998.
[18] Ceri S. Distributed databases principles and systems.关春英等(译).北京:水利电力出版社, 1989.
[19]陈建荣,严隽永,叶天荣.分布式数据库设计导论.北京:清华大学出版社, 1992.
[20] S. M. Deen. Distributed Database-An Introduction Distributed Data Base. North-Holland Publishing Company, 1979.
[21]李昭原.数据库技术新进展.北京.清华大学出版社, 1997.
[22] Stefano, Cerietal. Distributed Database Design Methodologies. Proceedings of the IEEE, 1987, 75(5): 533-546
[23]周龙骧.分布式数据库系统实现技术.北京:中国地质大学出版社, 1993.
[24] Simon Wiseman. Database Security: Rtospective and Way Forward. DERA, 2001.
[25] Stefano Ceri. Optimal Design of Distributed Database. 1987.
[26] D. Serain. Client/server: Why? What? How? in: Proceedings of the IEE Colloquium on International Seminar on Client/Server Computing. La Hulpe, Belgium. 1995. 1~7
[27]朱力军. RFID电子标签封装设备软件系统的设计和实现.华中科技大学硕士学位论文, 2008.
[28]张海藩.软件工程.北京:人民邮电出版社, 2002. 25-26
[29] Yao S B et al. Principles of Database Design: Local Organization. Vol.1, Prentice-Hall, 1985.
[30]Michael J. Hernandez. Database design for mere mortals : a hands-on guide to relational database design.范明,邱保志,职为梅(译).北京:电子工业出版社, 2005
[31] Michael V. Mannino. Database design, application development, & administration database design, application development, & administration Chi.韩宏志译.北京:清华大学出版社, 2007.
[32] Normalized Data Base Structure: A Brief Tutorial. Proc. of ACM SIGFIDET Workshop on Data Description, Access and Control. November 1971.
[33] Fagin R. Multivalued Dependencies and a New Normal Form for Relational Database. ACM TOPS, 2: 3, September 1977.
[34]李安平.分布式数据库系统概论.北京:科学出版社, 1992.
[35]王以和,涂小平.分布式数据库系统.北京,电子工业出版社, 1988.
[36]杨成忠,郑怀远.分布式数据库.哈尔滨,黑龙江科学技术出版社, 1990.
[37]王道祥.基于分布式数据库的综合信息系统关键技术研究.国防科学技术大学硕士学位论文, 2006.
[38]杨湖,李凤雷,王斌. SQL Server 2005数据库系统开发案例精选(第一版).北京.人民邮电出版社, 2007.
[39]孙明丽,王斌,刘莹. SQL Server 2005数据库系统开发完全手册(第一版).北京.人民邮电出版社, 2007.
[40]周亦武.港口装卸设备运行参数在线采集与记录系统研究.大连海事大学硕士论文, 2007.
[41]袁永林,宁义,汪海波等. SQL Server 2005中文版数据库管理与开发从入门到精通.北京:清华大学出版社, 2007.
[42]王晖.精通Visual C++ 6.0(第一版).北京:电子工业出版社, 1999. 304-306
[43]王立颖.光测设备检测数据库系统的建立和开发.中国科学院长春光学精密机械与物理研究所硕士学位论文, 2006.
[44]郑阿奇,丁有和,郑进. Visual C++使用教程(第一版).北京:电子工业出版社, 2000.