Malloc Corporation - Database Analyzer
analyzer, Database Structure
DB Analyzer is a tool that helps you analyze database server, database structure and data.
The following analysis can be performed:
database server features
database structure (catalogs, schemas, tables, views, columns, constraints)
data (sample data, cardinality, occurrence, etc.)
relationships between database tables
DB Analyzer is designed to help IT personnel such as Business
Analysts, Managers, System Architects, Developers and
Database Administrators to better understand how and what data is stored in the database. It gives a huge jumpstart during the data
analysis, data mapping, conversion, system development, optimization, troubleshooting and in any task where good understanding of the database and the data is required.
Try Database Analyzer today - download a trial version and
analyze as many databases as you want. The only limitation
of this version is that will include first 5 tables in all
reports. Once you get the licensed version you can produce
complete reports using analysis done with the trial
version (no need to rerun analysis, unless there are
changes in the database).
DB Analyzer analyzes database structure and data. This particular feature distinguishes this software from CASE tools such as Erwin and Power Designer
which you can use to analyze structure of the database but not the data.
Moreover, while CASE tools are primarily used by Systems
Architects and Developers, DB Analyzer is excellent tool for
Business/System Analysts as well as Architects and Developers.
Business Analyst might be interested in what data is stored in certain tables and columns – what is really stored in field BOND_DESC?
Developer might be interested in format of data – does the phone number has spaces, dashes, brackets?
Database Administrator is interested number of records in database tables so he can do the proper sizing of the database.
Data Architect is interested in data duplication so he can determine degree of model normalization, utilization of the space – why filed declared as CHAR(100) has only ‘Y’ and ‘N’ values, etc.
(QA) analysts can check the quality of test bed database and ensure the data is sufficiently diversified and appropriate for user acceptance testing.
System Architect might be interested in available database features
All this information can be obtained by typing SQL commands however that required skills and it is tedious and error prone. DB
Analyzer produces consolidated and convenient way to exploit this information at your fingertips.
, Database Structure