MATLAB DATABASE TOOLBOX RELEASE NOTES Guide de l'utilisateur télécharger pdf (Page 333)

100

101

Retrieving BINARY and OTHER Data Types

5-55

Retrieving BINARY and OTHER Data Types

This example shows how to retrieve data of types BINARY and OTHER, which may require

manipulation before it can undergo MATLAB processing. To retrieve images using the

dbtoolboxdemo data source and a sample file that parses image data, matlabroot/

toolbox/database/vqb/parsebinary.m:

For Data Operation, select Select.

In Data source, select dbtoolboxdemo.

In Tables, select Invoive.

In Fields, select InvoiceNumber and Receipt (which contains bitmap images).

Select Query > Preferences.

In the Data return format field, specify cellarray.

As the MATLAB workspace variable, specify A.

Click Execute to run the query.

Type A in the Command Window to view the query results.

A =

[1] [21626x1 int8]

[2] [21626x1 int8]

[3] [21722x1 int8]

[4] [21626x1 int8]

[5] [21626x1 int8]

[6] [21626x1 int8]

[7] [21626x1 int8]

[8] [21626x1 int8]

[9] [21626x1 int8]

Assign the first element in A to the variable photo.

photo = A{1,2};

Make sure your current folder is writable.

Run the sample program parsebinary, which writes the retrieved data to a file,

strips ODBC header information, and displays photo as a bitmap image.

cd I:\MATLABFiles\myfiles

parsebinary(photo, 'BMP');

1 2 ... 328 329 330 331 332 333 334 335 336 337 338 ... 683 684

Commentaires sur ces manuels

Pas de commentaire

MATLAB DATABASE TOOLBOX RELEASE NOTES Guide de l'utilisateur Page 333

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel MATLAB DATABASE TOOLBOX RELEASE NOTES