Schema evolution and the relational algebra
Information Systems
Temporally oriented data definitions: managing schema evolution in temporally oriented databases
Data & Knowledge Engineering
Schema versioning for multitemporal relational databases
Information Systems
An architecture for automatic relational database sytem conversion
ACM Transactions on Database Systems (TODS)
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
Foundations of Databases: The Logical Level
Foundations of Databases: The Logical Level
Temporal and Real-Time Databases: A Survey
IEEE Transactions on Knowledge and Data Engineering
Proceedings of the International Workshop on Temporal Databases: Recent Advances in Temporal Databases
Rondo: a programming platform for generic model management
Proceedings of the 2003 ACM SIGMOD international conference on Management of data
Constraint-based XML query rewriting for data integration
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Semantic adaptation of schema mappings when schemas evolve
VLDB '05 Proceedings of the 31st international conference on Very large data bases
Implementing mapping composition
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
MARS: a system for publishing XML from mixed and redundant storage
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
Mapping adaptation under evolving schemas
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
Temporal slicing in the evaluation of XML queries
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
Indexing temporal XML documents
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Querying complex structured databases
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Temporal XML: modeling, indexing, and query processing
The VLDB Journal — The International Journal on Very Large Data Bases
ArchIS: an XML-based approach to transaction-time temporal database systems
The VLDB Journal — The International Journal on Very Large Data Bases
Graceful database schema evolution: the PRISM workbench
Proceedings of the VLDB Endowment
Managing the History of Metadata in Support for DB Archiving and Schema Evolution
ER '08 Proceedings of the ER 2008 Workshops (CMLSA, ECDM, FP-UML, M2AS, RIGiM, SeCoGIS, WISM) on Advances in Conceptual Modeling: Challenges and Opportunities
Graceful database schema evolution: the PRISM workbench
Proceedings of the VLDB Endowment
Managing the History of Metadata in Support for DB Archiving and Schema Evolution
ER '08 Proceedings of the ER 2008 Workshops (CMLSA, ECDM, FP-UML, M2AS, RIGiM, SeCoGIS, WISM) on Advances in Conceptual Modeling: Challenges and Opportunities
PRIMA: archiving and querying historical data with evolving schemas
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
Identifying query incompatibilities with evolving XML schemas
Proceedings of the 14th ACM SIGPLAN international conference on Functional programming
Automating database schema evolution in information system upgrades
Proceedings of the 2nd International Workshop on Hot Topics in Software Upgrades
Proceedings of the 13th International Conference on Extending Database Technology
Scalable architecture and query optimization fortransaction-time DBs with evolving schemas
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
CODS: evolving data efficiently and scalably in column oriented databases
Proceedings of the VLDB Endowment
CRIUS: user-friendly database design
Proceedings of the VLDB Endowment
Update rewriting and integrity constraint maintenance in a schema evolution support system: PRISM++
Proceedings of the VLDB Endowment
Supporting complex changes in evolving interrelated web databanks
OTM'10 Proceedings of the 2010 international conference on On the move to meaningful internet systems - Volume Part I
Efficient and scalable data evolution with column oriented databases
Proceedings of the 14th International Conference on Extending Database Technology
Impact of XML Schema Evolution
ACM Transactions on Internet Technology (TOIT)
E-ETL: framework for managing evolving etl processes
Proceedings of the 4th workshop on Workshop for Ph.D. students in information & knowledge management
OTM'11 Proceedings of the 2011th Confederated international conference on On the move to meaningful internet systems - Volume Part II
When conceptual model meets grammar: A dual approach to XML data modeling
Data & Knowledge Engineering
ICMT'12 Proceedings of the 5th international conference on Theory and Practice of Model Transformations
Static analysis of XML document adaptations
ER'12 Proceedings of the 2012 international conference on Advances in Conceptual Modeling
Automating the database schema evolution process
The VLDB Journal — The International Journal on Very Large Data Bases
Hi-index | 0.01 |
The old problem of managing the history of database information is now made more urgent and complex by fast spreading web information systems, such as Wikipedia. Our PRIMA system addresses this difficult problem by introducing two key pieces of new technology. The first is a method for publishing the history of a relational database in XML, whereby the evolution of the schema and its underlying database are given a unified representation. This temporally grouped representation makes it easy to formulate sophisticated historical queries on any given schema version using standard XQuery. The second key piece of technology is that schema evolution is transparent to the user: she writes queries against the current schema while retrieving the data from one or more schema versions. The system then performs the labor-intensive and error-prone task of rewriting such queries into equivalent ones for the appropriate versions of the schema. This feature is particularly important for historical queries spanning over potentially hundreds of different schema versions and it is realized in PRIMA by (i) introducing Schema Modification Operators (SMOs) to represent the mappings between successive schema versions and (ii) an XML integrity constraint language (XIC) to efficiently rewrite the queries using the constraints established by the SMOs. The scalability of the approach has been tested against both synthetic data and real-world data from the Wikipedia DB schema evolution history.