Re:The Next 50 Years of Databases (2015)
by carlineng on Monday November 11, 2019 @09:17PM
(#21510934)
This would be amazing, but it's an open question in my mind if it's possible to have a system that works sufficiently well for both OLTP and OLAP use cases at large scale. HTAP systems today are still very raw, and it intuitively feels like we'll be bumping into the Pareto frontier, where optimizing for analytics use cases can only come at the expense of transactional performance.
Re:The Next 50 Years of Databases (2015)
by georgewfraser on Tuesday November 12, 2019 @01:52AM
(#21512064)
You’re not going to run your analytical queries off your production DB once you have more than a couple users writing ad-hoc queries. And you probably don’t won’t to replicate your salesforce/ads/clicks into your prod db. So you’re going to create a replica. So why does it matter if the replica is a different type of database than prod?
Re:The Next 50 Years of Databases (2015)
by hinkley on Tuesday November 12, 2019 @12:37PM
(#21516067)
Do any current databases support replicas with heterogeneous indexes? It seems like that would greatly reduce this problem.
Google Cloud Spanner kind of does what you want.
We spend so much time and energy copying data around into specific data stores to solve specific problems / answer specific questions / enable specific features... It's messy, complex, and adds a ton of overhead.
It could simplify a lot of technology if an operational database could also handle non-trivial analytical workloads.