What do you know about your BLOB data?

BLOB Statistics is a tool for collecting, viewing and analyzing information about stored BLOB data. With BLOB Statistics, you can determine the number of images, office documents, sounds, videos (etc.) stored in your Database (or Warehouse), how much space is used, what is the minimum, average and maximum size of data, etc.

Here are some key features of "BLOB Statistics":

· Automatically determines database BLOB objects and creates statistics for them
· Recognizes most popular data formats -Generates statistics for the entire database, for each table, for data formats
· Produces reports with drill-down details
· Supports ODBC and desktop Databases
· BLOB Statistics supports the following reports:
· Database Summary Report - The Summary Report contains summary information about BLOBs for the entire database.
· Table Summary Report - The Table Summary Report contains summary information for each table.
· Format Summary Report - The Format Summary Report includes information on all recognized formats.
· Formats by Tables Report - This report allows you to determine which formats are used in each particular table.
· Tables by Formats Report - This report allows you to determine in which tables each particular format is used.
· Database: Recognized/Unrecognized Data - This report allows you to compare the properties of recognized and unrecognized data for the entire database.
· Tables: Recognized/Unrecognized Data - This report allows you to compare the properties of recognized and unrecognized data for each table.


Limitations:

· Adds 'DEMO' strings to reports