Background Image

DOCUMENTATION

?

Shortcut

PrevPrev Article

NextNext Article

Larger Font Smaller Font Up Down Go comment Print Attachment

 

Author: Henry Kwon 

 

DB modelling tool, eXERD now supports the open source DBMS CUBRID. eXERD can handle logical models/physical models, etc., and is a solution focused on increasing the design capabilities of developers with Eclipse-based DB modelling tools. On average, more than 3,000 downloads occur per month, and its use is spreading across all industries.

 

From now on, let me explain about eXERD. For eXERD download, you can access the URL below to download their trial installation fie: http://en.exerd.com/ .

 

There are many functions in eXERD. Among them, the environment in which CUBRID is operated was considered. Now, let me introduce the “reverse engineering” function that automatically draws the ERD based on the CUBRID DB in operation.

 

Menu selection: Select eXERD> Reverse Engineering menu.

exerd_reverse.PNG

 

 

The reverse engineering wizard is launched. Enter the file name and project name.

exerd_new.PNG

 

 

Check the version of the DB you want to access, and select CUBRID 9.0~9.3 or CUBRID 10.1~10.2 from the target DBMS selection.

select_dbms.PNG

 

 

Enter the database connection information, and click the [Connection Test] button to check the connection.

setting_exerd.PNG

 

 

 

If the connection is successful, you can see the connection test result screen below, and the [Next] and [Finish] buttons are activated.

connection_success.PNG

 

 

Click the [Next] button.

exerd_next.PNG

 

 

 

 

The screen for setting reverse engineering options appears.

option_exerd.PNG

 

  • Item settings include schema, table, view, function, stored procedure, trigger, and domain (user-defined data type), you can select any of them to convert.
  • In the owner setting, you can select from all accessible objects, objects owned by the current accessor, and selection from the schema list.

 

Select the reverse engineering option and click the [Finish] button to see the progress screen.

exerd_status.png

 

 

The diagram creation wizard works in conjunction with the newly added models.

add_diagram.PNG

 

 

The screen for editing individual diagram elements is displayed.

add_diagram2.PNG

 

 

This is the screen where reverse engineering work has been completed.

exerd_result.PNG

 

 

So far, we have introduced eXERD through reverse engineering function. More detailed features are available through Help(H) → Help Contents → eXERD E-R Modeler Guide → Getting Started.

 

Thank you!

 

 


List of Articles
No. Category Subject Date
37 Interfaces Analyzing JDBC Logs with LOG4JDBC 2020.05.21
36 Tools CSQL - Command Line SQL Interpreter 2020.05.12
35 Server CUBRID Backup & Restore – Part I (Backup) file 2020.06.22
34 Server CUBRID Backup & Restore – Part II (Restore) file 2020.06.22
33 Server CUBRID Configuration Guide to Launch Services 2020.06.24
32 Server CUBRID GRANT ALL TABLES file 2020.07.17
31 Server CUBRID HA (High Availability) Starting Guide 2020.05.22
30 Interfaces CUBRID JDBC Tutorial 2020.05.12
29 Server CUBRID Java Stored Procedures file 2020.06.24
28 Server CUBRID Log Files file 2020.06.10
Board Pagination Prev 1 2 3 4 Next
/ 4

Join the CUBRID Project on