Title |
Abstract |
| Data Warehouse Best Practices: From Methodology to Design |
This presentation sorts out the confusion about data warehouse architectures and methodologies. Choosing the right architecture and development approach for an organization is a challenge governed by many factors. The presentation addresses surrounding the construction of a warehouse. It also discusses the overall architecture, design, and development considerations and deployment. All of the presentation is based on real-world solutions and provide best practices that have been learned from these implementations. The presentation provides guidelines and techniques to assess your requirements and make informed choices when constructing a data warehouse. |
| Fusion Development: A Database-Centric Approach |
The only portion of the Fusion platform that is not rapidly evolving or is likely to be obsolete in the near future is the database. Enforcing data-intensive logic in the database requires less code than when written in Java in the middle tier. The logic also executes much faster and requires less network traffic if placed in the database. This presentation describes a number of techniques using SQL and PL/SQL in the database including INSTEAD OF trigger views, views based on functions accessing object collections and various bulk SQL operations. It will also discuss how to successfully integrate these components into a Fusion application using ADF BC. The main sources of poor performance in a web application are poorly written SQL and high numbers of network round trips between the application server and database. A “thick database” approach to web development improves performance and reduces the amount of rewriting required as web development tools continue to evolve. |
| Fusion’s ADF BC in Depth |
ADF BC is the cornerstone of Fusion’s web development environment. It enables applications to integrate with the database. ADF BC has a very rich architecture and a host of sophisticated features that developers can take advantage of when building applications. However, if incorrectly used, many of these features can cause catastrophic failures including terrible performance (e.g. 12-minute tree refreshes), unmaintainable code, bizarre data locking bugs, and users swapping sessions and inadvertently seeing each other’s data. This hands-on session will illustrate some of the possible mistakes and show how to write code that avoids these pitfalls. The presentation will also discuss how ADF BC can enforce business logic without significantly impacting performance. |
| Oracle Fusion Middleware 10g Release 3 Overview |
Along with the phenomenal benefits provided by implementing a SOA architecture, teams must equip themselves with a new skills and software to deal with the fact that several of the historical methods for debugging and tuning their applications will no longer be viable. In this presentation, the Oracle SOA suite will be presented illustrating the products included, and how they work together to enable a SOA architecture. These will then be contrasted to historical implementations illustrating where gaps have been introduced in debugging and testing capabilities. Finally, several experience based tips, techniques and tools will be discussed that bridge these gaps highlighting several features of the SOA suite, and additional toolsets such as the Oracle Grid Manager. In this hour session many of the more dangerous landmines encountered will be covered as well as solutions derived from project based experiences that will allow one to overcome the challenge or sidestep the danger altogether. |
| Virtual Hosts in a Real World |
Should I use Web Cache Load Balancing? How can I use Virtual Hosts? How do I make my server launch unique applications (or unique manifestations of an application) from both x.acme.com and y.acme.com? Join us for a discussion of these capabilities and a glimpse at a production environment where it is successfully deployed. |
| Introducing Oracle Queueing /Messaging Technologies |
The advancement of contemporary information technologies has gone well far beyond imaginable boundaries from a decade ago. Internetworking has set the web as an invaluable resource, by changing business models at a fast pace, as new technologies enable their pragmatic development. In particular, this paper focuses on a discussion about advanced message queuing technology, by introducing the most relevant technical and business concepts, their usage, and the criteria that apply to their practical implementation. With the integration of business information systems, advanced message queuing models allow for a robust consolidation of Service Oriented Architecture (SOA) and Web Services applications, emphasizing reliability, and information privacy and security, and consistently enriching the steady growing information integration business landscape. |
| Business Process Improvement through AP Automation |
Thousands of Oracle E-Business Suite users are benefiting from Document Automation technology to enable AP departments to overcome tedious work, such as keying in information from incoming invoices, so that it is handled automatically. ReadSoft will explain all functionality, including flow monitoring capabilities, automatic validation, tools for high speed verification, streamlined transfer, approval workflow and EDI. By utilizing these tools, E-Business Suite users can increase efficiency of AP processing while significantly cutting down on manual handling costs. Users who expect the ultimate level of automation can benefit from the capacity, accuracy, speed, flexibility and ease of use of Document Automation technology for AP that also enables Sarbanes Oxley compliance. |
| Fusion Applications on Oracle Application Server 10g R3: Top 10 Infrastructure Changes to Learn |
Oracle Application Server 10g R3 has become the core infrastructure of Oracle E-Business Suite and the forthcoming Fusion Applications. In this session, you will learn the top 10 infrastructure changes that will impact developers and administrators of Fusion Application Server 10g R3. The goal of this talk is to help developers and administrators understand how the Oracle Application Server development and deployment model has evolved in Oracle Application Server 10g R3 and which are important issues to consider when planning uptake of future releases. |
| Name Service Beyond TNSNAMES.ORA and OID |
The simple function of Oracle Name Service has gone from traditional tnsnames.ora to Oracle Names, Oracle Internet Directory and EZConnect. With multitude versions of databases and different platforms of clients and servers in today's corporate world, it becomes more desirable to centralize this service so that one change applies to all. A quick research into Oracle's documentation will find that Oracle Names was the solution in 8i and standalone OID in 9i and integrated Oracle Application OID in 10g beyond. The issue of license and complexity of configuration and support has discouraged many DBA's to withdraw back from this venture and stick to tnsnames.ora. This paper reveals a technique using Active Directory as a name service solution. It will be relatively easy, highly available and "FREE". |
| Proactively Identify and Solve Oracle Middleware Performance Problems |
Performance and Availability Management This session describes how Oracle business-critical middleware require a new approach to performance and availability management. In a detailed discussion of customer performance examples garnered from Wily Technology’s customer crit-sit services, learn about frequent infrastructure performance issues and how to avoid them and meet critical SLA’s. The presentation also discusses the need to adopt a proactive approach to a Web application and middleware performance management strategy and various options for avoiding high levels of inefficiency, customer attrition and revenue loss. |
| Oracle Application Server High-Availability Options |
Oracle Fusion Middleware and its centerpiece, the Oracle Application Server (OAS), lie at the heart of many corporate SOA, Portal and Identity Management initiatives. These mission-critical applications may require 24x7x365 high-availability while allowing for unplanned or planned downtime for individual system components. Oracle provides several methods for achieving OAS high-availability and it is important to understand and choose the optimal architecture to fit the business needs. For example, while configuring OAS in an Active-Passive mode provides fail-over, it does not include load-balancing. Full redundancy, high-availability and load-balancing can only be achieved with an Active-Active configuration. To leverage OAS as the core technology for any mission-critical initiative, each high-availability option must be carefully considered. This presentation will address the OAS alternative configurations and the associated benefits and risks of each. |
| Rewiring the Procurement Approval Process using iProcurement and OAF |
Oracle Purchasing and Oracle iProcurement offer three document approval methods "out of the box". When none of these methods is appropriate, the Oracle Applications Framework (OAF) extension mechanism may be used to implement a customized approval process with full GUI integration. This paper describes how this was done for the iProcurement implementation project at the Jet Propulsion Laboratory (JPL). |
| Using Fusion for Custom Application Development |
Oracle's Fusion Middleware technology stack is a state-of-the-art application development environment that Oracle will be using internally to develop the next generation of all Oracle applications. This same technology stack can be used to quickly build sophisticated web applications. This presentation will provide a roadmap for organizations trying to create custom applications in the Fusion Middleware environment. A demonstration of a high-quality production application built using Fusion Middleware will be included. |
| Integration: Using OracleAS Portal to 'Bring It All Together' |
As systems become more and more complex, end-users are faced with increasingly complicated and varying user interfaces. There is an urgent need for IS depatments to integrate systems and provide consistency between these applications. OracleAS Portal provides the means to integrate Oracle- and non-Oracle-based systems into a visually-consistent environment that end-users can access easily and administrators can maintain securely. |
Serving 20,000+ Oracle technology professionals with access to 10+ SIGs, multiple regional groups and thousands of online resources
