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

How to get a value from nested array?

php arrays nested

Trying to fetch the first URL field from an array of them that comes from a JSON I have decoded but I get this error:

How to append to existing documents using mongoimport and csv files

mongodb

I am trying to use mongoimport to translate a one-to-many relational structure into mongoDB using csv files. My approach is to import the "one" file then use the upsert option to append the "many"

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.