New York Oracle Users Group, Inc.

NYOUG SIG Meetings Presentations












 
NYOUG is an Affiliate of IOUG


NYOUG does not share its email list with any vendors or other organizations. You may opt out of receiving our email blasts at any time by sending an email to info@nyoug.org with "Remove" in the subject line.

 

Back to Top 

Business Intelligence/Data Warehousing SIG

Shyam Varan Nath

Jul 27, 2012

"Big Data and Analytics, 'R' you Ready"

This webinar will include an introduction to Big Data and topics like Hadoop and NoSQL along with discussion of Oracle's Big Data Appliance and Oracle R Enterprise for Big Data Analytics. Shyam will discuss the industry landscape and use cases to benefit from the use of Big Data. Attendees will learn about Oracle R and how to apply it for Big Data Analytics.

 
Loading the player ...
Back to Top 
 
Tony Jedlinski 
May, 26, 2011
 

Joint BI/DW- Web SIG Meeting.

This presentation will expose the power of Oracle Application Express, a powerful rapid web application development tool included at no charge with every Oracle database since version 9.2. In less than an hour, you will learn what APEX does extremely well and how to quickly develop secure web based applications using this powerful tool.
Shown with live demos.

 
 Josh Millinger 
January, 20, 2011
 

Joint BI/DW- Web SIG Meeting.

Application Express provides a lot of wonderful features with Interactive Reports (IR) that allow end-users to develop their own custom reports. The question for developers is how to "break-in" to the black box to customize the interactive reports and use them the most effectively. This presentation will show attendees how the interactive reports are generated and managed by Oracle. In addition, discussion will revolved around best practices and considerations when developing with IR's.

 
Tony Politano
Senior Director in Oracle's Enterprise Solution Group
August 10, 2010
 

Joint BI/DW- Web SIG Meeting.

In today's economic environment, organizations must be constantly focused on managing performance. An emerging trend is the role of Chief Performance Officer, a single point of focus for enterprise performance management within an organization. Part technologist, part business executive and part communicator, the CPO helps organizations to better understand and take proactive measures in managing performance. In this session, Tony Politano will outline the keys to successfully rolling out performance management and BI in your organization and how an Oracle platform can provide a scalable solution for any organization.

 
Rick Michaud
May 4, 2010
 

Joint BI/DW- Web SIG Meeting.

Oracle Database 11g is a revolutionary product release in terms of the capabilities and features it brings to enterprise IT to reduce costs, improve productivity, and enable IT to meet and in some cases surpass the business drivers of many corporations. PL/SQL is no exception to this revolution and is an often overlooked strength of the platform. This presentation will cover 10 of the most compelling new features and enhancements to the the PL/SQL language and development platform.

 
Ulf Mattsson
Februrary 3, 2010
 

Joint BI/DW- Web SIG Meeting.

There are a number of encryption schemes and data protection technologies being marketed today. Do they offer the same levels of protection? What risks to data exist in the different schemes? How can a company decide between competing encryption technologies? This session will review the latest methodologies and technologies, such as Type Preserving Encryption, Data Masking, Tokenization and Database Activity Monitoring. This session is focused on answering the question "How can IT security professionals provide data protection in the most cost effective manner in an Oracle environment?"

Eugene Plagge,
Senior Principal Consultant at IT Convergnece, Inc.

April 28, 2009

Presentation:Trade in Discoverer F-150 Pickup for OBIEE Lexus
Podcast: Trade in Discoverer F-150 Pickup for OBIEE Lexus.mp3

This presentation will show how to migrate a Discoverer Metadata to an OBIEE environment. Eugene will discuss the architecture and processing of OBIEE from a high level, and then explain how to complete the migration. The demonstration will show how to move the metadata using Oracle tools, and how to verify the success of the migration. 

Michael Richards, Oracle Subject Matter Expert

June 3, 2008

Star Transformation & Optimization
This presentation illustrates how to utilize the Star Schema for performance advantages leveraging "Star Query Transformation" vs. the traditional Third Normal Form Snowflake schema. Mike will explain how the Oracle Optimizer prunes a query's result set with its conversion of many logical joins into a single operation using Bitmap Indexes. He will also answer the question of why Bitmaps should not just be used for low cardinality and are up to 100 times faster than traditional indexes.
David Gnau, Senior Sales Consultant - Oracle Corporation

January 30, 2008

11g Partitioning - New Features and Information Lifecycle Management (ILM)

Learn about the evolution, benefits, and basic partition strategy in Oracle from its introduction in 8.0 to our latest version in 11g. Learn how partitioning can improve performance, simplify database manageability and availability. David will review new partitioning features in 11g, such as interval, reference, and virtual column based partitioning. In addition, this presentation will touch upon how partitioning can reduce the costs of ILM ( Information Lifecycle Management).

Shyam Nath & Ratan Vakil, Oracle Corporation

August 17, 2006

An Inside Look at Oracle OLAP with Advanced Analytics
The presentation covers the definition of OLAP and a comparison of OLAP to OLTP technologies. A case will be made why organizations require both OLTP and OLAP solutions. Examples of the wide ranging use of OLAP tools across different industries, types of organizations and expected business solutions will be highlighted.
The Oracle OLAP products are covered, together with a demonstration of some of the OLAP tools.
Tina Yetman, Oracle Corporation Enterprise BI for Better Decisions
A look at building a complete business intelligence architecture. Focuse on key business scenarios that will lead you through a complete process of transforming / loading data into a data warehouse (both relational and multi-dimensional data structures). Covers building end-user reports and deploying them through a custom dashboard.  There are 3 zip files for this presentation
ORACLE BI PUBLISHER ENTERPRISE REPORTING & DELIVERY
ORACLE ENTERPRISE BI
ORACLE BUSINESS ACTIVITY MONITOR
David Friedland, CoSort/IRI Speeding High-Volume ETL for Oracle Data by Combining Optimized Flat-File Tools
John McKenna, Counterpoint Technologies, Inc. Aggregate Navigation - Using Materialized Views And Query Rewrite
Jennifer Leung, Oracle Oracle Data Warehousing - A Guided Tour
Richard Solari, Senior Product Manager of Data Mining Technologies, Oracle Oracle9i Data Mining 06/18/02 -PAPER [505K]PRESENTATION [150K] - What is data mining and how it fits into the world of business intelligence and more specifically, how it fits into the Oracle 9i infrastructure.
Detailed focus will be on the 2 areas where data mining is being used today.
1. The use of data mining technologies to solve business problems.
   We will share some real world projects that we have used data mining for.
2. The integration of data mining technologies into other applications,
   such as CRM, to create analytical intelligence within these applications.
Mary Rehus, Oracle Oracle9i Oracle Reports 02/05/02 - 425k
Mary Rehus, Oracle Oracle9i Oracle Discoverer 02/05/02 - 2M
Mary Rehus, Pat Larkin, Oracle Oracle9i OLAP Services 10/30/01 - 515k
Rob Edwards Oracle9i Data Warehouse Review 06/26/01 - 230K
Chris Muli SQL Extensions and Metadata
Rob Edwards Data Warehousing 101
Rob Edwards Data Warehousing 102
Chris Muli Data Warehouse Builder
Rob Edwards Data Warehousing: Extraction, Transformation, & Loading
Rob Edwards Designing Star Schemas For Data Warehousing
Oracle Corp. Data Warehouse Business Intelligence
Meryl Surgan The Evolution Of Data Warehousing
Angelo Bobak Three Parallel Paths to Implementation of a Data Warehouse
Back

Back to Top

DBA SIG

Robert Stackowiak, Vice President Data Systems Architecture
Oracle Enterprise Solutions Group

Sep 21, 2012

Oracle ZFS Storage Appliance for Exadata Backup & Recovery

When it comes to the backup and recovery infrastructure of the Exadata Database Machine, conventional solutions often have only limited performance to keep up with Exadata throughput, whereas Oracle ZFS Storage Appliance can be configured as a very fast, capable, and easy-to-manage backup and recovery solution for any Exadata environment. In this session Husnu Sensoy will describe some of the configuration possibilities of the ZFS Storage Appliance to create a flexible backup and recovery environment for Exadata, as well as various tuning do's and dont's to maximize your backup and recovery performance.
 

Back to Top 

Robert Stackowiak, Vice President Data Systems Architecture
Oracle Enterprise Solutions Group

Sep 21, 2012

An Integrated Analytics & Big Data Infrastructure

This webinar will discuss An Integrated Analytics & Big Data Infrastructure.
 
Loading the player ...
Back to Top 
Michael S Abbey

Feb 3, 2012

RMAN - Don't Forget the Basics

This webinar will discuss the bare bones RMAN setup items that will bulletproof your image backups. There are many emerging bells and whistles with 11gR2. This session will present the top 10 setup items that are fundamental to writing recoverable RMAN backups from day one. After the basic setup, the technologist can move on to leverage some of the new-fangled functionality of this legacy but developing backup solution. Topics covered include: present configuration and implementation items. use of a recovery catalog, block change tracking, restore database validate, and the ultimate configuration requirement-controlfile autobackup. If you read the fine print in the documentation, you would find assumptions of setup items that are expected to be in place to allow feature XYZ to work as documented. The nature of those assumptions is at the heart of this webinar. The target audience is beginner to experienced.
 
Loading the player ...
Back to Top 
Stéphane Faroult
RoughSea Ltd

Oct 28, 2011

What Oracle Can Tell You About Your Applications

For most database administrators, monitoring performance means checking that nothing is horribly wrong with waits or locks or the top 5 SQL statements by CPU, logical I/Os, or physical I/Os. For most developers, the database is something fairly abstract, usually at the root of their performance issues, for which the usual panacea is called "indexing". When they meet, they have trouble reconciling their visions and looking for solutions or improvements. But in fact Oracle can tell more about the application it runs than the top waits or the top SQL statements - even if you have to read between the lines. I'll try to briefly take you through a few analysis that can be made and can help DBAs and developers to discuss more effectively.
Loading the player ...
Back to Top 
George Trujillo

Oct 14, 2011

Virtualization Workshop for Oracle DBAs/Developers

The default platform for Oracle database/application servers is rapidly moving towards virtual machines. This is why virtualizing Oracle Databases on VMware is one of the largest growth areas in the IT industry. This presentation will show attendees the various virtualization alternative technologies and how virtualization works under the covers. Key features such as vMotion, Storage vMotion, DRS /HA clusters and SRM will show attendees how virtualization is completely changing how Oracle environments are being managed. Success recipes for virtualization projects and virtualization best practices will be covered.
 
Loading the player ...
Back to Top 
Jordan Braunstein
Oracle Ace Director Visual Integrator Inc.

June 24, 2011

Flying in the Clouds - An Introduction to Cloud Computing

An Introduction to Cloud Computing, fundamental concepts, principles, benefits, and challenges. The session will start with an overview of Cloud and help to define what cloud is and what it consists of. Jordan will cover what makes cloud computing unique from its predecessor paradigms and why the industry is so excited about moving companies and data centers into the cloud. The session will also cover practical approaches to implementing a cloud project, both as a cloud provider or a cloud consumer-in other words a methodology for "entering the cloud". Also discussed will be challenges, dispelling myths, and how to take incremental steps for getting started with a cloud implementation.
Loading the player ...
Back to Top 
Arup Nanda, Principal Database Architect, Starwood Hotels

March 11, 2011

Deferred Statistics and SQL Plan Management for Performance in Oracle 11g

Statistics can make or break performance. While it may help in many cases, it may hurt as well. Pending stats in Oracle 11g solve the problem by bringing a sort of try-before-you-buy concept into statistics management. In this session attendees will learn how to enable, test and promote deferred statistics, gather history, use it for a test database and use SQL Plan management to fix a plan using the statistic gathered to go around the inefficient execution plan. Shown with live demos.
Loading the player ...
Back to Top 
Marshall Presser
David Partridge
Oracle Corporation

June 1, 2010

The new Exadata V2 database machine goes beyond data warehousing to also deliver extreme performance and scalability for online transaction processing applications (OLTP). Oracle Exadata Storage Servers combine Oracle's smart storage software and Oracle's industry-standard Sun hardware to deliver the industry's highest database storage performance. To overcome the limitations of conventional storage, Oracle Exadata Storage Servers use a massively parallel architecture to dramatically increase data bandwidth between the database server and storage. In addition, smart storage software offloads data-intensive query processing from Oracle Database 11g servers and does the query processing closer to the data. The result is faster parallel data processing and less data movement through higher bandwidth connections. This massively parallel architecture also offers linear scalability and mission-critical reliability. Marshall Presser and David Partridge will provide a technical overview of the Exadata hardware and software platform. An Exadata demo will also be featured.

Presentation: Oracle Exadata V2: The World's First OLTP Database Machine with Sun Flash Fire Technology
 

Iordan Iotzov
News America Marketing (NewsCorp)

March 2, 2010

The presentation provides guidance for selecting the optimal number of hash or range index partitions in OLTP databases. The presented method focuses on the height of the index partitions, and can deliver index scan improvements of up to 12%. Experimental results and practical hints are reviewed and discussed.

Presentation: Flatten indexes by tuning the number of partitions
Text file with test setup scripts: Flatten indexes by tuning the number of partitions.txt
 

Jim Williams
Oracle Corporation

October 6, 2009

A vital element of all enterprise database environments is the underlying management of storage. Before Oracle 10g, storage management components below the database were left for others to provide. Vendors often developed general solutions that did not account for essential requirements of large databases. Many point solutions addressed certain problems, but created weaknesses in other areas. Furthermore, some of the most difficult problems involved databases in clusters. Consequently, Oracle developed ASM in response to these shortcomings. This presentation discusses some of these challenges and how ASM addresses them.

Automatic Storage Management

Michael New
April 14, 2009
Oracle Enterprise Manager 10g Grid Control is a robust web-enabled systems management product, having matured considerably since its OEM 9i client/server roots. Accompanying this expanded functionality is a more complex installation and configuration process. This presentation begins with installation issues, including Grid Control architectural design considerations and recommendations for high availability and disaster recovery. The second half of the presentation deals with configuration matters -- notification rules, Agent configuration tips, metric tuning recommendations, job and user-defined metrics examples, Grid Control backup recommendations and methods, and recovery configuration settings and procedures.

Presentation:Oracle Enterprise Manager 10g Grid Control 
Podcast:Oracle Enterprise Manager 10g Grid Control.mp3

Sanjeev Joglekar
Oracle Solution Support

March 12, 2009

Oracle Database 11g contains many new features and enhancements that are beneficial for DBAs, developers, and end-users. This presentation will describe some of the most popular new features for DBAs, including hot patching, Snapshot Standby, Active Data Guard, Real Application Testing, Oracle Total Recall, and a few others. At the end of this session, attendees will have a high-level understanding of the change management functionality along with some other features to help simplify the upgrade of existing databases to Oracle Database 11g.

Oracle Database 11g - New Features for DBAs

Anthony D. Noriega
Advanced Data Networks

October 30, 2008

Formulating the Grid Reliability and Performance Model
Tanel Poder
Researcher and Database Engineer

March 4, 2008

Advanced Oracle Troubleshooting
Arup Nanda
Lead DBA
Starwood Hotels

October 11, 2007

Real Life RAC Performance Tuning
 
Sanjeev Jonglekar Technical Project - Advanced Customer Services. Oracle

February 28, 2007

Oracle Streams
 
Mike Erwin - Hotsos Entreprise, Ltd. RAC Performance Presentation Notes
 
MatthewZito, Chief Scientist forGridApp Systems Strategies & Tools for Centralizing and Automating Database Management
Tom Kyte
Oracle Corporation
Tom Kyte describes common SQL techniques he has encountered and utilizes day to day to tune query performance. Features such as scalar subqueries, using rownum (yes, to 'tune'), analytics, some hints and more will be demonstrated. Emphasis is on when they work (where the 'trick' applies) as well as when they don't work and where they do not apply. Care is taken to show these not as a "top 10 things to do" but rather techniques to keep in mind when looking at problems in general.
ZIP FILE
Logicworks Migrating To 10g On Linux
Jarugumilli, Barhmaiah,  Entreprise Architect  
GE- Consumer Finance
Analysis of Oracle System Load for Performance Management and Simulation
PRESENTATION
PAPER
Dave Anderson - SkillBuilders Oracle10g New Features: Flashback Enhancements
Simay Alpoge Bulk Collections and Inserts in Oracle 9i & 10g
Dave Anderson - SkillBuilders Oracle 10g Feature: RMAN Incrementally Updated Backups
Larry Carpenter, Oracle Corporation Oracle DataGuard New Features in 9i and 10g
Larry Carpenter, Oracle Corporation Introduction To DataGuard
Jeff Holt and Gary Goodman, Hotsos Enterprises, Ltd. Using 10046 trace data to resolve Oracle performance issues - A review of three case studies
Paper ;Presentation - This is a very interactive presentation where we will review 3 actual case studies from the last year.  We will examine our client's performance problems and how the Hotsos method was utilized to rapidly determine and repair the root cause issues.  We will use these case studies to show the effectiveness of using 10046 level 8 trace data as the basis for Oracle optimization.  We will close with a brief discussion of Hotsos and a short demo of the Hotsos Profiler.
Bill Beauregard Oracle 9i Workspace Manager Overview
Kristina M. Murray Automating Database Startup and Shutdown on Unix 2/6/02 - 440k
Paul Baumgartel Designing For Performance 07/10/01 - 25k
Henry Pikner Oracle Pipes- Presented on 05/17/00
Rachel Carmichael
Marlene Theriault
DBA101: A Refresher Course - 50k
Rachel Carmichael
Marlene Theriault
Exploding The Myths - by Rachel Carmichael & Marlene Theriault - 70kPaper 40k
Marlene Theriault Oracle8 Challenges for DBAs
Megh Thakkar Oracle8 On Windows NT- 120k
Marlene Theriault Let's Tune Oracle8 For NT - By Marlene Theriault 95kPaper 60k
Back Back to Top

Long Island SIG

Gurcan Orhan

December 7, 2012

Oracle Data Integrator (ODI) seems slow when it is installed out-of the box. Since it has to comply with different versions of the databases and operating systems, this default installation is not the optimal choice. ODI is a flexible product can be customized for specific requirements and to implement new features of the database or operating systems. Attendees will learn how to easily create a customized ODI environment. This presentation will demonstrate the flexibility of the Knowledge Module, configuration best practices, and the best query response time tips and techniques. It will include information about how to load an extensive number of files quickly with a special algorithm, as well as how to define new or customized data types and analytical functions.

Presentation: Best practices with Oracle Data Integrator (ODI): Do you know how flexible ODI is?

 

Loading the player ...

Back to Top

Erik de la Iglesia

February 22, 2012

This session presents actual IT case studies and reference architectures for integrating Solid State Disk (SSD) into existing storage infrastructures to boost performance and enable virtualization especially in big data environments where data volumes are growing rapidly, and applications and users are demanding high-speed concurrent access. Attendees will see how large Oracle environments can be more strategic in their deployment of SSD and reap 10-fold performance acceleration without the need to reconfigure or move applications or data, without forklift hardware upgrades, and without changing data protection policies.

Presentation: Increase Performance of Existing Oracle RAC Up To 10x

 

Rich Niemiec, Oracle Ace Director and a co-founder and CEO of TUSC

November 16, 2010

This presentation discusses which 11g new features should be investigated for use. Most of the features covered are relevant for DBAs, but there will also be a few outside that realm. There will be simple examples to show the basic functionality of the following new features:
  • Start Me Up €“ Using Memory Target, The Buffer Cache & The Result Cache
  • Virtual Columns
  • Invisible Indexes & Online Index Rebuilds
  • DDL Lock Timeout, PL/SQL Expressions/Simple Integer
  • Secure Files
  • ADDM Enhancements
  • SQL Plan Management (SPM) and capturing SQL Plan Baselines
  • SQL Performance Analyzer, Access Advisor & Query Repair Advisor
  • Exadata Simulation
  • Real Application Testing (Database Capture and Replay) & Adding Nodes
  • Interval Partitioning & Partition Compression
  • Automatic Diagnostic Repository (ADR)
  • Auto Sample, Creating Pending Statistics
  • Adaptive Cursor Sharing and Bind Peeking
  • EM, Grid Control, Security Enhancements & the Future Sizes

 

Girish Venkat CISSP, Oracle Corporation

June 3, 2010

Virtualized hardware is all the rage in enterprise IT. However, is a purely virtualization-focused, Infrastructure-as-a-Service (IaaS) approach really the right one for enterprises and government? What is becoming clear is that virtualization is but one piece of a much bigger strategy for fast, self-service deployment and ultra-efficient operations, referred to as €œplatform as a service€ (PaaS). PaaS leverages a wider set of middleware capabilities to enable application deployment in minutes rather than days and reduces operational costs by up to 90%. This general session will compare and contrast the IaaS and PaaS approaches, discussing architectural and operational considerations for PaaS using examples of best practices. It's a must-attend session for anyone considering building a private cloud.

Presentation:PaaS is the Remedy for VM Hangover
 

Marshall Presser
David Partridge
Oracle Corporation

June 1, 2010

The new Exadata V2 database machine goes beyond data warehousing to also deliver extreme performance and scalability for online transaction processing applications (OLTP). Oracle Exadata Storage Servers combine Oracle's smart storage software and Oracle's industry-standard Sun hardware to deliver the industry's highest database storage performance. To overcome the limitations of conventional storage, Oracle Exadata Storage Servers use a massively parallel architecture to dramatically increase data bandwidth between the database server and storage. In addition, smart storage software offloads data-intensive query processing from Oracle Database 11g servers and does the query processing closer to the data. The result is faster parallel data processing and less data movement through higher bandwidth connections. This massively parallel architecture also offers linear scalability and mission-critical reliability. Marshall Presser and David Partridge will provide a technical overview of the Exadata hardware and software platform. An Exadata demo will also be featured.

Presentation: Oracle Exadata V2 €“ The World€™s First OLTP Database Machine with Sun Flash Fire Technology
 

Michael New
May 14, 2009
Oracle Enterprise Manager 10g Grid Control is a robust web-enabled systems management product, having matured considerably since its OEM 9i client/server roots. Accompanying this expanded functionality is a more complex installation and configuration process. This presentation begins with installation issues, including Grid Control architectural design considerations and recommendations for high availability and disaster recovery. The second half of the presentation deals with configuration matters -- notification rules, Agent configuration tips, metric tuning recommendations, job and user-defined metrics examples, Grid Control backup recommendations and methods, and recovery configuration settings and procedures.

Presentation:Oracle Enterprise Manager 10g Grid Control 
Podcast: Oracle Enterprise Manager 10g Grid Control.mp3

Abdul Hafeez Shaik Apps Associates.

March 12, 2009

This Presentation will provide an overview of how Datawarehousing Administration Console (OBIEE DAC) abstracts underlying Complex ETL, handles the Incremental Extraction & Load processes. It also discusses advantages of Micro ETL of DAC and best practices in customizing existing or creating the new DAC and ETL processes . You will learn how Oracle DAC is used in scheduling & managing the ETL runs and its role in ETL performance tuning and OBIEE.

Datawarehousing Administration Console (OBIEE DAC)

Sanjeev Joglekar
Oracle Solution Support

March 12, 2009

Oracle Database 11g contains many new features and enhancements that are beneficial for DBAs, developers, and end-users. This presentation will describe some of the most popular new features for DBAs, including hot patching, Snapshot Standby, Active Data Guard, Real Application Testing, Oracle Total Recall, and a few others. At the end of this session, attendees will have a high-level understanding of the change management functionality along with some other features to help simplify the upgrade of existing databases to Oracle Database 11g.

Oracle Database 11g - New Features for DBAs

Anthony D. Noriega
Advanced Data Networks

October 28, 2008

Case Studies in RMAN Metrics
 
Bill Rose
Estee Lauder Companies

October 28, 2008

Leveraging Oracle with Microsoft .Net
 
Jamon Bowen
Texas Memory Systems

March 13, 2008

Understanding Storage Impact on Oracle Performance
 
Nick Donatone
Grid Sales Consultant, Oracle Corporation

January 29, 2008

PL/SQL Tips and Techniques
 
Geoffrey Wiland
Skillbuilders

January 29, 2008

XML in Oracle
 
Simay Alpoge
Next Information Systems, Inc.

March 1, 2007

Oracle 10g analytical SQL for Business Intelligence Reporting
 
Larry Klein,
VP of Hotsos Entreprises, Ltd.

June 27, 2006

Business consumers of an Oracle-based application measure the success of "the system" based on the metrics of availability, response time, and throughput.
Technical support staff measure that same system success using metrics of utilization and transactions per second. These two views use different vocabulary which often leads to miscommunication, ineffective problem management, substandard performance, and over utilization of hardware resources. This presentation suggests how "the system" can be modeled as a factory, and common metrics can be established and shared among all stakeholders in simple and meaningful ways. Characterizing Workload thru an Oracle Database
Prabhu Shanmugam
Arrow Electronics

June 27, 2006
LI & Web SIG Meeting
Currently, application frameworks are very prominent in software development whether you work with home grown or COTS-based applications. This presentation will describe the changes from function-oriented to object-oriented to service-oriented development. Attendees will learn how having a framework helps application development with focus on some of the MVC (Model-View-Controller) based frameworks, and how component oriented development helps you work in the service-oriented framework world.
Application Frameworks
Vikas Sawhney A Look at Partitioning
Howard Horowitz - Oracle Oracle 10g (OCP) Certification Preparation
Sandeepan Banerjee - Oracle Integrating A Heterogeneous Environment Using XML
Alex Hoyos, Senior Data Architect Cablevision Accessing Oracle from C# and Microsoft .NET
Jack Raitto
CDC Development Manager, Oracle Corp.
Change Data Capture in Oracle 10g
Martin Farber
Qualitec Inc.
The Art Of SQL Tuning
Michael Fargo
Cablevision/Data Modeler / Data Architect
Materialized Views - Euphoria, Reality and altering your Design
  Backup Scripts (ZIP FILE)Restore Scripts (ZIP FILE)
Raj Sakthi
Senior Oracle DBA
NMHCrx
GO LOCAL..! ALL ABOUT LOCALLY MANAGED TABLESPACES - The audience will learn all about LMT's. What makes them tick, Why it is a better choice, what are the advantages, and more.
Yomi Odedeyi,
Euro RSCG Circle
Migrating From Unix To Linux - An Oracle's Journey - Yomi discusses his trials and tribulations migrating his Oracle Databases from Solaris to Linux. He discusses topics such as cost justifications for doing it, resources necessary, critical success factors, installation process, lessons learned.
Rob Edwards, Dulcian Oracle 9i Data Warehouse Review  - Oracle9i Server presents the latest move by Oracle in establishing a data warehouse platform for supporting e-business intelligence applications. This new version release of Oracle Server lays the foundation for a "Data Warehouse Platform" that adds integrated OLAP services, data mining, an ETL infrastructure, and additional analytical SQL functions to the relational database.  The new Oracle Warehouse Builder 3i, with its new mapping architecture and enhancements, will also be reviewed.
Howard Horowitz Oracle Certification Preparation (OCP) - Attendees are introduced to general Oracle Certification Professional (OCP) exam info, what's needed to pass the exams and an overview of each exam. This 45 minutes to one hour session is divided into two parts. First part focuses on what OCP is and how it can help you in today's market/economy. It examines the resources used to prepare for the exam and discusses the structure of the exams and strategies used to pass them.

The second part of the presentation discusses each section of the exam and focuses on various topics
from each of the six sections. Exams discussed: (1Z0-001-Intro to SQL and PL/SQL,
1Z0-023- Oracle 8i Architecture and Administration, 1Z0-025- Oracle 8i Backup and Recovery,
1Z0-024-Oracle 8iPerformance and Tuning, 1Z0-026- Oracle 8i Network Administration,
1Z0-030-Oracle 9I New Features).
Back Back to Top

Web SIG

Michelle Kolbe

Feb 8, 2013

Overview of Dimensional Modeling Principles using Oracle SQL Developer Data Modeler

Most BI tools require a dimensional model but how do you go about designing that kind of model? What's a star schema, fact or dimension table? In this session we will start with the basics of dimensional modeling including a retail dimensional model example. Then we will take a look at building the model in Oracle SQL Developer Data Modeler. This free tool from Oracle has basically all of the same features as licensed data modeling tools. By the end of this session, you should be comfortable building a simple dimensional model in Oracle SQL Developer Data Modeler.
 

Loading the player ...
Back to Top 
Dan Stober

Jun 1, 2012

ORACLE Analytics Functions Windowing Clause

Agenda
Loading the player ...
Back to Top 
 
Tony Jedlinski 
May, 26, 2011
 

Joint BI/DW- Web SIG Meeting.

This presentation will expose the power of Oracle Application Express, a powerful rapid web application development tool included at no charge with every Oracle database since version 9.2. In less than an hour, you will learn what APEX does extremely well and how to quickly develop secure web based applications using this powerful tool.
Shown with live demos.

 
Josh Millinger 
January, 20, 2011
 

Joint BI/DW- Web SIG Meeting.

Application Express provides a lot of wonderful features with Interactive Reports (IR) that allow end-users to develop their own custom reports. The question for developers is how to "break-in" to the black box to customize the interactive reports and use them the most effectively. This presentation will show attendees how the interactive reports are generated and managed by Oracle. In addition, discussion will revolved around best practices and considerations when developing with IR's.

 
Tony Politano
Senior Director in Oracle's Enterprise Solution Group
August 10, 2010
 

Joint BI/DW- Web SIG Meeting.

In today's economic environment, organizations must be constantly focused on managing performance. An emerging trend is the role of Chief Performance Officer, a single point of focus for enterprise performance management within an organization. Part technologist, part business executive and part communicator, the CPO helps organizations to better understand and take proactive measures in managing performance. In this session, Tony Politano will outline the keys to successfully rolling out performance management and BI in your organization and how an Oracle platform can provide a scalable solution for any organization.

 
Rick Michaud
May 4, 2010
 

Joint BI/DW- Web SIG Meeting.

Oracle Database 11g is a revolutionary product release in terms of the capabilities and features it brings to enterprise IT to reduce costs, improve productivity, and enable IT to meet and in some cases surpass the business drivers of many corporations. PL/SQL is no exception to this revolution and is an often overlooked strength of the platform. This presentation will cover 10 of the most compelling new features and enhancements to the the PL/SQL language and development platform.

 
Ulf Mattsson
Februrary 3, 2010
 

Joint BI/DW- Web SIG Meeting.

There are a number of encryption schemes and data protection technologies being marketed today. Do they offer the same levels of protection? What risks to data exist in the different schemes? How can a company decide between competing encryption technologies? This session will review the latest methodologies and technologies, such as Type Preserving Encryption, Data Masking, Tokenization and Database Activity Monitoring. This session is focused on answering the question "How can IT security professionals provide data protection in the most cost effective manner in an Oracle environment?"

 
Ulf Mattsson
Februrary 3, 2010
 

Joint BI/DW- Web SIG Meeting.

There are a number of encryption schemes and data protection technologies being marketed today. Do they offer the same levels of protection? What risks to data exist in the different schemes? How can a company decide between competing encryption technologies? This session will review the latest methodologies and technologies, such as Type Preserving Encryption, Data Masking, Tokenization and Database Activity Monitoring. This session is focused on answering the question "How can IT security professionals provide data protection in the most cost effective manner in an Oracle environment?"

Marc Sewtz
September 9, 2009
 
This presentation introduces the ways in which Oracle SQL Developer, Oracle SQL Developer Data Modeler and Oracle Application Express (APEX) work together to aid your development efforts".  Marc's APEX blog can be found at   http://marcsewtz.blogspot.com/
Marc Sewtz
June 4, 2009
 
"Whether converting from Oracle Forms or migrating from Microsoft Access, Oracle Application Express (Oracle APEX) is an effective tool to modernize existing legacy business applications. This presentation provides an overview of Oracle APEX, outlines the conversion process, and includes live demonstrations of a Microsoft Access to Oracle APEX and an Oracle Forms to Oracle APEX conversion"
Coleman Leviter
March  5, 2009. 
Many times during a project life cycle, new technology is introduced that presents first time challenges. The author will present a project using Oracle 10g XML DB. The presentation will cover the project, why XML DB was chosen, how XML DB was used and technical issues encountered.
The author will provide several examples using XMLTYPE, CLOBs, XML DB methods, XMLAGG, XMLELEMENT and XMLFOREST. Additionally, namespace examples and an introduction to XML Schema Definition (XSD) will be presented.

"Integrating Oracle 10g XML: A Case Study Part II"

Josh Millinger
December 4, 2008. 
As important as it is, security is almost always added to an application as a last step, if at all. Designing your APEX application with security in mind is critical and should not be overlooked. This presentation will discuss how to build secure APEX applications from the ground up so that a hacker cannot exploit them. The presentation will also include information about how to segment functionality inside an APEX application so that only authorized users can perform specific tasks. It will examine what can be done to secure the underlying data of an APEX application. Finally, Josh will outline what needs to be secured in an installation of APEX, as well as the associated infrastructure components.

"Implementing APEX with Securityin Mind"

Dr.Paul Dorsey and Michael Rosenblum. Dulcian, Inc.

August 7, 2008. 

Database independence is frequently touted as a desirable quality in applications. However, by placing logic in the database, applications require less code, run faster, and will usually place less load on the database than applications that are so called “database independent.”

The benefits of the "thick database" approach have been discussed extensively at conferences in the last year or so. What is missing is detailed information about how to implement this approach in real-world projects. This presentation will provide a brief overview of the benefits of the thick database approach as well as discussing specific details about how to implement the approach in SQL and PL/SQL with emphasis on collections and dynamic SQL/PL/SQL and will also demonstrate a 100% thick database approach to application development where all code and UI information is maintained in the database. This presentation is targeted at experienced PL/SQL developers.

"Thick Database" Techniques in Web Architecture

Eunhee Lee,
Returnpath
Oracle 10g Instant Client

May 3, 2007

This presentation addresses the installation and issues one may encounter installing Oracle 10g Instant Client onto an XP workstation.

Oracle 10g Instant Client XP Installation


 
Nick Dimtchev,
Oracle Corporation

Oracle overview of SOA reference architecture

May 3, 2007

This presentation will provide an overview of SOA reference architecture, maturity model, and building blocks. Nick will also discuss Process Orchestration with BPEL and Business Rules, and Enterprise Services Bus for integration.

Oracle overview of SOA reference architecture


 
Tarek Abdelsalam, Oracle Corporation

Oracle Web Center Suite Overview and Demo

February 8, 2007

This presentation will discuss Oracle WebCenter Suite, an integrated suite of technology designed to deliver a unified, context-aware user experience specifically targeted at the needs of information workers. Oracle WebCenter Suite combines the standards-based, declarative development of Java Server Faces (JSF), the flexibility and power of portal technology, and a set of horizontal, Web 2.0 services. Together these tools and services provide a unique ability to build applications that eliminate context shifts and maximize productivity.

Oracle Web Center Suite Overview and Demo
 

Prabhu Shanmugam

Application frameworks - function oriented -to- object oriented -to- service oriented

November 21, 2006

Application frameworks these days are very prominent in software development whether you work in home grown applications or COTS based applications. In this session you will learn about the basics of how we have changed from being function oriented to object oriented to service oriented. You will understand how having a framework helps application development with focus on some of the MVC (Model-View-Controller) based frameworks today. Towards the end of the session, you will also understand how component oriented development helps you work on the service oriented framework world.
Application frameworks - function oriented -to- object oriented -to- service oriented
 
Greg Cranz

Model-Driven Architecture (MDA) with Java

October 05, 2006

There have been many articles written recently extolling the virtues of Ruby on Rails as a technology that is a "Java Killer" with regard to web application development. Claims have been made that you can develop web applications in 1/3 the time using Ruby than the time needed when using standard Java techniques. This presentation will explore these claims and discuss how you can achieve the same results using Java, MDA, "ruthless automation" and leveraging open-source frameworks
Model-Driven Architecture (MDA) with Java
 
Prabhu Shanmugam
Arrow Electronics

June 27, 2006
LI & Web SIG Meeting
 
Currently, application frameworks are very prominent in software development whether you work with home grown or COTS-based applications. This presentation will describe the changes from function-oriented to object-oriented to service-oriented development. Attendees will learn how having a framework helps application development with focus on some of the MVC (Model-View-Controller) based frameworks, and how component oriented development helps you work in the service-oriented framework world.
Application Frameworks
 
Back Back to Top

FairWest SIG

Dave Anderson
SkillBuilders
What's New For SQL Tuning?  Are you working on Oracle9i but have yet to learn the new SQL tuning-related features?  Are you interested in what 10g delivers in this area?  If so, this presentation is for you.  Dave will bring you up to speed on the latest SQL statement performance and tuning features available with Oracle9i and Oracle10g. Some of the new SQL language features available with Oracle10g will also be presented.
Back Back to Top


Home | Membership | Presentations | Sponsors | About NYOUG | Upcoming Events | Tech Journal | Search | Photo Gallery | RSS Feed | LinkedIn

 For problems or questions regarding this Web site contact webmaster@nyoug.org.
Copyright 1984-2013 NYOUG. All rights reserved.
Last updated: 12/18/12.