Rax 1.1 released

Posted on Posted in Rax

We are happy to announce that Rax 1.1 is avalaible from today! This release contains many stability and performance improvements. Most importantly: Added r’years and a’weeks magic tags to relative duration. Added a sample \ operator for sets: some_set\10 will list random 10 elements of some_set. In explorative analytics scenarios this is handy as it’s […]

R comes to SQL Server

Posted on Posted in Rax, SQL Rants

Database vendors understand that SQL, while great for simple queries, is not a good enough interface for complex analytics. Here at Coders’Co. we would say: use Rax :-). Since R so popular among data scientists, though, many database vendors attempt to somehow integrate R into their technology. This post is the beginning of a series […]

Sessionization with Temporal Union

Posted on Posted in Big-Data Blab, Rax

A common problem in web analytics is sessionization or session reconstruction: taking a series of user events and splitting the series into a set of sessions [1]. Often, it is done based solely on the timestamps of the events: a session ends after a certain time of user inactivity. As an example, let’s take the […]

Welcome Snowflake

Posted on Posted in Big-Data Blab, Coding, Rax

Snowflake Computing has recently emerged from stealth with a bold claim of having reinvented the data warehouse. Ease of use is their main motto and I dare to say they live up to this promise. Since one of Snowflake’s co-founders, Marcin ┼╗ukowski, is a good friend of mine, I’ve got a chance to play with […]

Rax/MySQL vs. Rax/Azure vs. Rax/Redshift

Posted on Posted in Coding, Rax, SQL Rants

Our SQL-backend family is contantly growing. Rax could already connect to SQLite, MySQL and PostgreSQL databases. Now we have also ported Rax to two major cloud databases: Microsoft Azure and AWS Redshift. The port to Azure gave us some headache due to problems with their ODBC driver for Linux. The port to Redshift was straightforward, […]

Write Once, Run Everywhere – Rax SQL Backends

Posted on Posted in Big-Data Blab, Coding, Rax, SQL Rants

Rax is running atop an SQL-based relational database backend, translating data-heavy operations into SQL queries. Actually, there are several SQL backends that Rax can use. Rax syntax and functionality are not dependent on the backend used. In other words, Rax/Redshift can execute exactly the same Rax code as Rax/MySQL and Rax/Azure. The subtle differences between […]

What Is Rax?

Posted on Posted in Big-Data Blab, Rax

Rax (Relational Algebra with eXtensions) is a scripting language for behavioral-data exploration. The language is a mix of relational, regular, and temporal algebra and is designed to facilitate the transition from ETL to data modeling. Rax empowers data analysts to explore behavioral data in a way that feels intuitive and familiar. Rax shares some features […]

Graphics and Plotting in Rax

Posted on Posted in Rax

Rax contains a number of built-in graphical procedures ranging from simple ones, like `line to complete charting procedures, like `scatterplot. The set of simple or primitive graphical procedures is modelled on PostScript: Rax has procedures which manipulate the current graphical state, such as `setrgbcolor,`setlinewidth, `translate/`scale or `gsave/`grestore, path construction procedures (`newpath, `moveto, `lineto, etc.), and […]