It may come as a surprise to you to know that Relational Databases may become a

Question

It may come as a surprise to you to know that Relational Databases may become a thing of the past. The whole reason for the existence of Oracle is because data has been and is currently held on disk drives. It takes a great program to find the quickest way possible to create, read, update, and delete data. It only takes two things to make these problems go away: solid-state memory and transactional databases. Your assignment is to explore how transactional databases work, and why they will eventually replace relational databases. The company to watch is Datomic (www.datomic.com). Have fun.

Explanation / Answer

Lets see how transactional database works:-

- Transactional data are data describing an event.
- It mostly described with verbs.
- It always has a time dimension, numeric value and refers to one or more objects.
- The transactional database works using the ACID rule of thumb, this four rules are:-

1. Atomacity - It does not dependent on previous and following transactions.
2. Consistent - Data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t.
3. Isolation - No transaction sees the intermediate results of current transaction.
4. Durability - The values persist if the data was committed even if the system crashes after.

Now coming to the relational database i.e why transactional database is replace with relational database:-
- Relational database used to manage transaction oriented applications i.e OLTP.
- It usually works with structured data.
- The reason for the use of relational databases are: simplicity, performance, flexibility, robustness, scalability and compatibility in managing generic data.
- There is an built-in and fool proof method of ensuring the business logic and rules at database layer.
- For an instance that a withdrawal is charged to the correct bank account, through primary keys and foreign keys.
- In key-value stores, this responsibility falls squarely on application logic.
- This is one of the reason why relational databases will continued to be used.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.