尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
P. Burte, B. Aleman-Meza, D. Brent Weatherly, Rong Wu
                    University of Georgia
                       May 06, 2006
Repsented by :Mohamed Zeinelabdeen
•   In traditional database systems rely on the
    disk subsystem to retrieve and update data
    and use an offline storage device such as
    magnetic tape for backup.
•   In this experiment, a main-memory database
    will use physical memory as primary storage
    and a disk subsystem for backup.
•   A Java object, class Transaction, encapsulates
    all operations that are accessible by a
    database transaction.
•   The data set used for testing had 80 different
    extents. A total of 1,000 Transactions were
    run via 1,000 threads (one transaction per
    thread).
•   Each Transaction executed a fixed number of
    operations on each set of tests , each
    operation involves a single extent, which is
    chosen randomly from the 80 possibilities.
•   Each set of tests was run with different
    percentages of updates/queries.
   The different percentages tested were:
    ◦   0% updates, 100% queries .
    ◦   20% updates, 80% queries.
    ◦   40% updates, 60% queries.
    ◦   60% updates, 40% queries.
    ◦   80% updates, 20% queries.
    ◦   98% updates, 2% queries .
   For each of these tests, the following information was
    recorded:
    ◦ time taken for completion of all the transactions.
    ◦ average number of times a transaction needed to wait for
      an extent used by other transaction.
    ◦ number of transactions aborted because of a detected
      Deadlock .
   Each of the tests was run several times to in order to
    obtain an average for each value.
   Transaction performance is measured in
    two areas:
   the throughput for transaction
    completion.
   the average number of times a
    transaction goes to 'wait' state because it
    is unable to obtain a lock on a resource.
   Transaction throughput is measured by
    taking the total number of transactions
    attempted, subtracting the number of
    transactions that were aborted because of
    deadlock, and dividing by the time required
    to complete the test.
•   For the set of tests executing only one
    operation per transaction, the number of
    wait-states increased slowly for percentages
    of updates under 60%.
•   For percentages of updates over 60%, the
    number of wait-states increased rapidly.
•   For the set of tests executing 1 to 5
    operations per transaction, the number of
    wait-states increased with the percentage of
    updates increasing.
   for deadlock detection, the test results were
    as expected. The number of aborted
    transactions because of a detected deadlock
    increases as the percentage of updates
    increases.
   no deadlock occurs if all transactions contain
    a single operation on a single extent.
   From this experiment, Inferred performance
    tests show our implementation is promising
    an average throughput of two hundred and
    thirty transactions per second for a thousand
    single-operation transactions is a good start.

More Related Content

Similar to Transaction management for a main memory database

Transaction Management, Concurrency Control and Deadlocks.pdf
Transaction Management, Concurrency Control and Deadlocks.pdfTransaction Management, Concurrency Control and Deadlocks.pdf
Transaction Management, Concurrency Control and Deadlocks.pdf
beshahashenafe20
 
Summit 16: StorPerf: Cinder Storage Performance Measurement
Summit 16: StorPerf: Cinder Storage Performance MeasurementSummit 16: StorPerf: Cinder Storage Performance Measurement
Summit 16: StorPerf: Cinder Storage Performance Measurement
OPNFV
 
Concurrency Control in Distributed Systems.pptx
Concurrency Control in Distributed Systems.pptxConcurrency Control in Distributed Systems.pptx
Concurrency Control in Distributed Systems.pptx
MArshad35
 
Process management in Operating System_Unit-2
Process management in Operating System_Unit-2Process management in Operating System_Unit-2
Process management in Operating System_Unit-2
mohanaps
 
How to use Twitter in your trading strategies?
How to use Twitter in your trading strategies?How to use Twitter in your trading strategies?
How to use Twitter in your trading strategies?
The NAGA Group AG
 
Performance tuning Grails applications
 Performance tuning Grails applications Performance tuning Grails applications
Performance tuning Grails applications
GR8Conf
 
An Adaptive Hybrid Technique approach of Test Case Prioritization
An Adaptive Hybrid Technique approach of Test Case PrioritizationAn Adaptive Hybrid Technique approach of Test Case Prioritization
An Adaptive Hybrid Technique approach of Test Case Prioritization
INFOGAIN PUBLICATION
 
Performance testing
Performance testingPerformance testing
Performance testing
Jyoti Babbar
 
Lean in fishing net
Lean in fishing netLean in fishing net
Lean in fishing net
Ilyas Hussain
 
Implementation of Banker’s Algorithm Using Dynamic Modified Approach
Implementation of Banker’s Algorithm Using Dynamic Modified ApproachImplementation of Banker’s Algorithm Using Dynamic Modified Approach
Implementation of Banker’s Algorithm Using Dynamic Modified Approach
rahulmonikasharma
 
Implementation of Banker’s Algorithm Using Dynamic Modified Approach
Implementation of Banker’s Algorithm Using Dynamic Modified ApproachImplementation of Banker’s Algorithm Using Dynamic Modified Approach
Implementation of Banker’s Algorithm Using Dynamic Modified Approach
rahulmonikasharma
 
Low latency for high throughput
Low latency for high throughputLow latency for high throughput
Low latency for high throughput
Peter Lawrey
 
Need for Speed: How to Performance Test the right way by Annie Bhaumik
Need for Speed: How to Performance Test the right way by Annie BhaumikNeed for Speed: How to Performance Test the right way by Annie Bhaumik
Need for Speed: How to Performance Test the right way by Annie Bhaumik
QA or the Highway
 
Test talk academy apachejmeter-120521121306-phpapp02
Test talk academy apachejmeter-120521121306-phpapp02Test talk academy apachejmeter-120521121306-phpapp02
Test talk academy apachejmeter-120521121306-phpapp02
veeru madduri
 
Fundamentals Performance Testing
Fundamentals Performance TestingFundamentals Performance Testing
Fundamentals Performance Testing
Bhuvaneswari Subramani
 
1675091151425_Process Management Risk.pptx
1675091151425_Process Management Risk.pptx1675091151425_Process Management Risk.pptx
1675091151425_Process Management Risk.pptx
ZerayacobTeklearegay
 
Key steps in transforming a calibration program slideshare
Key steps in transforming a calibration program slideshareKey steps in transforming a calibration program slideshare
Key steps in transforming a calibration program slideshare
John Cummins, CPIP
 
13680904.ppt
13680904.ppt13680904.ppt
13680904.ppt
Muhammad Athar
 
IBM impact-final-reviewed1
IBM impact-final-reviewed1IBM impact-final-reviewed1
IBM impact-final-reviewed1
Priya Thinagar
 
Ask the Expert: Lean Leadership - Can We Talk About OEE?
Ask the Expert: Lean Leadership - Can We Talk About OEE?Ask the Expert: Lean Leadership - Can We Talk About OEE?
Ask the Expert: Lean Leadership - Can We Talk About OEE?
MileyJames
 

Similar to Transaction management for a main memory database (20)

Transaction Management, Concurrency Control and Deadlocks.pdf
Transaction Management, Concurrency Control and Deadlocks.pdfTransaction Management, Concurrency Control and Deadlocks.pdf
Transaction Management, Concurrency Control and Deadlocks.pdf
 
Summit 16: StorPerf: Cinder Storage Performance Measurement
Summit 16: StorPerf: Cinder Storage Performance MeasurementSummit 16: StorPerf: Cinder Storage Performance Measurement
Summit 16: StorPerf: Cinder Storage Performance Measurement
 
Concurrency Control in Distributed Systems.pptx
Concurrency Control in Distributed Systems.pptxConcurrency Control in Distributed Systems.pptx
Concurrency Control in Distributed Systems.pptx
 
Process management in Operating System_Unit-2
Process management in Operating System_Unit-2Process management in Operating System_Unit-2
Process management in Operating System_Unit-2
 
How to use Twitter in your trading strategies?
How to use Twitter in your trading strategies?How to use Twitter in your trading strategies?
How to use Twitter in your trading strategies?
 
Performance tuning Grails applications
 Performance tuning Grails applications Performance tuning Grails applications
Performance tuning Grails applications
 
An Adaptive Hybrid Technique approach of Test Case Prioritization
An Adaptive Hybrid Technique approach of Test Case PrioritizationAn Adaptive Hybrid Technique approach of Test Case Prioritization
An Adaptive Hybrid Technique approach of Test Case Prioritization
 
Performance testing
Performance testingPerformance testing
Performance testing
 
Lean in fishing net
Lean in fishing netLean in fishing net
Lean in fishing net
 
Implementation of Banker’s Algorithm Using Dynamic Modified Approach
Implementation of Banker’s Algorithm Using Dynamic Modified ApproachImplementation of Banker’s Algorithm Using Dynamic Modified Approach
Implementation of Banker’s Algorithm Using Dynamic Modified Approach
 
Implementation of Banker’s Algorithm Using Dynamic Modified Approach
Implementation of Banker’s Algorithm Using Dynamic Modified ApproachImplementation of Banker’s Algorithm Using Dynamic Modified Approach
Implementation of Banker’s Algorithm Using Dynamic Modified Approach
 
Low latency for high throughput
Low latency for high throughputLow latency for high throughput
Low latency for high throughput
 
Need for Speed: How to Performance Test the right way by Annie Bhaumik
Need for Speed: How to Performance Test the right way by Annie BhaumikNeed for Speed: How to Performance Test the right way by Annie Bhaumik
Need for Speed: How to Performance Test the right way by Annie Bhaumik
 
Test talk academy apachejmeter-120521121306-phpapp02
Test talk academy apachejmeter-120521121306-phpapp02Test talk academy apachejmeter-120521121306-phpapp02
Test talk academy apachejmeter-120521121306-phpapp02
 
Fundamentals Performance Testing
Fundamentals Performance TestingFundamentals Performance Testing
Fundamentals Performance Testing
 
1675091151425_Process Management Risk.pptx
1675091151425_Process Management Risk.pptx1675091151425_Process Management Risk.pptx
1675091151425_Process Management Risk.pptx
 
Key steps in transforming a calibration program slideshare
Key steps in transforming a calibration program slideshareKey steps in transforming a calibration program slideshare
Key steps in transforming a calibration program slideshare
 
13680904.ppt
13680904.ppt13680904.ppt
13680904.ppt
 
IBM impact-final-reviewed1
IBM impact-final-reviewed1IBM impact-final-reviewed1
IBM impact-final-reviewed1
 
Ask the Expert: Lean Leadership - Can We Talk About OEE?
Ask the Expert: Lean Leadership - Can We Talk About OEE?Ask the Expert: Lean Leadership - Can We Talk About OEE?
Ask the Expert: Lean Leadership - Can We Talk About OEE?
 

More from Mohamed Zeinelabdeen Abdelgader Farh jber

الآثار الأخلاقية المترتبة على الملكية الفكرية في أفريقيا
الآثار الأخلاقية المترتبة على الملكية الفكرية في أفريقياالآثار الأخلاقية المترتبة على الملكية الفكرية في أفريقيا
الآثار الأخلاقية المترتبة على الملكية الفكرية في أفريقياMohamed Zeinelabdeen Abdelgader Farh jber
 
Comparison of the workflow management systems bizagi, process maker, and joget
Comparison of the workflow management systems bizagi, process maker, and jogetComparison of the workflow management systems bizagi, process maker, and joget
Comparison of the workflow management systems bizagi, process maker, and joget
Mohamed Zeinelabdeen Abdelgader Farh jber
 
Comparison of the workflow management systems bizagi, process maker, and joget
Comparison of the workflow management systems bizagi, process maker, and jogetComparison of the workflow management systems bizagi, process maker, and joget
Comparison of the workflow management systems bizagi, process maker, and joget
Mohamed Zeinelabdeen Abdelgader Farh jber
 
Black & White Box testing
Black & White Box testingBlack & White Box testing
Workflow Management Systems Comparison Study
 Workflow Management Systems Comparison Study Workflow Management Systems Comparison Study
Workflow Management Systems Comparison Study
Mohamed Zeinelabdeen Abdelgader Farh jber
 
Transaction management transparencies
Transaction management transparenciesTransaction management transparencies
Transaction management transparencies
Mohamed Zeinelabdeen Abdelgader Farh jber
 
Embedded systems1
Embedded systems1Embedded systems1
B trees
B treesB trees
Web servers
Web serversWeb servers
Requirements engineering
Requirements engineeringRequirements engineering
Online Msc Application Workflow Management System
Online Msc Application Workflow Management SystemOnline Msc Application Workflow Management System
Online Msc Application Workflow Management System
Mohamed Zeinelabdeen Abdelgader Farh jber
 
DISTRIBUTED DATABASE
DISTRIBUTED DATABASEDISTRIBUTED DATABASE

More from Mohamed Zeinelabdeen Abdelgader Farh jber (13)

الآثار الأخلاقية المترتبة على الملكية الفكرية في أفريقيا
الآثار الأخلاقية المترتبة على الملكية الفكرية في أفريقياالآثار الأخلاقية المترتبة على الملكية الفكرية في أفريقيا
الآثار الأخلاقية المترتبة على الملكية الفكرية في أفريقيا
 
موزع البريد الرقمي
موزع البريد الرقمي موزع البريد الرقمي
موزع البريد الرقمي
 
Comparison of the workflow management systems bizagi, process maker, and joget
Comparison of the workflow management systems bizagi, process maker, and jogetComparison of the workflow management systems bizagi, process maker, and joget
Comparison of the workflow management systems bizagi, process maker, and joget
 
Comparison of the workflow management systems bizagi, process maker, and joget
Comparison of the workflow management systems bizagi, process maker, and jogetComparison of the workflow management systems bizagi, process maker, and joget
Comparison of the workflow management systems bizagi, process maker, and joget
 
Black & White Box testing
Black & White Box testingBlack & White Box testing
Black & White Box testing
 
Workflow Management Systems Comparison Study
 Workflow Management Systems Comparison Study Workflow Management Systems Comparison Study
Workflow Management Systems Comparison Study
 
Transaction management transparencies
Transaction management transparenciesTransaction management transparencies
Transaction management transparencies
 
Embedded systems1
Embedded systems1Embedded systems1
Embedded systems1
 
B trees
B treesB trees
B trees
 
Web servers
Web serversWeb servers
Web servers
 
Requirements engineering
Requirements engineeringRequirements engineering
Requirements engineering
 
Online Msc Application Workflow Management System
Online Msc Application Workflow Management SystemOnline Msc Application Workflow Management System
Online Msc Application Workflow Management System
 
DISTRIBUTED DATABASE
DISTRIBUTED DATABASEDISTRIBUTED DATABASE
DISTRIBUTED DATABASE
 

Recently uploaded

Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdfLee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
leebarnesutopia
 
QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...
QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...
QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...
AlexanderRichford
 
APJC Introduction to ThousandEyes Webinar
APJC Introduction to ThousandEyes WebinarAPJC Introduction to ThousandEyes Webinar
APJC Introduction to ThousandEyes Webinar
ThousandEyes
 
Introducing BoxLang : A new JVM language for productivity and modularity!
Introducing BoxLang : A new JVM language for productivity and modularity!Introducing BoxLang : A new JVM language for productivity and modularity!
Introducing BoxLang : A new JVM language for productivity and modularity!
Ortus Solutions, Corp
 
Fuxnet [EN] .pdf
Fuxnet [EN]                                   .pdfFuxnet [EN]                                   .pdf
Fuxnet [EN] .pdf
Overkill Security
 
Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!
Tobias Schneck
 
Facilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptxFacilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptx
Knoldus Inc.
 
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to SuccessMongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
ScyllaDB
 
Demystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through StorytellingDemystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through Storytelling
Enterprise Knowledge
 
Day 2 - Intro to UiPath Studio Fundamentals
Day 2 - Intro to UiPath Studio FundamentalsDay 2 - Intro to UiPath Studio Fundamentals
Day 2 - Intro to UiPath Studio Fundamentals
UiPathCommunity
 
Guidelines for Effective Data Visualization
Guidelines for Effective Data VisualizationGuidelines for Effective Data Visualization
Guidelines for Effective Data Visualization
UmmeSalmaM1
 
Introduction to ThousandEyes AMER Webinar
Introduction  to ThousandEyes AMER WebinarIntroduction  to ThousandEyes AMER Webinar
Introduction to ThousandEyes AMER Webinar
ThousandEyes
 
ThousandEyes New Product Features and Release Highlights: June 2024
ThousandEyes New Product Features and Release Highlights: June 2024ThousandEyes New Product Features and Release Highlights: June 2024
ThousandEyes New Product Features and Release Highlights: June 2024
ThousandEyes
 
Session 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdfSession 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdf
UiPathCommunity
 
Elasticity vs. State? Exploring Kafka Streams Cassandra State Store
Elasticity vs. State? Exploring Kafka Streams Cassandra State StoreElasticity vs. State? Exploring Kafka Streams Cassandra State Store
Elasticity vs. State? Exploring Kafka Streams Cassandra State Store
ScyllaDB
 
MySQL InnoDB Storage Engine: Deep Dive - Mydbops
MySQL InnoDB Storage Engine: Deep Dive - MydbopsMySQL InnoDB Storage Engine: Deep Dive - Mydbops
MySQL InnoDB Storage Engine: Deep Dive - Mydbops
Mydbops
 
Mutation Testing for Task-Oriented Chatbots
Mutation Testing for Task-Oriented ChatbotsMutation Testing for Task-Oriented Chatbots
Mutation Testing for Task-Oriented Chatbots
Pablo Gómez Abajo
 
Must Know Postgres Extension for DBA and Developer during Migration
Must Know Postgres Extension for DBA and Developer during MigrationMust Know Postgres Extension for DBA and Developer during Migration
Must Know Postgres Extension for DBA and Developer during Migration
Mydbops
 
Poznań ACE event - 19.06.2024 Team 24 Wrapup slidedeck
Poznań ACE event - 19.06.2024 Team 24 Wrapup slidedeckPoznań ACE event - 19.06.2024 Team 24 Wrapup slidedeck
Poznań ACE event - 19.06.2024 Team 24 Wrapup slidedeck
FilipTomaszewski5
 
From NCSA to the National Research Platform
From NCSA to the National Research PlatformFrom NCSA to the National Research Platform
From NCSA to the National Research Platform
Larry Smarr
 

Recently uploaded (20)

Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdfLee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
 
QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...
QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...
QR Secure: A Hybrid Approach Using Machine Learning and Security Validation F...
 
APJC Introduction to ThousandEyes Webinar
APJC Introduction to ThousandEyes WebinarAPJC Introduction to ThousandEyes Webinar
APJC Introduction to ThousandEyes Webinar
 
Introducing BoxLang : A new JVM language for productivity and modularity!
Introducing BoxLang : A new JVM language for productivity and modularity!Introducing BoxLang : A new JVM language for productivity and modularity!
Introducing BoxLang : A new JVM language for productivity and modularity!
 
Fuxnet [EN] .pdf
Fuxnet [EN]                                   .pdfFuxnet [EN]                                   .pdf
Fuxnet [EN] .pdf
 
Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!
 
Facilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptxFacilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptx
 
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to SuccessMongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
 
Demystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through StorytellingDemystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through Storytelling
 
Day 2 - Intro to UiPath Studio Fundamentals
Day 2 - Intro to UiPath Studio FundamentalsDay 2 - Intro to UiPath Studio Fundamentals
Day 2 - Intro to UiPath Studio Fundamentals
 
Guidelines for Effective Data Visualization
Guidelines for Effective Data VisualizationGuidelines for Effective Data Visualization
Guidelines for Effective Data Visualization
 
Introduction to ThousandEyes AMER Webinar
Introduction  to ThousandEyes AMER WebinarIntroduction  to ThousandEyes AMER Webinar
Introduction to ThousandEyes AMER Webinar
 
ThousandEyes New Product Features and Release Highlights: June 2024
ThousandEyes New Product Features and Release Highlights: June 2024ThousandEyes New Product Features and Release Highlights: June 2024
ThousandEyes New Product Features and Release Highlights: June 2024
 
Session 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdfSession 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdf
 
Elasticity vs. State? Exploring Kafka Streams Cassandra State Store
Elasticity vs. State? Exploring Kafka Streams Cassandra State StoreElasticity vs. State? Exploring Kafka Streams Cassandra State Store
Elasticity vs. State? Exploring Kafka Streams Cassandra State Store
 
MySQL InnoDB Storage Engine: Deep Dive - Mydbops
MySQL InnoDB Storage Engine: Deep Dive - MydbopsMySQL InnoDB Storage Engine: Deep Dive - Mydbops
MySQL InnoDB Storage Engine: Deep Dive - Mydbops
 
Mutation Testing for Task-Oriented Chatbots
Mutation Testing for Task-Oriented ChatbotsMutation Testing for Task-Oriented Chatbots
Mutation Testing for Task-Oriented Chatbots
 
Must Know Postgres Extension for DBA and Developer during Migration
Must Know Postgres Extension for DBA and Developer during MigrationMust Know Postgres Extension for DBA and Developer during Migration
Must Know Postgres Extension for DBA and Developer during Migration
 
Poznań ACE event - 19.06.2024 Team 24 Wrapup slidedeck
Poznań ACE event - 19.06.2024 Team 24 Wrapup slidedeckPoznań ACE event - 19.06.2024 Team 24 Wrapup slidedeck
Poznań ACE event - 19.06.2024 Team 24 Wrapup slidedeck
 
From NCSA to the National Research Platform
From NCSA to the National Research PlatformFrom NCSA to the National Research Platform
From NCSA to the National Research Platform
 

Transaction management for a main memory database

  • 1. P. Burte, B. Aleman-Meza, D. Brent Weatherly, Rong Wu University of Georgia May 06, 2006 Repsented by :Mohamed Zeinelabdeen
  • 2. In traditional database systems rely on the disk subsystem to retrieve and update data and use an offline storage device such as magnetic tape for backup. • In this experiment, a main-memory database will use physical memory as primary storage and a disk subsystem for backup. • A Java object, class Transaction, encapsulates all operations that are accessible by a database transaction.
  • 3. The data set used for testing had 80 different extents. A total of 1,000 Transactions were run via 1,000 threads (one transaction per thread). • Each Transaction executed a fixed number of operations on each set of tests , each operation involves a single extent, which is chosen randomly from the 80 possibilities. • Each set of tests was run with different percentages of updates/queries.
  • 4. The different percentages tested were: ◦ 0% updates, 100% queries . ◦ 20% updates, 80% queries. ◦ 40% updates, 60% queries. ◦ 60% updates, 40% queries. ◦ 80% updates, 20% queries. ◦ 98% updates, 2% queries .  For each of these tests, the following information was recorded: ◦ time taken for completion of all the transactions. ◦ average number of times a transaction needed to wait for an extent used by other transaction. ◦ number of transactions aborted because of a detected Deadlock .  Each of the tests was run several times to in order to obtain an average for each value.
  • 5. Transaction performance is measured in two areas:  the throughput for transaction completion.  the average number of times a transaction goes to 'wait' state because it is unable to obtain a lock on a resource.
  • 6. Transaction throughput is measured by taking the total number of transactions attempted, subtracting the number of transactions that were aborted because of deadlock, and dividing by the time required to complete the test.
  • 7.
  • 8. For the set of tests executing only one operation per transaction, the number of wait-states increased slowly for percentages of updates under 60%. • For percentages of updates over 60%, the number of wait-states increased rapidly. • For the set of tests executing 1 to 5 operations per transaction, the number of wait-states increased with the percentage of updates increasing.
  • 9.
  • 10. for deadlock detection, the test results were as expected. The number of aborted transactions because of a detected deadlock increases as the percentage of updates increases.  no deadlock occurs if all transactions contain a single operation on a single extent.
  • 11.
  • 12. From this experiment, Inferred performance tests show our implementation is promising an average throughput of two hundred and thirty transactions per second for a thousand single-operation transactions is a good start.
  翻译: