Infobright Blog

If you need quick, high-level statistics about your Infobright database, a new user-contributed software download may suit your need.  Thanks to the intern team at the University of Illinois, users can simply drag-and-drop a few files into their web server directory.  The user can then navigate to the main page and quickly pull information regarding their database and their tables.  For example, here's the data which can be extracted:

1. List of all Accessible Databases (by that user)
2. Database Summaries
   
   • Estimated Raw Data Size for the entire Database
   • Overall database compression
   • Table Names
   • Engines Used
   • Number of Rows
   • Collation
   • Compression Ratios per Table
   • Estimated Raw Size per Table
3. Tables
   
   • DDL
   • Collation Type
   • Privileges
   • Estimated raw data size per column
   • Compressed data size per column
   • Compression Ratio

To learn more about the tool, watch this short video: