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 […]

A Different Kind of Easy

Posted on Posted in Coding, Cool Bugs

Putting into words when something will happen is easier than calculating it. This is nothing new. Since 325 CE, Christian Easter falls on “the Sunday after the ecclesiastical full moon.” Easy words for hard numbers. Even “next business day shipping ” can be hard to crunch. To a human it is easy; “Tomorrow is New […]

Whorfianism

Posted on Posted in Coding, The Company

The Sapir-Whorf hypothesis (or principle of linguistic relativity) holds that language affects its speakers cognitive process and world view (neo-Whorfianism). Some hold this true even for programming languages, assuming coding in some language implies thinking in that language. K.E. Iverson, inventor of APL, argued that more powerful notations aided alogorithmic thinking (ACM Turing Award Lecture). […]

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 […]

Understanding Time

Posted on Posted in Coding, Designing A Language

With behavioral data, time plays a very important role. Yet, time-related data is especially hard to analyze. The main culprit is the fact that time concepts are confusing. While humans can handle time intuitively, passing these intuitions to a computer program is hard. For example, implementing a growth rate using a relative duration of “twelve […]

A Swiss-Army Knife

Posted on Posted in Big-Data Blab

Data analysts often use a chain of 3 to 4 tools to achieve a single task. For example, first they query the database to extract aggregated data. Then they import it into Excel to do some more processing. Next, they move to R, to run some statistical analyses. Then they go back to Excel to […]

Rax/MySQL vs. Rax/Azure vs. Rax/Redhift

Posted on Leave a commentPosted in Rax

Our SQL-backend family is contantly growing. Rax could already connect to SQLite, MySQL and PostgreSQL databases. Recently we have also ported Rax to two major cloud databases: Microsoft Azure and AWS Redshift. Now we can easily compare the performance of various database systems on behavioral data. Before Rax it was difficult, as each database vendor […]