Application design for when a database is temporarily disconnected?

Here is the problem:

  • Incoming data from source
  • Your program that process that data
    • Written in C# and targeting .NET 4.0
  • Output database not associated with source
  • Output database may be disconnected temporarily
    • Disconnection time is between 0 and 2 hours
    • Still receiving data from source while disconnected

What would be the right pattern to follow when you have this situation? Is this too vague or situation specific?

Answers


Cache it using a queue on the server side. Remove the data off the queue once the data is dumped into DB.


Need Your Help

Can I install RubyMine 5 with openJDK instead of Oracle JDK?

linux ide rubymine openjdk

I already have openJDK installed on my system (Fedora 19), and I'd rather not put the Oracle JDK on it. Is it possible to run RubyMine 5 with openJDK instead? If yes, how. If no, then why? Thanks!

Jade lang getting variable back from javascript

pug

I know how to pass Jade variable into Javascript code using syntax like this: