Re:SAML Is Insecure by Design
by paulmd on Thursday August 05, 2021 @09:16PM
(#28082166)
these days if you are modeling the "sparse, high-dimensional data" of the kind that EAV schema does well, you probably should be reaching for JSON columns instead of EAV schema.
[ Parent
| on HN ]
Re:SAML Is Insecure by Design
by jiggawatts on Thursday August 05, 2021 @11:06PM
(#28082855)
Some databases support "sparse columns", which use EAV under the hood but are better optimised: https://docs.microsoft.com/en-us/sql/relational-databases/ta...
Thanks, I forgot about that! :)
Isn't that the problem that these "columnar store" DBs address?
A bunch of dictionaries containing UUID/data, where each dimension is its own dict, and the dicts might or might not be running on the same system?