Impact of Operating System on Real-Time Main-Memory Database System's Performance

As long as there have been databases there has been a large interest to measure their performance. However, operating system impact on database performance has not been widely studied. Therefore, this paper presents experimental results on operating system impact on database performance. Two different operating systems are studied: Linux and Chorus. Linux operating system is tested with different kernel versions and different network speeds. Chorus is used as reference point because it is a real-time operating system. Our results clearly indicate that Linux can be used as a platform for real-time main-memory databases, but the newest kernel version 2.4 should be used. Our simple experiment also confirms that the UDP gives better response time than TCP. The work done in the Linux community to reduce the long latency in the kernel has been successful and with sufficiently long request deadlines it can be used as a platform for real-time databases.

[1]  Hector Garcia-Molina,et al.  Main Memory Database Systems: An Overview , 1992, IEEE Trans. Knowl. Data Eng..

[2]  Kimmo E. E. Raatikainen,et al.  A Distributed Real-Time Main-Memory Database for Telecommunication , 1999, Databases in Telecommunications.

[3]  Ilsoo Ahn.  SIGMOD challenges paper: database issues in telecommunications network management , 1994, SIGMOD '94.

[4]  Sang Hyuk Son,et al.  Developing a Real-Time DB: The Starbase Experience , 1997 .

[5]  Ilsoo Ahn,et al.  Database Issues in Telecommunications Network Management , 1994, SIGMOD Conference.

[6]  Sang Kyun Cha,et al.  Object-oriented design of main-memory DBMS for real-time applications , 1995, Proceedings Second International Workshop on Real-Time Computing Systems and Applications.

[7]  Paul J. Fortier,et al.  The design of real-time extensions to the Open Object Oriented Database system , 1994, Proceedings of Words '94. The First Workshop on Object-Oriented Real-Time Dependable Systems.