SQL/MM

Within the international SQL standards efforts, SQL/MM is the responsibility of the committee ISO/IEC JTC 1/SC 32/WG 4 SQL/Multimedia and application packages. The current parts of SQL/MM are:

• SQL/MM Part 1: Framework
• SQL/MM Part 1: Framework
• SQL/MM Part 2: Full Text
• SQL/MM Part 3: Spatial
• SQL/MM Part 5: Still image
• SQL/MM Part 6: Data mining

here is an example of media table for still Images defined as per SQL/MM standards :

SI_MEDIA Table Definition :

CREATE TABLE PM.SI_MEDIA(
PRODUCT_ID NUMBER(6),
PRODUCT_PHOTO SI_StillImage,
AVERAGE_COLOR SI_AverageColor,
COLOR_HISTOGRAM SI_ColorHistogram,
FEATURE_LIST SI_FeatureList,
POSITIONAL_COLOR SI_PositionalColor,
TEXTURE SI_Texture,
CONSTRAINT id_pk PRIMARY KEY (PRODUCT_ID));
COMMIT;

Oracle interMedia ("interMedia") contains the following information about object types that comply with the first edition of the ISO/IEC 13249-5:2001 SQL MM Part5:StillImage standard (commonly referred to as the SQL/MM Still Image standard):