“We use a variety of NoSQL databases in a polyglot persistence model,” said Brian Roy, director of products at Zephyr Health. “We firmly believe that the primary lesson to be learned from the NoSQL movement is that no one database is appropriate across a wide range of use cases. Ultimately, this was the fatal flaw in the relational-database-for-everything approach.”
FairCom’s de Oliveira agreed, underscoring today’s need for performance.
“If you’re at the point where the service level is critical, don’t rely on complex SQL queries,” he said. “You have options available to handle it differently.”