A: The “A” in ACID database properties represents Atomicity. Atomicity is described easily using “all or nothing” i.e, if we consider that the database processes the transactions either it should be fully completed or not at all done. If a single task in a transaction fails then the whole transaction fails.
According to this ACID rule, Let us consider two persons John and Bean. When John wants to transfer 1$ from his account to Beans account a Transaction will be performed. This transaction consists of two actions
1, withdrawing 1$ from Johns account.
2, Depositing 1$ to Beans account.
By using this Property, if the deposit action of 1$ to Beans account is failed then withdrawal action from Johns account also should not be done.
Consider that John has 6$ and Bean has 4$ in their accounts. If the ACID property is not met then, when John has started the transfer and in the middle of the transfer from John to Bean if the system fails then 1$ will be withdrawn from the Johns account but 1$ will not be deposited in the Beans account.
4Q: What is the "C" in ACID database properties? Give an example of the use of this property and what might happen if the property is not met.
A: The “C” in the ACID database properties represents consistency. Consistency allows only valid data with rules and constraints enter in to the database. When the transaction accounts to invalid data, then the database returns to its original state before the transaction.
Consider that John has 6$ in his account and Bean has 4$ in his account. Now sum of their accounts is 10$ before the transaction. The use of this pr...
... middle of paper ...
...elp solve the problem?
A: The problem that can be solved by using EXPLAIN QUERY PLAN is optimizing queries. Explain Query plan is helpful in attaining high level description of a plan that is used for the implementation of a specific sql query.
EXPLAIN QUERY PLAN describes in which way that specific query utilizes database indices.
EXPLAIN QUERY PLAN is not at all useful for select query but can be used for the other queries like update, delete etc.
1Q, Why is it useful to have an index that partially sorts a query if it doesn 't present all of the results already sorted?
A: For providing an index to the table in the database system, the index will be partially sorted during the first phase of building it. In the next phases the response to the accessing portions of the index will be done and then sorting the accessed portions of the index will be done in that order.
Need Writing Help?
Get feedback on grammar, clarity, concision and logic instantly.Check your paper »
- Overview The purpose of this report is to examine the idea of transaction management and how it relates to two different database systems that I have chosen for the purpose of the project and for may research. I am also looking at the different elements with regard to transaction management and how each of them work and what they are for in the overall scheme that is transaction management. I will go through the definition of transaction the meaning of transaction how it functions the limitations and restrictions on the access to the user.... [tags: Advanced Database Systems ]
2621 words (7.5 pages)
- Introduction. The introduction of the computer has significantly changed our lives in a very short period of time. Originally the computers were designed to help a person calculate numbers and nowadays a computer allows huge amounts of information to be stored in a small place, calculate mathematical problems easily and communicate with other people via the social networks. Between the 1960’s and the 1970’s emerged different types of databases in order to satisfy the need of storing and retrieving data in an organised and consistent manner.... [tags: Information, Storage, Programming]
996 words (2.8 pages)
- Table of Content No Topic Page 1. Differentiate between database management system and information retrieval system by focusing on their functionalities. 2. Highlight the differences between data and information. 3. Make appropriate use of diagrams to illustrate the underlying concepts/components of database management system and information retrieval system. 4. Differentiate between structured and non-structured data. Give examples for each. 5. Reference Question 1 Database Management System (DBMS) is a program that use by one or more computer users for create and access data to in a database or a set of software tools that control access, organize, store up... [tags: technology, DBMS, programming]
2613 words (7.5 pages)
- Research Report Normalization Database Introduction: Database Normalization is a method of arranging the information in the database. Normalization is an orderly approach of information repetition and undesirable qualities like Insertion, Update and Deletion. It is a multi-step prepare that places information into even shape by expelling copied information from the connection tables. Normalization: Without Normalization, it gets to be hard to handle and redesign the database, without confronting information misfortune.... [tags: Database normalization, Third normal form]
1022 words (2.9 pages)
- Every application in the real world needs to interact with databases. Java Database Connectivity (JDBC) is the Application Programming Interface (API) used to build Java applications that can interact with relational databases. There are many relational databases such as Oracle, My SQL, DB2, Java DB, Dbase, Sybase, Ingress, Informix, FoxPro and so on. The researcher will be able to use the four types of JDBC drivers to interact with any kind of database in the world. In this iteration, the researcher also learns Structured Query Language (SQL) which is the underlying language used long with JDBC API to get things done in backend (a term used to refer database).... [tags: SQL, Database, Database management system]
1365 words (3.9 pages)
- Introduction to NoSQL For storing the data in organized manner we use the traditional relational databases and in these databases the information is stored in the form tables. NoSQL is an abbreviation or a short form for ‘Not only SQL’. Carlo Strozzi in 1998 for the first time used this name to refer their open source relational database, which didn’t exposed its SQL interface. As this was different from the relational databases so on later stage he suggested to name it NoRel (No Relational) instead of NoSQL (Not only SQL).... [tags: Database, SQL, ACID, Data management]
1298 words (3.7 pages)
- Feasibility Report of Database Booking System Summary This document will discuss the feasibility of developing a new database application system at Time 4 Children’s Centre to better mange the booking and recording of user details. The system will have a database of users and employees, and the system will computerise the booking procedure. Background Time 4 is a small government funded charity that provides multi-agency services that are flexible and meet the needs of young children and their families.... [tags: Business Databse Analysis]
1678 words (4.8 pages)
- 4D Database System In the company I work in the program we use was developed specifically for our company. In land development, there are a number of factors that need to be taken in consideration to keep track of lots and blocks within different subdivisions. As well as lots being bought and sold to companies and individuals. The database system we use is called Ginger, a custom database designed to achieve the following objectives for our company: 1. Replace our old database. 2. Combine date from the old database.... [tags: Database Software Data]
1027 words (2.9 pages)
- Database Report Introduction A database contains a collection of information organised in such a way that a computer program can quickly select pieces of data. You can think of a database as an electronic filing system. A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records. For example, a telephone book is analogous to a file. It contains a list of records, each of which To access information from a database, you need a database management system.... [tags: Papers]
2500 words (7.1 pages)
- Database Concepts, what are Databases all about. I am writing this paper to answer a few questions as part of my first assignment in a class designed to provide a better understanding of Database Concepts. There are many different types of databases, different implementations of databases, and different database software applications. So how does all this database stuff work. I have worked with databases for most of my professional career at many different levels. Sometimes as the user, entering data, retrieving information, and compiling reports.... [tags: Database Data]
1204 words (3.4 pages)