Sometimes, when people talk about OSMO®, they talk about RAW data being transferred directly from accounts package to the lender’s system. This couldn’t be further from the truth.

Here’s the science…Normalization is the word coined by E.F.Codd (who conceived of the relational model) and his colleagues to refer to the organization of the logical structure of a database so as to facilitate ad-hoc query as well as data update.

In a 1993 interview with DBMS magazine, Codd stated that he got the inspiration for this phrase in 1972 when he read about President Nixon “normalizing relations” with China. (Codd used the word “Relation” as a synonym for “Table”.) It implies “logical” (proper) design of a database with minimal redundancy of data.

Normalization is therefore the process of efficiently organising data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.

“What does this mean for me”, I hear you ask? When you receive data from OSMO®, rules and tables are checked automatically, ensuring you receive PURE data. Now, that is stacking the chips in your favour.