Temporal Support for Persistent Stored Modules

Richard T. Snodgrass, Dengfeng Gao, Rui Zhang, Stephen W. Thomas
2012 2012 IEEE 28th International Conference on Data Engineering  
We show how to extend temporal support of SQL to the Turing-complete portion of SQL, that of persistent stored modules (PSM). Our approach requires minor new syntax beyond that already in SQL/Temporal to define and to invoke PSM procedures and functions, thereby extending the current, sequenced, and non-sequenced semantics of queries to such routines. Temporal upward compatibility (existing applications work as before when one or more tables are rendered temporal) is ensured. We provide a
more » ... ormation that converts Temporal SQL/PSM to conventional SQL/PSM. To support sequenced evaluation of stored functions and procedures, we define two different slicing approaches, maximal slicing and per-statement slicing. We compare these approaches empirically using a comprehensive benchmark and provide a heuristic for choosing between them.
doi:10.1109/icde.2012.70 dblp:conf/icde/SnodgrassGZT12 fatcat:zs6nsudozvcrvi4wxnpxdbqplm