Tools trace patterns of IMAGE databases
July 31, 2013
Is there any program that will show the network of a TurboIMAGE database? I want to output the relationships among sets and items.
In 2011, Connie Sellitto researched the above question, a query posed again just today on the HP 3000 newsgroup. Sellitto was aiding new programmers who were charged with moving a pet organization's operations to a non-MPE system. Understanding the design of the database was important to this team. Sellitto mentioned a popular tool for PCs, but one not as essential as an IT pro's explanations.
You might try Microsoft's Visio, and you may need to have an ODBC connection to your IMAGE database as well. This produces a graphical view with search paths shown, and so on. However, there is still nothing like a detailed verbal description provided by someone who actually knows the interaction between datasets.
To sum up from 2011, we'll refer to ScreenJet founder's Alan Yeo's testing of that Visio-IMAGE interplay
Taking a reasonably well-formed database into Visio and reverse engineering, you do get the tables and items. It will show you what the indexes in the tables are, but as far as I can see it doesn't show that a detail is linked to a particular master. Automasters are missing anyway, as they are really only for IMAGE.
My conclusion: if you have done all the work to load the databases in the SQL/DBE and done all the data type mappings, then importing in Visio might be a reasonable start to documenting the databases, as all you would have to do is add the linkages between the sets.
If you don't have everything in the SQL/DBE, then I would say we are back where we started.
ScreenJet knows quite a bit about moving 3000 engineering into new formats. It built the EZ View modernization kit for 3000 user screens that are still in VPlus. Yeo said the ubiquitous Visio might be overkill for explaining relationships.
Visio has free and open source competition, software which HP support veteran Lars Appel pointed out a few years back. "Perhaps Visio has similar 'database graph' features, such as the free or open source tools like dbVisualizer or SquirrelSQL."
If you have Adager, Flexibase, or DBGeneral -- or already have a good schema file for the databases -- just generate the schema files and import them into Word or Excel and give them to [your migrators]. If they can't put together the data structure from that, no amount of time you can spend with Visio is going to impart any more information.
Barry Lake of Allegro pointed out that users "may want to take a look at Allegro's DBHTML product, which creates a browser viewable HTML file documenting the structure of an IMAGE database." Allegro's site has an example DBHTML output on its website, although it doesn't draw pretty pictures.
At a more fundamental OS level, Michael Anderson points out to understand the structure of a TurboIMAGE database, "you could use QUERY.PUB.SYS, then issue the command FO ALL, or FO SETS."
A few other options for tools came up. Yeo said that "I think there was a schema draw option in Flexibase SQL that drew a neat block diagram of the database and the linkages." And finally, Brian Edminster of Applied Technologies looked through his toolbox and found software written by theKompany, an enterprise founded by former Newswire columnist Shawn Gordon. Edminster reports
There's DataArchitect from theKompany, founded by Shawn Gordon. I bought an early copy of it, and found it useful for satisfying those people at my client's sites that just had to have such a tool to believe that the DBMS was 'industrial strength.'
But alas, Edminster's research showed theKompany.com's website is offline today, and so getting a copy of DataArchitect might be a fruitless pursuit. When a database can outlast the industry-standard (Linux-based) tools that are built to track it, that says something about oldest-school design.