A bad day for DBAs: MIT boffins are replacing you with a mere spreadsheet

Or at least a database so simple it looks and behaves like a spreadsheet

MIT boffins reckon they've cracked one of the tough nuts of usability, creating an easy-to-use SQL interface for non-database administrators.

The tool, SIEUFERD, has been in gestation since at least 2013 (Oracle mentions it here), but considering the problem it addresses has been around since the 1970s, let's not be harsh about delivery delays.

The problem is this: relational databases are really powerful, but unless you're a DBA, they're also a pain in the neck to use.

Eirik Bakke and David Karger took the covers off there Schema-Independent End-User Front-End for Relational Databases at the recent ACM Sigmod 2016 in this paper (PDF).

The idea is to make query-building responsive and incremental – and in an interface that almost everybody who drones away in the beehives of business has had to learn to use, or die trying: the spreadsheet.

SIEUFERD then pushes the query processing down to the database layer.

As MIT says in this article, which impressively fails to name the tool throughout:

“The tool’s main drop-down menu has 17 entries, most of which — such as “hide,” “sort,” “filter,” and “delete” — will look familiar to spreadsheet users. In the conference paper, Bakke and Karger prove that those apparently simple functions are enough to construct any database query possible in SQL-92, which is the core of the version of SQL taught in most database classes.”

Bakke reckons the user tests he conducted at the MIT Computer Science and Artificial Intelligence Laboratory (CSAIL) showed SIEUFERD was rated as easier to use than Microsoft Access. The user study covered things like formulas, manual joins, field selection and the like.

It's probably easier to see than to describe, so here's some of the images from the presentation.

SIEUFERD example

Bakke et al's basic description of SIEUFERD

SIEUFERD example

How the query builder in SIEUFERD looks like in practice

Other aspects of SIEUFERD that Bakke highlights are that it decouples query and result updates (so for example you don't need to re-run a query when something in the database changes); queries are interruptible; queries are automatically limited (the 1000 returns limit familiar to users of many SQL tools); error handling; and undo/redo support.

Bakke has more to say in the video below; personally, this writer would just like to get his hands on the code. ®

Youtube Video

Keep Reading

The nightmare is real: 'Excel formulas are the world's most widely used programming language,' says Microsoft

So here's LAMBDA to make custom functions out of those formulas

Microsoft kills broad entry-level IT certifications, replaces them with all-Microsoft curriculum

‘Technology Associate’ exams that taught general skills like Python, HTML and Java are on the way out. No refunds offered

Python swallows Java to become second-most popular programming language... according to this index

Coincidentally, Python creator Guido van Rossum joins Microsoft

Foundation thrillogy: Rust programming language gets new home and million-dollar spending account

Mozilla moves Rust under a non-profit foundation

AWS Location Service aims to rescue devs from lock-in with 'business and programming models of a single provider'

Those bitten by Google Maps price rises in 2018 will welcome alternative – but will the data be good enough?

Swift tailored for Windows no longer folklore: Apple's programming language available for Microsoft OS

The Redmond-aligned can try the Cupertino-spawned lingo thanks to a Googler's intervention

A new take on programming trends: You know what's not a bunch of JS? Devs learning Python and Java ahead of JavaScript

O'Reilly's opinionated survey says low-code on the up and modern web dev is 'chilling'

BBC picks SiFive RISC-V chip for Doctor Who programming-for-kids kit – with Jodie Whittaker narrating

Time Lord tapped to introduce youngsters to hardware and coding

Biting the hand that feeds IT © 1998–2021