Pre Oct. 2013: WEB SIG Presentations

In 2013 NYOUG redesigned its web site. To keep the older presentations they were grouped together by SIG and posted as one post. The following are all the WEB SIG presentations that occurred prior to October 2013.

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.
 

 

Dan Stober

Jun 1, 2012

ORACLE Analytics Functions Windowing Clause

Agenda

 

 
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