Data Modeling BC (Before Coding) Warren Capps, Illuminations Inc.
The completion of the data model is just the beginning of development. Too many programmers jump straight from one stage to the next without considering what features of the database can be used to enhance the data model and make their development task easier. This presentation will look at how to abstract the data model to easily accommodate change to the basic data model structure and adapt the data model to capture simple business rules.
Masque of the Red Data Warren Capps, Illuminations Inc.
Both local security rules and government regulations may require that sensitive data, moved out of production into development, test, and/or QA databases remain secure. Rather than making these databases conform to a complex regulatory environment, data masking allows us to convert the data when moving it in accordance to a set of masking rules and templates. This masked data can still retain critical relationships, yet be completely secure.
Coding with the Stars! Top Oracle Tips and Techniques for Developers Tony Catalano, Rolta TUSC
Tony Catalano has accumulated a list of tips and techniques that assist with the development of Oracle-based custom applications. These tips and tricks can be used to improve application performance, to streamline code, and to create higher quality applications. The speaker will describe each topic in detail as well as provide real world examples of how to use them.
Oracle SQL Developer Unit Testing: Testing your PL/SQL Code Ashley Chen , Oracle Corporation
Oracle SQL Developer supports the development of SQL and PL/SQL code. You can create, edit, compile, and run your code using the editors provided. Once compiled, building tests to ensure the code is accurate is essential. In this session, Kris Rice will show you how to use SQL Developer unit testing to create and run unit tests. He will look at the different aspects of working with PL/SQL code and where unit tests fit into the flow.
Explain the Explain Plan Maria Colgan, Oracle Corporation
The explain plan is an invaluable tool in managing database performance. Within this session, Maria Colgan will examine the different aspects of an execution plan (from selectivity to parallel execution), explain what information you should be getting from the plan, and how it affects the execution. You will learn why the optimizer made the decisions it did and derive a set of corrective measures that can be used to improve each aspect of the plan.
Finally Plan Stability during Database Upgrade with SQL Plan Management
Maria Colgan, Oracle Corporation
This session will provide step-by-step instruction on how to maintain predictable SQL performance by providing plan stability during a database upgrade. It will cover detailed instructions on how to capture your existing execution plans before the upgrade, as well as an in-depth discussion on what to expect after you upgrade to 11g. The session will also cover optimizer statistics management during an upgrade.
In-Depth (1/2 day): Data Warehouse Performance Best Practices Maria Colgan and Jean-Pierre Dijcks, Oracle Corporation
Have you wondered whether your data warehouse is getting the best performance it can? Or whether you've made the right decisions to keep your multi-terabyte system highly available? Attend this session to learn best practices for deploying a data warehouse on Oracle Database 11g. Using detailed examples and live demonstrations, this session will cover schema design, hardware considerations, data loading, partitioning strategies, parallel query, workload management, and more. Last but not least, you will learn how to monitor, diagnose, and correct performance issues. Using both the old reliable tools such as explain plan and AWR as well as an introduction to the latest and greatest SQL monitor tool. After this session you will be able to effectively design a data warehouse and administer and diagnose any issues that may arise.
Understanding Your Code with PL/Scope and the Hierarchical Profiler Lewis Cunningham, Database Architect
PL/Scope is a compile time tool provided by Oracle that allows you to better understand your compiled (in the database) code. PL/Scope is a great tool for code reviews as it tells you a lot of information about what data types are being used, formal parameter definitions, call stacks, and variable usage. While PL/Scope allows you to better understand your compiled code, the hierarchical profiler allows you to understand the run time aspects of your code; what's running well and what's not. This session will explain what PL/Scope is, how to use it, as well as WHY and when to use it. The session will also show how to run the hierarchical profiler and interpret its output. After attending this session, you will have the tools to really understand your application's database usage.
Oracle and/or Hadoop – The Answers You are Looking for! Jean-Pierre Dijcks, Oracle Corporation
A lot has been blogged about MapReduce or its Hadoop implementation and sometimes it feels like this is the solution for everything from parallel processing to the common cold and beyond. This session will explain what MapReduce or Hadoop actually is, how you can apply the same rules and processes in Oracle, and what a good strategy for leveraging the best of both worlds would look like.
Get the Best out of Oracle Partitioning with Oracle Database 11g
Jean-Pierre Dijcks, Oracle Corporation
Partitioning is a key technology for addressing the requirements of large data volumes, for data warehouse, as well as OLTP environments. Benefits are not only for performance, but also increasingly for manageability and Information Lifecycle Management. This session will recap partitioning fundamentals as well as discuss enhancements of Oracle Database 11g Release 2. It will furthermore provide an insight into how to get the best leverage out of Oracle Partitioning after upgrading.
Effective Utilization of the Database in Web Development Paul Dorsey, Dulcian, Inc.
This presentation discusses how the decision to use a “thick database approach” impacts database developers. Successful application logic in the database requires SQL and PL/SQL features such as object types and collections, INSTEAD OF triggers, function-based views, bulk operations, autonomous transactions, etc. This presentation will include real world examples to help attendees build systems that perform better and are easier to maintain over time.
Agile UML Modeling in JDeveloper Susan Duncan , Oracle Corporation
The presenter first examines how UML class modeling tools substitute, more than adequately, for traditional ERD logical data models, both in capturing semantics and in transforming them into database designs. He then explores how other core UML models (Use Case, Sequence, and Activity) interact to provide a lightweight, but effective, framework for application development. This presentation demonstrates the techniques, extensively, using JDeveloper R11 UML2 modeling tools.
Guarantee Application Success Steven Feuerstein, Quest Software
Successful applications are correct, fast enough, and maintainable. But how do you achieve these objects? This session will explore techniques to do just that.
Coding Therapy for Software Developers Steven Feuerstein, Quest Software
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. Steven Feuerstein will, in this keynote address, offer 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.
XML Database - Design Concepts for XML Applications that will Perform! Marco Gralike, AMIS Services BV
The relational world has a lot of best practices regarding coding applications and its design. Most of these best practices will not work while dealing with XML data or applying these principles in XML architectures. XML data on disk is very often ten to one hundred times faster than handling XML in memory. Why does this work and what are the principles behind this? This presentation will show and explain methods to make your XML application perform.
OMG! Identifying and Refactoring Common SQL Performance Anti-patterns Jeff Jacobs, Jeffrey Jacobs & Associates
You too can be a SQL performance hero without being a DBA. Many of today's SQL performance problems are due to poor design and poorly written SQL and are easily identifiable Anti-patterns. The presentation will discuss why developers produce poorly performing queries and applications, and offer quick fixes to many common SQL performance problems.
Database Development Panel
Jeff Jacobs, Jeffrey Jacobs & Associates
SQL, PL/SQL, CBO, performance, architecture, new features, design, modeling ... You have questions, our world class experts have answers! Featuring Jonathan Lewis, Steven Feuerstein, Cary Millsap, Maria Colgan, Lewis Cunningham, and John King. Moderated by Jeff Jacobs.
Introducing and Demonstrating Oracle Database 11gR2's Killer Feature – Edition- Based Redefinition for Developers and DBAs Abstracts Lucas Jellema, AMIS
Edition-based redefinition (EBR) in Oracle Database 11g Release 2 is spectacular, introducing a new dimension to the database which allows us to version objects within a schema. Through EBR, we achieve zero-downtime application upgrade and multiple application versions simultaneously against one schema. No more big-bang upgrade! This session introduces EBR, demonstrates the SQL, and shows the multi-version application. It dives into some complexities of data synchronization between editions and discusses best practices with EBR.
Multi-User Access and Version Control for SQL and PL/SQL Files Sue Harper , Oracle Corporation
This session considers SQL and PL/SQL file management and version control. This session looks at best practices and offer advice based on experience gathered from an internationally situated development team. It looks at multi-user access, checking in code, and at sharing files with colleagues. The discussion is supported by demonstrations, using SQL Developer as the client to access the files in the file system, and Subversion, an open source version control tool for managing the files.
SQL Developer Data Modeler: From Soup to Nuts
Sue Harper, Oracle Corporation
Oracle SQL Developer Data Modeler is a feature-rich product supporting logical, relational, multi-dimensional, data type and data flow models, and physical data modeling for Oracle and non-Oracle databases. In this session, Sue Harper will not illustrate every detail the product offers. Instead she will follow a flow of work, starting from scratch with an empty model and touching all aspects of the product, discussing how the models relate to each other, and the salient points of each.
Oracle 11g for Developers: What You Need to Know John King, King Training Resources
New features of the Oracle Database, geared to developers, are discussed and demonstrated. Attendees are introduced to new and improved features of Oracle11g directly impacting developers. Specific topics include: new SQL functions, regular expression improvements, virtual columns, new XMLType options, XML indexing improvements, SQL pivot statements, JDBC improvements, PL/SQL syntax enhancements, PL/SQL compiler, trigger improvements, PL/SQL result cache, and materialized view improvements.
Why Isn't Oracle Using My Index Jonathan Lewis, JL Computer Consultancy
This is a short introduction to the way in which the optimizer decides on an execution plan for your query. Combining a few graphics with a little arithmetic, Jonathan Lewis will explain why Oracle will ignore an index that you think it should be using, and why it will use an index that you think is unsuitable. He will also consider how various parameter settings affect the choice.
Co-operating with the Database Jonathan Lewis, JL Computer Consultancy
It is easy to write SQL that has to run inefficiently, and it is easy to write SQL that results in very unstable performance. In this presentation, Jonathan Lewis will take an example of each type of problem and explain why the developer sometimes has to do a little extra work, and introduce some extra complexity, in the front-end code to allow the database to respond efficiently and consistently.
How to Write Efficient SQL Jonathan Lewis, JL Computer Consultancy
If you want to write an efficient query, you need to be familiar with the data, metadata, and the intent of the query. In this presentation, Jonathan Lewis will discuss the information you need to know (or collect), and then explain how knowing this information will allow you to construct a "picture" of your query that allows you to identify the most efficient route to your final result.
Online Application Upgrade Using Edition-Based Redefinition Bryn Llewellyn, Oracle Corporation
Oracle Database 11g Release 2 introduces new capabilities that allow upgrading the database component of an application without uninterrupting its availability. These new kinds of objects are key: the edition, the editioning view, and the cross-edition trigger. Code changes are installed in the privacy of a new edition. The capability as a whole is called edition-based redefinition -- EBR for short. This session explains how it all works.
Thinking Clearly About Performance Cary Millsap, Method R Corporation
Cary Millsap describes the fundamentals of performance in a session designed to put DBAs and developers alike onto the right path of thinking clearly about the speed of software and how to manage it.
Oracle Extended SQL Trace Data for Developers Cary Millsap, Method R Corporation
Cary Millsap describes Oracle extended SQL trace data to developers so they can learn how to use this rich source of performance data to build faster, more scalable, more easily maintainable applications.
Performance instrumentation is a little extra application code that makes it possible to efficiently diagnose and solve performance problems quickly and permanently, often before users even sense something is wrong. This presentation will provide examples of how to include instrumentation in your code using Oracle's built-in packages and a free open source instrumentation package called the Instrumentation Library for Oracle (ILO) that will make code instrumentation an easy and effective part of your coding standards.
Analytic Functions Revisited Alex Nuijten, AMIS Services
Analytic function can make your life as a developer a lot easier once you get analytic functions in your fingertips. Even though the syntax may seem daunting at first, it becomes second nature very quickly. This presentation will cover the syntax and is packed with real life examples of how to apply them on a daily basis. See the performance increase with just a few lines of code and bring you sheer development joy.
Automatic Test Data Generation For an 11g Database – A Case Study and Demo Chandu Patel, Deloitte Consulting
This paper presents a technique to automatically generate and populate test data in desired tables of a schema. It is very desirable to have test/UAT databases populated with large quantity data, with end-condition values, and with proper referential integrity. It discusses what all DBA dictionary views are used to generate data. It also describes how to generate data for columns accepting only valid codes/values. The modular design makes it easy to extend and customize.
