-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Daniel,
On 6/3/19 16:26, Davis, Daniel (NIH/NLM) [C] wrote: > I think the sweet spot of Cassandra and Solr should be mentioned > in this discussion. Cassandra is more scalable/clusterable than > an RDBMS, without losing all of the structure that is desirable in > an RDBMS. Amusingly enough, there is also Solandra if you don't want to choose :) https://github.com/tjake/Solandra It's a lot like DataStax. > In contrast, if you use a full document store such as MongoDB, you > lose some of the abilities to know what is in your schema. > > DataStax markets a platform that combines Cassandra (as a > distributed replacement for an RDBMS) that is integrated with Solr > so that records in managed in Cassandra are indexed and > up-to-date. > > If your real problem with an RDBMS is the lack of scaling, but you > like the ability to specify columnar structure explicitly, then > this combination might be a good fit. > > Now, MongoDB is also a strong alternative to an RDBMS. > > The other thing to recall though is that the power of sharding has > reached into the databases themselves, and databases such as > PostgreSQL can operate with some tables sharded and other tables > duplicated. See > https://pgdash.io/blog/postgres-11-sharding.html. Even MySQL and MariaDB -- the most bare-bones solutions in the RDBMS space -- now have clustering available to them, to it's hard to defend an RDBMS solution at this point that does NOT provide clustering, or something similar. - -chris -----BEGIN PGP SIGNATURE----- Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/ iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlz1kA8ACgkQHPApP6U8 pFif4w/+Ph5ZsQdEiVuK96ygWYJcq0x5RzBfrQhQ5oq7IvhdlLzdzwIPilwLZoaO 9/JcwQOUfVo5XNC72mpclg6J+1jhkBuvee7tMqvSA90PLoTmJLft/oeFoBBm374Z 9UAhJgHF/lhcyp00w4L1JjRH+jQzZia3cohi56oeLReKnyHY//EvqzHKNe2TbiPf 7m5jOIiscxmzAMaI2pEBE4gHWUL8rXVG0SVkUbMQYqR+dRj50sOKk3w2lO2akWV/ rLkYD175LAtpQ7qMXU+CAGro2UAIdTXJOtp7yhCquA6T6Vo4BcBsvQ2bGBMDpeld MsnyxzM1hiOZ71DOhyFjfGN9Ivqr1/UijVNsZWazBYtYp9N9/H1l3hl6NlKUVGIF c+pSVWleNAzsO4ShUGJrOkdfv64vRjfK1s/unggAnu/XtyTWKoNV6vxhXwceEYlD 1xVDk8O4ANErXxj4XvQvtgrvBeYOK5sJ5aqn0guN1UIX6Q2gE61bclYwJp9r4NO9 cJjTQedEPdVdRYAz+lDucmSESETQITghhSgub8558BmTSc1PF61f3nAKEYiWrhfN NnxR0dLKY+QOQ5Mo9lX6RSsCYb9x5F8K1jAoy/GSllpnGc88oswquJT/7Vm6R0yX 9YvFI7JsUHfhIwSkV8uupBZ03KJpYgJvXwirBGzV4j7i4M4qr7o= =9ZXf -----END PGP SIGNATURE-----
