database statistics
database statistics in title
database statistics in description
Two main purposes of IBAnalyst are:
· Visualize database statistics
· Offer proven solutions and "how-to" to improve database performance based on resuly of automatic examination of database statistics.
Using IBAnalyst developer will be able to see in a few seconds all actual and potential problems with database: poor indices, fragmented tables, state of transactions, etc and get professional solutions how to solve these problems.
You know that InterBase has special tool to gather database statistics - gstat. It is a command line tool which provides large amount of statistical information about database inside. Statistics is represented in a text view and developer needs to spend a lot of time to retrieve useful information from gstat output.
But retrieving the useful information is not enough developer needs to make some decisions based on this information, and it is not easy to understand the actual meaning of all these values.
If you ever try to get statistics of your database and understand what all this stuff means, you will appreciate the features of IBAnalyst.
First, IBAnalyst visualizes database statistics you can easily navigate through all your indices, tables and their relationships and view their states, with smart hints and colored representation of problem objects.
Second, IBAnalyst makes decisions for you! The powerful analytic module is embedded into IBAnalyst. It automatically analyzes all gathered statistics and generates the recommendations and "how-to" solutions
Here are some key features of "IBAnalyst":
· Retrieving database statistics via Service API and from gstat output.
· Summary of all actual and possible problems in database
· Colored grid representation of tables, indices and table->indices, which highlights fragmented tables, poor indices
· Automatic expertise of statistics
Performance Monitoring
Displays connected users
Displays CPU usage of host system
Memory usage of watched database
Number of writes and read to database and to buffer cache
Local SQL Monitor and Event Log
Here are displayed internal events (e.g. lost connection and recovery actions) and all statements run on local host by applications written using FIBPlus.
Server Log
This module can view server log file.
Database Statistics
Here you can enumerate database statistics.
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
Report all or selective database objects. Alternatively you can apply your own css to the reports. Migrate all or selected database objects between supported databases. View, insert, update, delete data and execute stored procedures using respective SQL statements of your database.
Works with Microsoft SQL Server (6.5, 7.0 and 2000), Microsoft Access (2.0 to XP), Oracle 8i, Oracle 9i, Personal Oracle and IBM DB2 7.x. Connect to any other database that is supported by OLEDB by giving a valid connection string. Copy names of database objects to clipboard.
View properties of a database like the statistics of database objects, creation dates and more. Control the number of database objects in a single page. Customize the XML namespace and XML namespace URI. Supports Windows authentication and Database specific authentication.
Limitations:
· 30 uses / 30 days trial
The ExpressMaint application was designed to be an automated database maintenance tool for SQL 2005 Express Edition.
Features of "ExpressMaint":
· Full Database Backup
· Differential Database Backup
· Log Backup
· Housekeeping of backup files
· Database Integrity Checks
· Database Index Rebuilds
· Database Index Reorganization
· Database Statistics Update
· Report Creation
Requirements:
· SQL Server 2005 Express Edition
foo sic is a lightweight and useful add-on for foobar2000 designed to be a playback statistics tracking system and an automated music database as well. foo_sic is a component that submits the tracks you listen to the foosic database.
Requirements:
· foobar2000
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.
Key Features:
-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:
1. Database Summary Report - The Summary Report contains summary information about BLOBs for the entire database.
2.Table Summary Report - The Table Summary Report contains summary information for each table.
3. Format Summary Report - The Format Summary Report includes information on all recognized formats.
4. Formats by Tables Report - This report allows you to determine which formats are used in each particular table.
5. Tables by Formats Report - This report allows you to determine in which tables each particular format is used.
6. Database: Recognized/Unrecognized Data - This report allows you to compare the properties of recognized and unrecognized data for the entire database.
7. Tables: Recognized/Unrecognized Data - This report allows you to compare the properties of recognized and unrecognized data for each table.
Download your free demo version now!
: EasyStruct is the proven database structure documentation and migration tool. It documents the complete structure of a database and generates output as XML, HTML or Microsoft Word documents.
It helps you to migrate database structure from one database to another. The "execute query" feature allows you to execute SQL statements and view the output.
ER) Entity Relationship diagram for each database.
(ER) Entity Relationship diagram included in HTML Report
Ability to display dependencies of Views, Stored procedures and Triggers
Ability for each user to view the privileges of every object in the database and for all users
New Report formats and styles
Columnar display of report in word document and xml
Run EasyStruct in silent mode for batch processing
Ability to generate complete SQL script file for the selected database
Execute SQL Query
Generate reports as XML and Microsoft word documents apart from HTML
View the database structure and choose objects to be included in the report
View export tables, foreign keys and indexes from one database engine to another
Generate Customized reports
Preview report output for individual objects
RCounter is really the best way to monitor your web site traffic, measure online behavior and profile visitors.
Basic functions and advantages of the system:
- plenty of diverse kinds of statistics (hits, hosts totally and by dates, unique IP-addresses, "where from" statistics);
- support of statistics on separate pages of a large/complex-structured site;
- calendar statistics - possibility to see distribution of web site attendance by time and by pages simultaneously
(two-dimensional statistical report);
- access to statistics (review) through Internet;
- set-up of the RCounter system through Internet (Web-access);
storage of site statistics in the separate database completely belonging to a site owner;
- storage of site statistics in the separate database completely belonging to a site owner;
- support of "skin" technology for counter appearance setting on your site, capability to disable
show of the counter on your site.
RCounter is an easy-to-implement professional web site tracking and analysis service.
Basic functions and advantages of the system:
- plenty of diverse kinds of statistics (hits, hosts totally and by dates, unique IP-addresses, "where from" statistics);
- support of statistics on separate pages of a large/complex-structured site;
- calendar statistics - possibility to see distribution of web site attendance by time and by pages simultaneously
(two-dimensional statistical report);
- access to statistics (review) through Internet;
- set-up of the RCounter system through Internet (Web-access);
storage of site statistics in the separate database completely belonging to a site owner;
- storage of site statistics in the separate database completely belonging to a site owner;
- support of "skin" technology for counter appearance setting on your site, capability to disable
show of the counter on your site.