Building Customer Relationships

 

Phone: 647-236-3222

 

 

 

  

 

 Messenger

 

 (Enter e-mail below  in IM)

  Contact@

      VirtualVantage.ca

Send E-mail

DB2 is the first multimedia, Web-ready  DBMS strong enough for the demands of large corporations and flexible enough to serve the varying needs of small and medium-sized businesses

DB2 Extenders

DB2 Extenders can take your database applications beyond traditional numeric and character data to images, video, audio, and complex documents. DB2 Extenders define new data types and functions using DB2's built in support for user-defined types (UDTs) and user-defined functions (UDFs). With DB2 Extenders the user can store text documents, images, videos, and audio clips in DB2 tables by adding columns of the new data types. The actual data can be stored inside the table or outside, in external files. These new data types also have attributes that describe aspects of their internal structures, such as "language" and "format" for text data. Each Extender provides the appropriate functions for creating, updating, deleting, and searching through data stored in its data types. The user can include these new data types and functions in SQL statements for integrated content searching across all types of data.

Some highlights of the DB2 Extenders included with DB2 are:

DB2 XML Extender
It provides ability to store eXtensible Markup Language (XML) documents as a new column datatype, and new functions that assist you in working with these structured documents. Entire XML documents can be stored in DB2 databases as character data or stored as external files but still managed by DB2. Retrieval functions allow you to retrieve either the entire XML document or individual elements or attributes. The DB2 XML Extender is provided with each DB2 Universal Database edition to:

· Extracts XML elements and attributes into traditional SQL data types, leveraging the sophisticated indexing and SQL query of DB2

· Provides storage, retrieval, and updates of XML documents in a single column

· Composes existing DB2 data into XML documents

· Stores XML documents as a collection of DB2 data, in multiple columns and tables

DB2 Audio Extender
The DB2 Audio Extender defines a new data type and functions for audio. With the DB2 Audio Extender, users can:

· Import and export audio clips and audio attributes into and out of a database. When an audio clip is imported, the DB2 Audio Extender stores and maintains audio attributes such as number of audio channels, transfer time, and sampling rate.

· Secure and recover audio data. Audio clips and their attributes stored in a DB2 database are afforded the same security and recovery protection as traditional business data.

· Query audio clips based on related business data or by audio attributes. Users can search for audio clips based on data that they maintain, such as a name, number, or description; or by data that the DB2 Audio Extender maintains, such as the format of the audio or the date and time that it was last updated.

· Play audio clips. A user can use the DB2 Audio Extender to retrieve an audio clip. The user can then use the DB2 Audio Extender to invoke a favorite audio browser to play the audio clip.

· Support of a variety of audio file formats. The DB2 Audio Extender supports a variety of audio file formats, such as WAVE, MIDI, MPEG1, and AU, and can work with different file-based audio servers.

DB2 Image Extender
The DB2 Image Extender defines a new data type and functions for images. With the DB2 Image Extender, users can:

· Import and export images and image attributes into and out of a database. When an image is imported, the DB2 Image Extender stores and maintains image attributes such as size in bytes, format, height, width, and number of colors.

· Control access to images with the same level of protection as traditional business data. Convert the format of images. Users have the flexibility of importing or exporting an image in its source format or converting the format of the image when importing or exporting. A user can also convert an image in other ways, such as rotating it or changing its scale.

· Secure and recover images. Images and their attributes stored in a DB2 database are afforded the same security and recovery protection as traditional business data.

· Query images based on related business data or by image attributes. Images can be searched based on data that the user maintains, such as a name, number, or description; or by data that the DB2 Image Extender maintains, such as the format of the image or its distribution of colors.

· Generate and display image thumbnails and full images. A thumbnail is a miniature version of an image. When an image is imported into a database, the DB2 Image Extender creates and stores a thumbnail of the image. A user can use the DB2 Image Extender to retrieve a thumbnail or a full-size image. The user can then use the DB2 Image Extender to invoke a favorite browser to display the thumbnail or full-size image.

The DB2 Image Extender supports a wide variety of image formats, such as GIF (including animated GIFs), JPEG, BMP, and TIFF.


DB2 Video Extender
The DB2 Video Extender defines a new data type and functions for video. With the DB2 Video Extender, users can:

· Import and export video clips and their attributes into and out of a database. When a video clip is imported, the DB2 Video Extender stores and maintains video attributes such as frame rate, compression format, and number of video tracks.

· Secure and recover video data. Video clips and their attributes stored in a DB2 database are afforded the same security and recovery protection as traditional business data.

· Query video clips based on related business data or by audio attributes. Users can search for video clips based on data that they maintain, such as a name, number, or description; or by data that the DB2 Video Extender maintains, such as the format of the video or the date and time that it was last updated.

· Build storyboards. A user can access the DB2 Video Extender to segment automatically a video clip into shots based on scene changes. A scene change is a point in a video clip where there is a significant difference between two successive frames. When the DB2 Video Extender detects a scene change, it records data for the associated take, including representative frames. This makes it easy to build summaries of a video, called storyboards.

· Play video clips. A user can use the DB2 Video Extender to retrieve a video clip. The user can then use the DB2 Video Extender to invoke a favorite video browser to play the video clip.

 

· Support of a variety of audio file formats. The DB2 Video Extender supports a variety of video file formats, such as MPEG1, MPEG2, AVI, and QuickTime, and can work with different file-based video servers.

 

Product Detail:

IBM DB2^(R) Universal Database