|
ODTUG OOW 2013 Weekly Sessions ODTUG is pleased to participate in Oracle OpenWorld, September 22-26 in San Francisco. Check out our Sunday Symposiums or browse the list of sessions below. Times and dates for the sessions during the week should be posted soon to the Content Catalogue. |
|||||
|
|||||
 |
|||||
|
CON7387: Scaling To Infinity: Making Star Transformations Sing Dimensional data models (i.e. star schemas) are a crucial component of the presentation layer of data warehouses and data marts, because that is the format in which business-intelligence analysts expect to find their data model. Yet, so many decision-support environments based on Oracle attempt to live with star schemas without using star transformations for joins, brute-forcing their way and eventually wishing they could buy an Exadata. The reasons for this vary from lack of understanding to practical impediments related to ETL processing. This presentation will explain the justification for the “star transformation” mechanism, including comparisons to other execution plans, how to implement, how to optimize, and how to troubleshoot. |
|||||
|
|
|||||
|
CON2271: PL/SQL Goodies in Oracle Database 12c Oracle Database 12c offers an array of exciting new features for PL/SQL developers. The function result cache has been enhanced to support functions defined with invoker rights. Use the ACCESSIBLE BY clause to define "whitelists" of the program units that can execute subprograms in a package. Grant roles to PL/SQL program units, rather than to schemas, giving you much greater flexibility over access control. Design a procedure to implicitly return a result set, much like you can do in SQL Server (useful for migration projects). Define a view with BEQUEST CURRENT_USER so that it behaves like an invoker rights unit. Declare and call PL/SQL functions entirely inside the WITH clause a SELECT statement. And more! |
|||||
|
|
|||||
|
CON2038: Exadata, Oracle Data Integrator and Parallel - A Real World Case Study Oracle Data Integrator offers the new age developer and DBA an effective and robust tool to build an ETL. When paired with Exadata as the home for the data load and for reporting, a winning combination is pretty much a no-brainer. On the rare occasion expectations aren't achieved, it's important to ensure that careful research is performed to understand what is causing the performance issue. This session is based on a real-world scenario for one company who undertook this challenge and how ensuring they knew the cause of performance issues and the correct introduction of parallel to the ODI layer created an effective and efficient ETL and reporting Exadata environment for their company. |
|||||
|
|
|||||
|
CON6900: Oracle Database 12c New Features for Developer With each release of Oracle’s database come a rich complement of new features and improvements. Attendees are introduced to the new and improved features of Oracle database 12c that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or speed deployment. |
|||||
|
|
|||||
|
CON6629: Making Workflow Flow If you are using E-business Suite and have not taken some steps to enhance the health of your workflow processing, you are undoubtedly dealing with a growing backlog of workflow run-time data that is not being purged and shrinking performance levels for all things workflow. Learn about some ways to get ahead of these problems before they become a crisis based on years of working with workflow and some recent real-life examples. |
|||||
|
|||||
|
CON4070: How to Handle DEV&TEST&PROD for ODI Most of us have development teams apart from test and operation teams using different environments. And there are generally three different Oracle Data Integrator installations and repositories that each of the teams uses separately. Chaos is usually expected and actually happens when it is unclear who will test which development and what to deploy into production. In this session, two Oracle Data Integration experts, one of them an Oracle ACE Director, discuss how Oracle Data Integrator can handle your development hierarchy with ease of use and in a simplified/synchronised way for successful deployments. |
|||||
|
|
|||||
|
CON4811: Innovations in BI: Oracle Business Intelligence against Essbase & Relational In OBIEE (Oracle Business Intelligence Enterprise Edition), we can create models against multiple disparate sources that pull data and metadata from relational databases and multi-dimensional sources. In this session, we will demonstrate a particularly powerful combination: using Essbase for pre-consolidated cube data with an Oracle database alongside for transactional information. Join Oracle ACE's, published authors, and presumed experts Stewart Bryson and Edward Roske as they demonstrate the fun of metadata development against a sample Essbase database sourced from an Oracle database. Attendees will leave the session knowing how to model complex Essbase options and integrate those with relational sources like the Oracle database. |
|||||
|
|||||
|
CON7267: ADF On-Ramp: What You Need to Know to use the Core ADF Technology Stack This presentation explains the core technologies you will use when working with Oracle Application Development Framework (ADF) in JDeveloper: ADF Business Components, ADF Faces Rich Client, ADF Model, and ADF Controller. It also describes and shows the techniques and files used to build and test an ADF application. The session provides guidelines for how much you need to know about the various languages used in ADF, and it offers advice on how to learn what you need to know before starting Java web development in JDeveloper. |
|||||
|
|
|||||
|
|||||
|
CON4092: Oracle APEX - WebSockets (or When Push Comes to Shove) WebSockets are a new and emerging HTML5 technology that offers interesting possibilities to web applications. In this session I will explain what WebSockets are, how they work, and show practical uses for WebSockets in APEX applications (some obvious and some not so obvious!) |
|||||
|
|
|||||
|
CON1944: Automatic for the People - End to End Automatic Testing of Your APEX Application Continuous integration is a well-known aspect of Java development projects. Key here is automated testing of all parts of the solution, back-end as well as front-end. In this session you will learn how to use not only the already better known automated back-end testing facilities for PL/SQL, but also how to automate testing of your user interface. Using this approach you can execute regression tests, aiming at a reliable and stable outcome. |
|||||
|
|
|||||
|
CON5936: Building Application Express Applications that Can Survive Without the Internet In Oracle Application Express (APEX) 4.2, new features were added to give developers the ability to easily create mobile web applications that look like native mobile applications. But with new capabilities come new challenges. One such challenge developers must contend with is that mobile devices often lose their internet connections where signals are weak. Can a mobile web application built with APEX continue to work when unplugged from the web? The short answer is yes, at least to some degree, thanks to a number of new technologies that have emerged to tackle this common problem. In this session attendees will learn about these exciting new technologies and how they can be utilized in APEX applications. |
|||||
|
|
|||||
|
CON7675: Rules and Guidelines: A Template for APEX Development Standard A set of Rules and Guidelines for Oracle Application Express (APEX) development has taken shape in the crucible of many Agile software development projects. Rules and guidelines shape a team’s development activities so that APEX projects are done in a consistent and productive manner. The value of this paper is not in the rules and guidelines themselves which are specific to individual teams; rather, the value is in the format, strategy, and team-centric authoring process that builds this seriously practical and concise tool for steering an Agile APEX software development team to success. |
|||||
|
|
|||||
|
CON5469: How to Instrument our PL/SQL and APEX Code This session will cover how to instrument (i.e. log) both Oracle PL/SQL and Application Express (APEX) code. Attendees will learn about tools that will help them maintain and support their applications. These tools will help reduce the support and development costs within their organization. Topics that will be covered include:
|
|||||
|
|||||
