基于关系数据库的多媒体资源管理与发布系统的设计与实现
|
摘要
随着多媒体技术和网络技术的快速发展，我们可以获得的多媒体资源越来越多，同时我们对多媒体资源共享和交换的需求也越来越大。如何有效地管理多媒体资源，如何高效地发布共享多媒体资源逐渐成为一个亟待解决的问题。因此，我们设计了这个多媒体资源管理与发布系统。
本系统由三部分组成：客户端软件、服务器软件和Web服务器。客户端软件可以作为一个桌面型的多媒体资源管理工具独立使用，它能很好的完成多媒体资源的分类管理功能，尤其是它提供了基于多媒体资源内容的检索能力，能帮助用户迅速找到所需多媒体资源。客户端软件还具有非常友好的用户界面，采用与资源管理器类似的操作方式。客户端软件又是访问服务器的工具，使用客户端软件能够登录到服务器，并在服务器上发布和共享多媒体资源。服务器软件具有与客户端软件相同的资源管理功能，并支持用户的发布管理。Web服务器集成在服务器上，服务器管理的多媒体资源由Web服务器发布到Internet上。用户使用浏览器访问Web服务器，不但可以浏览查询多媒体资源，还可以上传和下载多媒体资源。
本文首先对多媒体资源的属性进行了详细的分类和描述，并以此为基础，完成多媒体属性数据库的设计。多媒体资源的管理与发布是系统要实现的重要功能，我们在资源管理子系统和资源发布子系统中进行了详细的阐述。最后对开发工作进行总结，并对后续工作做了展望。
With the development of multimedia technology and network technology, more and more multimedia resource can be utilized by us. The demand for individual user to share and exchange the multimedia resource becomes increasingly greater. How to manage these resources properly and distribute them on Internet effectively now turns out to be a serious problem. So we design this multimedia resource management and distribution system.
The whole system consists of three parts: Client software, Server software and Web Server. The client software is a desktop tool and can run properly by itself. It can deal with multimedia resource management perfectly. Especially, it supports to look up some multimedia resource by their contents and make it convenient to find out what we want. The Client software also provides to user with a friendly user interface. The user interface is similar to
Windows explorer. The client software is the tool to access the server. A user uses the client software to access the multimedia resource in the server and distribute his resource. The Server software has more powerful function. It can do all of the works that the client software can do. Further more, it deals with client distribution management. Web server is integrated in the server machine, it use web page to distribute the multimedia resource in the
Internet. A user uses Internet explorer to access web server. In the web pages, user can look up multimedia resource and download or upload them.
We classify and describe the multimedia resource according to their properties at the beginning of this paper. On the basis of these work, we establish the multimedia property database. The management and distribution of the multimedia resource is the most important function of this project. We discuss these parts in the resource management subsystem and resource distribution system in detail. Finally, we summarize our research work and give a perspective on future research.
本系统由三部分组成：客户端软件、服务器软件和Web服务器。客户端软件可以作为一个桌面型的多媒体资源管理工具独立使用，它能很好的完成多媒体资源的分类管理功能，尤其是它提供了基于多媒体资源内容的检索能力，能帮助用户迅速找到所需多媒体资源。客户端软件还具有非常友好的用户界面，采用与资源管理器类似的操作方式。客户端软件又是访问服务器的工具，使用客户端软件能够登录到服务器，并在服务器上发布和共享多媒体资源。服务器软件具有与客户端软件相同的资源管理功能，并支持用户的发布管理。Web服务器集成在服务器上，服务器管理的多媒体资源由Web服务器发布到Internet上。用户使用浏览器访问Web服务器，不但可以浏览查询多媒体资源，还可以上传和下载多媒体资源。
本文首先对多媒体资源的属性进行了详细的分类和描述，并以此为基础，完成多媒体属性数据库的设计。多媒体资源的管理与发布是系统要实现的重要功能，我们在资源管理子系统和资源发布子系统中进行了详细的阐述。最后对开发工作进行总结，并对后续工作做了展望。
With the development of multimedia technology and network technology, more and more multimedia resource can be utilized by us. The demand for individual user to share and exchange the multimedia resource becomes increasingly greater. How to manage these resources properly and distribute them on Internet effectively now turns out to be a serious problem. So we design this multimedia resource management and distribution system.
The whole system consists of three parts: Client software, Server software and Web Server. The client software is a desktop tool and can run properly by itself. It can deal with multimedia resource management perfectly. Especially, it supports to look up some multimedia resource by their contents and make it convenient to find out what we want. The Client software also provides to user with a friendly user interface. The user interface is similar to
Windows explorer. The client software is the tool to access the server. A user uses the client software to access the multimedia resource in the server and distribute his resource. The Server software has more powerful function. It can do all of the works that the client software can do. Further more, it deals with client distribution management. Web server is integrated in the server machine, it use web page to distribute the multimedia resource in the
Internet. A user uses Internet explorer to access web server. In the web pages, user can look up multimedia resource and download or upload them.
We classify and describe the multimedia resource according to their properties at the beginning of this paper. On the basis of these work, we establish the multimedia property database. The management and distribution of the multimedia resource is the most important function of this project. We discuss these parts in the resource management subsystem and resource distribution system in detail. Finally, we summarize our research work and give a perspective on future research.
引文
[1]Michael Abbey, Michael J. Corey, Ian Abramson著 乐嘉锦 王兰成等译，Oracle 8i初学者指南，机械工业出版社
[2]王朴，多媒体，国防科学技术大学出版社
[3]Steve Teixeira, Xavier Pacheco著 任旭钧 王永生 冯泽波等译，Delphi 5开发人员指南，机械工业出版社
[4]Brad McGehee, Rob Kraft著 李昕 倪明田译，实用SQL Server 7教程，清华大学出版社
[5]清宏计算机工作室编著，Delphi数据库开发，机械工业出版社
[6]胡晓峰、吴玲达、李国辉、老松杨等，多媒体系统原理与应用，人民邮电出版社，1996．12
[7]吴伟煜，多媒体系统软件设计及应用，电子工业出版社，1996．12
[8]李慧、安静斌，多媒体信息管理系统FindMedia的实现方案，计算机应用研究，2001．5
[9]C J Date. An Introduction to Database System.3_rd Edition, Addition Wesley, 1981
[10]C Zaniolo, H Ait_Kad, D Majer. Object_Oriented Database Systems and Knowledge Systems. MCC, Expert Database Systems, Proc. From the Nine Int Work Shop, 1994.10
[11]郑庆华、李人厚、胡峻，多媒体数据库的主要问题、研究内容和实现方法，计算工程和应用，1998．1
[12]Richard Winer. An Introduction to Object_Orient Programming. Reading Mass. 1998
[13]Join Method for Data Skew in the Super Database Computer (SDC) Proc. VLDB 90,Australia, AVG. 1990, pp210-221
[14]J.B.Smith, S.F. Weiss, Hypertext Communication of ACM.Vol.31, No.7, 1998
[15]曹康等译，开放式数据库互连ODBC方案集粹，北京电子工业出版社，1995
[16]Ralf Steinnetz, Klara Nahrstedt. Multimedia: Computing Communication and Applications．清华大学出版社，1996
[17]Dan Simovici, Richard L.Tenney. Relation database system. Academic Press, 1995
[18]P Verkat Rangan, Harrick M Vin. Efficient Storage Technique for Digital Continuous Multimedia. IEEE Transaction on Knowledge and Data Engineering. 1993; 5(4): 564-573
[19]杨品，多媒体技术的应用与发展技术专题版，1997年第50期
[20]Database Security. By Dan Rahmel.Internet System, April, 1997
[21]P Venkat Rangan, Srinivas Ramanathan, Thomas Kaeppner. Performance of Inter_Media Synchronization in Distributed and Heterogenuouos Multimedia Systems, Computer Networks and ISDN Systems, 1993.
[22]Windows2000 Resource Kit Reference. Microsoft Corporation.2000
[23]Windows2000 SDK Reference. Microsoft Corporation.2000
[24]Nancy Winnick Cluts. Programming the Windows95 User Interface. Microsoft Corporation, 1995
[25]周明天、汪文勇编著，TCP／IP网络原理与技术，清华大学出版社1993．12
[26]Dr.Kris Jamsa和Ken Cope著，刘素丽、李彤红等译，INTERNET编程，电子工业出版社1996．5
[27]W Kim, Hong_Tai, Jay Banerjee. Operations and Implementation of Complex Objects. IEEE Trans Software Engineering, 1988
[28]Jeffrey Richer著 王书洪、刘光明译，Windows高级编程指南，清华大学出版社，1999
[29]Andrew S. Tanenbaum. Computer Networks (third edition). 1996
[30]郝小花 多媒体信息中基于内容的检索，http://www.north.cetin.net.cn/hqingbao/qb99/qb99-3/qb3017.htm
[31]多媒体计算机技术原理 马华东
[32]刘志华 多媒体资源管理与发布系统的设计与实现 海军工程大学学报增刊 已录用
[2]王朴，多媒体，国防科学技术大学出版社
[3]Steve Teixeira, Xavier Pacheco著 任旭钧 王永生 冯泽波等译，Delphi 5开发人员指南，机械工业出版社
[4]Brad McGehee, Rob Kraft著 李昕 倪明田译，实用SQL Server 7教程，清华大学出版社
[5]清宏计算机工作室编著，Delphi数据库开发，机械工业出版社
[6]胡晓峰、吴玲达、李国辉、老松杨等，多媒体系统原理与应用，人民邮电出版社，1996．12
[7]吴伟煜，多媒体系统软件设计及应用，电子工业出版社，1996．12
[8]李慧、安静斌，多媒体信息管理系统FindMedia的实现方案，计算机应用研究，2001．5
[9]C J Date. An Introduction to Database System.3_rd Edition, Addition Wesley, 1981
[10]C Zaniolo, H Ait_Kad, D Majer. Object_Oriented Database Systems and Knowledge Systems. MCC, Expert Database Systems, Proc. From the Nine Int Work Shop, 1994.10
[11]郑庆华、李人厚、胡峻，多媒体数据库的主要问题、研究内容和实现方法，计算工程和应用，1998．1
[12]Richard Winer. An Introduction to Object_Orient Programming. Reading Mass. 1998
[13]Join Method for Data Skew in the Super Database Computer (SDC) Proc. VLDB 90,Australia, AVG. 1990, pp210-221
[14]J.B.Smith, S.F. Weiss, Hypertext Communication of ACM.Vol.31, No.7, 1998
[15]曹康等译，开放式数据库互连ODBC方案集粹，北京电子工业出版社，1995
[16]Ralf Steinnetz, Klara Nahrstedt. Multimedia: Computing Communication and Applications．清华大学出版社，1996
[17]Dan Simovici, Richard L.Tenney. Relation database system. Academic Press, 1995
[18]P Verkat Rangan, Harrick M Vin. Efficient Storage Technique for Digital Continuous Multimedia. IEEE Transaction on Knowledge and Data Engineering. 1993; 5(4): 564-573
[19]杨品，多媒体技术的应用与发展技术专题版，1997年第50期
[20]Database Security. By Dan Rahmel.Internet System, April, 1997
[21]P Venkat Rangan, Srinivas Ramanathan, Thomas Kaeppner. Performance of Inter_Media Synchronization in Distributed and Heterogenuouos Multimedia Systems, Computer Networks and ISDN Systems, 1993.
[22]Windows2000 Resource Kit Reference. Microsoft Corporation.2000
[23]Windows2000 SDK Reference. Microsoft Corporation.2000
[24]Nancy Winnick Cluts. Programming the Windows95 User Interface. Microsoft Corporation, 1995
[25]周明天、汪文勇编著，TCP／IP网络原理与技术，清华大学出版社1993．12
[26]Dr.Kris Jamsa和Ken Cope著，刘素丽、李彤红等译，INTERNET编程，电子工业出版社1996．5
[27]W Kim, Hong_Tai, Jay Banerjee. Operations and Implementation of Complex Objects. IEEE Trans Software Engineering, 1988
[28]Jeffrey Richer著 王书洪、刘光明译，Windows高级编程指南，清华大学出版社，1999
[29]Andrew S. Tanenbaum. Computer Networks (third edition). 1996
[30]郝小花 多媒体信息中基于内容的检索，http://www.north.cetin.net.cn/hqingbao/qb99/qb99-3/qb3017.htm
[31]多媒体计算机技术原理 马华东
[32]刘志华 多媒体资源管理与发布系统的设计与实现 海军工程大学学报增刊 已录用