Most enterprise applications are supported by a robust database platform that could be hosted in the internal data centres or the cloud. Decision support and transaction processing applications have very different characteristics. What are the key considerations that an enterprise architect must make in order to design database platforms for these two types of enterprise applications?
Answer
Some of features that should be in these two databases are:
1. Security
The first and foremost thing in any database is security, In case of transcational database security is of primary concern.
2. Ensuring data integrity
Transactional databases are therefore critical for business transactions where a high-level of data integrity is necessary. Transactional databases are architected to be ACID compliant, which ensures that writes to the database either succeed or fail together, maintaining a high level of data integrity when writing data to the database.
3. Low latency
Because transactional databases are designed to run production systems, they’re very good at operations that must complete in milliseconds. If you’re doing analytics on a transactional replica of your production database, the replica will likely be nearly in sync with the master database (i.e. sub-second latency).