4 ms·
So relational databases are old school, and column stores are all the hip trendy thing, despite throwing away a ton of features?
by collyw 13y ago
So relational databases are old school, and column stores are all the hip trendy thing, despite throwing away a ton of features?
- jlouis 13y agoWell, there are three types of databases: Relational, Columnar, and finally massively distributed. They throw away different feature sets in order to handle a certain subset better. The primary reason Relational databases are so friggin' strong is that they have a solid foundation and maturity. Most new "NoSQL" stuff is immature crap which should never be used in production for any kind of persistent data. But they are being used as such, and I do note that matures the products over time.
- collyw 13y agoTell me about it. I have been hauled into a project, where we are reimplementing a relational database using NoSQL. No idea why, other than the fact that they want to use NoSQL.
- ams6110 13y agoWe are now clearly in a world where many technology journalists are entirely unaware of the history of computing before the year 2,000 or so.
- coldtea 13y agoWorse, we are now clearly in a world where many developers are entirely unaware of the history of computing before the year 2,000 or so. I mean, we had "NoSQL" before we had SQL. Tons of schema-less, hierarchical etc DBs, talking directly to your program and such. Anybody that uses them without massive scaling needs doesn't know his history.
- avz 13y agoRelational databases are not the right choice for large-scale data stores serving large number of users because: - they provide unnecessary features at high cost (e.g. database-wide transactions), - they don't provide features that are essential (e.g. scalability, distribution, graceful degradation). By contrast NoSQL data stores like Bigtable are highly scalable and can easily be stacked over to provide more features if needed (see e.g. Megastore, http://pdos.csail.mit.edu/6.824-2011/papers/jbaker-megastore.pdf http://pdos.csail.mit.edu/6.824-2011/papers/jbaker-megastore...)