Controlled Flights Into Terrain: Learning from Catastrophic Database Design Failures (643KB) Presented at: Collaborate Date: 04/24/2006 Abstract: Many database application failures result from design errors. These errors limit the performance and functionality of the application, ultimately limiting the business process the application is supposed to service. This presentation will provide a review of database application failures and a list of design principles that would have avoided the failures. From a performance perspective, every system is designed to fail at some point - and the system design is the key to extending the viability and usefulness.

How to use Regular Expression Functions in 10g (339KB) Presented at: Collaborate Date: 04/24/2006 Abstract: As of Oracle Database 10g, you can use the regular expression functions to perform very complex searches. This presentation will show the formats for the functions along with examples of searches. Examples include case-insensitive searches and searches for classes of characters (such as all numbers, or all uppercase letters). As a bonus, case-insensitive search options that do not use the regular expressions will also be shown.