• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

embedded databases

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What are the major advantages and disadvantages of embedded databases like apache derby?
Can embedded databases be used for data driven web applications?
Do they have limitation on capacity of data storage?
And in what cases would an embedded database be preferred over the traditional databases?

Thanks in advance for your answers!
 
Author
Posts: 531
Mac OS X Netbeans IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
first you should look what an embedded database means, it means that database will run on the same JVM that you application run. so , it will use shared resources....
usually we use embedded database for cases like :
1-providing application that works standalone with no need to setup another databas
2-we do not need full featured database server , features like recovery , transaction isolation ,clustering , ....
also for Demo-ing an application you can use an embeded database
for storing some temp data during you application work, ....

using an embedded database for a web application could bring some problems because , Database will start/stop with your application so if the container crashed it is possible that you lose some data , also using embedde database will limit your application scalablity because you are in one jvm with you database.

you can safely use derby as embeded database with you web application if ,
it is not high load , your data are not too much important , you do not need high availablity ....

ps , derby is an exception between embedded databases. it support both recovery and transaction, isolation... with an small footprint.

list of almost all Open source java database which some of them could be used in embedded mode

http://www.java-source.net/open-source/database-engines
 
reply
    Bookmark Topic Watch Topic
  • New Topic