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).