Reporting, Query Tools
Query and Reporting:
A type of data access and analysis computer application that allows users to build queries of the data base and construct reports via a GUI.
From: www.egltd.com/production/Glossary.html
Many tools provide a graphical representation of the queried data, providing a visual perspective to the user.
Interbase Query and Performance Monitor
This tool allows completely manage any Interbase >5.x/Firebird database. It is based on Borland IBX components. It contains following modules:
SQL Editor
It contains SQL Editor with syntax highlighting with Result Buffer. You can run any type of sql statement or script. Output is flushed to formatted text, not to grid, what it allows more flexible and synoptic result overview.
You can also export/import data to/from CSV, XML, raw batch file or printer.
Every correctly run statement is saved in SQL History Buffer. You can open multiple instances of this editor to run "simultaneous" queries.
Object Explorer
Here you can inspect every database object including its detail properties. Some object you can edit too. Also you can extract metadata of all objects including data for tables.
Event Watcher
Here you can inspect user defined event triggering.
Performance Monitor
This tool allows profile and watch database operations. It contains following modules:
Memory usage of watched database
Number of writes and read to database and to buffer cache
User Manager
Allows you add, edit and delete database users and roles.
Grant Manager
Allows to grant or revoke privileges on all database objects.
Services
Here are available following services:
Server Log View
Server Properties Overview
Database Statistics Overview
Database Validation Task
Loading .....