Dr. Codd Was Right: To Serve R

The Kleptocracy of Muskistan Devours You

The world is not linear.
-- Dr. McElhone/1974

Well, I'm going to do it, whether the women like it or not. I'm going to protect them.
-- The Orange Shitgibbon^©anon./2024 [y'all get burkhas]

Scientists aren't vocal enough about science. There are large groups of people who think scientists are all frauds and who don't believe in science, and they're being cultured by some of our far right-wing politicians, religious leaders and community leaders.
-- Drew Weissman/2022

To date, Microsoft is stating that organizations testing In-Memory OLTP have seen transaction speeds improve by up to 30 times compared to past performance, with the best performance gains achieved when the business logic resides in the database and not in the applications.
-- Jonathan Watts/2015 [my emphasis]

I have had to explain and re-explain and re-explain and re-explain, you know, how relational databases work, what is an eigenvector, what is dimensionality reduction.

-- Christopher Wylie/2018

... but Flash-based storage has such a different performance profile from rotating media, that I suspect that it will end up having a large impact on filesystem design. Right now, most filesystems tend to be designed with the latencies of rotating media in mind.

-- Linus Torvalds/2007

I believe quite strongly that, if you think about the issue at the appropriate level of abstraction, you're inexorably led to the position that databases must be relational.

-- Chris Date/2009

This Week's thought

In fact, the number of full-time federal workers has been relatively static, within a few hundred thousand civilians, since the 1960s. ... [C]ontractors frequently end up costing the government more money.
-- Zachary B. Wolf/2024 [ya know, like The Musk Ox]

See you next week in a brand new show^{©Heckle and Jeckle}

Therefore:

In a time of SSD, multi-core/processor, two terabyte memory and Optane App Direct Mode machines, there is no reason not to build from BCNF data. Time to do what Dr. Codd demonstrated. Technology has finally caught up with the maths.

11 May 2015

To Serve R

A post on simple-talk regarding R and SQL Server in the usual R-session through ODBC/etc. connection to SQL Server moved me to comment that the other way 'round would be something to brag about. Not so snarky, but you get the drift. A comment was posted today saying "heard that R will be integrated with SQL Server 2016". Very cool.

And, it's true!!! Well, M$ says that's what's going to happen.

new in-database analytics with R integration.

Not too surprising, given that M$ bought Revolution Analytics, a value-add (semi-)proprietary version of R. The question which remains is whether the integration will run only with RA/R or with OS/R? All things considered, I'll bet (for now) that only the closed version of R will be supported. Still, for the SS crowd, at some price, things are looking up.

Yahoo.

Dr. Codd Was Right

The Kleptocracy of Muskistan Devours You

About

Shameless Plug

Extended Pieces

Good Stuff

Followers

Blog Archive

11 May 2015

To Serve R

No comments: