1.1. Area of usage
We claim that most valuable impact user can get with DIVA located in following areas:
1.1.1. Query building
In this case, DIVA will give user big performance boost, because developer can easy overview whole field of relations in 3D mode, find needed relations in 2.5D mode, and comfortably explore tables & relations in 2D.
The way of demonstrating all this information, ensures that it will be better memorized.
1.1.2. DB structure analysis
You still can print-out 2D views, for further exploration or for documentation.
1.2. DDL format
Every modern DBMS have built-in exporters in DDL format, which is quite often named as SQL in export utilities. DDL (Data Definition Language) is the part of SQL (Structured Query Language) standard. DDL defines all structural information and data itself.
Example of table declaration in DDL (Oracle example):
Refer to your database management tool in order to export your database structural data!
DDL have its own dialects, which are used by different DBMS, currently DIVA has a great support of Oracle and Microsoft SQL dialects. There is also MySQL support in development; you can use MySQL export scripts with DIVA, however parsing of such DDL still can be buggy.
When exporting, choose to export only structural data (tables and keys), choose option to make only external declarations of foreign keys, and save script in non Unicode text format.
External declaration of foreign key made by “alter table” & look like this (Oracle example):
Frequent issues, and how to solve them (read carefully!):
1. Loading of big DDL script can take a long period of time (on old PC's this can be a minute or two), be patient, DIVA is working, give it a time.
2. If, after loading your DDL you will notice that all tables are in place, but there are no foreign-keys - this mean that you saved DDL in Unicode format. To correct this - easiest way is to open your DDL script with notepad, copy all text from it, paste in new notepad window and save it in new txt file as ANSI text. Then open this new file - all foreign-keys must be in place!
In future, to obtain data via DDL file, we plan to add an option for online connection to database.