UnicodeIUC22
Program Showcase Registration Accommodation Travel Sponsors
Unicode Standard Conference Board Conference CD Last Conference Past Conferences Next Conference
Abstract

TWO UU (Table Wise Online Unicode Upgrade) - How to upgrade a large database system without down time

Joern Bartels - Oracle Corporation

&

Bernard Schilling - SAP AG

Intended Audience: Managers, Software Engineers, Systems Analysts, Marketers, Technical Writers
Session Level: Beginner, Intermediate, Advanced

An upgrade of a large non-Unicode application system to a Unicode-based system is normally associated with high costs in terms of human resource,hardware, and especially with long down time. We have developed a method to upgrade a non-Unicode database to a Unicode based system with no down time, with no additional hardware, and with minimum human resources.

Non-Unicode database tables are copied into Unicode tables one by one. As soon as the Unicode copy of a table is created, it replaces the original, non-Unicode table. During this operation, the non-Unicode system does not need to be shut down. The method requires no additional hardware because the copy is executed on the original database and it creates a duplicate of only one table at a time. The method is suitable also for systems larger than 1 Terabyte. Such system upgrades normally require the creation of a new database. In our experience, the method shortens the total upgrade time by a factor of 5 compared to the conventional upgrade method.

We would like to share the concepts of the method and our experiences with the attendees of the IUC in order to promote the Unicode standard also for large database-based applications.


Unicode
When the world wants to talk, it speaks Unicode

UnicodeIUC22
Program Showcase Registration Accommodation Travel Sponsors
Unicode Standard Conference Board Conference CD Last Conference Past Conferences Next Conference
International Unicode Conferences are organized by Global Meeting Services, Inc., (GMS). GMS is pleased to be able to offer the International Unicode Conferences under an exclusive license granted by the Unicode Consortium. All responsibility for conference finances and operations is borne by GMS. The independent conference board serves solely at the pleasure of GMS and is composed of volunteers active in Unicode and in international software development. All inquiries regarding International Unicode Conferences should be addressed to info@global-conference.com.

Unicode and the Unicode logo are registered trademarks of Unicode, Inc. Used with permission.

5 July 2002, Webmaster