Alan Choi
ABSTRACT
This paper describes Edition-Based Redefinition (EBR) in the Oracle database --- a novel technology and methodology to build database application patches so that installation of these patches does not require application downtime. It discusses the challenge of zero-downtime application patch installation and shows how EBR can meet the challenge. Customer experience shows that EBR provides online application upgrade in several industries.
- Oracle Database SQL Language Reference, 11gRelease 2 (11.2)Google Scholar
- Oracle Database New Features Guide 11gRelease 1(11.1)Google Scholar
- Oracle Database Administrator's Guide 11gRelease2 1(11.2)Google Scholar
- Doug Reid: Upgrading Oracle Siebel CRM with zero downtime: best practices, March 2009Google Scholar
- Database Rolling Upgrade Using Data Guard SQL Apply, Oracle Database 11g and 10gR2Google Scholar
- ISO/IS Database Language SQL -- Part 1: SQL/Framework, section 4.6.6.4, July 1999Google Scholar
Index Terms
- Online application upgrade using edition-based redefinition
Recommendations
Database high availability using SHADOW systems
SoCC '15: Proceedings of the Sixth ACM Symposium on Cloud ComputingHot standby techniques are widely used to implement highly available database systems. These techniques make use of two separate copies of the database, an active copy and a backup that is managed by the standby. The two database copies are stored ...
Consistent and automatic replica regeneration
Reducing management costs and improving the availability of large-scale distributed systems require automatic replica regeneration, that is, creating new replicas in response to replica failures. A major challenge to regeneration is maintaining ...
Styx++: Reliable Data Access and Availability Using a Hybrid Paxos and Chain Replication Protocol
CHI EA '22: Extended Abstracts of the 2022 CHI Conference on Human Factors in Computing SystemsHCI research often involves accessing and storing information in databases. However, in case of a database node failure, researchers could experience significant work delays, monetary costs, and data loss. How can researchers who have little or no ...
Comments