News & Events

NoSQL Vs Relational Database – Whats best?

There has always been the age old question of which is best, NoSQL or Relational Databases (well since database have been around). Here’s what we we think…

NoSQL Database

The term NoSQL Database embraces a myriad of different database technologies that were originally developed in response to a rise in the volume of data stored about users, objects and products, the frequency in which this data is accessed, and performance and processing needs. By reducing the reliance on full CAP (Brewers) Theorem (Consistency, Availability, Partition tolerance) which results in ACID based consistency (Atomic, Consistent, Isolated, Durable) they inherently scale-out extremely well thus are able to take full advantage of commodity based low cost hardware.

Relational Database

Relational databases, on the other hand, were not designed to cope with the scale and agility challenges that face modern applications, nor were they built to take advantage of the cheap storage and processing power available today. Hence they tend to be monolithic in terms of their scalability. i.e. exceptionally good at vertical scaling but extremely poor due to their BASE consistency model (Basic Availability, Soft-state, Eventual consistency) at horizontal or scale-out capabilities.

There’s no right answer to whether your application needs an ACID versus BASE consistency model. Developers and data architects should select their data consistency trade-offs on a case-by-case basis – not based just on what’s trending or what model was used previously.

This is where we use our consultancy services and leverage our experience in the field of both relational and NoSQL database technologies to help you make the right decision.

Get in touch

For more information or to schedule a demo please contact us

Contact us

News

DSP winners at the UK Oracle User Group Awards 2017/18

DSP attended the UK Oracle User Group Partner of the Year Awards last week, and we came away with awards for both categories in which we were nominated

Read more
View All

Event

"Self Managing Databases: Fable, Fantasy or the Future"

Join us for lunch and to hear some war stories from staff and customers with experience of Oracle Database Cloud Service. We'll also understand more about the Autonomous Database and how Oracle will compete with AWS.

Read more
View All

Blog

Migrating to Cloud? Meet Oracle Bitesize.

My last blog post focused on WHY businesses should consider modernisation, specifically by migrating to Oracle cloud. Now you’ve decided to start your move, make it easy with Oracle Bitesize.

Read more
View All