On: HBase Deprecation at Pinterest

[dehrmann]

The SQL world calls this an "index."

[winrid → dehrmann]

No. Most NoSQL dbs support indexes and secondary indexes too.

In SQL world we call this "denormalization". It's called the same thing in NoSQL, too.

[dehrmann → winrid]

Indices are essentially managed denormalization.

[winrid → dehrmann]

Ah, never thought of it that way.

[llm_trw → winrid]

It's called materialized views.

[winrid → llm_trw]

Well, yes, and no. :)

[badpun → dehrmann]

Indices are no good if you constantly do large amounts of inserts or updates (say, entire clickstream of a popular global site) - keeping them up to date will massively slow down the inserts/updates. Wheresas, in NoSQL, you can do as inserts as quickly as your disk can write data, and still query the dataset as if it had an index.

[winrid → badpun]

That has nothing to do with whether the DB is relational or not.

[badpun → winrid]

Which relational databases can simultaneously do milions of updates and milions of selects per second, to the same table?

[etc-hosts → dehrmann]

I am attempting to reach enlightenment by contemplating your wisdom.