Hierarchical structures are a fundamental part of any contemporary IT system consisting of organizational chains, responsibility trees, etc. But in the database world, still there is no clear consensus about the best way of working with these designs. For years, database professionals became accustomed to CONNECT-BY clauses (with all of their additional functionality), which are…

This is a two-part session that will take place on Tuesday and Wednesday. One of the most critical aspects of building effective systems is the successful management of unstructured information. The database is no longer only a place to store dollars and cents for accounting purposes. Documents, images, videos, podcasts, etc. must be sorted out…

A database cloud is a model for enabling convenient, on-demand access to a shared pool of configurable computing resources. These resources can include servers, storage, applications, and services, which can be rapidly provisioned and released with minimal management effort. Oracle Real Application Clusters (RAC) provides the required functionality to enable such a database cloud. You…

A database cloud is a model for enabling convenient, on-demand access to a shared pool of configurable computing resources. These resources can include servers, storage, applications, and services, which can be rapidly provisioned and released with minimal management effort. Oracle Real Application Clusters (RAC) provides the required functionality to enable such a database cloud. You…

Oracle Database security checklists and standards are focused on one database, not 1,000 databases. The significant challenge is when you have 100, 500, 1,000, or even 10,000 Oracle Databases in your organization to protect. In order to protect and securely maintain a thousand Oracle Databases requires an enterprise database security framework and database security program.…

Organizations deploying extranets and intranets need to maintain corporate branding and apply user interface designs often developed by traditional web designers.  By understanding a few key aspects of WebCenter templating, it is possible to style your portal to adhere to these designs.   During this session you will learn how to: - Develop dynamic navigation based…

Strategies for implementing gadget based websites with Oracle WebCenter Sites

Attendees are introduced to the new and improved features of Oracle 11g (both Oracle 11g R1 and Oracle 11g R2) that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: New SQL functions, virtual columns, result caching, XML improvements,…

Many of today’s application interfaces are Web-based and dynamic using the power of relational databases like Oracle and MySQL to provide “live” data on demand. This capability has made modern Web-based applications key to many business processes. But BEWARE; unwitting coding practices may lead to something called “SQL Injection” where someone taking advantage of poorly…

You want to run your database in a high availability configuration, Oracle RAC provides the great solution to achieve the high availability against the server failure. However Oracle RAC license can be very expensive especially if your database is running running on a physical server with a high number of CPU cores. Are there any…