摘要
在信息家电远程监控系统中,需对大量的实时数据进行采集和处理。家庭网关数据库是信息家电系统的核心,承担了定义数据,与外部设备进行实时数据交换等主要功能。本论文在综合分析当前嵌入式数据库系统的主要功能和发展现状的基础上,针对嵌入式设备的具体特点,结合在家庭网关中的实际应用需求,提出了基于ARM-Linux平台的嵌入式数据库系统的开发与设计方法。
本文重点研究嵌入式数据库系统的开发原则、设计过程与体系结构,为构建具有实时性能的嵌入式数据库的设计提供理论依据。并构造了一个S3C44B0X+uCLmux+SQLite+Boa的嵌入式实时家庭网关:以嵌入式微处理器S3C44B0X为中心设计硬件平台,对uCLinux进行实时性改造,并移植uCLinux作为嵌入式实时操作系统,以公共网关接口(CGI)原理为基础,以SQLite为数据存储及管理后台,用软件编程的方法实现实时数据的采集,处理与存储。
本文着重针对家庭网关的具体应用,对嵌入式实时数据库系统进行了设计。根据信息家电接口语言在SQLite中生成了家电信息表和实时状态表,并构造了一个HASH函数优化了实时数据库的索引机制。介绍了如何实现实时数据到历史数据的存储,以及设计主动规则库来提高系统的实时性能,从而满足嵌入式家庭网关对数据的实时管理要求。
In the remote monitoring and supervision system of information appliances, it needs to collect and handle plenty of real-time data. The Database in the Home Gateway is the core of the smart home system, It' s responsible for define variables to receive data from external device. By basically analyzing the main function and the actual developing state of current embedded Real-time Database system, this paper is aiming at combine the features of embedded devices and the actual requirements in home appliance gateway , designed an Embedded Real-time Database based on the ARM-Linux system.
Firstly this paper discusses the related technology and theory on the embedded real-time database(ERTDB). The emphases is to provide the base theory for the design of the real-time embedded database. Then we designed a embedded real-time databse in home gateway based on S3C44B0X+uCLinux+SQLite+Boa: It take the embedded micro-processor S3C44B0X as the hardware platform, the redesigned uCLinux as the real-time OS , the SQLite as the database, we also take use of the CGI programming to collect ,handle and store the data.
This paper is focus on the application of the Home Gateway , designed the embedded real-time database ,together with the home appliance information table and real-time status table based on the appliance interface language . Designed a HASH function to optimize the search engine . introduced the transition from real-time data to history data ,We also designed a initiative rule library enhencing the performance to meet the need of real-time data management for the embedded home appliance gateway.
引文
[1]李善平.Linux与嵌入式系统.北京:清华大学出版社,2003.32-62。
[2]符意德.嵌入式系统设计原理及应用.北京:清华大学出版社,2004.65-68。
[3]赵光煌,赵平.实时数据库的现状及发展趋势.天津农学院学报,2002,9(3):50-52
[4]L.Cingiser,DiPippo,V.Fay Wolf.Database Systems Handbook.us.McGraw Hill Publishers,1997.329-380
[5]V.F.Wolf,L.C.Dipippo,J.P JJ etal.The design of real-time extensions to the openobject-oriented database system.Object-Oriented Real-Time Dependable Systems,1994,1(10):86-93
[6]J.Prichard,L.C.Dipippo,J.Peckham etal.Rtsorac.A real-time Object-Oriented database model.Proceeding of the International Conference On Database and Expert Systems Applications.5th International Conference,DEXA'94,Athens,Greece.Sept 1994.601-610
[7]Shih.S,Young-Kuk Kim,Son.S.H.Performance evaluation of a firm real-time database system.Real-time Computing Systems and Applications,1995,Proceedings,Second International Workshop on.Tokyo Japan.Oct,1995:116-124
[8]Tokuda H,T.Nakajima,P.Rao.Real Time Mach:Towards a predictable Real-TimeSystem.Proceedings of the First USENIX Mach Workshop.Burlington,Vermont,USA.Oct 1990:73-82
[9]刘云生,李国徽.主动实时数据库事务的优先级分派.计算机学报,1998,21(5):470-475
[10]张孝.嵌入式移动数据库的现状及发展http://www.kingbase.eom.en/youqin/newol.htm
[11]移动计算和移动数据库在我国的应用前景http://www.swm.eom.en/rj/2001-4/10.htm
[12]张新国,刘映杰,马义德.嵌入式系统的现状及发展前景.信息技术,2001,12(1):34-37
[13]田泽.嵌入式系统开发与应用.北京:北京航空航天大学出版社,2005.120-123
[14]CPU-S3C44BOX-revl.pdf.Samsung Electronics.2002:2-3
[15]刘峥嵘,张智超,许振山.嵌入式Linux应用开发详解.北京:机械工业出版社,2004.56-58
[16]Mario J.Silva,Paula Afonso.Designing Information Appliances using a Resource Replication Model.http://xldb.fc.ul.pt/referencias/huc99.pdf
[17]Compact HTML for Small Information Appliances W3C NOTE.http://www.w3.org/TR/1998/'NOTE-compact
[18]徐晓磊,董兆华,吴建峰.Linux可抢占内核的分析.计算机工程,2003,9(1):115-117
[19]Jian Yang,Yu Chen.A Linux Kernel with Fixed Interrupt Latency for Embedded Real-Time System.Proceedings of the Second International Conference on Embedded Software and Systems,New York,2005.6.New York,2005.8:65-69
[20]韦益德.嵌入式Linux内核分析及其在多媒体机项盒中的应用研究:[湖南大学硕士学位论文].长沙.湖南大学.2004
[21]刘森,蔡春棣,沈卓立.嵌入式系统开发平台的构建与实现。电子产品世界,2002.(11):63-64
[22]秦艳凯.基于Linux嵌入式实时数据库系统的研究与设计:[华北电力大学硕士学位论文].河北:华北电力大学,2006
[23]杨进才,刘云生.嵌入式实时数据库系统的存储管理.小型微型计算机系统,2002,24(1):42-45
[24]王彤,王良.嵌入式移动数据库的综述及评价.计算机工程,2001,27(12):46-48
[25]Michael A Olson.Selecting and implementing an embedded database system.Computer,2000,33(9):56-57
[26]Sqlite使用说明书.http://www.sqlite.org
[27]Michael Owens.The Definitive Guide to SQLite.U.S...Apress,2006.79-80
[28]Chris Newman.SQLite.U.S.:SamsPublishing,2004.23-27.
[29]Mysql说明书.http://www.mysql.com
[30]Vikram Vaswani著,徐小青等译.MySQL完全手册.北京:电子工业出版社,2004.74-75.
[31]George Reese等著,林琪等译.MySQL权威指南.北京:中国电力出版社,2003.67-69.
[32]David McCullough,D.Jeff Dionne.Adding-User-Apps-HOWTO.http://www.uclinux.org
[33]雷小俊.基于嵌入式技术的家庭网关的研究与实现:[硕士学位论文].山东:大连理工大学,2005
[34]曹伟.基于ARM芯片的嵌入式家庭网关的设计:[硕士学位论文].中国优秀博硕士学位论文全文数据库:中国海洋大学,2004
[35]班建民,陆卫忠.嵌入式数据库在监控系统中的应用与实现.计算机工程与应用,2005,5(31):219-222
[36]黄慧华.基于信息家电设备定义语言的远程监控系统的设计与实现:[硕士学位论文].中国优秀博硕士学位论文全文数据库.湖南师范大学,2005.
[37]张佳.基于嵌入式技术与LVCL的信息家电万能遥控器的研究与实现:[硕士学位论文].湖南:湖南师范大学,2006.
[38]Object Management Group,Inc.OMG IDL Syntax and Semantics.http://www.omg.org/docs/formal/02-06-39.pdf
[39]Object Management Group,Inc.OMG IDL Tags.http://www.omg.org/docs/formal/02-06-61.pdf
[40]Takeshi Saito,Ichiro Tomoda,Yoshiaki Takabatake et al.Home Gateway Architecture and Its Implementation.Consumer Electronics IEEE Transactions.2000,46(4):1161-1166
[41]陈嘉.嵌入式主存数据库索引机制的研究与改进:[硕士学位论文].湖南:湖南师范大学,2006
[42]夏家莉.嵌入式实时数据库系统的事务模型及其处理技术.北京:经济管理出版社,2004。56-59.
[43]夏家莉.一种适用于嵌入式数据库系统的存取机制.计算机应用与软件,2003,5(6):61-63.
[44]Hongjun Lu,Yuet Yeung Ng etc.T-Tree or B-Tree:Main Memory Database Index Structure Revisited.Australasian Database Conference,2000:65-73.
[45]Chanho Ryu,Eunmi Song etc.Hybrid-TH:a Hybrid Access Mechani-sm for Real-Time Memory-Resident Database Systems.Real-Time Computing System and Applications,Proceeding of the Fifth Inter-national Conference,1998:303-310.
