Software in 2014

We’re at an in­flec­tion point in the prac­tice of con­struct­ing soft­ware. Our tools are good, our server de­vel­op­ers are happy, but when it comes to build­ing client-side soft­ware, we re­ally don’t know where we’re going or how to get there.

via ongoing by Tim Bray · Software in 2014.

BayesDB

INFER salary FROM mytable WHERE age > 30;

Fill in missing data with the INFER command. Unlike a traditional regression model, where you need to separately train a supervised model for each column you’re interested in predicting, INFER statements are flexible and work with any set of columns to predict.

via BayesDB.

Dimensional Modeling Techniques – Kimball Group

Ralph Kimball introduced the data warehouse/business intelligence industry to dimensional modeling in 1996 with his seminal book, The Data Warehouse Toolkit.  Since then, the Kimball Group has extended the portfolio of best practices.Drawn from The Data Warehouse Toolkit, Third Edition, the “official” Kimball dimensional modeling techniques are described on the following links and attached .pdf:

via Dimensional Modeling Techniques – Kimball Group.