readme file

Description

Last update : Septembre 2018

This is the eleventh version of Rever DB-Main, the Database Engineering tool. In its current state, it includes most basic functions commonly found in other DB CASE environments, but also some other functions which are less frequently available. Currently, the tool offers functions for :

*entering and managing multi-schemas projects

*entering and managing conceptual, logical and physical database schemas, based on ER model or as UML class diagrams

*entering and managing UML activity diagrams

*entering and managing UML use case diagrams

*viewing schemas through 7 formats : 4 hypertext and 3 graphical

*managing mappings

*deriving logical schemas from conceptual schemas (database forward eng.)

*deriving conceptual schemas from logical schemas (database reverse eng.)

*transforming data schemas (for normalization, optimization, restructuring, implementation, reverse engineering, etc), thanks to a toolset of 25+ operators

*executing problem-solving activities through a simple and intuitive transformation assistant

*automating the application of some transformations to a schema through a advanced global transformation assistant

*integrating projects, schemas or entity types

*analyzing schemas and searching them for complex structural patterns

*proposing some popular heuristics to find foreign keys

*writing design scripts and structural sub-models, and running them

*generating executable code according to several DBMS (SQL, IDS/II, CODASYL, COBOL and XML-DTD)

*generating reports

*extracting physical schemas from SQL, COBOL, IMS, RPG, IDS/II, PL/I DDL and XML (DTD) source texts

*extracting directly from relational databases via ODBC or JDBC drivers

*browsing source texts, such as programs, with a sophisticated, interactive, pattern matching engine

*processing sophisticated program analysis: dependency graph analysis, program slicing

*updating a logical schema from a source text

*sophisticated name processing

*recording user’s actions into a design history, and replaying them selectively

*creating views with automatic update propagation

*importing/exporting external specifications

and much more…


The JIDBM (Java Interface for Rever DB-Main) library is designed to develop Java plug-ins for Rever DB-Main. With this library, the Rever DB-Main users can develop their own functions in the tool.

Rever DB-Main is now implemented with wxWidgets a open-source GUI library.

This tool is implemented in C++ and runs on Windows (95, 98, Me, NT, 2000, XP, Vista, 7, 8 and 10) and Linux. It works well on 32-bit and 64-bit operating systems.

It now supports UTF-8 encoding since version 10.


Availability

Rever DB-MAIN is ready to download, fully functional and without object limitation.

Professional plug-ins (COBOL, IMS, RPG, IDS/II, PL/I, XML…) and support are also available. Contact us for more information.

How to setup Rever DB-Main ?

Windows

Installation

Execute the dbm-11xx-win-i386-setup.exe (32-bit) or dbm-11xx-win-amd64-setup.exe (64-bit) file to install Rever DB-Main on your machine.
This installation creates a directory for Rever DB-Main and fills it.
In the registry, only a single entry is created for easy uninstallation of Rever DB-Main.

Execution

Go to the Start menu and click on the entry DB-MAIN X.Y.Z.
A file DB_MAIN.INI is created in the user’s application data directory when Rever DB-Main is run for the first time.
Except that, nothing else is written outside of the Rever DB-Main directory.

IMPORTANT for Windows 7, 8 and 10 users : At first start, run Rever DB-Main as administrator (right click on the shortcut DB-MAIN and select Run as administrator) to allow the license file writing. Next starts, run Rever DB-Main normally.

Linux

Installation

Two kinds of installation may be performed:

Single user installation
Extract the dbm-11xx-linux-i386-setup.tar.gz (32-bit) or dbm-11xx-linux-amd64-setup.tar.gz (64-bit) archive in the directory of your choice:

cd ~/db-main
tar -xf dbm-11xx-linux-i386-setup.tar.gz or
tar -xf dbm-11xx-linux-amd64-setup.tar.gz

Edit the .bashrc file (.profile in some environment) in the home directory and add the following lines (adapt the ~/db-main/bin directory to the one chosen previously and choose the export LD_LIBRARY_PATH line corresponding to your hardware architecture):

export DB_MAIN_BIN=~/db-main/bin
export PATH=$DB_MAIN_BIN:$PATH
# For 32-bit
export LD_LIBRARY_PATH=$DB_MAIN_BIN:$DB_MAIN_BIN/../java/jre/lib/i386/client:$LD_LIBRARY_PATH
# For 64-bit
export LD_LIBRARY_PATH=$DB_MAIN_BIN:$DB_MAIN_BIN/../java/jre/lib/amd64/server:$LD_LIBRARY_PATH

Installation for all users
Extract the dbm-11xx-linux-i386-setup.tar.gz (32-bit) or dbm-11xx-linux-amd64-setup.tar.gz (64-bit) archive in /usr/local/db-main (or any other directory of your choice):

cd /usr/local/db-main
sudo tar -xf dbm-11xx-linux-i386-setup.tar.gz or
sudo tar -xf dbm-11xx-linux-amd64-setup.tar.gz

Change the permissions so that any user can execute db_main:

sudo chmod a+x /usr/local/db-main/bin/db_main

Edit the global bash profile for all users (something like /etc/bash.bashrc) and add the following lines (adapt the /usr/local/db-main/bin directory to the one chosen previously and choose the export LD_LIBRARY_PATH line corresponding to your hardware architecture):

export DB_MAIN_BIN=/usr/local/db-main/bin
export PATH=$DB_MAIN_BIN:$PATH
# For 32-bit
export LD_LIBRARY_PATH=$DB_MAIN_BIN:$DB_MAIN_BIN/../java/jre/lib/i386/client:$LD_LIBRARY_PATH
# For 64-bit
export LD_LIBRARY_PATH=$DB_MAIN_BIN:$DB_MAIN_BIN/../java/jre/lib/amd64/server:$LD_LIBRARY_PATH

Execution

To run Rever DB-Main, there are also two approaches :

Execute the file db_main as a normal user from the command prompt.

Create a shortcut on your desktop that calls a shell file that contains something like this:

#!/bin/sh
export DB_MAIN_BIN=/the-path-to-the-db-main-bin-directory
export PATH=$DB_MAIN_BIN:$PATH
# For 32-bit
export LD_LIBRARY_PATH=$DB_MAIN_BIN:$DB_MAIN_BIN/../java/jre/lib/i386/client:$LD_LIBRARY_PATH
# For 64-bit
export LD_LIBRARY_PATH=$DB_MAIN_BIN:$DB_MAIN_BIN/../java/jre/lib/amd64/server:$LD_LIBRARY_PATH
cd /the-path-to-the-db-main-bin-directory/
db_main

Adapt the-path-to-the-db-main-bin-directory to your environment, choose the export LD_LIBRARY_PATH line corresponding to your computer architecture, save the shell file in the Rever DB-Main bin directory (called db_main.sh for example) and give the execute permissions for all users.

Finally, put the following command in the shortcut:

/bin/sh /the-path-to-the-db-main-bin-directory/db_main.sh

A file db_main.ini is created in the .db-main directory of the user’s home directory when Rever DB-Main is run for the first time.

Download content

The setup files (dbm-11xx-win-i386-setup.exe or dbm-11xx-win-amd64-setup.exe for Windows, dbm-11xx-linux-i386-setup.tar.gz or dbm-11xx-linux-amd64-setup.tar.gz for Linux) contain :

readme.html: this readme file.

licence.txt: the licence file.

bin : the directory containing the Rever DB-Main software components.

doc : the directory containing the Rever DB-Main documentation.

DB-MAIN-reference-manual.pdf: the reference manual of the tool.

JIDBM-reference-manual.pdf: the reference manual of the Java Interface for Rever DB-Main library.

JIDBM-javadoc: the javadoc directory for the JIDBM library.

examples: the directory containing some examples.

DDL: some examples of DDL (data description language) scripts for different database management systems (SQL, IMS, CODASYL, COBOL).

projects: some typical Rever DB-Main projects.

reverse: two reverse engineering projects (one in English and one in French).

scripts: some patterns and transformation scripts

java : the Java Virtual Machine used by Rever DB-Main to run Java plug-ins.

plugins: this directory containing different plug-ins.

access: an Microsoft Access database that contains a form to extract structures from an SQL DDL generated by the Rever DB-Main Access generator.

docbook-0.1.jar: a Java plug-in that generates DocBook file from the Rever DB-Main repository. The DocBook XML file can be processed by xsltproc program to obtain a readable documentation.

jdbcextraction-0.6.jar: a Java plug-in that extracts relational databases structures through JDBC drivers. JDBC drivers must be downloaded, installed and added to CLASSPATH before use.

sql: a simpler SQL generator written in Java. This plug-in must be adapted to satisfy user’s requirements.

statistic: a Java plug-in that computes some elementary (but useful) statistics of the current schema.

Important notes of use

Characters

Rever DB-Main is UTF-8 compliant.

Copy/paste

Menu items (available from the menu bar and keyboard shortcuts) related to clipboard operations (“Copy”, “Paste”, …) act upon objects in textual and graphical views. If the insertion point is in a text input area, you should use the shortcut menu (control-click or right-click).