Relational Database Design And The No Sql Model As The Preferred Basis Of The New Application

935 Words4 Pages
application. Specifically, this report investigates the use of relational database design versus the no-SQL model as the preferred basis of the new application.

The requirements to consider are:
1. Intensive Usage – Facebook has millions of users worldwide and produce billions of transactions.
2. Growth of the application is expected to be 10% per annum.

3.2 Definitions

It is important to look at the key characteristics of these two different models in order to understand the conclusions of this report.

3.2.1 Relational Database Management Systems These systems are characterised by:
• A highly structured design held together by a database schema that consists: o Data pairs are stored as tuples within separate relations that are unique within the relation. o Tuples are identified uniquely with a key. o Tuples of a relation are connected to another tuple(s).
• Retrieval of data is achieved by a declarative programming language – SQL.
• The database is managed by a DBMS that provides for data retrieval (above), storage management, and transaction management.
• Operations are organised into transactions that are "atomic" units that must complete in whole or not at all.

(ref – db concepts and Database Design for Mere Mortals)

3.2.2 No-SQL
It is easier to compare no-SQL systems to the characteristics of traditional relational databases because they have evolved from them. No-SQL models can be characterised by:
• There is no real schema because the design to the

More about Relational Database Design And The No Sql Model As The Preferred Basis Of The New Application

Get Access