Forum Stats

  • 3,770,454 Users
  • 2,253,116 Discussions
  • 7,875,462 Comments

Discussions

Peer to Peer Enviroments

532835
532835 Member Posts: 4
edited Sep 9, 2006 10:01PM in Berkeley DB Java Edition
Gentlemen:

I am working a large Peer 2 Peer project that is to be used as a micropayment service. Each peer should have its own db and run unattended.

1. What type of db can be used for this application?

2. Can Berkley DB be used for this application?

Eric Brown

Comments

  • Greybird-Oracle
    Greybird-Oracle Member Posts: 2,690
    Hello Eric,

    Yes, Berkeley DB is an excellent choice for unattended embedded database applications.

    I don't personally know a lot about P2P or micropayment service implementations, but I suggest you try to find out from those with experience in these areas the requirements for data storage and retrieval. Try to find out the overriding requirements -- SQL support, ad-hoc queries, performance, scalability, etc.

    If performance is the overriding requirement, and SQL support is not important, then Berkeley DB is very likely the best choice.

    Mark
  • 532835
    532835 Member Posts: 4
    Thank you.

    http://www.eecs.berkeley.edu/Pubs/TechRpts/2005/5650.html

    The above link with white paper best describes what we are attempting to develop. Your input is appreciated as to the db at the peer level.

    Performance and size are critical. SQL is not so much. Think of each peer having a skype type interface with anonymous browser. A central db is planned, but having a db at the peer level allows us to push alot of the transaction load to the nodes and not the central db. At least that is the plan.

    Eric
  • Greybird-Oracle
    Greybird-Oracle Member Posts: 2,690
    Since performance is critical and SQL is not so important, then Berkeley DB is probably ideal.

    You mention size -- do you mean total data set size, or individual record size? On total data set size, Berkeley DB has no significant limits.

    On record size, while Berkeley DB works with very large records it does not have true LOB support. So if you have very large records (many MBs) and you need to access them using a streaming or chunking interface, this could be an issue. For more information on BDB JE LOB support see:

    http://www.oracle.com/technology/products/berkeley-db/faq/je_faq.html#3

    Mark
This discussion has been closed.