Presentations

Keynote Speaker
Lower IT Costs with Oracle Database 11g Release 2 
Tom Kyte, Vice President of the Core Technologies Group at Oracle Corporation

Oracle Database 11g is helping organizations across the world reduce their computing costs through consolidation onto enterprise grids, reduced storage requirements, and elimination of idle redundancy. Oracle Database 11g Release 2 includes new major features that make grid computing more accessible, DBAs more productive, offers up to 20x data compression ratios, and enables online application upgrades. In this keynote presentation, you’ll learn how to drive down costs and improve IT’s quality of service while simplifying your software portfolio.

Back to Top

Have you got lots of Discoverer in your environment?  What are you planning to do with all of those workbooks?  Should you move on to Discoverer 11g at the end of the summer?  Are you going to be forced to use OBIEE?  If you want to migrate, can you, or will it be a 'start from scratch' process?  Melissa Andrews, technical sales consultant at Oracle, will help you understand where Discoverer's future is, and for those of you interested in possibly moving to OBIEE, what your options are.

Back to Top

SOA has come into vogue, but not many people really know what goes into a successful implementation. This breakout session will cover the core concepts of Service Oriented Architecture as well as the set of Oracle technologies that can provide the necessary infrastructure components. We anticipate this session being highly interactive, so please come prepared with questions.

Back to Top

Oracle Data Integration (ODI)
Tyrone Borromeo, Oracle Corporation

Data integration is essential to providing fast and reliable information to make business decisions.  Oracle Data Integrator (ODI) is a comprehensive data integration platform that can support all your data integration requirements -- from high-volume, high-performance batches, to event-driven, trickle-feed integration processes, to SOA-enabled data services.  With built-in connectivity to all major databases, applications, data warehouses, business intelligence, and service-oriented architecture platforms, Oracle Data Integrator offers an extensible architecture that can meet your present and future integration needs.

Back to Top

This presentation will be a detailed look at the setup of a three-machine network lab designed to provide a proof of concept for Identity and Authorization Management (IAM) using existing Oracle products. Oracle Internet Directory infrastructure and associated repository are outlined, as well as LDAP concepts. An additional 11g database is configured to access the LDAP to retrieve user information that will be passed to an application to enable a context to be set for Virtual Private Database (VPD) filtering. Network topology and infrastructure details will be provided as well as code examples. LDAP management tools will be discussed as well.

Back to Top

Upgrade, Migrate or Evolve - determine the direction for your Oracle Forms and Reports Applications. What version of Oracle Forms and Reports are you running your custom applications on? If your answer is not 10g Release 2 or 11g, then you are running on an unsupported technology stack. This means that you are not getting support from Oracle on your software, but even worse you are not getting security patches applied to your environment. This could mean you could be in violation of company or government mandates. Part of your decision to get back on a supported platform may be to determine the direction for your Oracle Forms and Reports Applications. Besides upgrading to the most recent version of Oracle Forms and Reports you may consider migrating to ADF, APEX, or an SOA - enabled application. PITSS deploys its innovative PITSS.CON software to help its customers analyze, upgrade, migrate, and maintain their Oracle Forms and Reports applications.

Back to Top

The built-in functionality of SQL Developer is quite good, but what you may not know is how easy it is to extend SQL Developer to do things that Oracle didn’t think of. In this paper, I’ll show you how to do it. First of all, you can write your own reports in SQL Developer. We’ll add a few reports to the report navigator. Then we’ll export the reports so you can share them with all your friends. By default, SQL Developer can start several well-known external tools like Windows Explorer, Internet Explorer, and Microsoft Word. You can easily get it to open just about any tool on your computer, and even pass the external tool a few parameters. For instance, this can be used to invoke source control utilities that SQL Developer doesn’t currently support. It isn’t as good as the built-in version control support, but it is a good work-around. Would you like to add a new node to the connection navigator? This can be done with a little bit of XML and no programming. I’ll show you how I added a view into the Order Entry schema as a new navigator node. You can also add functionality to the existing nodes – I’ll show you how.

Back to Top

This presentation will discuss several basic, but noteworthy, new features available for PL/SQL in version 11g in addition to the PL/SQL result cache setup and use. Features such as new datatypes, use of the CONTINUE statement, the ability to directly reference sequence values, and new features for the PL/SQL compiler will be discussed. In addition, Oracle 11g provides many new ways to cache information. Cache more is the motto for 11g! One of the things we can now cache is the results of a PL/SQL function call. Often, we have multiple sessions making expensive function calls to the same function even with the same input parameter values. Now, we can cache these results so they may be used by subsequent sessions without those sessions having to incur the expense of the function call and execution. This presentation discusses the new features of the PL/SQL language available with version 11g.

Back to Top

Oracle's Business Intelligence Enterprise Edition software is now the company's flagship BI solution. This presentation provides a quick jumpstart for anyone interested in OBIEE, managers starting a project, or developers transitioning from other BI applications like Discoverer. The presentation reviews the OBIEE architecture and details its functional components. The presentation then considers an OBIEE case study that demonstrates the power and elegance of OBIEE. Finally, the presentation covers the challenges and pitfalls of the OBIEE platform. If time permits, some of latest OBIEE developments and announcements from OpenWorld will be discussed.

Back to Top

This presentation is a case study in the design, development, and deployment of an OBIEE business intelligence solution across multi-network domains for the U.S. Army.  The business intelligence application provides current and predictive analysis on multiple military units which have significant organizational dependencies.
Challenges dealing with common interface schema, authoritative data sources, data cleansing and load using the OWB ETL tool, Inter-network data calls, and selection of appropriate Oracle software tools are covered. Development of a common semantic layer and unification of data schemas will be addressed in the context of development using the OBIEE business intelligence tool.

Back to Top

This session will focus on optimizing the performance of database queries generated by the BI Server.  First, the session will overview how the BI Server determines what query will be generated based on a user's request.  It will then cover what modeling, metadata, and configuration options are available to optimize the query that is generated.  Lastly, the session will outline the resources available for troubleshooting and tuning BI Server performance.  Specifically, this session will cover function shipping, federated queries, hierarchy modeling, aggregate navigation, aggregate persistence, and caching.  This session assumes basic knowledge of the OBIEE BI Server and the organization of its metadata into physical, business, and presentation layers.  Attendees will gain an understanding of how BI Server capabilities can be utilized, in order to meet performance goals, while keeping total cost of ownership as low as possible. 

Back to Top

Managing Statistics for Optimal Query Performance
Karen Morton, Agilex Technologies

Half the battle of writing good SQL is understanding how the Oracle Optimizer analyzes your code and applies statistics in order to derive the "best" execution plan.  The other half of the battle is successfully applying that knowledge to the databases that you manage. The Oracle Optimizer uses statistics as input to develop query execution plans, and these statistics are the foundation of good plans. If the statistics supplied aren't representative, you can expect that garbage in will result in garbage out.  However, if the statistics are representative, it is more likely than not that the Oracle Optimizer will choose an optimal plan.

This presentation reviews several key areas where "bad" statistics can cause query plans to be sub-optimal.  Then, we'll discuss how to choose an optimal stats gathering strategy.  This strategy will include how to best use dynamic sampling and when and how to manually set statistics directly versus collecting them.

Back to Top

Make your Oracle APEX Web application look rich and provide the sizzle by integrating your Oracle APEX application with one of the best DHTML and JavaScript UI component libraries. This session will showcase real world examples on how to integrate Oracle APEX with dhtmlxTree, dhtmlxGrid, dhtmlxTreeGrid, and other dhtmlx products. I will provide live demonstrations with both small and large datasets and share some tips and tricks to overcome potential performance issues.

Back to Top

Oracle Application Express is made up of several technologies: PL/SQL, HTML, CSS, JavaScript, and Ajax. When something goes wrong, it's often more difficult to figure out what went wrong than it is to fix it. This presentation takes a brief look at each technology that makes up Oracle Application Express and discusses and demonstrates how to effectively track down and solve the problem. As an added bonus, every tool outlined in this presentation is available for free.

Back to Top

Users will make up their mind as to whether your site looks professional in a matter of seconds. Thus, you get only one chance to convey an image of professionalism to both existing and potential clients. Even sites that don't compete for clients, such as internal applications, will benefit from a crisp UI, as it will exude a level of confidence to your users. This session will outline the steps and skills required to create a custom look and feel for your APEX applications, and include a live demonstration of how to incorporate an existing look and feel into APEX templates.

Back to Top

This presentation is designed to convince DBAs and DBEs to take more responsibility in understanding object-relational mapping (ORM) tools, as well as to help them understand how they work. For demonstration purposes, we will use Hibernate, a very popular Java based ORM tool. As Hibernate is capable of working with a standard normalized database, we will first demonstrate how modifying the model can enhance the power of Hibernate. First we will focus on a simple problem set and the standard database model that would be utilized. A snippet of Java code will be used to show how the Java developer would work with the standard design. Then, we will present an ORM-friendly database model and a corresponding Java snippet demonstrating the power of the ORM tool. This will be followed by an introduction to Hibernate and its mapping capabilities, specifically as it relates to SQL generation. We will show how data is retrieved into Java domain objects, as well as how it is created, modified, and persisted via Hibernate. We will also discuss performance strengths and weaknesses of ORM tools, as well as common problems to watch out for when using Hibernate or other ORM tools as part of a multi-tiered application.

Back to Top

Oracle Universal Records Management
Julie Xiang, Oracle Corporation

While organizations are looking to centralize records and retention administration, Oracle Universal Records Management, a Department of Defense 5015.2 Chapter 2 and Chapter 4 certified system, provides a scalable and flexible solution that lets you consistently apply records and retention policies (as well as legal discovery and holds) to all types of content, regardless of where that content resides—from e-mail attachments and content stored in file servers to physical records in a warehouse.  This session will detail how this solution allows organizations to define, manage, and execute records and retention policies for all enterprise content from a single application.  Additionally, we will detail how this solution uses a distributed, adapter-based architecture to enforce records management and retention policies, and schedules in nearly any application or repository throughout an organization, providing a single point of interaction for electronic and physical records management.

Back to Top