Neo’s NoSQL Graph Database

by Chris S

I have done my last 2 blogs on NoSQL databases and have introduced what they are and why they are becoming more and more popular. One particular type that was recently released by Neo Technologies was the Neo4j, which is a NoSQL graph type database. Graph data model, nodes with type relationships are joined across nodes. They attach a key value pairs to nodes and their relationships, relying more on pointers than indexes. What join allows is the ability to hop from one entity to another. Specifically a join is a CPU-bound operation that merges the criteria between the two tables. Therefore, by having a direct pointer instead of an index or merge, you end up with huge increases in performance. The Neo4j database is java based and has no SQL layer, but proves to be useful when wanting to take part of a database and use a graph database. read more...

Read more

NoSQL Databases

by Chris S
Databases come in all types, from Relational Database Management Systems to Database warehouses. The RDBMS has been the most popular out of the bunch, but a new database has been gaining favor amongst businesses. NoSQL is the new database type that has been drawing lots of attention. It uses techniques that were not so fitting with the traditional SQL. The big difference is in how NoSQL functionality provides better data storage and retrieval. Technology in general will always have its pros and cons. NoSQL, however, has some interesting advantages. The big advantage to NoSQL database is that administrators will not have to “scale up” as data storage increases. The elasticity of NoSQL allows it to expand transparently to services new nodes that are added to it. Cloud servers are another example of admins not having to increase hardware size to meet big data needs. Big data is one reason why many companies are looking for new ways to handle the massive amounts of data stored on RDBMS. As businesses thrive and collect more data, the RDBMS may not be the best fit for storing decades of data and transaction logs. Everything about these new databases outweighs what RDBMS can do. Unfortunately, NoSQL databases are designed to require very little management, creating a decrease in demand for Database Administrators. That doesn’t mean DBAs will no longer be needed, but companies can cut back on the costs for such skilled individuals. NoSQL databases also cost less to store and retrieve data then typical RDBMS, since they utilize other servers to manage data and transactions. read more...

Read more