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.
- Microsoft Excel Files (.xls/.xlsx)
- Microsoft Access Files (.mdb/.accdb)
- Google Sheets
- CSV/TSV Files
- Microsoft SQL Server
- Amazon Athena*
*Experimental support for this SQL dialect.
A join is a fundamental database operation that combines data from two different tables, based on a common identifier such as "Room Number" or "Customer ID". Joins are frequently needed when working with multi-table datasets.
In Ultorg, you can quickly join data from multiple tables or data sources, and interact with the result through a single, spreadsheet-like data manipulation surface.
For SQL-based data sources, Ultorg will recognize existing foreign key relationships, and suggest relevant joins. Or you can join on arbitrary fields, e.g. to combine data from a spreadsheet and a CSV file.
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.
SQL Without SQL
At first glance, Ultorg's direct manipulation interface resembles a spreadsheet. The tabular layout you see on the screen, however, represents a real database query, which can be refreshed and modified without risking changes to the underlying raw data.
A visual query lets you see exactly the data you need for a particular business task, without descending into a code editor, form designer, or flow chart. Even for database experts, Ultorg will serve as a rapid alternative to hand-typed SQL.
Most SELECT queries that can be written in the core SQL language have a visual equivalent in Ultorg. For example, you can express arbitrary combinations of joins, filters, calculations, and subqueries.
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.
Create, Read, Update, Delete
With appropriate permissions, you can also edit data stored in an external relational database.
The Data Editing mode can be entered from any visual query. You can then edit values in individual cells, or insert or delete rows, like in a spreadsheet. Ultorg will show edits in a pending state, so that you can review all changes before committing them to the database. Pressing Apply Edits, you will see the new data reflected in all open queries.
For internal business operations, Ultorg can serve as an alternative to custom CRUD interfaces, or to spreadsheet-based recordkeeping.