Webify Your Database

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
Upside Downside

• 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

5
Stone Age Neolithic Era-Walking
6
Stone Age Neolithic Era-Walking
Upside Downside

• More complex than Paleolithic Era
• Batch processing
• Logic for synching databases
• Still Manual transactions with email/FTP

• Real time (self)
• Create and show past history
• Renew, pay bill
• Limited gatekeeping
• Publisher can touch data-redundancy

7
Bronze Age - Automate those transfers
8
Bronze Age - Automate those transfers
Upside Downside

• 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

9
Iron Age- Two systems. Too Messy.
10
Iron Age- Two systems. Too Messy
Upside Downside

• 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

11
Industrial Age Automated Integration
12
Industrial Age Automated Integration
Upside Downside

• Conceptually OK
• Redundancy
• Publisher can touch data
• Databases will stay in synch
• Simpler than Iron Age

• Batch processing
• Logic for processing refresh file

13
21st CenturyXML Web Services
14
21st CenturyXML Web Services
15
21st CenturyXML Web Services
Upside Downside

• 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

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!