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

Why Encryption is Key in the Event of a Data Breach

The summer of 2018 will be remembered for its record-breaking heatwave, England reaching the semi-finals of the World Cup and, for professionals in almost all areas of business, the long-awaited adoption of the General Data Protection Regulation (GDPR) across the EU. In the space of just a few short months, cybersecurity has gone from a tick- box exercise, somewhat far down the list of competing priorities faced by every business, to fighting for pole position amid swirling tabloid headlines warning of huge fines and plummeting share prices for organisations who suffer a data breach.

Read more
View All