For some time, years in fact, this endeavor has banged the drum for R in database. PL/R on Postgres was the choice for quite a while. Now we have R in SQL Server, and more publicly as time goes on.
Thanks to the folks at simple-talk, we get a link to this piece. With SQL Server soon to be standard product on linux (if not exorbitantly priced), we all get to do this sort of thing.
Despite what the reactionaries assert, the world is not flat nor is it hierarchical. The world is relational. Infinite granularity yields infinite complexity.
Vaccinated ≠ Not Infectious
$536,800,000 MARF™(party like it's 1829)
-- New York Slammers, so far/2024 [GA and The Feds still to come]
-- New York Slammers, so far/2024 [GA and The Feds still to come]
Covid-19 has killed at least 1,123,836 people (as of 20 March 2023, final update)
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]
-- 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
-- Chris Date/2009
This week's thought
Investigative reporters are an idiosyncratic breed of journalist. Typically fearless, they are often a source of angina to their editors. Mr. Walsh was no exception. -- Michael S. Rosenwald/2024 [no surprise - I spent a bit of time on Jack Anderson's staff]
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.
About
- Robert Young
- Been doing databases, both relational and others, as well as operations research since Hector was a Pup.
Shameless Plug
I know a little something about SQL, DB2 (preferably LUW, z/OS if the money's right), Oracle, SQL Server, Postgres, and database design in general. Mentoring/teaching/consulting on a short term basis, too. And a bit of stat analysis if it's R.
gnuoytr at rcn dot com.
gnuoytr at rcn dot com.
Extended Pieces
Good Stuff
Followers
Blog Archive
-
▼
2017
(193)
-
▼
January
(17)
- Stupid Is As Stupid Does
- Betting Line
- R.U.R. for Our Times
- Thought for The Day - 25 January 2017
- Damn You Kellyanne!
- If It Walks Like a Duck
- The Asymptote of Progress - part the first
- Addicted to Big Data
- Pig Latin
- Thought for The Day - 19 January 2017
- The Death of The Financial Quant
- Thought For The Day - 11 January 2017
- The Real Villian
- It's Always The Arithmetic
- It Had to Happen
- Equal and Opposite Reaction
- Thought For The Day - 5 January 2017
-
▼
January
(17)
No comments:
Post a Comment