TrustRadius
Apache Derby is an embedded relational database management system, originally developed by IBM and called IBM Cloudscape.https://dudodiprj2sv7.cloudfront.net/product-logos/7R/xW/VU44CV8S1PFI.jpegApache Derby- Great for localized Risk ModelingIn the Project I was using Apache Derby, we were shadowing larger databases (MS SQL + Cygnet), and providing some failover for those platforms. Most of the Use case was research-oriented, but it allowed the Risk Modelers to grab a subsection of data from these two data sources, and then combine them inside an apache derby instance. Given its size, it was a good fit.,Apache Derby is SMALL. Compared to an enterprise scale system such as MSSQL, it's footprint is very tiny, and it works well as a local database. The SPEED. I have found that Apache Derby is very fast, given the environment I was developing in. Based in JAVA (I know that's an obvious thing to say), but Java allows you to write some elegant Object Oriented structures, thus allowing for fast, Agile test cases against the database. Derby is EASY to implement and can be accessed from a console with little difficulty. Making it appropriate for everything from small embedded systems (i.e. just a bash shell and a little bit of supporting libraries) to massive workstations.,Not as well positioned in the market as the "big dogs" (Oracle, MSSQL) Been around awhile, and not a lot of exposure. This I believe is primarily due to it's relation to the Apache Project (which is not bad, but they don't force big, lumbering corporate volume licensing on you), and thus people are a bit gun-shy about NOT throwing money at something Java is still "slow" compared to C/C++, thus making Derby a bit slow too,10,Being Open source, the resources spent on the purchase of the product are ZERO. Contrary to popular belief, open source software CAN provide support, provided that the developers/contributors are willing to answer your emails. Overall, the ROI was positive: being able to experiment with an open source technology that could perform on par with the corporate products was promising, and gave us much information about how to proceed in the future.,,MongoDB, CouchDB, Microsoft SQL ServerDeveloping with DerbyThe product I worked on at IBM supported all the major database vendors, including Derby. Since Derby is free, most development and QA was done with Derby, although not many customers had adopted Derby as their production database vendor.,Much easier to use and learn than most commercial databases. Derby database errors are well documented. Most complex queries supported as well as by other database vendors.,It may not scale as well as some more mature database products. Used it primarily from the command line with openjpa and jdbc, and from third-party clients such as Squirrel. May benefit by providing more sophisticated tools to optimize query performance.,8,Saved money on database licensing.,Oracle Database 12c, DB2, Microsoft SQL Server
Unspecified
Apache Derby
4 Ratings
Score 8.8 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Apache Derby Reviews

Apache Derby
4 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.8 out of 101
Show Filters 
Hide Filters 
Filter 4 vetted Apache Derby reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-2 of 2)
  Vendors can't alter or remove reviews. Here's why.
Benjamin Albrecht profile photo
June 13, 2018

Review: "Apache Derby- Great for localized Risk Modeling"

Score 10 out of 10
Vetted Review
Verified User
Review Source
In the Project I was using Apache Derby, we were shadowing larger databases (MS SQL + Cygnet), and providing some failover for those platforms. Most of the Use case was research-oriented, but it allowed the Risk Modelers to grab a subsection of data from these two data sources, and then combine them inside an apache derby instance. Given its size, it was a good fit.
  • Apache Derby is SMALL. Compared to an enterprise scale system such as MSSQL, it's footprint is very tiny, and it works well as a local database.
  • The SPEED. I have found that Apache Derby is very fast, given the environment I was developing in.
  • Based in JAVA (I know that's an obvious thing to say), but Java allows you to write some elegant Object Oriented structures, thus allowing for fast, Agile test cases against the database.
  • Derby is EASY to implement and can be accessed from a console with little difficulty. Making it appropriate for everything from small embedded systems (i.e. just a bash shell and a little bit of supporting libraries) to massive workstations.
  • Not as well positioned in the market as the "big dogs" (Oracle, MSSQL)
  • Been around awhile, and not a lot of exposure. This I believe is primarily due to it's relation to the Apache Project (which is not bad, but they don't force big, lumbering corporate volume licensing on you), and thus people are a bit gun-shy about NOT throwing money at something
  • Java is still "slow" compared to C/C++, thus making Derby a bit slow too
Derby is absolutely the best when it comes to needing a small, embeddable RDBMS in your applications. Certain jobs, like Risk Modeling, are perfect for a database that is small enough to fit into memory with no trouble then store data from various sources, and then allow a user to access those data sets quickly.
Read Benjamin Albrecht's full review
Renato Ermann profile photo
April 10, 2017

Apache Derby Review: "Developing with Derby"

Score 8 out of 10
Vetted Review
Verified User
Review Source
The product I worked on at IBM supported all the major database vendors, including Derby. Since Derby is free, most development and QA was done with Derby, although not many customers had adopted Derby as their production database vendor.
  • Much easier to use and learn than most commercial databases.
  • Derby database errors are well documented.
  • Most complex queries supported as well as by other database vendors.
  • It may not scale as well as some more mature database products.
  • Used it primarily from the command line with openjpa and jdbc, and from third-party clients such as Squirrel.
  • May benefit by providing more sophisticated tools to optimize query performance.
[It's] Well suited for development and testing environments.
Read Renato Ermann's full review

Apache Derby Scorecard Summary

About Apache Derby

Apache Derby is an embedded relational database management system, originally developed by IBM and called IBM Cloudscape.
Categories:  Embedded Database

Apache Derby Technical Details

Operating Systems: Unspecified
Mobile Application:No