MongoDB shares jump more than 30% in $192M IPO

Re:MongoDB shares jump more than 30% in $192M IPO by flukus on Thursday October 19, 2017 @06:43PM (#15512160)

> EAVT is great as an intermediate format but it is absolutely useless to query for since most of the time you are trying to find a set of attributes for a given entity i.e. full table scan.

This is what indexes are for. An index on the entity id should avoid any full table scans.

[ Parent | on HN ]

Re:MongoDB shares jump more than 30% in $192M IPO by threeseed on Thursday October 19, 2017 @11:30PM (#15513365)

EAVT table with 100 million entities and 10000 attributes = one trillion row table.

And you want to build indexes on half the table ?

Good luck with that.

[ Parent | on HN ]

Re:MongoDB shares jump more than 30% in $192M IPO by flukus on Thursday October 19, 2017 @11:51PM (#15513443)

> Often with most of the values set to null.

Your math is at odds with your own requirements, null values don't need a row.

[ Parent | on HN ]

Re:MongoDB shares jump more than 30% in $192M IPO by threeseed on Friday October 20, 2017 @01:02AM (#15513635)

You clearly don't understand what you're talking about.

Sparcity is an issue for the wide table not the EAVT form.

[ Parent | on HN ]