Best Practices for NoSQL Databases

nosby Angela Guess

Wayne Kernochan recently shared his thoughts on NoSQL best practices in Enterprise Apps Today. His list begins, “(1) In many if not most cases, the NoSQL database should be used as a complement to an existing or additional relational database that at the least handles deeper post-arrival data analytics. (2) All else being equal, a NoSQL database that offers a broader range of ‘ACID relaxation’ — if possible, all the way from no consistency to near-ACID-compliance — is better than one that only allows no consistency. IT should plan how it will use and tune that ‘control knob’ up front. (3) If the application is aimed at Fast Data, IT should emphasize support for in-memory computing.  That typically means, among other things, implementing and using Apache Spark.”

He goes on, “I will also add a few suggestions that are less well established as part of a highly effective implementation – understandably, since the Fast Data market only began to take off less than two years ago, and thus “best practices” in that area are not fully developed: (1) ‘Data governance,’ as it is now typically called, should often be implemented at the beginning. One reason is that another hot topic with a misleading title, ‘data lakes,’ involves creating a pool of data that is not subject to the typical ETL (extract-transform-load) data cleansing of today’s analytics database architectures. Data lakes need data governance, and it is likely that some NoSQL data will move immediately into a data lake. Better to ensure NoSQL data governance compliance now, rather than create a situation in which data lake governance becomes ineffective.”

Read more here.

Photo credit: Flickr

We use technologies such as cookies to understand how you use our site and to provide a better user experience. This includes personalizing content, using analytics and improving site operations. We may share your information about your use of our site with third parties in accordance with our Privacy Policy. You can change your cookie settings as described here at any time, but parts of our site may not function correctly without them. By continuing to use our site, you agree that we can save cookies on your device, unless you have disabled cookies.
I Accept