Dr. Codd Was Right: Farther on Down the Road

The Kleptocracy of Muskistan Devours You

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

We don't pay taxes; only the little people pay taxes.
-- Leona Helmsley/1989 (or earlier)

[T]he massive push to relocate federal jobs outside the Beltway comes with the risk of kneecapping agencies through the loss of experienced workers and bogging them down in logistical minutia.
-- Curt Devine/2024 [that's the point: make the Damn Gummint incompetent, then destroy it because it's incompetent]

If anyone thinks for one minute the REAL backbone of the right wing and MAGA is gonna stand idly by while these big tech gillionaire Silicon Valley dweebs who didn't get bullied enough in high school, steal our country, they're mistaken.
-- Preston Parra/2024 [It's Still Funny ROTFL; whose ox is getting gored now?]

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

They wrote that in 2001, imatinib [aka, Gleevec, a leukemia drug] was priced at $30,000 (equivalent to $51,622 in 2023) a year, which was based on the price of interferon, then the standard treatment, and that at this price Novartis would have recouped its initial development costs in two years. ... By 2016, the average wholesale price had increased to $120,000 (equivalent to $152,346 in 2023) a year.
-- the wiki [my emphasis, puts recent events in some perspective]

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.

02 August 2017

Farther on Down the Road

The end of the Yellow Brick Road is running R inside the RDBMS. PL/R for Postgres was the first I worked with. The commercial databases offer similar support, but at Big Bucks. Alas. Today we find a new odbc package for R which makes a half-step farther down the Road.

But the real power comes in being able to use high-level functions from the dplyr package and have the data processing run in the database, instead of in the local R session.

If nothing else, this package admits that RDBMS semantics (aka, joins and such) belong there, not in R. Come on guys!! If you can figure out a bastard language like R, SQL is a piece of cake.

Dr. Codd Was Right

The Kleptocracy of Muskistan Devours You

About

Shameless Plug

Extended Pieces

Good Stuff

Followers

Blog Archive

02 August 2017

Farther on Down the Road

No comments: