UCLA researchers build toy version of new query language Prela
Researchers at UCLA's RePL lab are developing Prela, a query language that replaces SQL's multi-column tables with simple binary relations of just two columns. A tutorial shows how a wide table, such as one listing movie IDs, titles and years, can be broken into three binary relations, each pairing a row number with a single column's value, and demonstrates a movie-search query that takes 11 lines in Prela versus more than 20 in equivalent SQL.