Performance issues in database systems

✍ Scribed by Mukesh Singhal; Yelena Yesha

• Publisher: Elsevier Science
• Year: 1990
• Tongue: English
• Weight: 434 KB
• Volume: 14
• Category: Article
• ISSN: 0895-7177
• DOI: 10.1016/0895-7177(90)90170-r

✦ Synopsis

The performance of transaction processing systems is affected by contention for hardware as well as software resources (data objects). Software contention becomes prominent in database systems because concurrency control mechanism, which is used to insure integrity of the database, restrict concurrent and conflicting access to data objects of a database. Locking is the most popular scheme to achieve concurrency control in database systems. Performance of a database system is greatly determined by its underlying concurrency control algorithm because it determines the performance degradation in presence of software contentions. In this paper, we will examine the issues in the performance analysis of concurrency control algorithms and their affect on the overall database system performance. With many alternatives now available to design a database system, there is a tremendous need to assess the suitability of a design to a particular env~onment and need. In this paper, we will discuss difficulties in modeling concurrency control algorithms and describe how these difficulties have been overcome.