19.4 Database Input
About1 Introduction2 Image Recognition3 TransApplet4 API5 Interface6 Input7 Image Display8 Preprocessing9 Processing10 Normalization11 Parameter Class12 Image Signatures13 Unsupervised Filters14 BioFilters15 NeuralFilters16 Dynamic Library17 NeuralNet Filter18 Parameters19 Input Options20 Database Input21 Video Input22  Live Video Input23  Counting & Tracking24  Counting 25  Batch Job26 ImageFinder for DOS27 ImageHunt 28 Support Packages

19.1  File Input 
19.2  Sub-Directory  
19.3 Segment File 
19.4 Database Input 
19.5 Segment Database 
19.6 AVI to Images 
19.7 Live Video to Images 
[Home][19 Input Options][19.4 Database Input]

 

19.4   Database Input, Whole Image

The only database supported in this version is Microsoft Access. If you need a different Database supported, customization will solve this problem.

The Database consists of a set of tables. The table contains the locations of the images.

The data in a table is obtained by a SQL statement; therefore, to use this option, you must be able to write a SQL statement. The SQL output must list one image per row. When all fields in each row are combined, it must specify an absolute path.

A sample access table is:

        ID  Name

        1   .//2067(1).jpg

        2   .//2067(2).jpg

        3   .//2067(3).jpg

        4   .//2067(4).jpg

        5   .//2071(1).jpg

        6   .//2071(2).jpg

        7   .//2071(3).jpg

        8   .//2071(4).jpg

        9   .//2082(1).jpg

        10  .//2082(2).jpg

Some sample SQL statements are:

        select Path, Name from List1

        select Name from List2

Do not add the semicolon, �;� at the end of the SQL statement!

The result of a query must produce a list of paths for images. The result is either a single column or two columns, like path and name, which forms an absolute path when combined together.

Example. Database Input:

  •    Start the software;
  •    Select the option, �Access�;
  •    Click the �Source� button, and select file, �.\input_access\db1.mdb�;
  •    Enter the SQL statement, �Select Name from List2�;
  •    Click the �F� button in Figure 19.3 to see the first image, and click the �>� button to see the next image.

 

[Home][About][1 Introduction][2 Image Recognition][3 TransApplet][4 API][5 Interface][6 Input][7 Image Display][8 Preprocessing][9 Processing][10 Normalization][11 Parameter Class][12 Image Signatures][13 Unsupervised Filters][14 BioFilters][15 NeuralFilters][16 Dynamic Library][17 NeuralNet Filter][18 Parameters][19 Input Options][20 Database Input][21 Video Input][22 Live Video Input][23 Counting & Tracking][24 Counting ][25 Batch Job][26 ImageFinder for DOS][27 ImageHunt ][28 Support Packages]

Copyright (c) 2006 - 2007 Attrasoft. All rights reserved.

gina@attrasoft.com