Dr. Codd Was Right: Structured Relations

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]

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]

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

[The intelligence community] argued that [the restrictive amendment] would cripple the program because they typically use it before there is enough evidence to meet a standard of probable cause for a warrant, like early in investigations when they are trying to learn more about a phone number or an email account found to be in contact with a suspected foreign spy or terrorist.
-- Charlie Savage/2024 [IOW, let's catch the thief before the horse is out of the barn - the MARF^™(party like it's 1829) traitor's worst nightmare]

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.

29 September 2015

Structured Relations

The McArthur grants hit the news today. Always expecting to see my name. Alas, not this time. Again.

But there was this entry:

Christopher Re, 36, Stanford, California. Stanford University computer scientist, who has created an inference engine, DeepDive, that can analyze data in a way that is beyond the capabilities of traditional databases.

Of course, my first reaction was along the lines of the McArthur folks are pretty stupid, if they think some NoSql mumbo jumbo is stronger than the RM. So off to find DeepDive. This is what I found:

DeepDive helps bring dark data to light by creating structured data (SQL tables) from unstructured information (text documents) and integrate such data with an existing structured database. DeepDive is used to extract sophisticated relationships between entities and make inferences about facts involving those entities.

I didn't get the grant, alas. But the RM won the war. There's satisfaction in that. So, in the end, Codd and Date are right. So, may be, the NoSql folks with all jump off the Golden Gate Bridge; holding hands in failed solidarity.

Dr. Codd Was Right

Vaccinated ≠ Not Infectious

About

Shameless Plug

Extended Pieces

Good Stuff

Followers

Blog Archive

29 September 2015

Structured Relations

No comments: