Malloc Corporation - Database Analyzer

By: Malloc  09-12-2011
Keywords: 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.

For example:

  • 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.

  • Quality Assurance (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.

Keywords: analyzer, Database Structure

Other products and services from Malloc


Malloc Corporation - productsG DAOframework

Code generation overcomes some deficiencies of inheritance (i.e. Java allows class to be inherited only from one super class, each database object is represented by customized Java class, enables IDE features like ?Code Assist. Integrator with JDBC enabled Data Sources such as all major databases and file formats. G-DAO FRAMEWORK - PRODUCT DESCRIPTION What is G-DAO Framework. Java technologies such as JDBC.


Malloc Corporation - RemoteDataServices

We need a program which will continuously compare data in Sybase and Oracle databases and send us daily report about discrepancies.. Databases can be sent to us as an export files , bcp files or as any other popular file format. Remote access could be provided so we can export data ourselves or just work directly on your database. For complex requirements we provide a proof of concept which ensures success and quality of service.


Malloc Corporation - productsTestDaedmonDescription

Test Daemon captures transaction events as they occur in a database and presents them in a comprehensive and customizable report so the tester or developer can analyze these events. The tester links the tables to a test case and it is the test case execution that captures and stores the database transaction events once a program that changes data is run.


Malloc Corporation - dataMigrationCaseStudy

Many legacy databases do not implement referential integrity and sometimes are not even properly designed so even rudimentary data rules are implemented and controlled at the application level and not by database engine. Having data model will definitely help understood database structure however it will not do much when it comes to understanding data stored in the database, its format, usage, patterns, spreads, etc.


Malloc Corporation - services

Data migration between wide spectrum of sources and destinations such as databases, files, messaging and remote systems. Design and development of data layers for business applications also known as "back end" applications and middleware. Design and development of OLTP Relational Databases and back end systems. Performance optimization related to massive data volumes manipulation.