Resources

Existing Ultorg users: There is now a public issue tracker with answers to common questions and problems. You are welcome to post your own questions and bug reports there as well!

Tech Talk: Ultorg at the 2022 HYTRADBOI Database Conference

An edited 9-minute presentation and demo of Ultorg, presented at the first online Have You Tried Rubbing a Database On It (HYTRADBOI) conference on April 29, 2022. Ultorg is a general-purpose, graphical database app that connects to existing data in PostgreSQL, CSV files, and other data sources.

Tech Talk: Ultorg—A General-Purpose User Interface for Relational Databases

A longer talk about the Ultorg project, hosted during the pandemic by MIT CSAIL Alliances. "Ultorg's founder and CEO Eirik Bakke proposes a solution to arbitrary relational databases through a single, general-purpose user interface that non-programmers can use to interact with arbitrary relational databases."

Demo Video: Queries from "SQL for Data Scientists"

In this demo, we connect Ultorg to the example database from Renée Teate's freshly released book, SQL for Data Scientists. We then recreate queries from the book using Ultorg's visual query interface.

Demo Video: Which Banks are Still Processing PPP Applications?

In this demo, we use Ultorg to analyze public data about the U.S. government's Paycheck Protection Program, a stimulus package for small businesses. With the program's end date quickly approaching, small businesses will want to apply through banks that are processing applications quickly. We use Ultorg to join data about eligible financial institutions with data about approved PPP applications, to find the banks that approved the most applications in the program's last months, and which might still be accepting applications.

Academic Publications (BibTeX)

Expressive Query Construction through Direct Manipulation of Nested Relational Results
Eirik Bakke. PhD thesis, Massachusetts Institute of Technology, September 2016.

Expressive Query Construction through Direct Manipulation of Nested Relational Results (demo video)
Eirik Bakke and David R. Karger.
SIGMOD 2016: ACM International Conference on Management of Data.

Automatic Layout of Structured Hierarchical Reports (demo video)
Eirik Bakke, David R. Karger, and Robert C. Miller.
InfoVis 2013/IEEE Transactions on Visualization and Computer Graphics.

A Spreadsheet-Based User Interface for Managing Plural Relationships in Structured Data
Eirik Bakke, David R. Karger, and Robert C. Miller.
CHI 2011: SIGCHI Conference on Human Factors in Computing Systems.

The Schema-Independent Database UI: A Proposed Holy Grail and Some Suggestions
Eirik Bakke and Edward Benson.
CIDR 2011: Biennial Conference on Innovative Data Systems Research.