The PRISM Workwench: Database Schema Evolution without Tears

— Information Systems are subject to a perpetual evolution, which is particularly pressing in Web Information Systems, due to their distributed and often collaborative nature. Such continuous adaptation process, comes with a very high cost, because of the intrinsic complexity of the task and the serious ramifications of such changes upon database-centric Information System softwares. Therefore, there is a need to automate and simplify the schema evolution process and to ensure predictability and logical independence upon schema changes. Current relational technology makes it easy to change the database content or to revise the underlaying storage and indexes but does little to support logical schema evolution which nowadays remains poorly supported by commercial tools. The PRISM system demonstrates a major new advance toward automating schema evolution (including query mapping and database conversion), by improving predictability, logical independence, and auditability of the proces...

• Type: Conference
• Year: 2009
• Where: ICDE
• Authors: Carlo Curino, Hyun J. Moon, MyungWon Ham, Carlo Zaniolo
• Keywords: Database, ICDE 2009, Information Systems, Schema Evolution Process, Schema Evolutions