0
What are the Advantage and disadvantages of transaction database?
Wiki User
∙ 6y agoWant this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
Explain three disadvantages of centralized database and distributed database?
what are the disadvantages of centralized database system
What is transaction system in dbms?
any change in database is called transaction.
What is a database object that allows you to view or print formatted information but not enter data?
Database transaction
What is a transaction in a data base system?
Like transaction in banks there are transactions in a database system too like deleting data is also a transaction. Transaction can be recovered using rollback and save point.
What is ACID test in application in database system?
The ACID model is one of the oldest and most important concepts of database theory. It sets forward four goals that every database management system must strive to achieve: atomicity, consistency, isolation and durability. No database that fails to meet any of these four goals can be considered reliable.Let's take a moment to examine each one of these characteristics in detail: * Atomicity states that database modifications must follow an "all or nothing" rule. Each transaction is said to be "atomic." If one part of the transaction fails, the entire transaction fails. It is critical that the database management system maintain the atomic nature of transactions in spite of any DBMS, operating system or hardware failure. * Consistencystates that only valid data will be written to the database. If, for some reason, a transaction is executed that violates the database's consistency rules, the entire transaction will be rolled back and the database will be restored to a state consistent with those rules. On the other hand, if a transaction successfully executes, it will take the database from one state that is consistent with the rules to another state that is also consistent with the rules. * Isolation requires that multiple transactions occurring at the same time not impact each other's execution. For example, if Joe issues a transaction against a database at the same time that Mary issues a different transaction, both transactions should operate on the database in an isolated manner. The database should either perform Joe's entire transaction before executing Mary's or vice-versa. This prevents Joe's transaction from reading intermediate data produced as a side effect of part of Mary's transaction that will not eventually be committed to the database. Note that the isolation property does not ensure which transaction will execute first, merely that they will not interfere with each other. * Durability ensures that any transaction committed to the database will not be lost. Durability is ensured through the use of database backups and transaction logs that facilitate the restoration of committed transactions in spite of any subsequent software or hardware failures. Take a few minutes to review these characteristics and commit them to memory. If you spend any significant portion of your career working with databases, you'll see them again and again. They provide the basic building blocks of any database transaction model.
Disadvantages transaction processing Disadvantages of transaction processing systems Advantages of using transaction processing system What are the advantages of transaction processing What ar?
disadvantages of transaction processing system
What are the salient features of deferred database modification and immediate database modification schemes for recovery?
In deffered database the transaction is committed after the transaction is completed i.e(the transaction has completed its partially committed state) where as for immediate database the transaction is commited when tha transaction is in the active state. keta shah Oracle DBA track trainer ITS knp_shah@yahoo.co.in
Explain three disadvantages of centralized database and distributed database?
what are the disadvantages of centralized database system
What is transaction system in dbms?
any change in database is called transaction.
Advantages and disadvantages of centralized database system?
Centralized databases have the advantage of being fast, and easy to manage while information is easy to manage. However, it has its disadvantages as well. All the information must be stored on a server and if that server happens to fail, no one can access the database. Having outside servers can remove this issue.
What are the advantages and disadvantages of RTGS?
There are a few advantages and disadvantages of the RTGS system. One of disadvantages are the gross system been at risk of gridlock from not having enough money. The advantage is having the savings in money to support any payment transaction.
Why database integrity?
Database integrity refers to the safety of data. For example a transaction is made from an account of rs 500 and in between of transaction there is an abrupt , then integrity of data will be maintained and transaction will not occur.
What is a cloud computing database?
A cloud computing database is one in which a user's information is stored remotely for a fee. There are advantages and disadvantages to this. An advantage is that your information can be retrieved from any site, but a downfall is in the security of a user's information.
When was Advantage Database Server created?
Advantage Database Server was created in 1993-08.
Describe the database recovery process and the use of deferred-write and write-through techniques?
deferred-write: The transaction do not immediate update database, instead, only update log file. Then when transaction reach commit point, it will update the physical database. write-through: The database is update right away during the transaction execution.
What is a database object that allows you to view or print formatted information but not enter data?
Database transaction
How do you open adt file?
To open an adt file, you must use an advantage database driven application, server or utilities. .adt file=Advantage database file. Advantage database by Sybase.
