1 / 33

Michael B. Smith Oracle Corporation

Michael B. Smith Oracle Corporation. Agenda. What is Oracle HTML DB Features and benefits Customer examples Demonstration Conclusion Next steps Q&A. Does Your Organization:. Use spreadsheets as databases?

chaviva
Download Presentation

Michael B. Smith Oracle Corporation

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. Michael B. SmithOracle Corporation

  2. Agenda • What is Oracle HTML DB • Features and benefits • Customer examples • Demonstration • Conclusion • Next steps • Q&A

  3. Does Your Organization: • Use spreadsheets as databases? • Store mission critical data in applications developed in a desktop database such as Microsoft Access? • Not have time to build all of the applications that users are asking for?

  4. Drawbacks to Desktop Tools • Fragmented • Vulnerable • Platform dependent • Web unfriendly • Costly

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

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

  7. Oracle HTML DB Offers • The Qualities of a Personal Database • Productivity • Ease of Use • Flexibility • The Qualities of an Enterprise Database • Security • Integrity • Scalability • Availability • Portability • Built for the Web

  8. Spreadsheets Desktop Databases File Servers Consolidation with HTML DB HTML DB Any Browser

  9. Architecture Browser Oracle HTTP Server Oracle Database HTML DB

  10. How it Works • Shared Workgroup Database Service • Centrally Deployed & Managed • Accessed anywhere via a Browser • Declarative development style Oracle HTML DB

  11. Logical Architecture Finance Applications Applications Schema A Human Resources Applications Applications Schema B Marketing Applications Applications Schema C Oracle HTML DB

  12. Functionality Overview • Complete Environment • Application Builder • SQL Workshop • Administration

  13. Application Development • Reports • Data entry forms • Charts • Security • Navigation • Look and feel

  14. Reports • Pagination • Column sorting • Export to spreadsheet or XML • Calendar and tree • Template driven • Drill down to other reports, charts, forms

  15. Data entry forms • Many built in widgets • Pop up calendar • List of values • Validations • Lost update detection • Tabular forms • Master detail forms

  16. Charts • Bar, Pie, Line, Dial • SVG based • Drill down • Asynchronous refresh

  17. Security • Built in authentication modules • LDAP • Single Sign-On • Centrally defined authorization rules • Session state protection • Integration with database security features • FGAC • Transparent Data Encryption

  18. Navigation • Tabs • Lists • Menus • Breadcrumbs

  19. Look and feel • Template driven • Consistent throughout application • Customize with HTML and CSS

  20. Customer Examples • Telstra • PGA of America • Lansing Community College • QOD • Can you guess another real important one to us Oracle Geeks

  21. Telstra • Moved massive, distributed desktop application to web via HTML DB • Improved data integrity and security through consolidation

  22. “[Oracle HTML DB] allowed us to build reliable business-grade applications very quickly. We can make changes in a matter of days that would take weeks or even months to implement with traditional database programming. Oracle HTML DB dramatically increased our agility and enabled us to react to changes in the business sooner.” • Victor Hughes, Team Leader, Productivity and Logistics, Infrastructure Services, Telstra Corporation Limited

  23. PGA of America • Built financial reporting dashboard • Built purse management application to pay tournament winners • Integrated with eBusiness Suite

  24. “Typically, application development is completely out of the realm of what finance departments are capable of doing. With Oracle HTML DB, we can now build, deploy and manage our own web applications. It's that easy!” • Rosemarie Barr, Director/Corporate Controller of Finance, Professional Golfers Association of America

  25. Lansing Community College • Replaced MS Access and Excel-based applications • Replaced Lotus Notes applications • Consolidated and secured data in Oracle • Able to respond to business requirements using existing IT staff

  26. “Oracle HTML DB has clearly strengthened our ability to collect and present information via robust web based applications, with very short turnarounds and with very high user acceptance.” • Glenn CernyChief Information OfficerLansing Community College

  27. Ask Tom

  28. D E M O N S T R A T I O N Rapid Application Development

  29. Availability • Release 1.6 • Ships on 10gR2 Companion CD • Release 2.0 • Standalone download from OTN • Works & Supported in Oracle Database 10g and Oracle Database 9iR2 (9.2.0.3+) • Included as a component of Standard One, Standard and Enterprise Editions • No Additional Charge

  30. Next Steps • More information and downloads • otn.oracle.com/htmldb • Oracle HTML DB 2-Day Developer tutorial book • otn.oracle.com/htmldb • Download pre-built applications • htmldb.oracle.com/studio • Read tips and tricks • orablogs.com/sergio

  31. Conclusion • Improve application development productivity • Consolidate • Increase data security • Improve access

  32. Q & A

More Related