Changes to the community structure and the menu bar
Significant changes have happened to the structure of our community and our drop down menu bar. READ ABOUT IT HERE
Big Data
cancel

Embedded databases: Free does not always mean inexpensive

Embedded databases: Free does not always mean inexpensive

BigData_Guest

When you set out to build an application, what deliberations do you take when considering a database? The de facto choice has slowly moved over time from a commercial MPP database with the shift to NoSQL open source databases. It sounds great, right? No license fees! No support fees! A community of people to collaborate! 

pexels-photo-164527.jpegThere’s no doubt that there are some benefits from using open source, but let’s be clear - “free” does not always mean inexpensive. You often hear people use the analogy that “NoSQL / open source is free like a puppy.” It starts out as a wonderful idea, but it also requires a lot of care and feeding over time. If you do not choose the right database for your application, the same principles could apply. NoSQL databases are not designed to support complex reporting and analytics workloads. While many NoSQL databases can execute fast queries, complex queries with multiple users and tables become an issue.

On the flipside, a NoSQL could work for you. The data structures used by NoSQL databases (e.g. key-value, wide column, graph, or document) are different than those of a relational database. This could provide faster queries depending on your needs.

Should you embed a NoSQL or SQL database into your application? Sponsored by HPE Vertica, the Eckerson Group has created a "Rate my data" assessment to determine just that.  Considering many factors from organization to query needs, this assessment will provide you with a suggestion on what will meet your needs. You can also read a whitepaper with their findings.

0 Kudos
About the Author

BigData_Guest