OSWOUG

Oregon and Southern Washington Oracle User Group

Meeting Details



Tuesday, August 10, 2010

The Standard Insurance Center
900 S.W. Fifth Avenue
Portland, OR 97204

Standard Auditorium, C Level (down the escalator to the bottom level).

The meeting starts at 8:15 a.m.

New: Job Postings


Portland State Reporting Analyst

Contacts & Sponsors



Jon Wasserman jsw@oswoug.org
Erik Kaarto ejk@oswoug.org
Webmaster: open
Blogmasters: Erik Kaarto, Jon Wasserman, open, open!

Tek Systems

Software Technology Group

Presentation Slides

Presentations by Bradley Brown

How Oracle Came to Rule the Database World: presenter Richard Niemiec

Accessing Hierarchical Data in Oracle: presenter Carol-Lee Tutch



General Meeting, August 10, 2010. 8:30 a.m.



Oracle OpenWorld 2010: Brief Presentation.

Erik Kaarto will discuss Oracle OpenWorld 2010
Erik's career with Oracle, starting at Redwood Shores, extended through 15 years. He has attended almost every OpenWorld.


First Presentation: starts 8:50 a.m.

Boris Trukhnov, OCP, OCE
Installing Oracle 11gR2 RAC on Enterprise Linux 5 using VMware Server.

Boris will present installation considerations and details using VMware Virtual Machine and Red Hat Enterprise Linux.

Boris M. Trukhnov has been working with relational databases (primarily Oracle) since 1994 and is an author of several technical books published in US and translated into Portuguese, Chinese, and Russian, including “SQL Bible” (1st and 2nd editions) and “Introduction to Database Management”. Boris’s areas of expertise include RAC, ASM, RMAN, performance tuning, database and system architecture, platform migrations, and system upgrades. Boris is an Oracle 10g Database Administrator Certified Professional (OCP) and Oracle Real Application Clusters 10g Administrator (OCE).

Second Presentation: starts 10:15 a.m.

Jake “Joselito” Ramirez
Oracle 11gR2 Functional RAC implementation and configuration - What you need to know coming from 10g and 11gR1.

- Connection with SCAN address
- Updated crsctl and srvctl commands
- Review of new services under 11gR2 grid infrastructure
- Grid Infrastructure Install
- RAC Database Creation

Jake “Joselito” Ramirez Biography

Joselito has a career that spans 16+ years in the fields of technical design, engineering, computer programming and research and development. Joselito is a veteran of the United States Air Force in which he served as a Computer Technician for a missile defense network system. Joselito majored in Computer Science at the University of Texas at Austin and has since worked in various positions as a technical consultant for small and large entities. Currently Joselito serves as a consultant for Hewlett-Packard where his focus is Oracle Database Engineer concentrating on High Availbility, VMware Virtualization and Data Center Systems and Large Scale Networking. Joselito has an unofficial passion for High Performance Computing “HPC” system optimization and design. He is a former Chair of the San Antonio Oracle Users Group.



Previous Meetings, and Events


APEX Class, May 10, 2010. 3:30-8:30p.m. Location: LSI 15220 NW Greenbrier Parkway, Ste 100 Beaverton OR 97006.

Bradley D. Brown, CIO and Co-Founder of TUSC
at The Standard Insurance Center

David Alexander will be honored for his contributions to OSWOUG.

Breakfast sponsored by TekSystems' Beaverton Offices. Tek is a national staffing agency.

RSPV to jsw@oswoug.org


Bradley D. Brown, CIO and Co-Founder of TUSC
Brad is an accomplished Oracle author and world-renowned speaker, his books include: "Oracle HTML DB Handbook" (the product was renamed Oracle Application Express), "Oracle Application Server 10g", "Oracle9i Web Development," "Oracle8i Web Development", and "Oracle Application Server Web Toolkit Reference" in 1997.

Monday

APEX CLASS is scheduled for Beaverton 3:30-8:30p.m. location TBD.
Developing Applications using Application Express.
Instructions to download and install APEX will be posted here.

Tuesday

Understanding Oracle Licensing. starts at 8:25a.m.

Building a Mashup with Application Express. 1 Hour Presentation.

Recession-proof your company with SOA. 1 Hour Presentation.

Wimpy Web Services vs. Powerful Flexible Web Services. 1 Hour Presentation.

The presentations will include detailed technical demonstrations.

First Presentation, Starting at 8:25am.
Oracle Licensing - How to negotiate.
Brian Decker
Oracle Licensing Specialist for TUSC
The Oracle Specialists.
Approximately 1/2 hour and time allotted for questions. Talk Details


Second Presentation: starts at 9am. (ApEx)
Building a Mashup with Application Express (ApEx)
==========================================================
In this presentation, Brad will talk about how to develop a mashup using Oracle Application Express. Traditionally people think of ApEx as being an "Oracle database" tool only - not a mashup tool. However, Brad will show how you can consuming Web Services to access data from any source - Oracle, MySQL, SQL Server, Access, Excel, Cloud Databases (like Zoho), etc. In Brad's presentation titled "Scalable Oracle ApEx" he explains how to create an n-tier architecture for ApEx. This architecture provides unparalleled scalability to your organization. This presentation explains the implementation side (i.e. the specifics) of this solution.

Third Presentation: starts at 10:10am
Recession-proof your company with SOA
Using Quick Turns for Quick Feedback
====================================
The ability to rapidly modify service offerings is becoming key to success in today's turbulent economy. Many companies are turning to SOA to help their business reduce development effort and achieve agility, but implementing SOA effectively has proved a daunting challenge all its own. How can today's IT managers and CIOs realistically propose SOA and quickly deliver benefits without risking their jobs? Rolta TUSC's Brad Brown will explain why historic SOA implementations have failed, how you can benefit from innovative software that fundamentally transforms the complexity of implementing SOA to an "instant" task, and how an agile, iterative approach can deliver rapid ROI for your business and ultimately lower total cost of ownership. In a time where budgets can be cut at a moment's notice, this briefing will ensure you derive value from your SOA initiatives in weeks and become the "hero" for your business.

Fourth Presentation: starts at 11:20am
Wimpy Web Services vs. Powerful Flexible Web Services
====================================================
In this presentation, Brad will discuss the importance of strong Web Services, the difference between wimpy services and powerful flexible Web services. Many companies today are attaching SOA MBOs to their technical teams. These performance metrics often measure based on quantity rather than quality. What is quality? Reuse? Performance? Flexibility? Brad will discuss this topic in detail.
Will cover integration tools such as Eclipse and Java. Building an open API that provides dynamic services provides a powerful service architecture to any business.

BIO*
Bradley D. Brown is Chief Technology Officer of TUSC, a ROLTA company.

Oracle Application Server, Oracle Application Express, Web Services, and the Service Oriented Architecture are a few of the technologies Brad has mastered over a career that spans more than 25 years.

Thomas Kurian, senior vice president -- Oracle Server Technologies Division, says, "Brad is among the foremost experts on Oracle's technology in the world."
He is an accomplished Oracle author and world-renowned speaker, his books include: "Oracle HTML DB Handbook" (the product was renamed Oracle Application Express), "Oracle Application Server 10g", "Oracle9i Web Development," "Oracle8i Web Development", and "Oracle Application Server Web Toolkit Reference" in 1997.

Brad has enjoyed a countless number of major implementation successes over the years, One milestone that clearly stands out centers around the development of "Periscope" which he released through TUSC in 2002. Periscope is breakthrough software that makes data from other data sources (i.e., Microsoft Access, Sybase, SQL Server, DB2, Web Services, file systems, APIs, etc.) appear as if it's in one big Oracle Database. The data also can be inserted, updated and deleted from many source databases. The groundbreaking tool works with more than 100 databases.

* More Information on Brad.

Brian Decker - Oracle Licensing - Talk Details
How do you know if you are getting the best deal on your Oracle licenses? What is a fair discount level? Am I affected by User Minimums? What about Processor licenses? What is my core factor multiplier? Do I need full use licenses, Application Specific Licenses, Limited Use licenses? How do I license a DR site, or Test and Dev environments? Can I de-support old licenses? What about these Unlimited License Agreements (ULA's)? When is the best time to buy licenses? I will answer these questions in the presentation. Questions and Answers to follow.

Required: RSVP your attendance to Jon Wasserman: jsw@oswoug.org Breakfast is sponsored by Tek Systems.
February 2010

Rich Niemiec, President and co-founder of TUSC

Three presentations.

How Oracle Won the Database World (1hr.)

Performance Tuning Oracle Grid: Parts I and II (50 minutes each)

Oracle Security Issues for DBA's will be presented by a DBA from TUSC.
(45 minutes and Q&A as time allows.)
Send correspondence in advance of the event to Jon Wasserman with requests for security topics to be covered by the experts from TUSC.

BIO*
Rich Niemiec, 47, Rolta's President of International EICT (Enterprise Information & Communications Technology) and President of TUSC - A Rolta Company.

TUSC is a Chicago-based systems integrator of Oracle-based business solutions since 1988; TUSC was the Oracle Partner of the Year in 2002, 2004, 2007 & 2008.

Rolta is an international market leader in IT-based geospatial solutions, and caters to industries as diverse as infrastructure, telecom, electric, airports, defense, homeland security, urban development, town planning and environmental protection.

Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG).

Rich is one of six originally honored worldwide Oracle Certified Masters.

In 2007, he authored the Oracle bestseller "Oracle10g Performance Tuning Tips & Techniques," an update of his previous 2 Oracle best sellers on Oracle8i and Oracle9i Performance Tuning. Rich was inducted into the Entrepreneurship Hall of Fame in 1998.

* abbreviated BIO.


November 2009

Tek Systems discussed the current job market for Oracle professionals.

Anatole Schaff:

Business Process Analysis Suite

As business process management (BPM) expands beyond isolated projects to mainstream programs at the division or enterprise level, there is an increased need for collaboration between process analysts and IT. Oracle Business Process Analysis (BPA) Suite speeds process innovation by rapidly modeling business processes and converting them into IT executables. It supports UML, BPMN, process simulation, and round-trip engineering to BPEL models. This session will present how Oracle BPA Suite allows business users to design, model, simulate, and optimize business processes to achieve maximum operational efficiency and reduce the "strategy to execution" gap.

Oracle Data Integrator (45 minutes plus question and answer session)

A key component of Oracle Fusion Middleware, Oracle Data Integrator (ODI) delivers unique next-generation Extract Load and Transform (ELT) technology that improves performance and reduces data Integration costs, even across heterogeneous systems. ODI provides high-performance movement and transformation of data across heterogeneous systems (Oracle and non-Oracle) in batch, real- time, synchronous, and asynchronous modes. ODI offers the productivity of a declarative design approach, as well as the benefits of Knowledge Modules which encapsulate best practices in loading, transforming, or integrating data for a specific data source or target. Join this session to see how ODI can benefit your Data Warehouse, Application Integration, Master Data Management, or Modernization Migration project.

Anatole Schaff is a principal SOA/BPM solution specialist at Oracle in the areas of Business Process Management and Service Oriented Architecture. His technical expertise covers Oracle BPA Suite, Oracle SOA Suite, Application Integration Architecture and software development. Anatole has more than 10 years of experience in architecting and developing solutions with Oracle technologies. Prior to joining Oracle he was Enterprise Architect at Tektronix. Anatole holds a MS in Engineering and Technology Management from PSU.

Carol-Lee Tutch:

Accessing Hierarchical Data in Oracle (30 minutes plus question and answer session)

Bill of materials, parts explosion, or hierarchically structured data presents challenges for traditional SQL queries. The standard SQL methods for examining hierarchies will be illustrated and their shortcomings described. Oracle provides the CONNECT BY and START WITH clauses, along with several operators and psuedocolumns to greatly expand such querying. These SQL extensions will be examined, along with some of the advanced functions Oracle now provides. The talk will conclude by demonstrating a couple of surprising uses for Oracle's extensions.

Carol-Lee Tutch, began developing relational database solutions in the early 80's by creating a data warehouse and a cartographic metadata database for the Defense Mapping Agency. Her first major project in Oracle involved creating an order bill-of-materiels system for Westinghouse. She has designed database systems for the FBI, PBS, Emery Worldwide, PACE Manufacturing, New Edge Networks, and The Standard. She is currently on assignment, through VOLT, at The Standard.




February 2009
Maxina Parks
Oracle Technical Sales Support
Enterprise Grid Management and Oracle 11g.



Tuesday, May 13, 2008

Karen Morton
Director, Consulting & Education
Method R Corporation
The Cary Millsap Company

Oracle continues to add more and more automated features and advisors (i.e. ADDM, AWR, ASSM, SQL Tuning Advisor, etc.). Given all this automation and advice Oracle is providing, a question to ask is whether or not all this advice is "dumbing us down" or "smartening us up". Too often more automation can lead to using these features as a crutch and bypassing the acquisition of key skills and knowledge. Ideally, these features should be tools to help us do our jobs better instead of simply letting Oracle do it for us. The risk is becoming trained to only follow the advisors output, but when a situation arises where our skills and knowledge are needed, it's not there. This presentation looks at some of these automations and the knowledge and critical thinking skills needed by the DBA or Developer to understand and use them properly and effectively.

David Driscoll
Senior Systems Engineer
Pillar Data Systems

Smart Storage Devices designed specifically for Oracle Databases. Designed to work with all major storage hardware. This will be a deep dive into the workings of artificial intelligence for database storage.




Bill Slocumb
Oracle Corporation

Oracle Applications: The newest method for sizing the system.



February 12, 2008

David Alexander
Oracle Corporation

Paul Veilleux
Global Sales Director, Pillar Data Systems

Presentation
Simplifying the storage grid for Oracle 10g/11g Database