Features

image

Sort

Sort your database table data in either ascending or descending order and by a single column or multiple fields.

image

Search

Search the whole database or individual tables for entries using advanced conditionals if needed.

image

Import/Export

Import or export data that can then be used with a traditional spreadsheet application.

image

Profile

Analyze table columns for patterns, frequency, variation and clustering aspects.

 
 

Plugins


    The Aqjvue Java desktop application is essentially a plugin framework. The plugins identified below are included with the application by default. All plugins are loaded dynamically at run-time from the installation's sub-directory lib/plugins. Any Java JAR file placed in that directory will be scanned for the proper contents that can be identified as an Ajqvue plugin. Once identified the Ajqvue application will attempt to add that plugin as one of the main tabs the user will see on the right hand side of the Ajqvue window. A plugin once loaded may use Ajqvue's assets to obtain connections to the database and of course other routines labeled as public in the API, Application Programming Interface.
    Plugins are not limited to the local file system. A plugin may be loaded also from network sources through the Plugin Management Tool included with the application. Please see the Documentation page to review the tutorial(s) for creating plugins.


image

Heat Mapper

    The HeatMapper derives from an open source GNU project, called, Heat Map. The Heat Mapper plugin continued in line with the basic concept from the Heat Map demo project but aligned the input with a three variable parameter system. The X, Y, plot provided the the two dimension plotting and the third variable Z controlling the color, temperature, displayed. The plugin integrates the data input from a database and the capability to control a multitude of parameters on the plot. As a plugin the mapping can take advantage of various features like drag-n-drop from the SQL Query Bucket.

HeatMapper-2.7.src.tar.gz
HeatMapper-2.7.src.zip

Screenshots - US Zip Codes, Ocean Temperatures, Washington DC Crime Incidents 2012 by Ward


JavaFX Charts

    The JavaFX Charts plugin provides the ability to drag-n-drop queries to a selected chart type and results in the plotting of the data derived from the current database that Ajqvue has a connection to. The chart types support are Line, Bar, Pie, Area, Bubble, and Scatter. The charts were initially derived from Oracle's JavaFX examples provided with the Ensemble application.

JavaFx_Charts-3.2.src.tar.gz
JavaFX_Charts-3.2.src.zip

Screenshots - DC Purchases Computer, 2004-2011 DC Purchase by Agency, 2012-2015 DC Purchase by Agency, 2006-2015 DC Homicides


QueryBuilder

    The QueryBuilder derives from an open source GNU project that was part of code at Sourceforge under the name SQLeonardo. SQLeonardo, by nickyb, like Ajqvue provides a database GUI frontend for several common databases. The QueryBuilder in that application was integrated into the frame work while as part of Ajqvue it is a plugin. The QueryBuilder is a graphical tool that can be used to interactively create SQL statements via a drag and drop type of environment through icons for tables instead of through a text entry method.

QueryBuilder-2.4.src.tar.gz
QueryBuilder-2.4.src.zip

Screenshots - Diagram, Syntax


TableFieldProfiler

    The TableFieldProfiler derives from an open source GNU project that was active at Sourceforge under the name DataProfiler. The DataProfiler, by Arrah Technology, does not appear to have any files to download now, but was a sort of data analysis tool that connected to various databases. The TableFieldProfiler module encompasses aspects of the DataProfiler that gave general information for a database's table fields and also a number and cluster analysis. The information is presented in the form of graphic charts, bar, & pie for the field's record count, distribution, and patterns. The analysis aspect of the profiler gives frequency, variation, percentile, and clustered average information for a field.

TableFieldProfiler-5.8.src.tar.gz
TableFieldProfiler-5.8.src.zip

Screenshots - US Legislators, Record Count, State, US Legislators, Pattern, State. Rural Househould Accounts