(Kevin Kardasz, Vadim Kudryavtsev, Robert Mark, and Mikhail Seliverstov) At McGill University’s (Montreal, Quebec, Canada) Department of Development and Alumni Relations, we are in the process of moving extensive, multifaceted services for 200 to 300 paid and volunteer staff and up to 160,000 alumni

Heightened security concerns and the all too real threat of domestic terrorism have given rise to the need for high availability solutions and strategies for disaster recovery. High data availability should be top-of-mind for all organizations, regardless of size or industry. Every organization

(Benjamin Rosenzweig and Elena Silvestrova) In most languages, you have only two sets of characters: numbers and letters. Some languages, such as Hebrew or Tibetan, have specific characters for vowels that are not placed in line with consonants. Additionally, other languages, such as Japanese, have

(Carmen Beitzer) The MERGE functionality introduced in Oracle9i offers a simplified, yet powerful enhancement to the commonly known UPSERT approach of earlier editions. Just as its predecessor, MERGE is a valuable functionality when integrating same datasets over time, (i.e. when extracting incremen

(Anthony Lai, Jyotsna Laxminarayanan and Lars Ewe) This article discusses some of the challenges of legacy system integration, then introduces the J2EE Connector Architecture (J2EE CA) and explains how it can significantly reduce the problems of integrating your legacy system. It also offers a compr

(James Koopmann) This article is the third and last in the three part series, that has explored the use of VARRAYs in Oracle. This part will look at the performance implications if you should choose to use VARRAYS.

This paper focuses on the new features that have been added to Oracle Forms in Oracle Application Server 10g and Oracle Developer Suite 10J. Each new feature is explained in brief, with an outline of the feature and how it works. (PDF)

If you are creating queries using the Oracle database server, you can take advantage of features specific to that server. The following guidelines outline differences you will notice in the Query Designer when you work with the Oracle Server, and provide information about Oracle-specific features th

(Robert Westervelt) Oracle is bringing back Terry Olkin, a former Oracle database executive who founded the company’s advanced technology division, to be the chief architect of the company’s Collaboration Suite. That move could signal a major advancement for the software suite, analysts say, though

(Dave Aldridge) On a regular OLTP system, one of the perennial sources for doubt and debate is the number, type and configuration of indexes, and for good reason. An OLTP system generally runs with some limited set of select queries and a range of updates, inserts, and deletes. A balance has to be s