Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
You may use the phrase "snapshot isolation" as an illustration of how a
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- For the sake of this demonstration, let's suppose a database for an airline that implements "snapshot isolation." There is a potential that Airline will consent to a non-serializable execution if doing so would result in enhanced overall performance.arrow_forwardUsing an airline-managed database with "snapshot isolation" is probably the best way to get the most out of this example. A non-serializable execution may have been responsible for increasing overall performance of the airline, rather than a serializable execution.arrow_forwardThis example could be better if it started with an airline's database that uses "snapshot isolation." What if a non-serializable action made the airline's general performance worse instead of better?arrow_forward
- A good example of a database that benefits from snapshot isolation is an airline's reservation system. The airline could be willing to accept non serializable execution if it means greater overall performance.arrow_forwardFor example, consider a database for an airline that uses snapshot isolation. To achieve greater overall performance, the airline may be willing to accept nonserializable execution.arrow_forwardConsider a database used by an airline, where "snapshot isolation" is used. It's possible that airlines might be willing to accept a non-serializable solution if it meant better overall performance.arrow_forward
- To illustrate how "snapshot isolation" may be used in the context of creating an airline database, consider the following scenario. If airlines can improve their overall performance, then maybe a non-serializable system might be acceptable.arrow_forwardAlthough you always wanted to be a dog trainer, you ended up being an expert on databases because you love to work with data and logic. Your old love is still there, however, so you set up a database company, DogTraining, that builds a product for dog kennels. The core of this product is a database with a schema that captures all the information that kennels need to maintain. Kennels keep information about dog trainers, the First and Last names of the dog trainers (which are unique), birthplace, color of the dog trainers hair, and style of training. For each dog, the trainer, the date the dog was born, a name (not unique), the type of dog (e.g., Brittany, German Shepard, Collie, etc.), color of the dog’s hair, and how much weighs must be stored. Dogs are also classified into groups of various kinds, for example, hunting, guard, working; a given dog may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, kennels…arrow_forwardThis example might be improved by starting with a database maintained by an airline that employs "snapshot isolation." What if, rather of increasing the airline's overall performance, a non-serializable execution did so?arrow_forward
- A database used by an airline that implements "snapshot isolation" serves as an excellent starting point for this example. What if a non-serializable execution results in a better overall performance for the airline?arrow_forwardLet's look at an airline database to see how snapshot isolation is used in practice. The airline, for instance, could agree to a nonserializable execution if it means better long-term outcomes.arrow_forwardTake the case of a snapshot-isolated database used by an airline. I was wondering if you could provide me an example of a non-serializable execution that the airline would be prepared to tolerate in exchange for improved performance.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education