A User Interface
for Relational Data

Tables of Data

Whether in finance, engineering, operations, or the life sciences, you are likely working with tables of data in spreadsheets, CSV files, or an external database. Spreadsheets are excellent tools for managing a single table of data. They are a poor fit for database tasks, however, where data must be combined and queried in many different ways.

Ultorg is a general-purpose, graphical user interface for relational databases. That means any data that's organized into tables with rows and named columns. Behind the scenes, Ultorg generates SQL queries that execute either remotely or on your local computer.

Connect to:

• Microsoft Excel Files (.xls/.xlsx)
• Microsoft Access Files (.mdb/.accdb)
• Google Sheets
• CSV/TSV Files
• PostgreSQL
• Microsoft SQL Server
• MySQL/MariaDB
• SQLite*
• Oracle*
• Amazon Athena*
• Exasol*
• Snowflake*

*Experimental support for this SQL dialect.

One-to-Many Relationships

A join between two tables will often involve a one-to-many relationship, where each row in the first table can match multiple rows in the second table.

Ultorg will visualize any combination of one-to-many relationships, in a compact but readable way, using a specially developed system of visual data layouts. Sorting, filters, and formulas can be applied at any level, and joins can be chained or included side-by-side without losing or duplicating rows.

Among visual database tools, Ultorg is unique in its ability to handle one-to-many relationships in a general way.

One-to-many relationships also occur inside database queries, when grouping on fields to calculate sums or averages, or when nesting one query within another. Ultorg will visualize each stage of such data flows.

For example, you can see the individual values that contribute to a group-wise sum. This lets you audit the query visually. You can tweak filters and calculations in the input, while gaining confidence in the aggregated totals.

Dynamic Autolayout

In business or engineering data, or in the social sciences, you may be dealing with hundreds of fields of various data types—text, numbers, and dates—spread across dozens of tables, each with thousands (or millions) of rows.

To retain sanity, it is essential not to have to spend time tweaking formatting settings for each individual field, or for every new database query.

Ultorg eliminates such hard, manual labor, by analyzing your data on-the-fly and deriving carefully tuned defaults. For example, label placements, table column widths, text field dimensions, decimal precision, and pagination are all handled automatically. You can see all your data with fewer keystrokes.

Ultorg's typographical engine can visualize records and one-to-many relationships using a combination of general-purpose strategies, such as nested tables, forms, and crosstabs.

Ultorg's visual data layouts are analogous to the hand-designed user interface screens you might see in traditional, tailored database applications. But in Ultorg, they are available immediately, for any data, without custom programming.