Question

Part A: Database research (approx. 200-250 words):

Research Question: Explore history of database systems and discuss the three most important developments in database development history to date. (1.25 marks each)

Note: Use proper references in the APA style. Your research report must be well presented using proper content organization. (1.25 marks)

Answer 1

Answer is as follows :

Database is collection of various type of data which is accessed from computer system so the data can be organised properly.

As per given scenario the most important developments in database development history are as follows :

Relational DBMS - In 1970, Edgar Codd described a new system for storing and working with large databases. Instead of using any data structure like array or linked list, he used to use tables of fixed length records.

Accordingly there are multiple tables in database which represents a particular entity and multiple be merged to get data from multiple tables.

It is easy to maintain database and insertion, deletion and updation gets easy with the help of tables.

In later 1970, SQL was introduced based on the Codd's Concepts

Object Oriented - In 1990, with rise in Object Oriented Programming, it is measured that how data can be handled in various databases. So programmers used to treat database as object and it examines the relation between various objects instead of relation with attributes.

So Object Databases and Object Relational databases helps to solve translation between program objects and database tables by providing object oriented language to database.

By using Object Oriented concepts programmers can use purely relational SQL.

NO SQL and NEW SQL - In 2000s No SQL concept is introduced, no SQL databases are fast, do not require any fixed length tables, avoid join operations. So from here, programmers can operate very large databases easily and more efficiently.

No SQL also provides both availability and partition tolerance with reduced level of data consistency.(Before only one can be provided from Availability and Partition tolerance)

New SQL is totally based on No SQL but provides the scalable performance for transaction processing workloads.

So according to me these are best database improvements of database development history.

If there is any query please ask in comments..