Relational databases have been at the top of the database programming world for almost 50 years. They were invented by E.F. Codd while working at IBM's San Jose Research Laboratory. Non-relational databases also known as NoSQL databases are the new wave of formless data stores that don't use any schema (formless). They work with all kinds of data including data collected from smart city IoT sensors. The four main ones that have a solid user interface and an online free trial are.
www.RavenDB.com - Raven is a document datastore NoSQL database, that is entirely schema-less meaning no primary and foreign key relationships are required. Raven has an easy-to-use user interface and many functions for new database developers. RQL Raven querying languages is the database programming language used to write, read, update and delete records.
www.Aerospike.com - If transactions are your main goal then Aerospike is the right choice. Aerospike delivers speed when you need to access important read or write functions on credit card reports. AirospikeDB can handle acid transactions more efficiently than most relational databases since it was designed to do this.
www.Neo4j.com - Neo4j is a NoSQL graph database that is truly a winner in the non-relational database world. Ne04j is used in many of the most popular websites and applications since the data can be visualized in graphs with nodes.
www.datastax.com - Cassandra's datastax astra is a serverless NoSQL multimodule Column-Oriented database owned by parent company Facebook now Meta. CQL with an almost SQL a-like syntax is the database programming language used to write, read, update and, delete records. API's access is also made available through API services like GrapghQL, Swagger and, Document.
A few others worth a look at are MongoDB and FirebaseDB a document store by Google. For new beginners in the world of non-relational database technology, I would recommend these. However this technology is very new so don't be scared off and choose the best one that meets your App development needs. My last point is that relational databases stack vertically (scale-up) while non-relational databases stack horizontally (scale-out). Each option has its advantages and disadvantages i.e. costs less or more electrical power used.
Top comments (0)