OSWOUG

Oregon and Southern Washington Oracle User Group

Meeting Details



Tuesday, February 9, 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:30 a.m.

Contacts & Sponsors



Jon Wasserman jsw@oswoug.org
Erik Kaarto ejk@oswoug.org
Webmaster: Rob Loos

Tek Systems

Software Technology Group

Coming in February




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.


Remember to RSVP your attendance to Jon Wasserman: jsw@oswoug.org Breakfast will be provided by Tek Systems and we would like to have enough for everyone.


Previous Meetings



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