Request for a quick Blog Post or Webinar re: using RavenDb for a Banking scenario

[Justin A]

Hi Ayende,

a few of us were talking in JabbR about using RavenDb in a banking scenario. We'd love to hear about how you might leverage RavenDb in this type of scenario .. nothing too low level, but more high level, seeing what moving parts you would do, overall.

For example, the scenario is a bank that has accounts for medium/large businesses only. These accounts incur credits and debits very frequently. Meaning, people are putting money into the account (as they buy goods from the business) and the business also withdraws money to pay for large invoices, etc.

eg. Mon 1st May, 2012 4:52:32pm; Account# 1234; Deduction: $32.99;

The objective is to make sure we can get an accurate account balance at any given time. If the business accountant needs to pay for a big invoice, is there money in the account? etc.

The issues were we talking about was 

1) Do we put the balance into the Document (sorta like a de-normalized sum)?

2) If we have a Map/Reduce Index for the sum, what about it being stale? Lots of writes are occurring across many accounts.

3) Is this a possible candidate for some CQRS?

4) We know RavenDb can handle Optimistic concurrency .. but not sure if we should use it here (out gut feeling was, it should .. but how to handle a conflict?) 

and to top this off .. we're also guessing that a bank would generally be having replication and/or sharding in place cause they need to make sure stuff doesn't fall over AND it's scaling.

We believe it can be done .. we're be interested in some guidance from you and your colleges if you have some a moment.

Maybe this could be a catalyst for a community Q/A Webinar?

[redsquare]

Simples

http://elegantcode.com/wp-content/uploads/2009/11/DDDDevision_big_thumb.jpg

[Bohdan Szymanik]

Perhaps also consider how the transaction could be tagged with additional information that might be dynamically updated. Then this could be a parameter in a map reduce aggregation index.

[Oren Eini (Ayende Rahien)]

Justin,

I think that something like that would be great, sure. 

When can you join me and we will do this?

[Justin A]

before i check my free days, would you prefer morning or afternoon -your time- ?

(assumption: u're at home in Sede Izhak) 

[Oren Eini (Ayende Rahien)]

Morning Sunday / Monday would work best for me

[Justin A]

Hi Ayende. sorry, was off the grid for a day or two with family/kids, etc.

Morning Monday would be great for me. That would be 9am/10am in Israel == 4pm/5pm my time in Melbourne :) 

Or if this is too soon (not enough notice), then i can book any time during the week, etc :)

[Oren Eini (Ayende Rahien)]

10:00 AM tomorrow would be best from my perspective. If we can settle that, we can do that.

[ronnieoverby]

Looking forward to this!

[Justin A]

Ronnie - u kicked this entire thing off in JabbR. Any main questions you want to add, here? (PLEASE! :)  )

[Oren Eini (Ayende Rahien)]

Space is limited. Reserve your Webinar seat now at: https://www2.gotomeeting.com/register/143200658

In this webinar, we will go over the details of using RavenDB for banking scenarios.  We will discuss modeling, querying and reporting in that environment. Title: RavenDB in a banking scenario Date: Monday, May 7, 2012 Time: 10:00 AM - 11:00 AM IDT After registering you will receive a confirmation email containing information about joining the Webina

[Maverix]

Will this make it onto youtube?

On Monday, 7 May 2012 00:02:57 UTC+9:30, Oren Eini wrote:

Space is limited. Reserve your Webinar seat now at: https://www2.gotomeeting.com/register/143200658

In this webinar, we will go over the details of using RavenDB for banking scenarios.  We will discuss modeling, querying and reporting in that environment. Title: RavenDB in a banking scenario Date: Monday, May 7, 2012 Time: 10:00 AM - 11:00 AM IDT After registering you will receive a confirmation email containing information about joining the Webina

[Oren Eini (Ayende Rahien)]

Yes

[Justin A]

Thanks for the webinar Ayende :)

[steve flitcroft]

Did you record it?

[Oren Eini (Ayende Rahien)]

Of course

[Matt Warren]

Did this get posted anywhere, I'd be interested in watching it?

[Oren Eini (Ayende Rahien)]

Not yet.

[Jeremy Holt]

+1

I'd love to see this

Jeremy

On Sunday, 16 September 2012 12:39:14 UTC-3, Ronnie Overby wrote:

How about now?

[Oren Eini (Ayende Rahien)]

Sorry, slipped through the cracks.

Here it is:

http://www.youtube.com/watch?v=RLpu4JnKEOg