Aglowsoft SQL Query Tools is the key product developed by
K C Siaw. It includes 3 database tools. They are Aglowsoft Schema Tool,
Aglowsoft Designer, and Aglowsoft Browser. The tools are designed to allow building of SQL queries
with basic knowledge of SQL using user friendly interface. Result sets from SQL queries are
presented in a combination form of tree views and table views.
Tree view can be printed or exported to an XML file or an LDIF file, and table view can be exported to ODBC database table, Access 2000 database, XML or HTML format.
A key feature of Aglowsoft SQL Query Tools is the ability to build SQL
queries in the form of view definition tree, where a path in the view
definition tree discloses relationships between data from different
tables. Aglowsoft SQL Query Tools works with any OLE DB and ODBC-compliant database. SQL statements
supported include SELECT, INSERT, UPDATE, and DELETE.
The program includes Unicode support, support for ANSI inner and outer joins, entity relationship diagram,
and DDL Generation for relationships.
Aglowsoft Schema Tool is a component of Aglowsoft SQL Query Tools. It is a database
tool used for capturing the meta data from OLE DB and ODBC databases. Aglowsoft Schema Tool
also allows the user to improve and manage the information in the meta data that
has been captured.
The extracted schema is saved to a file which is called SHM (Schema ) file. User
can further refine the captured meta data by defining primary keys, entity relationships,
and column aliases. Nothing is changed in the given OLE DB or ODBC data source as the extracted
and refined schema data are saved to external SHM (Schema) file. The table
columns, primary keys, relationships, and column aliases will be used by
Aglowsoft Designer to build SQL queries.
Aglowsoft Designer is a component of Aglowsoft SQL Query Tools. It is a modeling
tool used for creating view definition tree. The view definition tree contains 3
different kinds of node types, namely the Label node, the Tree node, and the Table
node. Each node type is a view definition node. The view definition tree is a collection
of view definition nodes. Aglowsoft Designer saves the results of the view definition
tree to a view definition file (VDF).
The Label node is simply a static node, where you give a meaningful name to the Label.
It can have descendants. A label node can include other label nodes, tree nodes
or table nodes.
It has a URL attribute associated with it, where you can optionally assign a URL
to the Label. You can also optionally specify a User-Defined SQL.
The Tree node is a definition node that has a SQL query associated with it. The display
columns of the SQL query results are displayed in the tree. A tree node can have
descendants, which can be other tree nodes, label nodes or table nodes.
The Table node is a definition node that has a SQL query associated with it. It has
no descendants. The display columns of the SQL query results are displayed in the
table pane, which is the right pane in the Aglowsoft Browser.
Aglowsoft Browser is a component of Aglowsoft SQL Query Tools used
for navigating the View Definition Files (VDF) and OLE DB/ODBC database tables/views. It provides rich
features for customizing how user would want to view the SQL result sets
shown in the tree view and table panes.
Aglowsoft SQL Query Tools Online User's Guide