嵌入式媒体库的设计与实现
|
摘要
随着计算机网络技术、存储技术、嵌入式技术的不断发展,用户保存的媒体文件不断增多,如何有效地管理多媒体资源就成为一个亟待解决的问题。因此,作者设计了这个基于嵌入式系统的媒体库管理系统。
本系统主要包括四大模块:用户界面模块、数据库管理模块、文件管理模块、查询监视模块。用户界面模块采用SDI框架和CSplitterWnd类进行动态撤分窗口,用模型-视图-控制器(MVC)模式清晰地向用户展示各种多媒体资源信息。数据库管理模块结合嵌入式应用程序的特点,在时间和空间上折中后选用CEDB进行多媒体属性数据库的设计;并用CCeDBOpt类对数据库的操作进行封装,以方便呈现给上层模块使用。文件管理模块运用Factory Method模式对各种媒体文件属性类进行创建和抽象设计,以便于很好的继承和派生各种媒体资源属性类,从而达到可扩展和松耦合。文件管理模块设计了CCeFileOpt类对各种媒体资源信息进行操作和访问,而多媒体文件的存储与访问却交由Windows CE文件系统进行处理,因此相对扩展了存储容量和提高了访问效率。查询监视模块运用排序和属性信息表查找算法对数据库字段值进行查找,用文件系统变更消息对某些媒体文件夹进行监视,以达到同步文件系统和自动更新媒体库。
本文先对多媒体资源的属性进行详细的分类和描述,在此基础上,完成多媒体属性数据库的设计。多媒体资源的查询和管理是本系统要实现的重要功能。作者分别在数据库模块和查询监视模块中进行详细阐述。最后对开发工作进行总结,并对后续工作做了展望。
With the development of computer network、storage and embedded technology, the amount of user’s multimedia files grows quickly, how to manage the multimedia resources effectively becomes a problem that would be solved urgently. Therefore author has designed this media base management system which is based on embedded system.
The system includes four main modules: user interface、database management、file management and inquiry&monitor. User interface uses SDI frame and CSplitterWnd to divide window dynamically, uses model-view-controler(MVC) pattern to demonstrate various multimedia resources’informations distinctly for users. Database management uses the characteristics of embedded application program to design the media property database after the compromise of time and space; and uses CCeDBOpt to encapsule the operations for database in order to present conveniently to the upper level module for using. File management uses the pattern of Factory Method for creation and abstract design of various media files so that various media resources are well inherited and derived, accomplishing expansibility and loosen coupling. This module has designed CCeFileOpt for operating and visiting various media resource informations, and multimedia file's storage and visiting will be handled by the file system of Windows CE. Therefore it expands storage capacity and raises the visit efficience. Inquiry&monitor module uses rank and property information table to search values of database’s fields, uses the changing news of file system to monitor some media directories so that synchronization of file system and automatic updating media base is accomplished.
First, this paper classifies and describes the multimedia resoure's property fully, then finishes the design of the database of multimedia resource. The inquiry and management of multimedia resource are the important functions of the system. The author explains the inquiry&monitor module and management of the media resources fully and respectively. Finally, summarizes the work and makes expectation for the succeeding work.
本系统主要包括四大模块:用户界面模块、数据库管理模块、文件管理模块、查询监视模块。用户界面模块采用SDI框架和CSplitterWnd类进行动态撤分窗口,用模型-视图-控制器(MVC)模式清晰地向用户展示各种多媒体资源信息。数据库管理模块结合嵌入式应用程序的特点,在时间和空间上折中后选用CEDB进行多媒体属性数据库的设计;并用CCeDBOpt类对数据库的操作进行封装,以方便呈现给上层模块使用。文件管理模块运用Factory Method模式对各种媒体文件属性类进行创建和抽象设计,以便于很好的继承和派生各种媒体资源属性类,从而达到可扩展和松耦合。文件管理模块设计了CCeFileOpt类对各种媒体资源信息进行操作和访问,而多媒体文件的存储与访问却交由Windows CE文件系统进行处理,因此相对扩展了存储容量和提高了访问效率。查询监视模块运用排序和属性信息表查找算法对数据库字段值进行查找,用文件系统变更消息对某些媒体文件夹进行监视,以达到同步文件系统和自动更新媒体库。
本文先对多媒体资源的属性进行详细的分类和描述,在此基础上,完成多媒体属性数据库的设计。多媒体资源的查询和管理是本系统要实现的重要功能。作者分别在数据库模块和查询监视模块中进行详细阐述。最后对开发工作进行总结,并对后续工作做了展望。
With the development of computer network、storage and embedded technology, the amount of user’s multimedia files grows quickly, how to manage the multimedia resources effectively becomes a problem that would be solved urgently. Therefore author has designed this media base management system which is based on embedded system.
The system includes four main modules: user interface、database management、file management and inquiry&monitor. User interface uses SDI frame and CSplitterWnd to divide window dynamically, uses model-view-controler(MVC) pattern to demonstrate various multimedia resources’informations distinctly for users. Database management uses the characteristics of embedded application program to design the media property database after the compromise of time and space; and uses CCeDBOpt to encapsule the operations for database in order to present conveniently to the upper level module for using. File management uses the pattern of Factory Method for creation and abstract design of various media files so that various media resources are well inherited and derived, accomplishing expansibility and loosen coupling. This module has designed CCeFileOpt for operating and visiting various media resource informations, and multimedia file's storage and visiting will be handled by the file system of Windows CE. Therefore it expands storage capacity and raises the visit efficience. Inquiry&monitor module uses rank and property information table to search values of database’s fields, uses the changing news of file system to monitor some media directories so that synchronization of file system and automatic updating media base is accomplished.
First, this paper classifies and describes the multimedia resoure's property fully, then finishes the design of the database of multimedia resource. The inquiry and management of multimedia resource are the important functions of the system. The author explains the inquiry&monitor module and management of the media resources fully and respectively. Finally, summarizes the work and makes expectation for the succeeding work.
引文
[1] 林福宗编著. 多媒体技术基础[M]. 北京:清华大学出版社. 2002
[2] 李逸波等编著. 多媒体数据库技术[M]. 北京:机械工业出版社. 2004
[3] 何宗键编著. Windows CE 嵌入式系统[M]. 北京:北京航空航天大学出版社. 2006
[4] 范国珍. 基于嵌入式技术的车载电脑系统的研究[D]. 辽宁:辽宁工程技术大学. 2004
[5] 汪兵、李存斌、陈鹏等编著. EVC 高级编程及其应用开发[M]. 北京:中国水利水电出版社. 2005
[6] James Noble & Charles Weir 著,侯捷、王飞、罗伟译. 内存受限系统之软件开发[M]. 湖北:华中科技大学出版社. 2003
[7] Thomasian,Alexander. Distributed optimistic concurrency control methods for high-performace transaction processing[J]. XXXI IEEE Transactions on Knowledge&Data Engineering. 1998, 10 (1):173-190
[8] Lee Chiang.Query optimization in multidatabase systems considering schema conflicts[J]. XXXI IEEE Transactions on Knowledge&Data Engineering. 1997, 9 (6):941-956
[9] 潘爱民著. COM 原理与应用[M]. 清华大学出版社. 1999
[10] Taylor, R. N., etal, A Component and Message-Based Architectural Style for GUI Software [J]. IEEE Transaction on Software Engineering. 1996,22(6): 390-406
[11] Hix D. and Hartson H.R , Developing User Interfaces: Ensuring Usability Through Product and Process[M]. New York: John Wiley and Sons. 1993. 58-60
[12] Hartson H.R., Siochi A.C., Hix D. The UAN: A User-Oriented Representation for Direct Manipulation User Interface[J]. ACM Transactions on Information Systems. 1990, 8(3): 181-203
[13] 张明,蔡绍稷,张正兰. 多媒体数据库研究[J]. 计算机工程. 1995 21(4):55
[14] 刘志华. 基于关系数据库的多媒体资源管理与发布系统的设计与实现[D]. 北京:国防科技大学. 2002
[15] 邵晓敏,罗海飞,意志凌. 嵌入式数据库技术及其在智能电视节目选择系统中的实现[C]. 第二十四届中国控制会议论文集(下册). 2005,7:15-18
[16] 白亮. 音频分类与分割技术研究[D]. 北京:国防科技大学. 2004
[17] Jmxuan. MP3 文件格式[J]. http://blog.csdn.net/airhand/archive/2004/07/01/31799.aspx.
[18] Philippe Owezarski. New architecture for enforcing multimedia synchronization in videoconferencing applications Telecommunication Systems[M]. 1999, 11.
[19] David Singer, Mohammed Zubair Visharam. "MPEG-4 File Formats white paper"[J]. ISO/IEC JTC 1/SC 29/WG 11 N7609. Oct 2005, Nice
[20] 常用的视频格式详解[J]. 赛迪网一中国电脑教育报. 2006,3
[21] 严富勇,邢建春,张宜军. 基于 Windows CE 3.0 的嵌入式数据库应用开发[J]. 电子工程师. 2007,33(2)
[22] 余金山、林慧编著. SQL Server 2000/2005 数据库开发实例入门与提高[M]. 北京:电子工业出版社. 2006
[23] (美)Chip Andrews、David Litchfield、Bill Grindlay 著,周俊杰等译. SQL Server 安全性[M].北京:清华大学出版社. 2004
[24] 何珍祥. 多媒体数据库技术及其应用系统的实现[J]. 兰州铁道学院报. 2002,21(3)
[25] 杨海娟,任小康. 浅谈多媒体数据库技术[J]. 甘肃科技. 2007,23(1)
[26] 游志男编著. 数据库管理系统. 北京:机械工业出版社[M]. 2004
[27] 王志梅、黄河编著. 关系数据库基础与技术[M]. 北京:国防工业出版社. 2005
[28] J.Foote. Content-base retrieval of music and audio[J]. In:C.C.J.Kuo etal.(eds) Multimedia Storage and Archiving Systems II, Proc.of SPIE, volume 3229,pp. 138-147. 1997
[29] E.Scheirer,M. Slaney. Construction and Evaluation of a Robust Multifeature Music/Speech Discriminator[J]. Proc. of ICASSP 97, vol II, pp1331-1334. April 1997
[30] 吴瑜. 人机交互设计界面问题研究[D]. 武汉: 武汉理工大学. 2004
[31] Steven A.Wall, William Harwin. A high bandwidth interface for haptic human computer interaction[J].Mechatronics. 2001, 8(3): 371-387
[32] Frieder Nake, Susanne Grabowski. Human-computer interaction viewed as pseudo-communication[J]. Knowledge-Based Systems. 2001,14:441-447
[33] Judy York, Parag C.Pendharkar. Human-computer interaction issues for mobile computing in a variable work context[J].Int.J.Human-Computer Studies. 2004,60:771-797
[34] 北京博彦科技发展有限公司著. MFC Windows 程序设计(第二版)[M]. 北京:清华大学出版社. 2001,9
[35] 白成林. 面向对象的多媒体数据库研究[N]. 上海:上海铁道大学学报. 1999, 4
[36] 朱虹等. 一种多媒体数据库管理系统的体系结构[J]. 计算机研究与发展. 1998, 1
[37] 张霞等. 一种面向对象的多媒体概念模型[N]. 软件学报. 1996, 7
[38] 黄柏雄,严小卫. 多媒体数据库的媒体实例模型[J]. 计算机科学. 2001,28(4)
[39] 倪其育编著. 音频技术教程[M]. 北京:国防工业出版社. 2006
[2] 李逸波等编著. 多媒体数据库技术[M]. 北京:机械工业出版社. 2004
[3] 何宗键编著. Windows CE 嵌入式系统[M]. 北京:北京航空航天大学出版社. 2006
[4] 范国珍. 基于嵌入式技术的车载电脑系统的研究[D]. 辽宁:辽宁工程技术大学. 2004
[5] 汪兵、李存斌、陈鹏等编著. EVC 高级编程及其应用开发[M]. 北京:中国水利水电出版社. 2005
[6] James Noble & Charles Weir 著,侯捷、王飞、罗伟译. 内存受限系统之软件开发[M]. 湖北:华中科技大学出版社. 2003
[7] Thomasian,Alexander. Distributed optimistic concurrency control methods for high-performace transaction processing[J]. XXXI IEEE Transactions on Knowledge&Data Engineering. 1998, 10 (1):173-190
[8] Lee Chiang.Query optimization in multidatabase systems considering schema conflicts[J]. XXXI IEEE Transactions on Knowledge&Data Engineering. 1997, 9 (6):941-956
[9] 潘爱民著. COM 原理与应用[M]. 清华大学出版社. 1999
[10] Taylor, R. N., etal, A Component and Message-Based Architectural Style for GUI Software [J]. IEEE Transaction on Software Engineering. 1996,22(6): 390-406
[11] Hix D. and Hartson H.R , Developing User Interfaces: Ensuring Usability Through Product and Process[M]. New York: John Wiley and Sons. 1993. 58-60
[12] Hartson H.R., Siochi A.C., Hix D. The UAN: A User-Oriented Representation for Direct Manipulation User Interface[J]. ACM Transactions on Information Systems. 1990, 8(3): 181-203
[13] 张明,蔡绍稷,张正兰. 多媒体数据库研究[J]. 计算机工程. 1995 21(4):55
[14] 刘志华. 基于关系数据库的多媒体资源管理与发布系统的设计与实现[D]. 北京:国防科技大学. 2002
[15] 邵晓敏,罗海飞,意志凌. 嵌入式数据库技术及其在智能电视节目选择系统中的实现[C]. 第二十四届中国控制会议论文集(下册). 2005,7:15-18
[16] 白亮. 音频分类与分割技术研究[D]. 北京:国防科技大学. 2004
[17] Jmxuan. MP3 文件格式[J]. http://blog.csdn.net/airhand/archive/2004/07/01/31799.aspx.
[18] Philippe Owezarski. New architecture for enforcing multimedia synchronization in videoconferencing applications Telecommunication Systems[M]. 1999, 11.
[19] David Singer, Mohammed Zubair Visharam. "MPEG-4 File Formats white paper"[J]. ISO/IEC JTC 1/SC 29/WG 11 N7609. Oct 2005, Nice
[20] 常用的视频格式详解[J]. 赛迪网一中国电脑教育报. 2006,3
[21] 严富勇,邢建春,张宜军. 基于 Windows CE 3.0 的嵌入式数据库应用开发[J]. 电子工程师. 2007,33(2)
[22] 余金山、林慧编著. SQL Server 2000/2005 数据库开发实例入门与提高[M]. 北京:电子工业出版社. 2006
[23] (美)Chip Andrews、David Litchfield、Bill Grindlay 著,周俊杰等译. SQL Server 安全性[M].北京:清华大学出版社. 2004
[24] 何珍祥. 多媒体数据库技术及其应用系统的实现[J]. 兰州铁道学院报. 2002,21(3)
[25] 杨海娟,任小康. 浅谈多媒体数据库技术[J]. 甘肃科技. 2007,23(1)
[26] 游志男编著. 数据库管理系统. 北京:机械工业出版社[M]. 2004
[27] 王志梅、黄河编著. 关系数据库基础与技术[M]. 北京:国防工业出版社. 2005
[28] J.Foote. Content-base retrieval of music and audio[J]. In:C.C.J.Kuo etal.(eds) Multimedia Storage and Archiving Systems II, Proc.of SPIE, volume 3229,pp. 138-147. 1997
[29] E.Scheirer,M. Slaney. Construction and Evaluation of a Robust Multifeature Music/Speech Discriminator[J]. Proc. of ICASSP 97, vol II, pp1331-1334. April 1997
[30] 吴瑜. 人机交互设计界面问题研究[D]. 武汉: 武汉理工大学. 2004
[31] Steven A.Wall, William Harwin. A high bandwidth interface for haptic human computer interaction[J].Mechatronics. 2001, 8(3): 371-387
[32] Frieder Nake, Susanne Grabowski. Human-computer interaction viewed as pseudo-communication[J]. Knowledge-Based Systems. 2001,14:441-447
[33] Judy York, Parag C.Pendharkar. Human-computer interaction issues for mobile computing in a variable work context[J].Int.J.Human-Computer Studies. 2004,60:771-797
[34] 北京博彦科技发展有限公司著. MFC Windows 程序设计(第二版)[M]. 北京:清华大学出版社. 2001,9
[35] 白成林. 面向对象的多媒体数据库研究[N]. 上海:上海铁道大学学报. 1999, 4
[36] 朱虹等. 一种多媒体数据库管理系统的体系结构[J]. 计算机研究与发展. 1998, 1
[37] 张霞等. 一种面向对象的多媒体概念模型[N]. 软件学报. 1996, 7
[38] 黄柏雄,严小卫. 多媒体数据库的媒体实例模型[J]. 计算机科学. 2001,28(4)
[39] 倪其育编著. 音频技术教程[M]. 北京:国防工业出版社. 2006