Database Development Session Presentations

After thirteen years within Oracle consulting in Australia, New Zealand, and the United States, David Peake joined the product development team as the Oracle Application Express (APEX) product manager in 2006. David regularly presents at many Oracle conferences around the world and often contributes Oracle Magazine articles as well as maintaining a popular blog (http://dpeake.blogspot.com).

After thirteen years within Oracle consulting in Australia, New Zealand, and the United States, David Peake joined the product development team as the Oracle Application Express (APEX) product manager in 2006. David regularly presents at many Oracle conferences around the world and often contributes Oracle Magazine articles as well as maintaining a popular blog (http://dpeake.blogspot.com).

After thirteen years within Oracle consulting in Australia, New Zealand, and the United States, David Peake joined the product development team as the Oracle Application Express (APEX) product manager in 2006. David regularly presents at many Oracle conferences around the world and often contributes Oracle Magazine articles as well as maintaining a popular blog (http://dpeake.blogspot.com).

Once the code is compiled, building tests to ensure that it is accurate is essential. This session shows you how to create unit tests, build implementations, save tests to a library, and run the tests, individually or as a suite. You will also learn how to take advantage of the new features in Release 3.1, such Database Diff, Database Copy, Oracle Recovery Manager (Oracle RMAN), and Migrations.

Step-by step-demos illustrate how to get started with developing Oracle Database .NET applications, using each of these free products. The presentation pays special attention to PL/SQL and .NET coding techniques as well as the Oracle PL/SQL tools and debugger built into Visual Studio that give .NET and PL/SQL developers more power than ever.

Product manager for Oracle Database on Windows as well as for .NET technologies for database developers, such as our Oracle Developer Tools for Visual Studio and Oracle Database on Windows.

This session features step-by-step demonstrations that build an Entity Data Model (EDM) from an Oracle Database schema, query that EDM with LINQ, perform data manipulation on the EDM, and generate an Oracle Database schema with Entity Framework. It also introduces the new fully managed Oracle Data Provider for .NET (ODP.NET), which greatly eases the deployment of .NET applications. As a single dynamic-link library (DLL), it has no dependencies on any other Oracle Database client libraries and is very lightweight, making it very easy to deploy and manage side by side with other assemblies. The presentation also discusses additional new features coming in .NET for Oracle Database.

Product manager for Oracle Database on Windows as well as for .NET technologies for database developers, such as our Oracle Developer Tools for Visual Studio and Oracle Database on Windows.

This session covers advanced Oracle Database mechanisms that help optimize Java persistence, performance, scalability, and high availability. It discusses how to scale and fail over Java connections with Universal Connection Pool, fast connection failover, and runtime load balancing; how to implement efficient Java persistence with row prefetching, LOB prefetching, array DML, SecureFile LOB, query change notification, and consistent client-side result caching; and how to optimize Java performance in the database. Understand the architecture, memory manager, JIT compiler, security manager, threading, and more.

Kuassi Mensah is Group Product Manager for Oracle Database Access Frameworks (Drivers, DRCP, Net Services) and database programming APIs (Java, C/C++, PHP, Ruby, Python, Perl). Mr Mensah holds a MS in Computer Sciences from the Programming Institute of University of Paris VI. He has published several articles and a book @ http://www.amazon.com/exec/obidos/ASIN/1555583296 He is is a frequent speaker at Oracle and IT events and maintains a blog @ http://db360.blogspot.com, as well as facebook, linkedin, and twitter (http://twitter.com/kmensah) pages.

This session shows how you can use Oracle Database monitoring tools such as Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and Oracle SQL Developer to identify and remedy application issues early in the development cycle and after application deployment. Topics include diagnosing connection issues; hard parsing; soft parsing; wrong default; cursor and memory leaks; excessive network round-trips; and application design best practices for ensuring high performance. The session uses Java examples, but the techniques it describes apply to any programming language, such as Java, C, C++, C#, PHP, Python, Ruby, or Perl.

Kuassi Mensah is Group Product Manager for Oracle Database Access Frameworks (Drivers, DRCP, Net Services) and database programming APIs (Java, C/C++, PHP, Ruby, Python, Perl). Mr Mensah holds a MS in Computer Sciences from the Programming Institute of University of Paris VI. He has published several articles and a book @ http://www.amazon.com/exec/obidos/ASIN/1555583296 He is is a frequent speaker at Oracle and IT events and maintains a blog @ http://db360.blogspot.com, as well as facebook, linkedin, and twitter (http://twitter.com/kmensah) pages.

It explains how Oracle's flexible approach to XML optimizes storage and indexing and delivers efficient, performant processing of structured and unstructured XML content. It includes an introduction to binary and object-relational XML storage and how to use XML standards such as XQuery to process XML content. You will also learn about generating XML from relational data with SQL/XML and using the XML DB repository to create document-centric applications that use familiar file /folder metaphors to organize XML.

Learn how to use standard SQL and database APIs such as JDBC, ODBC, .NET, OCI, Pro*C, and PL/SQL to dramatically improve application response time and throughput. The presentation shows how to effectively extend an application to scale out transaction throughput and the effective size of cached data, using an in-memory database cache grid. This session is ideal for database developers requiring maximum performance for new and existing applications, using well-understood and widely used database APIs.

Simon Law is a Principal Product Manager responsible for the Oracle In-Memory Database Cache and TimesTen In-Memory Database products at Oracle. Simon has been with Oracle for over 10 years, working first in the Support services division and then as a product manager at the Server Globalization team. He joined the TimesTen division of Oracle in 2006. He is responsible for driving new requirements, promoting TimesTen features, and working as the communication channel between customers and development.

This session shows how this can be achieved with just a few mouse clicks with Oracle Application Development Framework (Oracle ADF) Data Visualization Tools in conjunction with Oracle Spatial or Oracle Locator. A demo scenario merges geospatial information from a database with statistical information and renders a cartographic map in a simple JavaServer Faces page, using the Oracle Fusion Middleware MapViewer feature. The presentation explains architectural aspects of managing location information and briefly touches on the possibilities of rendering three-dimensional data.

However, the key challenge for most companies is trying to understand how to unlock the real business value within these new datasources. The Oracle Big Data platform—including Oracle Big Data Appliance, Oracle Exadata, and Oracle Exalytics—provides enabling technology that greatly simplifies the process of acquiring, organizing, and analyzing these datasources. This session includes a case study explaining how Oracle Big Data technology can be used to harness the power of these new datasources—social media in this case—to identify new business opportunities and deliver enhanced customer satisfaction.

It is designed to scale up from single servers to thousands of machines, each offering local computation and storage. Hadoop can be integrated with MySQL to take advantage of this framework for data-intensive applications, and this session demonstrates the integration of Hadoop with MySQL.

It examines techniques for optimizing connection pooling, statement caching, data fetching and updating, statement batching, and Oracle datatype usage. Furthermore, it demonstrates tuning tools included with Oracle Developer Tools for Visual Studio, such as Oracle Performance Analyzer, which monitors the running application, highlights performance problems, and offers specific recommendations. Finally, the session discusses best practices for ODP.NET and Oracle client deployment to your midtier servers or clients.

Product manager for Oracle Database on Windows as well as for .NET technologies for database developers, such as our Oracle Developer Tools for Visual Studio and Oracle Database on Windows.

It shows how the repository provides a powerful, flexible platform for managing XML and other forms of content and how to access content stored in the repository by using industry-standard protocols such as HTTP and WebDAV as well as via SQL. It also discusses how access control lists enforce security and how to interface the repository with externally defined user communities. It demonstrates using repository events to store content in user schemas. Finally, it introduces two interoperable content management applications—one built with Ajax and XSL, the other with Oracle Application Express—and a solution for performing file-level backup-and-restore operations.

Oracle Database has long had support for the MapReduce paradigm via SQL analytics, user-defined pipelined table functions, and aggregation objects. Apache Hadoop implements the MapReduce model. This session describes a prototype of an Oracle in-database Hadoop implementation that lets you write and execute Hadoop-compatible applications written in Java directly in the database. The major advantages of this implementation: source compatibility with Hadoop, minimal dependency on the Apache Hadoop infrastructure, seamless integration of MapReduce functionality into Oracle SQL Developer, and better parallelism and efficiency.

Kuassi Mensah is Group Product Manager for Oracle Database Access Frameworks (Drivers, DRCP, Net Services) and database programming APIs (Java, C/C++, PHP, Ruby, Python, Perl). Mr Mensah holds a MS in Computer Sciences from the Programming Institute of University of Paris VI. He has published several articles and a book @ http://www.amazon.com/exec/obidos/ASIN/1555583296 He is is a frequent speaker at Oracle and IT events and maintains a blog @ http://db360.blogspot.com, as well as facebook, linkedin, and twitter (http://twitter.com/kmensah) pages.

In this session, learn how Oracle In-Memory Database Cache enables application developers to use standard SQL and database APIs to dramatically improve application response time and throughput by caching performance-critical subsets of an Oracle Database in the application tier. The in-memory cache grid enables applications to easily scale-out without service interruption, making Oracle In-Memory Database Cache ideal for a wide-range of applications with requirements for extreme performance in the application-tier.

Simon Law is a Principal Product Manager responsible for the Oracle In-Memory Database Cache and TimesTen In-Memory Database products at Oracle. Simon has been with Oracle for over 10 years, working first in the Support services division and then as a product manager at the Server Globalization team. He joined the TimesTen division of Oracle in 2006. He is responsible for driving new requirements, promoting TimesTen features, and working as the communication channel between customers and development.

Database design and generation can start with a blank page and users start by building a new ERD. In today's development environments, much development starts with an existing data model. In this session we reverse engineer an existing data model, make changes to the model, compare and merge changes and update the database with those changes. In the process we also look at the utilities offered by the Data Modeler for verifying the design though design rules and by applying transformation scripts.