Kiev, Ukraine (PressExposure) June 09, 2009 -- Introduction DIVA - is a software for database developers, programmers and analysts who work with various databases on daily basis. DIVA is a viewer of database physical structure, it can show you any section of DB in several usable and easy forms (2D, 2.5D, 3D). In this way user can easily understand dependency between tables.
Area of usage You can use DIVA with various database management systems (DBMS), like Oracle, MsSQL and MySQL. DIVA was designed to fill the gap of structural understanding for DB developers; it can be used with other software related to queries creation or with CASE systems.
DIVA use export script (SQL / DDL) from database to build interactive DB model, this allow user to view database offline, while not being connected to them directly.
We claim that most valuable impact user can get with DIVA located in following areas: - Query building - DB structure analysis - DB showcase
Query building When creating complex SQL queries developer needs to continuously look-up to DB structure schema to overview foreign-key dependencies, table & field names, and field's properties. However, in today's tools & methods all these micro-tasks, quite poorly supported. Often it's not possible to obtain good drawing of relation's scheme, or they are too big to navigate effectively.
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. Also DIVA interface is quite playful and fun to work with, which is good to make monotone work more creative.
DB structure analysis Easy and quick understanding for every part of DB structure is needed when developer face problems in his / her database structure design. Using DIVA such analysis can be made quicker and easier. This is also valuable when developer needs to integrate one DB subsystem with another, and make proper connections between tables in different subsystems. You still can print-out 2D views, for further exploration or for documentation.
DB showcase DIVA can be used as interactive illustration for database structure; this can be effectively used on meetings, presentations or brainstorms.