Oracle Magazine January - February 2007 Features Departments Technology, Developer & Comment Sections—    Articles and Columns

FEATURES

Always Available By Alan Joch Does your business depend on expensive hardware for disaster insurance? New high-availability technologies run on inexpensive commodity hardware, provide disaster insurance, and improve the performance of day-to-day operations. See how Oracle helps growing businesses stay up and running. Go XML By David Baum Business transactions on the Web and content-rich applications have put new demands on enterprise databases. XML—the markup language that is used to store and exchange all kinds of data—can meet these demands. Find out how Oracle XML DB manages diverse XML data. Expanding to Meet Demands By David A. Kelly Small and medium businesses still have to meet big demands—for fast performance, high availability, data security, and scalability—usually under tight budgets. Discover what Oracle is doing to help SMBs meet these challenges, satisfy their customers, and grow and thrive under changing market conditions.

DEPARTMENTS

From Our Readers Readers tell us what they think. Available and working By Tom Haunert AT ORACLE Events Find out about current and upcoming industry events. Oracle Resources Here's your guide to Oracle's broadband, education, and online offerings, plus what's new at Oracle. OTN Community Bulletin Learn what's happening with Oracle's most dynamic online community. Oracle News Briefs Oracle News Oracle is offering enterprise-class Linux support—the same level of support that Oracle provides for the database—through the Unbreakable Linux program. CHANNELS Commitment The Nature Conservancy protects endangered species and drinking water. Partner News GridApp Systems, IBM, EMC, Adobe, Itemfield, Genpact, Turnkey Solutions, NAVTEQ, Application Security, Inc., and SilverStorm plus Book Beat Peer-to-Peer Steve Karam, Nicolas Gasparotto, Dave Moore Cutting Edge Encrypted hard drives and perching planes

TECHNOLOGY AND DEVELOPER SECTION—ARTICLES & COLUMNS

TECHNOLOGY PL/SQL PRACTICES The Right Place for PL/SQL By Steven Feuerstein Best practices for PL/SQL location, location, location RECOVERY Recover in a Flash By Arup Nanda Reduce database recovery time, using the Oracle flash recovery area. ASK TOM On Top-n and Pagination Queries By Tom Kyte Our technologist gets more results using ROW_NUMBER, RANK, and DENSE_RANK.

ORACLE DEVELOPER OPEN SOURCE Embedding Open Source By Rich Schwerin The Oracle Berkeley DB family of products exemplifies Oracle's open source commitment. FRAMEWORKS Modeling Tables and Components By Steve Muench Maintain your data-centric business services with visual diagrams. ODP.NET Using PL/SQL Associative Arrays By Mark A. Williams Bring the power of PL/SQL stored procedures to ODP.NET. BROWSER-BASED Sizing Up Performance By Mike Hichwa Tips and techniques for optimal Oracle Application Express performance

COMMENT IN THE FIELD Listening to You By Ari Kaplan IOUG surveys provide guidance for expanding databases and open source software issues. ALL SECURE Security Goes Mainstream By Mary Ann Davidson Security is too important to be left to experts. ANALYST'S CORNER The Right Stuff By David Baum Small businesses can compete on a big scale if they have enterprise-caliber software.