1 / 50

Application Express within New Zealand Post

Application Express within New Zealand Post. David Thornburrow Senior Data Architect New Zealand Post. Agenda. New Zealand Post Application Express N ational P ostal A ddress D atabase (NPAD) N PAD D ata A ttributes M aintenance (NDAM) M overs A ddress L ist T ool (MALT).

zoey
Download Presentation

Application Express within New Zealand Post

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. Application Express withinNew Zealand Post David Thornburrow Senior Data Architect New Zealand Post

  2. Agenda • New Zealand Post • Application Express • National Postal Address Database (NPAD) • NPAD Data Attributes Maintenance (NDAM) • Movers Address List Tool (MALT)

  3. New Zealand Post Serving New Zealanders since 1840 Approximately 17,000 employees Has around 97% of the domestic postal market 96.8% of mail is delivered on time Processes over 1 billion items of mail each year Between 500,000 and 700,000 people visit our PostShops each week

  4. Application Express Web Application Development Tool Little or no programming experience required Quickly build and deploy web applications Its FREE

  5. History of Application Express Oracle 9ir2 January 2006 2007 July 2007 August 2008 2009 HTML DB Renamed Application Express V3.0 Released V3.0.1 Released V3.1.2 Released V4 Planned

  6. Application Express Architecture • Versions Before Oracle 11.1 • Versions After Oracle 11.1

  7. National Postal Address Database (NPAD) • One database – single source of the truth • Building a single system for validating, maintaining and distributing core address data • Geospatial data model ensures data completeness, integrity and consistency across all address elements • NZ Post is confident of managing address changes in the future

  8. National Postal Address Database (NPAD) Npad Overview DVD

  9. Application Express in the NPAD Architecture

  10. Why Build NDAM? • Improve the timeliness of data updates • Reduce the effort required to make changes • Remove the possibility of mistakes being made due to data changes • Remove the requirement of a DBA

  11. Road Name Change

  12. NPAD Street Search

  13. Road name walkthrough Username Password

  14. Road name walkthrough Old Bollock

  15. Road name walkthrough

  16. Road name walkthrough Old Bullock Road

  17. Road name walkthrough

  18. Road name walkthrough

  19. Road name walkthrough

  20. Road name walkthrough

  21. NDAM walkthrough mo wellington

  22. NDAM and LDAP

  23. NDAM and LDAP

  24. NDAM and LDAP

  25. NDAM and LDAP

  26. NDAM and LDAP

  27. NDAM and LDAP

  28. NDAM and LDAP

  29. NDAM and LDAP

  30. NDAM and LDAP

  31. MALT Requirements Reduce Datamail operational costs Reduce the time to generate datalists Improve the ordering process Enable NZ Post to have control over new movers data lists The new prospect planning tool was a year away from completion

  32. MALT Login

  33. MALT Search Screen

  34. MALT Search Screen Cont.

  35. MALT Address Summary

  36. MALT Demo

  37. MALT Demo

  38. MALT Demo

  39. MALT Demo

  40. MALT Demo

  41. MALT Demo

  42. MALT Demo

  43. MALT Demo

  44. MALT Demo

  45. MALT Demo

  46. MALT Demo

  47. MALT

  48. Summary • Application Express is a quick and agile tool • NDAM • Allowed real-time updates • Simplified the process for NPAD Attribute updates • Removed the need of a DBA to make changes • MALT • Datalists can now be generated on the fly • Improved customer service • Removed the dependence on Datamail to create standard datalists

  49. Q & A

  50. Thank You!

More Related