ODTUG is a real world user group for real world technologists, providing community, technical resources and support for a wide range of technologists working with the Oracle platforms.
| Tools, Tools, Tools - The Kscope11 Database Development Symposium |
   |
|
Tools, Tools, Tools - The Kscope11 Database Development Symposium 8:30-8:45 Introduction Chet Justice, ORACLENERD 8:45-9:00 How Tools Relate To Performance Cary Millsap, Method R Corporation Cary Millsap will be speaking before three of the four sessions for ten to fifteen minutes. He will speak on the importance of considering performance while you are designing or coding. He will also do a small demo of Method-R's MR Trace and MR Profiler tools. 9:00-9:40 What's Hot, What's Not Sten Vesterli, Scott/Tiger A/S Are you still using Oracle Forms and wondering what to do in the future? Is Application Express right for you? Considering Oracle Application Development Framework (ADF)? This presentation gives you an overview of the three most important application development approaches available from Oracle today, discussing the strong and weak points of each: Application Express (browser-based development, additional logic is implemented in PL/SQL and JavaScript, used by Oracle for thousands of in-house applications); Application Development Framework, ADF (strong tool support in JDeveloper, advanced component library, additional logic implemented in Java, used by Oracle for Fusion Applications); Oracle Forms (the classical Oracle development tool, high developer productivity, logic implemented in PL/SQL, now Web deployed with some client-side integration possible) The presentation is concluded with a "hot or not" summary of which application development approach will be right for you and your organization in the coming years. 9:45-10:30 Oracle SQL Developer 3.0: Product Update and New Features Kris Rice, Oracle Corporation Oracle SQL Developer provides database developers with a powerful tool for database tasks. This session reviews the latest features, including the new visual query builder, support for DBMS Scheduler, and the SQL Code Advisor. The new feature list includes a wide variety of changes and updates, some large, such as the new DBA navigator, which supports DBA-related functionality, such as DB Controls and support for roles and tablespaces, and smaller features, like the updates to the export and import functionality. This session will demonstrate some of the new features and highlight points of interest for the others. 10:30-10:45 Break 10:45-11:25 Collaborative Development and Other New Features Sue Harper, Oracle Corportion 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. This session assumes a basic knowledge of the product and demonstrates the new functionality introduced in SQL Developer Data Modeler 3.0. Using an existing model, the presenter will demonstrate the new integration support for Subversion, which allows users to track changes to models and objects and work collaboratively. The session will also demonstrate the ability to add custom design rules and transformations and a wide variety of minor changes and additions to the product. 11:30-12:15 The Business Value of Data Modeling with SQL Developer Data Modeler Marc de Oliveira, Simplify Systems 12:15-1:00 Lunch 1:00-1:15 Why Logging and Monitoring Is Good Cary Millsap, Method R Corporation 1:15-1:40 DBMS_MONITOR, DBMS_TRACE, DBMS_APPLICATION_INFO Tom Kyte, Oracle Corporation Practical Instrumentation - This symposium will take a quick look at database features/capabilities you already have that you might not be using, or might not be using enough. Some of the items covered will be dbms_monitor, dbms_trace, and dbms_application_info. 1:45-2:15 SQL Developer's Built in Logging and Monitoring Kris Rice, Oracle Corporation 2:30-2:45 Agile Development Cary Millsap, Method R Corporation 2:45-3:25 On the Importance of a Good Data Model Robyn Sands, Cisco With all the emphasis on features, business process models, and work flows, have data models become irrelevant? Does the object model replace the ERD diagram, or are we skipping a critical design process in our rush to be 'agile'? This presentation will discuss data model requirements and why understanding the data is necessary for scalability, performance, and agility. 3:30-4:30 Development Procedures and Database Structures Dominic Delmolino, Agilex Technologies The traditional programmer has many processes and tools that enable development to occur in a semi-orderly manner. Robust source code control infrastructures coupled with mature build processes and integrated development environments are the norm for most software development teams. This is in stark contrast to the database developer, who struggles with making sure that database schemas and structures can fit into a file-based source code control system. This talk describes database development patterns and antipatterns in the context of producing database versions along with deployment packages. Concepts such as the ability to support multiple schema versions (both pre-11g and with 11g edition support), database change tracking, integration with source code control, generation of deployment scripts, and schema deployment planning will be discussed and demonstrated. Minimization of outages related to schema changes will also be covered. This topic will also be discussed in the context of using various database modeling, development, and change management tools, with special attention to their applicability to the development lifecycle.
|
Subtopics
- Design/Data Modeling
OLTP, OLAP, DW, All design topics under here - Coding
PL/SQL, SQL, Java in the DB, XML, Hadoop/PHP/Ruby, etc. - Maintenance
Tuning, Performance, ALM, Upgrading, etc. - Best Practices
Instrumentation, Agile, Security, etc. - MySQL