A Customised ASM Thesis for Database Transformations

In order to establish a theoretical foundation for database transformations, we search for a universal computation model as an umbrella for queries and updates. As updates are fundamentally distinct from queries in many respects, computation models for queries cannot be simply extended to database transformations. This motivates the question whether Abstract State Machines (ASMs) can be used to characterise database transformations in general. In this paper we start examining the differences between database transformations and algorithms, which give rise to the formalisation of five postulates for database transformations. Then a variant of ASMs called Database Abstract State Machines (DB-ASMs) is developed, and we prove that DBASMs capture database transformations, i.e. the main result of the paper is that every database transformation stipulated by the postulates can be behaviourally simulated by a DB-ASM.

[1]  Yuri Gurevich,et al.  Sequential abstract-state machines capture sequential algorithms , 2000, TOCL.

[2]  Klaus-Dieter Schewe,et al.  Towards a Logic for Abstract MetaFinite State Machines , 2008, FoIKS.

[3]  Jörg Flum,et al.  Finite model theory , 1995, Perspectives in Mathematical Logic.

[4]  Bernhard Thalheim,et al.  A theory of data-intensive software services , 2009, Service Oriented Computing and Applications.

[5]  Bernhard Thalheim,et al.  Fundamental Concepts of Object Oriented Databases , 1993, Acta Cybern..

[6]  Tatiana Yavorskaya,et al.  On Bounded Exploration and Bounded Nondeterminism , 2006 .

[7]  Klaus-Dieter Schewe,et al.  Axiomatization of Database Transformations , 2007 .

[8]  Andreas Blass,et al.  Abstract state machines capture parallel algorithms , 2003, TOCL.

[9]  Yuri Gurevich,et al.  Metafinite Model Theory , 1994, LCC.

[10]  Jan Van den Bussche,et al.  On the completeness of object-creating database transformation languages , 1997, JACM.

[11]  Jan Gilbert Van Den Bussche Formal aspects of object identity in database manipulation , 1993 .

[12]  Bernhard Thalheim,et al.  Updates, Schema Updates and Validation of XML Documents - Using Abstract State Machines with Automata-Defined States , 2009 .

[13]  Egon Börger,et al.  Abstract State Machines. A Method for High-Level System Design and Analysis , 2003 .

[14]  Bernhard Thalheim,et al.  Identification as a Primitive of Database Models , 1998, FMLDO.

[15]  Jan Van den Bussche,et al.  Non-Deterministic Aspects of Object-Creating Database Transformations , 1992, FMLDO.

[16]  Serge Abiteboul,et al.  Datalog Extensions for Database Queries and Updates , 1991, J. Comput. Syst. Sci..

[17]  Sara Cohen,et al.  User-defined aggregate functions: bridging theory and practice , 2006, SIGMOD Conference.

[18]  Klaus-Dieter Schewe,et al.  A multi-level architecture for distributed object bases , 2007, Data Knowl. Eng..

[19]  Nikolai Tillmann,et al.  Partial updates , 2005, Theor. Comput. Sci..

[20]  Catriel Beeri,et al.  On genericity and parametricity (extended abstract) , 1996, PODS '96.