Scheduling real-time transactions with disk resident data
VLDB '89 Proceedings of the 15th international conference on Very large data bases
Priority in DBMS resource scheduling
VLDB '89 Proceedings of the 15th international conference on Very large data bases
Scheduling real-time transactions: a performance evaluation
ACM Transactions on Database Systems (TODS)
Multiversion concurrency control—theory and algorithms
ACM Transactions on Database Systems (TODS)
Priority Inheritance Protocols: An Approach to Real-Time Synchronization
IEEE Transactions on Computers
Scheduling Real-time Transactions: a Performance Evaluation
VLDB '88 Proceedings of the 14th International Conference on Very Large Data Bases
Managing Memory to Meet Multiclass Workload Response Time Goals
VLDB '93 Proceedings of the 19th International Conference on Very Large Data Bases
Service Differentiation in Real-Time Main Memory Databases
ISORC '02 Proceedings of the Fifth IEEE International Symposium on Object-Oriented Real-Time Distributed Computing
A method for transparent admission control and request scheduling in e-commerce web sites
Proceedings of the 13th international conference on World Wide Web
Workload-Aware Load Balancing for Clustered Web Servers
IEEE Transactions on Parallel and Distributed Systems
Improving Preemptive Prioritization via Statistical Characterization of OLTP Locking
ICDE '05 Proceedings of the 21st International Conference on Data Engineering
Toward a theory of transactional contention managers
Proceedings of the twenty-fourth annual ACM symposium on Principles of distributed computing
Getting priorities straight: improving Linux support for database I/O
VLDB '05 Proceedings of the 31st international conference on Very large data bases
Multi-Server Queueing Systems with Multiple Priority Classes
Queueing Systems: Theory and Applications
Web servers under overload: How scheduling can help
ACM Transactions on Internet Technology (TOIT)
Provisioning servers in the application tier for e-commerce systems
ACM Transactions on Internet Technology (TOIT)
On the effect of inexact size information in size based policies
ACM SIGMETRICS Performance Evaluation Review
ACM SIGMETRICS Performance Evaluation Review
Evolutionary Function Approximation for Reinforcement Learning
The Journal of Machine Learning Research
Managing energy-performance tradeoffs for multithreaded applications on multiprocessor architectures
Proceedings of the 2007 ACM SIGMETRICS international conference on Measurement and modeling of computer systems
Performance impacts of autocorrelated flows in multi-tiered systems
Performance Evaluation
Adaptive quality of service management for enterprise services
ACM Transactions on the Web (TWEB)
Incrementally parallelizing database transactions with thread-level speculation
ACM Transactions on Computer Systems (TOCS)
Scheduling despite inexact job-size information
SIGMETRICS '08 Proceedings of the 2008 ACM SIGMETRICS international conference on Measurement and modeling of computer systems
OLTP through the looking glass, and what we found there
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
A case for flash memory ssd in enterprise database applications
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Modeling and exploiting query interactions in database systems
Proceedings of the 17th ACM conference on Information and knowledge management
A class-based scheme for E-commerce web servers: Formal specification and performance evaluation
Journal of Network and Computer Applications
Efficient application placement in a dynamic hosting platform
Proceedings of the 18th international conference on World wide web
Optimizing i/o-intensive transactions in highly interactive applications
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
NCQ vs. I/O scheduler: Preventing unexpected misbehaviors
ACM Transactions on Storage (TOS)
Towards Autonomic Service Provisioning Systems
CCGRID '10 Proceedings of the 2010 10th IEEE/ACM International Conference on Cluster, Cloud and Grid Computing
Priority scheduling of requests to web portals
Journal of Systems and Software
Interaction-aware scheduling of report-generation workloads
The VLDB Journal — The International Journal on Very Large Data Bases
Multi-query SQL progress indicators
EDBT'06 Proceedings of the 10th international conference on Advances in Database Technology
Adaptive admission control algorithm in a QoS-aware Web system
Information Sciences: an International Journal
Developing an optimized application hosting framework in Clouds
Journal of Computer and System Sciences
| Hi-index | 0.00 |
Transactional workloads are a hallmark of modernOLTP and Web applications, ranging from electronic commerceand banking to online shopping. Often, the databaseat the core of these applications is the performance bottleneck.Given the limited resources available to the database,transaction execution times can vary wildly as they competeand wait for critical resources. As the competitor is "only aclick away," valuable (high-priority) users must be ensuredconsistently good performance via QoS and transaction prioritization.This paper analyzes and proposes prioritization fortransactional workloads in traditional database systems(DBMS). This work first performs a detailed bottleneckanalysis of resource usage by transactional workloads oncommercial and noncommercial DBMS (IBM DB2, PostgreSQL,Shore) under a range of configurations. Second,this work implements and evaluates the performance of severalpreemptive and non-preemptive DBMS prioritizationpolicies in PostgreSQL and Shore. The primary contributionsof this work include (i) understanding the bottleneckresources in transactional DBMS workloads and (ii) ademonstration that prioritization in traditional DBMS canprovide 2x-5x improvement for high-priority transactionsusing simple scheduling policies, without expense to low-prioritytransactions.