Click here to Skip to main content
16,005,552 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
QuestionEsb experiences Pin
Tom Wauters22-Feb-16 6:59
Tom Wauters22-Feb-16 6:59 
AnswerRe: Esb experiences Pin
jschell6-Mar-16 8:24
jschell6-Mar-16 8:24 
GeneralRe: Esb experiences Pin
Tom Wauters6-Mar-16 11:36
Tom Wauters6-Mar-16 11:36 
GeneralRe: Esb experiences Pin
jschell31-Mar-16 9:35
jschell31-Mar-16 9:35 
QuestionFile Sharing App Proposed Architecture Pin
Kevin Marois10-Feb-16 11:20
professionalKevin Marois10-Feb-16 11:20 
AnswerRe: File Sharing App Proposed Architecture Pin
Richard Deeming11-Feb-16 0:38
mveRichard Deeming11-Feb-16 0:38 
GeneralRe: File Sharing App Proposed Architecture Pin
Kevin Marois11-Feb-16 3:39
professionalKevin Marois11-Feb-16 3:39 
QuestionArchitecture - handling consecutive updates - Azure Pin
Rajeshjoseph9-Feb-16 5:13
Rajeshjoseph9-Feb-16 5:13 
I am working towards developing a system that has some of its components in Microsoft Azure and rest on premises. Some key components are the Azure Cloud Services wich has a web role (MVC web applicaiton) and Azure SQL DB as a local datastore. The core Database systems (system of records) are onpremise. Certain transactions follows a specific flow where in they need to be updated in the Azure SQL DB first and then it will be asyncronously updated in the core DB on premise, and then this update along with some other calculated values will flow back to the SQL Azure DB. This flow back to Azure SQL DB is planned using Azure SQL Data Sync. Azure Data sync has a minimum delay of 5 minutes between consecutive updates. The web will always display its data from the Azure SQL DB.

In a scenario where a customer updates a field - say name - immediately two or more times, the web applcation since it is getting data from Azure SQL DB will display the last updated value. However, since the core databases are updated asynchronously and these updates from the core databases will flow to the Azure SQL DB at a later point in time, the last updated record in Azure SQL DB by the web can be replaced with the values coming from the core database which was a result of the initial updates. This may cause some level of inconsistency with respect to user experience. The customer may see the latest updated "Name" as soon as he does his final update, but this value will change (to one of the earlier updates) after the data sync, and finally it will display the last updated value. Any recommendations on the best way to implement such a functionality?

Moreover, what would be the best option to sync an on premise SQL Server and an Azure SQL DB, if not Azure SQL Data Sync?
AnswerRe: Architecture - handling consecutive updates - Azure Pin
Eddy Vluggen9-Feb-16 6:45
professionalEddy Vluggen9-Feb-16 6:45 
AnswerRe: Architecture - handling consecutive updates - Azure Pin
Gerry Schmitz9-Feb-16 17:40
mveGerry Schmitz9-Feb-16 17:40 
AnswerRe: Architecture - handling consecutive updates - Azure Pin
jschell12-Feb-16 12:21
jschell12-Feb-16 12:21 
GeneralRe: Architecture - handling consecutive updates - Azure Pin
Rajeshjoseph16-Feb-16 4:55
Rajeshjoseph16-Feb-16 4:55 
GeneralRe: Architecture - handling consecutive updates - Azure Pin
Wayne Stewart_16-Feb-16 13:11
Wayne Stewart_16-Feb-16 13:11 
GeneralRe: Architecture - handling consecutive updates - Azure Pin
jschell19-Feb-16 12:55
jschell19-Feb-16 12:55 
AnswerRe: window application form work in KIOSK Pin
Eddy Vluggen9-Feb-16 6:46
professionalEddy Vluggen9-Feb-16 6:46 
GeneralRe: window application form work in KIOSK Pin
Richard MacCutchan9-Feb-16 7:24
mveRichard MacCutchan9-Feb-16 7:24 
GeneralRe: window application form work in KIOSK Pin
Eddy Vluggen9-Feb-16 7:40
professionalEddy Vluggen9-Feb-16 7:40 
GeneralRe: window application form work in KIOSK Pin
tracie.macmoon8-Mar-16 22:29
tracie.macmoon8-Mar-16 22:29 
AnswerRe: window application form work in KIOSK Pin
ZurdoDev9-Feb-16 8:38
professionalZurdoDev9-Feb-16 8:38 
GeneralRe: window application form work in KIOSK Pin
Gerry Schmitz9-Feb-16 18:01
mveGerry Schmitz9-Feb-16 18:01 
Questionflyweight design pattern - need some explanation Pin
D4rkTrick7-Feb-16 12:03
professionalD4rkTrick7-Feb-16 12:03 
AnswerRe: flyweight design pattern - need some explanation Pin
Gerry Schmitz8-Feb-16 6:46
mveGerry Schmitz8-Feb-16 6:46 
Generalmisleading example Pin
D4rkTrick8-Feb-16 9:06
professionalD4rkTrick8-Feb-16 9:06 
GeneralRe: misleading example Pin
Gerry Schmitz8-Feb-16 13:10
mveGerry Schmitz8-Feb-16 13:10 
Praisethanks Pin
D4rkTrick11-Feb-16 1:22
professionalD4rkTrick11-Feb-16 1:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.