And sessions that are in my interest list are as follow;
Consistent, robust error management is a critical feature of any successful application. Developers need to know all that is possible in PL/SQL regarding the raising, handling, and logging of errors, to standardize the way those tasks are performed. This session explores the wide range of specialized error management features in Oracle PL/SQL. It covers FORALL’s SAVE EXCEPTIONS, DML error logging with the DBMS_ERRLOG package, the AFTERSERVERERROR trigger, the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function, and more. After attending this session, you will be able to fully leverage PL/SQL error management features, making it easier to identify the sources of problems and fix them more rapidly.
1 Hour Conference Session Steven Feuerstein
Various programming disciplines have taken advantage of collaborative development, agile methods, and rapid feedback to achieve quality code faster. The ability to constantly build and deploy code into identical environments assists in this capability. This session discusses techniques that enable high levels of visibility and traceability for developing database code and schema objects. It also covers the value of constant environmental comparisons between developer copies, central development databases, and integration environments that can reduce potential deployment problems.
1 Hour User Group Forum (Sunday Only) Kellyn Pot’Vin Stewart Bryson
DBAs, applications developers, and database developers: attend this hands-on lab to experiment with new MapReduce and scalable data manipulation capabilities in the database system:
• Implement Hadoop mappers and reducers directly in the database.
• Implement in-database PL/SQL MapReduce.
• Implement scalable data manipulation with SQL pattern matching.
• Implement parallel pipelined table functions in Java or PL/SQL.
1 Hour HOL (Hands-on Lab) Gerard Laker Martin Gubar , Jean-Pierre Dijcks , Kuassi Mensah
This session covers five capabilities of the SQL and PL/SQL languages in the latest generation of database technology that you probably don’t know about—but should.
1 Hour Conference Session Thomas Kyte
Oracle Business Intelligence, a component of Oracle Fusion Middleware, brings a metadata layer, shared/user-defined calculation, interactive dashboards and visualizations, and connectivity to Oracle Essbase multidimensional analysis. It shares security, an Oracle Application Development Framework (Oracle ADF) development environment, and management tools with the rest of the Oracle Fusion Middleware suite, so BI can be embedded into applications, business processes, and portals. This session shows BI functionality’s use in Oracle Fusion Middleware applications and business processes and how BI dashboards and other visualizations can be used in Oracle ADF applications. You’ll see what works, what’s not quite there, and how Oracle uses integration capabilities in Oracle Fusion Applications.
45 Minutes User Group Forum (Sunday Only) Mark Rittman
Oracle Exalytics is Oracle’s hardware/software platform for “speed of thought” analytics. This presentation, delivered by a speaker from an Oracle partner that was the first to buy Oracle Exalytics in the U.K., looks at the architecture of Oracle Exalytics and goes through best practices for the install and configuration of the product and for the use of Oracle In-Memory Database Cache together with the other caching and optimization tools available with the platform. The session also considers alternative approaches to loading and populating the in-memory cache, including the use of Oracle GoldenGate, and discusses what types of performance problems are best solved by Oracle Exalytics.
1 Hour User Group Forum (Sunday Only) Mark Rittman
When faced with a database performance problem, how do you solve it? Do you follow a top-down approach, taking a holistic view to identify resources used, and then prove or disprove your ideas? Or do you google and hack your way through guesses and performance myths, hoping to solve the problem? Find out how your approach compares to the proven methods of the Oracle Real-World Performance Group, which presents some of the performance challenges it faces on a daily basis. This session includes interactive demos, role play, and worked examples as well as cameo appearances from other well-known database experts. This is Part 1 of 3 sessions: (1) “Real-World Performance Challenges,” (2) “Real-World Performance Solutions,” (3) “Wrap-up and Q&A.”
1 Hour Conference Session Andrew Holdsworth Graham Wood , Thomas Kyte
Bring your problems caused by poor query performance, bad indexing schemes, or stale statistics to this session. Also bring your questions on query optimization on Oracle Exadata and Oracle’s SPARC SuperCluster products to this distinguished panel of Oracle experts. Send your questions in advance via http://bit.ly/tuning-roundtable
1 Hour Conference Session Jagan Athreya Graham Wood , Thomas Kyte
One of the crucial skills in the big data world is being able to understand the basics of Hadoop Distributed File System (HDFS) and the MapReduce framework. This session shows you how to work with HDFS and construct a basic MapReduce job that leverages Oracle’s big data software stack. After this session, you will have an understanding of how Hadoop, HDFS, and MapReduce work and be ready to start work on your own big data projects.
1 Hour HOL (Hands-on Lab) Jean-Pierre Dijcks
Even if you are a novice Oracle DBA, you know that one thing is guaranteed: there will be a performance issue at some point. How do you plan your activity? In this session for beginners, you will learn a methodical approach to troubleshooting performance issues in Oracle—making you more effective by executing some precise steps rather than unplanned haphazard approaches with tangential directions. The foundations of the analysis are the use of v$session, v$session_event, v$sesstat, v$active_session_history, and dbms_monitor. The session presents all concepts with live demos.
1 Hour User Group Forum (Sunday Only) Arup Nanda
A new data warehouse implementation is challenging when the legacy data warehouse is the basis of a multitenant BI service customers rely on for daily analytics. Emerson Climate Technologies – Retail Solutions (ECT-RS) needed to replace its data warehouse while maintaining service levels for its customers. With the help of Rittman Mead, ECT-RS exploited the architecture of Oracle Business Intelligence Enterprise Edition to rapidly design and deploy a new data warehouse while ensuring that customers experienced no loss in service. The project team used the Oracle Business Intelligence Enterprise Edition business model to drive the design of new, optimized content while relying on its federation capabilities to deploy that new content to customers incrementally. Learn more in this session.
1 Hour User Group Forum (Sunday Only) Stewart Bryson Gary Braswell
Big data solutions, Hadoop, and NoSQL databases are hot topics. This year, Oracle introduced a complete suite of technologies for big data and the process of acquiring, organizing, analyzing, and making business decisions with all this data. You’ve heard the product presentations. You’ve seen the demos. Attend this BOF session to share your experiences, pose questions to the experts, and meet other customers who are working on big data application solutions. Senior members of the Oracle NoSQL Database, Oracle Big Data Connectors, Oracle R Enterprise, and Oracle Big Data Appliance teams will be there to answer your questions.
45 Minutes BOF (Birds-of-a-Feather) Jean-Pierre Dijcks David Segleau , Melliyal Annamalai
Is your data warehouse growing faster than your storage budget? Is your data warehouse’s size slowing down your queries? Are you struggling with the challenge of archiving online transaction processing (OLTP) data while keeping it accessible to users? If you answered yes to any of these questions, your attendance at this session is mandatory! You’ll learn how Oracle Database’s Hybrid Columnar Compression feature can shrink your data warehouse to as little as 1/15 of its original size while greatly improving query performance. You’ll also learn how, with up to 50X compression for archive data, it enables you to keep your historical data available for users, and your storage administrator won’t even care it’s there. The session offers Oracle Hybrid Columnar Compression best practices.
1 Hour Conference Session Holger Friedrich Miles Oustad , Vineet Marwah , Gregg Christman
This session looks at various database features in the latest generation of database technology that every developer needs to be aware of and shows how you can implement your application with security in mind.
1 Hour Conference Session Thomas Kyte
Oracle plans to integrate Oracle Essbase and the EPM product suite with Oracle Business Intelligence Enterprise Edition and Oracle Fusion Middleware. So with the latest release of Oracle Business Intelligence Enterprise Edition, 184.108.40.206, how do you connect Oracle Business Intelligence Enterprise Edition to your Oracle Essbase databases and how well does it handle Oracle Essbase features such as scenario and account dimensions, changing outlines, and unbalanced/parent-child hierarchies? How well do Oracle Business Intelligence Enterprise Edition’s ad hoc reporting tools handle Oracle Essbase hierarchies and member selections in the 220.127.116.11 release? Can we still embed Oracle Business Intelligence Enterprise Edition dashboards in Oracle Workspaces? Learn the answers in this session.
1 Hour User Group Forum (Sunday Only) Mark Rittman
We can’t write software without our brains, and our brains come with a full load of “issues.” The way our brain remembers the past and projects into the future has a big impact on how we write code. Moving beyond physiology, human psychology also plays its role, making it difficult for us to acknowledge ignorance and ask for help. This session offers an intensive coding therapy session (including couples therapy, dream therapy, and shock therapy) to help all attendees come to grips with their innate, unavoidable issues, making it easier to write better code—and help others on their team write better code.
1 Hour Conference Session Steven Feuerstein
Oracle Exalytics is Oracle’s hardware/software platform for “speed of thought” analysis. This presentation looks initially at the architecture and capabilities of Oracle Exalytics and then goes through the development of an Oracle Exalytics application sourcing data from structured and semistructured sources, analyzed with Oracle Business Intelligence and Oracle Endeca Information Discovery. Aimed at developers looking to leverage this new in-memory platform, the session provides an end-to-end guide to developing fast, interactive, and highly visual applications with these new BI tools.
1 Hour Conference Session Mark Rittman
Weblogs, social media, smart meters, sensors, and other devices generate high volumes of fast-moving data: big data. This session explains how to harness big data, your existing data, and predictive analytics to make better decisions in an environment of rapid shifts in behavior and instant feedback. It outlines a technology landscape for maximizing the impact of your big data implementation on your business. You will learn about the technologies that constitute a big data architecture, how to leverage and implement advanced analytics for real-time decisions, and the tools needed to know the unknown.
1 Hour Conference Session Jean-Pierre Dijcks
Oracle Endeca Information Discovery is a new Oracle Fusion Middleware product that helps you analyze unstructured, semistructured, and structured data sets from disparate datasources with little up-front data modeling. This session, for Oracle BI/data warehouse developers, develops an Oracle Endeca Information Discovery application from data sourced in Oracle Endeca Information Discovery’s Integrator feature to dashboards and shows how disparate jagged datasources are loaded and integrated in Oracle Endeca Server. With this data, the session involves building a hybrid search/analysis application with Oracle Endeca Information Discovery’s Studio feature and shows how such applications complement and extend the traditional relational and OLAP-based Oracle Business Intelligence dashboards.
1 Hour User Group Forum (Sunday Only) Mark Rittman
This presentation looks at an Oracle Business Intelligence implementation that was designed to provide real-time analytics based on a high-volume event-driven enterprise architecture. It looks at the design and architecture decisions and talks through some of the technical challenges of using Oracle Data Integrator to read high-volume data from an event queue into Oracle Exadata. Reporting was provided through Oracle Business Intelligence Enterprise Edition, and the presentation looks at some of the physical and logical structures required to support the query times needed for real-time reporting, plus some of the visualization techniques used to enable the business to understand the ever-changing data set.
1 Hour User Group Forum (Sunday Only) Jon Mead
Learn how Oracle Data Integrator provides best-in-class technology for reliable, repeatable bulk data movement and transformation with high performance. Oracle Data Integrator delivers success in enterprise integration across a variety of scenarios such as SOA-based architectures, data warehousing, and many more. This session features actual customers sharing their experiences as well as how they maximized their investment in Oracle Data Integrator.
1 Hour Conference Session Soeren Ahrens Paul Stracke , Gurcan Orhan , Julien Testut
Data integration is more than simply moving data in bulk or in real time—it is also about unifying information for improved business agility and integrating it in today’s service-oriented architectures. This hands-on lab—for developers, DBAs, and architects—demonstrates best practices for integrating Oracle Data Integrator and Oracle SOA Suite.
1 Hour HOL (Hands-on Lab) Denis Gray Christophe Dupupet , Alexander Kotopoulis
Data warehousing solutions are as critical for IT environments as online transaction processing (OLTP) systems. Attend this session to see how Oracle Data Integrator and Oracle GoldenGate provide industry-leading performance and scalability for data integration on Oracle Exadata. In the session, Oracle Product Management demonstrates how Oracle Data Integration can maximize the performance of source and target systems and minimize batch windows while ensuring data quality—all without adding more hardware resources. The session focuses on best practices for Oracle Data Integration on Oracle Exadata that deliver high performance and low TCO for your data warehousing solutions. It includes real-life customer examples.
1 Hour Conference Session Denis Gray Julien Testut
This hands-on lab highlights for developers, DBAs, and architects some of the best practices for implementing extract/load/transform (ELT) techniques to improve performance and reduce data integration costs with Oracle Data Integrator. Participants will walk through the steps needed to load and transform various sources into a relational table target, including how to deploy and manage interfaces with Oracle Data Integrator.
1 Hour HOL (Hands-on Lab) Julien Testut Jayant Mahto , Michael Eisterer
In this session, the Oracle Data Integration product management team presents an overview of Oracle Data Integrator, the current strategy for Oracle Data Integrator, as well as the latest new and future exciting key features. The presentation focuses on the latest Oracle Data Integrator 11g features as well as a preview of the future product roadmap and strategy for Oracle Data Integrator. Features and functionality covered during the presentation include big data integration, cloud integration, smart import/export, Oracle Data Integrator shortcuts, Global Knowledge Modules, XML enhancements, BI enhancements, Oracle Data Integration load plans, and many additional performance and productivity enhancements.
1 Hour Conference Session Denis Gray
An accelerated increase in compute capacity, data volumes, and heterogeneous datasources fueled by advances in architectures such as very large memories, distributed parallel computing, and engineered systems at a practical price/performance ratio is changing the nature of enterprise business analytics and requirements for data integration tools. This session covers Oracle’s major data integration products, including Oracle GoldenGate, Oracle Data Integrator, Oracle Enterprise Data Quality applications, and Oracle Big Data Connectors. It highlights key product updates, along with the roadmap and future strategy for addressing the next tier of data integration challenges.
1 Hour Conference Session Irem Radzik Bradley Adelberg
Learn tips and tricks for utilizing Oracle Data Integrator in a real-time integration scenario. This session covers Raymond James’ implementation of real-time data warehousing, including customizations to Oracle Data Integrator to improve throughput and lower integration latency.
1 Hour Conference Session Tim Garrod Ryan Fonnett , Christophe Dupupet
The advent of industry megatrends such as social data, device sensor data, and mobile computing platforms’ growth in popularity over desktops means that data volumes are going to be explosive, with organizations trying to figure out how to save and analyze the data. Oracle Data Integrator is critical to any enterprise big data strategy—it provides native support for Hadoop and Hadoop Distributed File System (HDFS) via Oracle Big Data Connectors. In this session, you’ll learn about Oracle Data Integrator and Oracle Big Data Connectors and how, coupled together, they provide the critical connectivity to multiple big data sources. Also, hear how Oracle Data Integrator supports business intelligence/data warehouse enterprise initiatives that are extended through big data analytics.
1 Hour Conference Session Mala Narasimharajan Michael Eisterer
In this session, the Oracle Product Management team focuses on advanced data integration patterns and customer use cases that are proven to increase overall performance while also reducing total cost of ownership. The presentation covers how easily Oracle Data Integrator can natively integrate with your SOA platform without additional hardware as well as how easy it is to extend and adapt Oracle Data Integrator to your business needs. Oracle Data Integrator can handle even the most complex of tasks out of the box, but there are always advanced outside-of-the-box requirements. By utilizing the Oracle Data Integrator SDK and its Groovy scripting and adapting its knowledge modules, you can easily adapt Oracle Data Integrator to meet your advanced data integration and business requirements.
1 Hour Conference Session Alexander Kotopoulis Christophe Dupupet
The Integrated Capture mode of extract, available in Oracle GoldenGate Release 11.2.1, is specific to Oracle Database, using native database mining to capture database changes. This session focuses on the new capabilities; datatypes, such as compressed tables and XMLType; and advantages available in this mode and presents configuration recommendations for best performance.
1 Hour Conference Session Joydip Kundu Lik Wong
You might expect to have DBAs involved in data modeling and maintaining physical objects and entities, but how are they involved with master data management (MDM)? MDM becomes important for DBAs as they see data issues and deal with them. DBAs are definitely part of MDM activities but can’t do it alone. Support of the business and involvement with other architects and technologists are critical. This involvement includes a unique perspective to help provide metrics and other solutions that those in this role are able to provide—especially across the larger database environment. This session provides some insights into how to get involved in MDM projects and shows what value can be added by the DBA role.
1 Hour Conference Session Michelle Malcher
This session highlights new features in external tables and in Oracle Database’s SQL*Loader feature that make it easy to load your files. In the presentation, Oracle developers tell you how to take your SQL*Loader control file and make an external table out of it. Learn about shortcuts you can use to simplify the syntax in your control file or external tables. Discover tools available to help you write your control files and access parameters. Hear a speaker from Accenture discussing SQL*Loader’s new features and performance and offering tips for reducing load times.
1 Hour Conference Session Radu Parvu Michael Sakayeda , James Stenoish