skip to main content
10.1145/1620432.1620442acmconferencesArticle/Chapter ViewAbstractPublication PagesideasConference Proceedingsconference-collections
research-article

Semantics of a runtime adaptable transaction manager

Published: 16 September 2009 Publication History

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.

Cited By

View all
  • (2014)Datenbank-Forschung am Lehrstuhl für Informatik 6 (Datenmanagement) der Friedrich-Alexander-Universität Erlangen-NürnbergDatenbank-Spektrum10.1007/s13222-014-0153-214:2(151-157)Online publication date: 25-Jun-2014
  • (2010)Dynamic metamodel extension modules to support adaptive data managementProceedings of the 22nd international conference on Advanced information systems engineering10.5555/1883784.1883822(363-377)Online publication date: 7-Jun-2010
  • (2010)Dynamic Metamodel Extension Modules to Support Adaptive Data ManagementActive Flow and Combustion Control 201810.1007/978-3-642-13094-6_29(363-377)Online publication date: 2010

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
IDEAS '09: Proceedings of the 2009 International Database Engineering & Applications Symposium
September 2009
347 pages
ISBN:9781605584027
DOI:10.1145/1620432
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 16 September 2009

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. SQL phenomena
  2. adaptation
  3. runtime
  4. transaction management

Qualifiers

  • Research-article

Conference

IDEAS '09
Sponsor:
  • ACM
  • Concordia University

Acceptance Rates

Overall Acceptance Rate 74 of 210 submissions, 35%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)3
  • Downloads (Last 6 weeks)1
Reflects downloads up to 15 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2014)Datenbank-Forschung am Lehrstuhl für Informatik 6 (Datenmanagement) der Friedrich-Alexander-Universität Erlangen-NürnbergDatenbank-Spektrum10.1007/s13222-014-0153-214:2(151-157)Online publication date: 25-Jun-2014
  • (2010)Dynamic metamodel extension modules to support adaptive data managementProceedings of the 22nd international conference on Advanced information systems engineering10.5555/1883784.1883822(363-377)Online publication date: 7-Jun-2010
  • (2010)Dynamic Metamodel Extension Modules to Support Adaptive Data ManagementActive Flow and Combustion Control 201810.1007/978-3-642-13094-6_29(363-377)Online publication date: 2010

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media