[dayton-oracle] Dayton Oracle Users Group Meeting Oct. 14
- From: "Vicki Blommel" <ouredge@xxxxxxxxxxxxx>
- To: <Dayton-oracle@xxxxxxxxxxxxx>
- Date: Sat, 2 Oct 2010 09:52:30 -0400
Dayton Oracle Users Group
Meeting: Oct 14, 2010
Location : YSI, Inc., 1725 Brannum Lane, Yellow Springs, OH 45387
Sponsors :
YSI Inc.
YSI_Inc.jpg
Oracle Corporation <http://www.oracle.com/>
AGENDA
08:30 AM - 09:00 AM Meeting Registration
09:00 AM - 09:50 AM Oracle Application Express and Oracle SQL
Developer, a Compelling
Combination for
Database Development - Eric Rudie (Oracle Corp.)
09:50 AM - 10:00 AM Break
10:00 AM - 10:55 AM Shredding XML into Relational Structures using
Oracle ? Dale Ward
(Booz Allen Hamilton)
10:55 AM - 11:05 AM Break
11:05 AM - 12:00 PM Consuming Web Services in Oracle ? Dale Ward
(Booz Allen Hamilton)
12:00 PM - 12:50 PM Lunch ? Pizza
12:50 PM - 01:45 PM Oracle Business Intelligence Solutions, Where
We?ve Been and Where We?re
Heading - Eric Rudie
(Oracle Corp.)
01:45 PM - 02:00 PM Announcements / Raffle
02:00 PM - 02:10 PM Break
02:10 PM - 02:45 PM DAY-O business
Presentation Abstracts :
Oracle Application Express and Oracle SQL Developer, a Compelling
Combination for Database Development - Eric Rudie (Oracle Corp.)
Oracle Application Express (Oracle APEX) is a rapid web application
development tool for the Oracle database. Using only a web browser and
limited programming experience, you can develop and deploy professional
applications that are both fast and secure. Oracle APEX is a fully
supported, no cost option of the Oracle database. Oracle SQL Developer is a
free and fully supported graphical tool for database development. With SQL
Developer, you can browse database objects, run SQL statements and SQL
scripts, and edit and debug PL/SQL statements. You can also run any number
of provided reports, as well as create and save your own. SQL Developer
enhances productivity and simplifies your database development tasks.
During this session I will review the latest developments in each of these
powerful tools, give a brief demonstration of the functionality, and review
how they complement each other in the development process.
Shredding XML into Relational Structures using Oracle ? Dale Ward (Booz
Allen Hamilton)
XML is everywhere and is finding its way into the lives of database
professionals. That's actually a good thing. All too often, parsing and
processing of XML is left to mid-tier application developers using Java or
whatever else. Processing XML using SAX and DOM can be complicated and
slow, so wouldn't it be nice to have a SQL-based solution to the challenge
of XML? In this presentation we'll look at some new features of Oracle
10g/11g that harness the power of SET based operations and the Oracle
database to quickly and easily shred XML documents into relational table
structures using SQL. We'll also examine XML Schema validation of XML
documents and how the use of XML Schemas in the Oracle database can actually
enhance performance.
Consuming Web Services in Oracle ? Dale Ward (Booz Allen Hamilton)
The ascension of SOA (Service Oriented Architecture) and the ongoing
proliferation of Web Services
has left some Database Professionals wondering where they fit in this new
world. The reality is that nothing has changed. The vast majority of
organizations wishing to engage SOA still (and will probably always) store
their data in an RDBMS like Oracle. In this session, we will look at some
capabilities and techniques that enable your Oracle database to reach out
and interact with both REST and SOAP-based Web Services. Specifically, we
will demonstrate simple SQL and PL/SQL techniques using UTL_HTTP and other
packages to consume web services and process data in a database context.
Oracle Business Intelligence Solutions, Where We?ve Been and Where We?re
Heading - Eric Rudie (Oracle Corp.)
Oracle Business Intelligence Enterprise Edition 11g (OBIEE) is a
comprehensive business intelligence platform that delivers a full range of
capabilities?including interactive dashboards, ad hoc queries, notifications
and alerts, enterprise and financial reporting, scorecard and strategy
management, business process invocation, search and collaboration, mobile
and disconnected analytics, integrated systems management and more. OBIEE
11g is based on a proven Web-based service-oriented architecture that
integrates with an organization?s existing information technology (IT)
infrastructure for the lowest total cost of ownership and highest return on
investment. OBIEE 11g provides complete, relevant insight to everyone in an
organization, resulting in improved decision-making better-informed actions,
and more-efficient business processes. During this session I will review
Oracle?s history in the business intelligence space, where we are today with
OBIEE, and the strategic direction as we move into the future.
Speaker Biographies
Dale Ward is a consultant employed by Booz Allen Hamilton in Dayton, Ohio.
He is currently serving as Data Migration Architect for the Air Force's
Expeditionary Combat Support System (ECSS). ECSS is currently the world's
largest ERP implementation. Dale has been working with Oracle Database
Technologies for the past 10 years and is responsible for the design and
implementation of a number of data warehousing, OLTP and SOA-related
database solutions within the Department of Defense including the Air Force
and the Defense Logistics Agency.
Eric Rudie first gained Oracle experience in 1987 while at Ball State
University, writing Pro*Fortran code for an Oracle v4.2 database
application. For several years after graduation, Eric maintained
COBOL-based systems, first for the United States Army Finance and Accounting
Center (now Defense Finance and Account Service) and then for an
Indianapolis-based bank. Eric worked for a major pharmaceutical company on
development projects using Oracle Forms and Oracle Reports. Upon taking a
position at Oracle Corp. in the consulting division, he expanded his
expertise to include Oracle CASE (now Oracle Designer) with a focus on data
and functional modeling. In his current role at Oracle, Eric is a Sales
Consultant in the Oracle Public Sector sales organization and a senior
member of the United States Department of Defense pre-sales team. Eric
earned his B.S. in Computer Science from Ball State University in Muncie,
IN.
Meeting Attendees :
RSVP by October 12 to : <http://daytonoracle.eventbrite.com>
http://daytonoracle.eventbrite.com
No entry fee to attend this meeting.
Lunch will be provided onsite at a cost of $6 (cash). Serving pizza, salad
and beverage.
DIRECTIONS TO YSI Inc. ? Yellow Springs, OH
Link to a map :
http://maps.google.com/maps/place?cid=9443767340495863288
<http://maps.google.com/maps/place?cid=9443767340495863288&q=ysi+inc+ohio&hl
=en&gl=us> &q=ysi+inc+ohio&hl=en&gl=us
YSI, Inc.
1725 Brannum Lane
Yellow Springs, OH 45387
Phone: (937) 767-7241 (1) ? (800) 765-4974
Directions to YSI, Inc. from North of Dayton and Yellow Springs :
· Take I-75 S toward DAYTON.
· Merge onto I-70 E via exit number 61A toward COLUMBUS. Merge onto
I-675 S via exit number 44A toward FAIRBORN/CINCINNATI. Take the OH-235
exit- exit number 22- toward XENIA/FAIRBORN. Turn LEFT onto OH-235.Turn
left onto Hyde Road and follow it across country (approx. 3 miles) to the
stop sign (intersection of Hyde Road and SR 68).
· Turn left onto SR 68 North, go about 100 feet and turn left onto
Brannum Lane (Brannum Lane is a service road that runs between YSI?s two
main buildings).
· Look for the signs ?Event Parking? just before the building on the
right (East Building).
Directions to YSI, Inc. from South of Dayton or Cincinnati Area :
· Take I-75 North towards Dayton.
· Just before Dayton, take 675 North towards Columbus.
· Take the Dayton-Yellow Springs Road exit-20 make a right turn
towards Yellow Springs.
· Travel approx. 2 miles on Dayton-Yellow Springs Rd and look for
sign ? Greene County Career Center - turn right. This will be SR 235 and go
about ¼ mile to Hyde Road (first left).
· Turn left onto Hyde Road and follow it across country (approx. 3
miles) to the stop sign (intersection of Hyde Road and SR 68).
· Turn left onto SR 68 North, go about 100 feet and turn left onto
Brannum Lane (Brannum Lane is a service road that runs between YSI?s two
main buildings).
· Look for the signs ?Event Parking? just before the building on the
right (East Building).
Directions to YSI, Inc. from Columbus Airport :
· Take I-670 to downtown Columbus.
· Stay on I-670 to I-71 South, this merges with I-70 West.
· Stay on I-70 West towards Indianapolis for approx. 47 miles to the
SR 68 South exit.
· Follow SR 68 South to Yellow Springs (approx. 7 miles).
· Stay on SR 68 through Yellow Springs (three traffic lights).
· Approx. ½ mile after the last traffic light (there is a Dollar
General store on the left), turn right onto Brannum Lane.
· Look for the signs ?Event Parking? just after the building on the
left (East Building).
Other related posts:
- » [dayton-oracle] Dayton Oracle Users Group Meeting Oct. 14 - Vicki Blommel
