DIVA

While developers attempt to create complex SQL queries, they are required to view database structure schemes on a regular basis to overview tables and fields names, foreign-key dependencies, and field`s properties. Even, a majority of tools to handle these tasks may become complex and infuriating at times. In such case, DIVA 1.1 can serve the purpose efficiently by providing overview of entire fields of relations and let you find needed relations, and aid you to easily explore tables and fields in 3D, 2.5D, and 2D mode respectively. Database Immersive Visual Analysis (DIVA) is an effective viewer that aids administrators in viewing databases physical structure.

DIVA 1.1 application facilitates your work by displaying any section of the database in several ways such as 2D, 2.5D, or 3D. The tool helps you in understanding connections within tables; query building; DB structure analysis; and DB showcase. It plays a helpful role while you try integrating different DB subsystems, by creating appropriate connections within included tables. The interactive presentation of database structure can be used effectively for meetings, project presentations, or brainstorms. Different features supported by tool lets you work with several database structure aspects such as query building, DB structure analysis, DB showcase, and DDL format. Further with Visualization modes, you get 3D representation covering Layer, Column, Navigation, Circular layer mouse controls, Square layer mouse controls, Square layer model, and Relation analyzer. Whereas 2.5D mode comprises of Legend, Navigation, and List of tables, and 2D mode includes Field markings, Navigation, and Print support. In addition the GUI supports full table info, zoom gauge, search, and bookmarks.

DIVA 1.1 further is compatible to function with CASE systems; different software to create queries; and works with MsSQL, Oracle, and MySQL. Structure design problems relating a database are competently solved with expertise by the program, for which it deserves the rating at 4 points.

DIVA - Database Immersive Visual Analysis: a viewer for databases physical structure that can show you any section of DB in different ways (2D, 2.5D, 3D). Using DIVA users can easily understand connections between tables. It's compatible with: Oracle, MsSQL and MySQL. It can be used with other software for queries creation or with CASE systems. DIVA helps in: query building, DB structure analysis, DB showcase.
- When creating complex SQL queries, developers need to continuously look-up DB structure schemas to overview foreign-key dependencies, table & field names and field's properties. However, today's tools &
methods often poorly support all these micro-tasks. Often it's not possible to obtain a good drawing of a relation's scheme, or they are too big to navigate effectively. In that case, DIVA will give users a big performance boost, because developers can easily overview the whole field of relations in 3D mode, find needed relations in 2.5D mode, and comfortably explore tables & relations in 2D. This manner of
demonstration provides better memorization of the structure.
- Easy and quick understanding of every part of DB structure is needed when developers face problems in structure design of database. Using DIVA such analysis can be made quicker and easier. This is also
valuable when developers need to integrate one DB subsystem with another, and make a proper connections between tables in different subsystems.
- DIVA can be used as interactive illustration for database structure; this can be effectively used in meetings, presentations or brainstorms.
Also, the DIVA interface is quite playful and fun to work with, which turns boring work into fun and creative work.