1 / 17

Best Practices for Web-Connecting Your Database: An Evolutionary Journey

Explore the evolutionary path of database connectivity from the Stone Age to the 21st Century. Discover how manual processing, automated transfers, and real-time integration can enhance your web presence. Learn about the challenges and benefits of different eras, including basic crawling methods and XML web services. This guide will help you determine the best approach for your needs by consulting with in-house technical staff, hiring consultants, or collaborating with your fulfillment house. Adapt your strategy according to your requirements and technological capabilities.

evania
Download Presentation

Best Practices for Web-Connecting Your Database: An Evolutionary Journey

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. Webify Your Database Best practices to attach your database on the web

  2. Evolutionary Path • Stone Age – Simple, manual processing. • Bronze Age – Automated transfers quasi real-time. • Iron Age – Black Plague strikes -Two separate systems. • Industrial Age - Real time integration Hybrid • 21st Century – XML Web Services – Lingua Franca of the web.

  3. Stone Age - Paleolithic Era-Crawling

  4. Stone Age - Paleolithic-Crawling Is relatively low cost Can often utilize existing resources. Ok for low volume websites Fulfillment house manually processes the transactions. New Orders only Bad for high volume websites No gatekeeping capability Batch processing Transfer data via FTP or email Upside Downside

  5. Stone Age – Neolithic Era-Walking

  6. Stone Age – Neolithic Era-Walking Real time (self) Create and show past history Renew, pay bill Limited gatekeeping Publisher can touch data-redundancy More complex than Paleolithic Era Batch processing Logic for synching databases Still Manual transactions with email/FTP Upside Downside

  7. Bronze Age - Automate those transfers

  8. Bronze Age - Automate those transfers Closer to real-time Gatekeeping improved Create and show current history Renew, pay bill No manual transactions Publisher can touch data - redundancy More complex Batch processing Logic for synching databases Upside Downside

  9. Iron Age- Two systems. Too Messy.

  10. Iron Age- Two systems. Too Messy Conceptually OK Publisher can touch data –redundancy (if you can trust it) More complex Batch processing Logic for synching databases Duplicated Business Rules Twice (or more) of the amount of work. Databases WILL get out of synch Upside Downside

  11. Industrial Age –Automated Integration

  12. Industrial Age –Automated Integration Conceptually OK Redundancy Publisher can touch data Databases will stay in synch Simpler than Iron Age Batch processing Logic for processing refresh file Upside Downside

  13. 21st Century–XML Web Services

  14. 21st Century–XML Web Services

  15. 21st Century–XML Web Services Real time – timely data Uses XML standard Publisher can touch data Multiple vendors & partners access data No data synch issues Central repository for business rules Multi-pub access w/integrated database Technical Expertise and time to implement Upside Downside

  16. How to make it happen • Which way is best for you? (Choose your Era) • - A few options - • Talk to your in-house technical staff • Hire a consultant to help. • Talk to your fulfillment house about their capabilities. Many have qualified technical staff, knowledge of your product and would welcome the opportunity.

  17. Thanks!

More Related