Semantics of a runtime adaptable transaction manager

ABSTRACT

Database Management Systems (DBMSs) that can be tailored to specific requirements offer the potential to improve reliability and maintainability and simultaneously the ability to reduce the footprint of the code base. If the requirements of an application change during runtime the DBMS should be adapted without a shutdown. Runtime-adaptation is a new and promising research direction to dynamically change the behavior of a DBMS. Especially the adaptation of the Transaction Manager (TM) states a challenge.

In this paper, we present the session semantics of a runtime-adaptable TM. We define preliminaries and assumptions to activate the TM during sessions from a conceptual point of view. The advantages and disadvanteges of different approaches are discussed, especially regarding the occurence of ANSI SQL phenomena. From a technical point of view, we define requirements for the architecture of the TM and the DBMS that arose in our prototype.

REFERENCES

• 1: S. Banerjee, V. Krishnamurthy, and R. Murthy. All your data: the Oracle extensibility architecture. Component database systems, pages 71--104, 2001.
• 2: R. Bastide and O. Sy. Formal specification of CORBA services: experience and lessons learned. Proceedings of the 15th ACM SIGPLAN conference on Object-oriented programming, systems, languages, and applications, pages 105--117, 2000.
• 3: H. Berenson, P. Bernstein, J. Gray, J. Melton, E. O'Neil, and P. O'Neil. A critique of ANSI SQL isolation levels. SIGMOD Rec., 24(2):1--10, 1995.
• 4: J. A. Blakeley. Data access for the masses through OLE DB. SIGMOD Rec., 25(2):161--172, 1996.
• 5: J. Cheng, J.; Xu. XML and DB2. Proceedings of the 16th International Conference on Data Engineering (ICDE), pages 569--573, 2000.
• 6: R. Chitchyan and I. Sommerville. Comparing Dynamic AO Systems. In Dynamic Aspects Workshop (DAW 2004), Lancaster, England, März 2004.
• 7: A. Geppert and K. R. Dittrich. Component database systems: introduction, foundations, and overview.Component database systems, pages 2--28, 2001.
• 8: A. Geppert, S. Scherrer, and K. R. Dittrich. KIDS: Construction of database management systems based on reuse. Technical Report ifi-97.01, University of Zurich, 1997.
• 9: J. Gray. The Next Database Revolution. In ACM SIGMOD International Conference on Management of Data (SIGMOD 2004), pages 1--4, New York, NY, USA, Juni 2004. ACM.
• 10: T. Härder. DBMS Architecture - Still an Open Problem. In G. Vossen, F. Leymann, P. C. Lockemann, and W. Stucky, editors, 11. GI-Fachtagung für Datenbanksysteme in Business, Technologie und Web (BTW 2005), volume 65 of LNI, pages 2--28. GI, März 2005.
• 11: F. Irmert, M. Daum, and K. Meyer-Wegener. A New Approach to Modular Database Systems. In Software Engineering for Tailor-made Data Management (SETMDM 2008), pages 41--45, März 2008.
• 12: F. Irmert, C. Neumann, M. Daum, N. Pollner, and K. Meyer-Wegener. Technische Grundlagen für eine laufzeitadaptierbare Transaktionsverwaltung. In BTW 2009, 2009.
• 13: C. Kästner. Aspect-Oriented Refactoring of Berkeley DB. Diplomarbeit, Otto-von-Guericke-Universität Magdeburg, School of Computer Science, Department of Technical and Business Information Systems, Februar 2007.
• 14: J. Melton. ISO/IEC 9075--2:2003 - Foundation (SQL/Foundation). International Organization for Standardization (ISO), 2003.
• 15: D. Nyström, A. Tesanovic, C. Norström, and J. Hansson. The COMET database management system. MRTC report ISSN 1404--3041 ISRN MDH-MRTC-98/2003-1-SE, Mälardalen Real-Time Research Centre, Mälardalen University, April 2003.
• 16: M. A. Olson. Datablade extensions for informix-universal server. In COMPCON '97: Proceedings of the 42nd IEEE International Computer Conference, page 143, Washington, DC, USA, 1997. IEEE Computer Society.
• 17: U. Röhm and K. Böhm. Working together in harmony - an implementation of the CORBA object query service and its evaluation. In ICDE'99: Proceedings of the 15th International Conference on Data Engineering, 23--26 March 1999, Sydney, Austrialia, pages 238--247, 1999.
• 18: M. Rosenmüller, N. Siegmund, H. Schirmeier, J. Sincero, S. Apel, T. Leich, O. Spinczyk, and G. Saake. FAME-DBMS: Tailor-made data management solutions for embedded systems. In Software Engineering for Tailor-made Data Management, pages 1--6, 2008.
• 19: M. T. Roth and P. M. Schwarz. Don't scrap it, wrap it! A wrapper architecture for legacy data sources. In M. Jarke, M. J. Carey, K. R. Dittrich, F. H. Lochovsky, P. Loucopoulos, and M. A. Jeusfeld, editors, VLDB'97, Proceedings of 23rd International Conference on Very Large Data Bases, August 25--29, 1997, Athens, Greece, pages 266--275. Morgan Kaufmann, 1997.
• 20: E. Sciore. Simple DB: a simple java-based multiuser system for teaching database internals. In 38th ACM Technical Symposium on Computer Science Education (SIGCSE 2007), pages 561--565, New York, NY, USA, März 2007. ACM.
• 21: I. Subasu, P. Ziegler, and K. R. Dittrich. Towards Service-Based Data Management Systems. In Datenbanksysteme in Business, Technologie und Web (BTW 2007), Workshop Proceedings, 3-86130-929-7, pages 296--306, March 2007.
• 22: A. Tešanović, K. Sheng, and J. Hansson. Application-tailored database systems: A case of aspects in an embedded database. In 8th International Database Engineering and Applications Symposium (IDEAS 2004), pages 291--301, Washington, DC, USA, July 2004. IEEE Computer Society.
• 23: W. H. Tok and S. Bressan. DBNet: A service-oriented database architecture. In DEXA '06: Proceedings of the 17th International Conference on Database and Expert Systems Applications, pages 727--731, Washington, DC, USA, 2006. IEEE Computer Society.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.4 Systems
          Subjects: Relational databases

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.4 Systems
          Subjects: Transaction processing

General Terms:
Design, Theory

Keywords:
SQL phenomena, adaptation, runtime, transaction management