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?
On Wednesday, 2 May 2012 01:31:27 UTC+1, Justin A wrote:
> 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.
> 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?
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.
On Wed, May 2, 2012 at 3:31 AM, Justin A <jus...@adler.com.au> wrote:
> 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.
> 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?
On Thu, May 3, 2012 at 2:35 AM, Justin A <jus...@adler.com.au> wrote:
> before i check my free days, would you prefer morning or afternoon -your
> time- ?
*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
On Sun, May 6, 2012 at 5:28 PM, Justin A <jus...@adler.com.au> wrote:
> Ronnie - u kicked this entire thing off in JabbR. Any main questions you
> want to add, here? (PLEASE! :) )
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 > On Sun, May 6, 2012 at 5:28 PM, Justin A wrote:
>> Ronnie - u kicked this entire thing off in JabbR. Any main questions you >> want to add, here? (PLEASE! :) )
On Mon, May 7, 2012 at 2:49 AM, Maverix <ajha...@gmail.com> wrote:
> 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<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
>> On Sun, May 6, 2012 at 5:28 PM, Justin A wrote:
>> Ronnie - u kicked this entire thing off in JabbR. Any main questions you
>>> want to add, here? (PLEASE! :) )
