1 / 49

Work Hard, Play Hard Oracle HTML DB in Production

“This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”.

fstory
Télécharger la présentation

Work Hard, Play Hard Oracle HTML DB in Production

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. “This presentation is for informational purposes only and may not be incorporated into a contract or agreement.”

  2. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

  3. Work Hard, Play Hard Oracle HTML DB in Production

  4. Mark Moran Applications Development Manager mark.e.moran@chase.com

  5. David Green Senior Manager Financial Systems Michael Porter DBA – PGA of America Scott Hill SH Information Services

  6. Sergio LeunissenSr. Product Manager

  7. Agenda • About Oracle HTML DB • Customer case studies • Chase Home Finance • PGA • Conclusion • Q&A

  8. Oracle HTML DB • Quick assembly of reporting and data entry applications • Based on existing tables and views or data from spreadsheets • No programming or scripting • Instant deployment on the Web • Use the full power of Oracle Database 10g

  9. Simplify Application Development on Oracle • PL/SQL Developers • Non-professional developers • Power users • Departments • Small enterprises

  10. Success Story • More than 140,000 downloads* • 10,000 workspaces on htmldb.oracle.com • HTML DB 2.0 released this month • Top 3 forum on OTN in database category *Since Feb. 2004

  11. About CHASE • Global “Super Bank” Company with 185,000 Employees world wide. • #2 Bank in the world based on Tier 1 Capital ($m) - 68,621. • #4 Bank in the world based on Market Capitalisation ($m) – 126,902 • #7 Bank in the world based on Totals Assets ($m) – 1,157,248http://www.thebanker.com/news/fullstory.php/aid/3063/THE_TOP_ONE_THOUSAND_WORLD_BANKS.html • Chase Home Finance Division – Prime Mortgage, Home Equity Lending, Sub-Prime Lending & Student Loans – About 35,000 Employees • Perform a variety of functions – loan origination, servicing and collections

  12. Challenges before HTML DB • Multiple database platforms for applications – access, advantage, DB2, sql server, oracle • Multiple types of coding –asp, aspx, cgi, jsp, php, html, javascript, etc. • Multiple groups of web servers and application servers all connecting to the same database platforms – Apache, Cold Fusion, IIS. • Hard to maintain code base and extend an application. • When a new application was requested, we would have to evaluate which web technologies, database platform, and servers to utilize. • Required a lot of training to be able to develop new applications and to be able to maintain all existing applications. • Not easy to deploy an access database over the web.

  13. Challenges after HTML DB • None. • Easy to deploy • Easy to develop • Easy to maintain • Easy to integrate with existing work flow • Integrated with our NetIntegrity SiteMinder Single Signon Technology

  14. Savings with HTML DB • Removal of all servers but the database servers. We were able to remove the application server and web server layers. One time savings $250,000, Annual savings $100,000. • Consolidate to single database platform and application platform for web development. Annual savings $75,000. • Reduced training costs. Only have to train on the Oracle SQL, PL/SQL and HTML DB. • Increased time to market. It no longer takes months to be able to design, develop, test, and deploy an application. Now it may only take days. Able to leverage all existing code and database objects.

  15. Best Practices with HTML DB • Store css, images and javascript external of the database. • Group related pages together. • Let the database do the heavy lifting. • Be consistent with your development practices. • Use bind variables where possible to speed up queries and render pages faster. • Review the Oracle HTML DB Best Practices June 2004 white paper.

  16. Our Oracle Architecture Operation Data Store Servers • 3 Environments – Production, Development & Disaster Recovery • Production ServerServer Type – Fujitsu 850Operating System - Solaris 9Oracle Version - 9.2.0.4.0Processors – 12 @ 1.89ghzAmount of Memory – 24 gb ramAmount of DASD Available – 500 gbAmount of DASD Used – 300 gbAverage # of Users – 60 concurrent, 100 daily distinct & 20,000 indirect users • Warehouse Servers • 3 Environments – Production, Development & Disaster Recovery • Production ServerServer Type – Fujitsu 1500Operating System - Solaris 9Oracle Version - 10.1.0.4.0Processors – 20 @ 1.89 ghz Amount of Memory – 40 gb ram Amount of DASD Available – 7 tb Amount of DASD Used – 6.5 tb Average # of Users – 220 concurrent, 360 daily distinct & 20,000 indirect users

  17. HTML DB Applications/Solutions • On-Line Forms & Data Library • Data Collection • Data Display – Searchable & Sortable Lookup Tables • E-Mail Support directly from PL/SQL • Integration with our Oracle Application Server & Oracle Reports • Financial Calculators • Best Rate Calculator • Loan Calculator • On-Line Loan Rate Sheets & Competitive Intelligence • Download File Streaming

  18. HTML DB Applications/Solutions • Telephone Call Tracking Applications • 6 Tables, 8 Pages & 400 Users • Simple Data Collection and Display • Operations Sites & Employee Sales Goal Management • 7 Tables, 5 Pages & 60 Users • Data integration with Enterprise Application and Oracle Reports • Finance Forecast & Budget Management • 3 Tables, 12 Pages & 10 Users • What if Scenario options • Sales Force Customer Management • 12 Tables, 28 Pages & 650 Users. • Simple CRM Tool

  19. HTML DB Applications/Solutions • On-Line Forms & Data Library – Data Collection • 36 Tables, 48 Pages & 3650 Users

  20. HTML DB Applications/Solutions • On-Line Forms & Data Library – Data Display • 36 Tables, 48 Pages & 3650 Users

  21. HTML DB Applications/Solutions • Financial Calculators – Best Rate Calculator • 0 Tables, 2Pages & 5500 Users

  22. HTML DB Applications/Solutions • Financial Calculators – Loan Calculator • 1 Table, 2Pages & 5500 Users

  23. HTML DB Applications/Solutions • Financial Calculators – Loan Calculator

  24. HTML DB Applications/Solutions • Financial Calculators – On-Line Rate Sheets • 4 Tables, 2Pages & 5500 Users

  25. HTML DB Applications/Solutions • Financial Calculators – Competitive Intelligence • 4 Tables, 2Pages & 5500 Users

  26. D E M O N S T R A T I O N Chase

  27. The Professional Golfers Association of America • The PGA of America is a not for profit trade association with more than 28,000 Men and Women • PGA Golf Professionals throughout the United States • The PGA runs its own tournaments, The Ryder Cup, PGA Championship, Senior PGA Championship, Grand Slam, and the Club Professional Championship • There are 41 PGA Section offices in the United States, that also operate Golf Tournaments during the year

  28. PGA National Headquarters • Based in Palm Beach Gardens, Florida with a staff of around 200 people. Annual revenues of $200m. • The Finance Department uses Oracle eBusiness suite and Oracle Project Accounting • The Section Tournament accounting is managed through Project Accounting, and we process all Purse payouts at the National Headquarters in Florida.

  29. Financial Dashboard • HTMLDB Dashboard Application • We created a Financial dashboard in HTMLDB, by using the standard templates and wizards that were provided in the application. • We were able to customize the application with our own PL/SQL scripts, and access data from the multiple databases within our organization. • Single sign on with CA’s Siteminder service • Quick development time, first application was up in a week

  30. Custom Applications • Able to build one off applications on top of Oracle eBusiness Suite • Integration with Purchasing, Payables, and custom membership system • With HTMLDB we have been able to process daily purse payments quickly to tournament winners • Custom built Financial Statements Dashboard

  31. Results - Big Savings • We are now able to process Purse payouts, in large numbers from within HTML DB • This has resulted in significant time savings for our accounts payable dept, and reduced our need to hire new staff..approx savings were $100,000 • Our financial dashboard application was built with very low cost…We estimate that our savings for this alone was in excess of $150,000

  32. Architecture and Integration HTML DB Data Warehouse 10g RDBMS 9iAS eBusiness Suite Core Financials 11.5.9 SQL Server Reporting Services Other PGA Legacy Systems Data is extracted from eBusiness Suite into warehouse (daily) as well as retrieved by HTML DB application directly from eBusiness Suite via database link. Data is pulled “live” by reporting services directly from various sources for report display. Data is pushed (loaded) into data warehouse from various sources instead of live where appropriate.

  33. Powerful User Experience Browser • HTML DB easy to integrate with existing apps • Virtually pure HTML • Accessible from any internet connection HTML DB Other Web Apps • Windows 2K3 Server • SQL Server Reporting Services • Linux Redhat AS 3.0 • 10g RDBMS • HTML DB 1.6

  34. D E M O N S T R A T I O N PGAFinancial Dashboard

  35. D E M O N S T R A T I O N Financial Reporting Dashboard

  36. Conclusion • Customers are saving money with HTML DB • Customers are saving time with HTML DB • Oracle HTML DB not just for simple applications

  37. Next Steps • More information and downloads • otn.oracle.com/htmldb • Download pre-built applications • htmldb.oracle.com/studio • Read tips and tricks • orablogs.com/sergio

  38. Q & A

More Related