Developing Data Migrations and Integrations with Salesforce: Patterns and Best Practices

© David Masri 2019

David MasriDeveloping Data Migrations and Integrations with Salesforcehttps://doi.org/10.1007/978-1-4842-4209-4_1

1. Relational Databases and Normalization

David Masri¹ 

(1)

Brooklyn, NY, USA

 

In today’s world of big data, it’s easy to forget just how much of the world’s systems run on relational databases. But the fact remains, relational databases still dominate the data space.¹ There is good reason for this: They work incredibly well, particularly when dealing with structured, well-defined data.

As the Internet became prevalent, the need to scale up and big became more common. People began to think about alternatives to relational databases to make scaling easier; thus, the “NoSQL” movement was born.² During the mid 2000s, there ...