基于ORACLE数据库的多媒体数据SQL级操作探究-《计算机技术与发展》

文章信息/Info

Title:: Research of Multimedia Data Type Operating in SQL Level Based on ORACLE Database

Author(s):: YUE Guo-hua; ZHAO Jing-jing; Xi＇an University of Science ＆ Technology

摘要:: 探索ORACLE数据库平台下多媒体数据在SQL级直接操作的可行性。以Oracle interMedia为背景,运用多媒体数据PL/SQL API实现多媒体数据文件存取。虽然在关系数据库中对多媒体数据即非结构化数据进行操作时,和结构化数据的处理方式不同,但在ORACLE数据库平台下将基本SQL和多媒体数据PL/SQL API整合运用,屏蔽了多媒体数据处理的复杂性,对外呈现出一致的SQL级操作是可能的。在ORACLE10g的数据库平台上,通过分析Oracle interMedia体系结构和多媒体数据的特点以及在ORACLE中的存储方式,探索在SQL级实现常规结构化数据类型与表示多媒体内容的非结构化数据类型统一操作的可行性和实现途径

Abstract:: Explore ORACLE database platform multimedia data in SQL level directly the feasibility of the operation.With Oracle interMedia for background,use multimedia data PL/SQL API multimedia data files access.Although in the relational database of multimedia data points-unstructured data is operated,and structured data processing in different ways,but with the help of ORACLE database platform,make basic SQL and multimedia data PL/SQL API integration using multimedia data processing,shielding the complexity of foreign shows consistent SQL level operation is possible.According to the analysis of the Oracle interMedia system structure and characteristics of multimedia data as well as storage mode in ORACLE under ORACLE10g database platform,expound mainly the feasibility and implementation approaches that conventional structured data type and multimedia content which is the unstructured data type are unified operation in SQL level of oracle