Cloudspace

As one of our project is looking for a open source, lightweight and stable database to be embedded into application, cloudspace has come into my eyes as its superior features and ready support of synchronization with various enterprise back ends, such as DB2 UDB™ or Informix® Dynamic Server.

Cloudscape is the original zero-admin, embeddable, 100% Java relational database that entered the marketplace in 1996. In August 2004 IBM contributed Derby, a copy of its Cloudscape 10.0 relational database product, to the Apache Software Foundation (ASF) to help accelerate innovation around data-driven Java applications. IBM continues its Cloudscape commercial offering at no-charge, which adds features to the core Derby engine. The most current release is Cloudscape 10.1, which includes Apache Derby 10.1.

Cloudscape- Key Features

* 100% Pure Java
o Completely portable to any hardware, any OS
o Only requires JVM (J2SE 1.3 or higher)
* Embeddable
o Can be installed as a JAR file (as part of a Java application)
o Can be started within an application
o Installation, startup and shutdown are invisible to user
* Fully-functional RDBMS

* Adheres to standards
o JDBC
o SQLJ
o ANSI SQL-92 * "Zero" Administration
o No need for DBA at customer site
o Users may even be unaware that a database engine is present
* Lightweight
o Approx. 2MB “footprint”
o Can run on many “palm”-size devices (new feature!)
* Scales to Moderate Size
o No defined limits on table sizes
o Table size limit of 2GB in some environments (OS limit)
o Existing customer databases of >10 GB working well
* Supports Disk Encryption
o Tested with IBM JCE

* Easy for Application Developers to Use
o To set up, just copy Cloudscape JAR files and set Java CLASSPATH
o Database engine starts automatically when application attempts to connect to it
* Cloudscape databases are completely portable
o To move a Cloudscape database to another machine, just copy it! (This works even if the machines have different OS or hardware!)
* Distributed transaction support (new!)
o Participates in XA transactions with other database systems

Cloudscape is a Fully-Functional RDBMS

* Indexes
* Views
* Triggers and Stored Procedures
* Constraints (primary-key, foreign-key, unique, check)
* Concurrency Support
o Transactions (with crash recovery)
o Savepoints
o Row-level locking, with escalation
o JDBC isolation levels (including dirty-read)
* Scrollable Cursors (result sets)
* Cascading Delete
* Internationalization/Localization Support

Reference List:

Synchronize IBM Cloudscape V10.0 and IBM DB2 Everyplace Sync Server V8.2


DB2 Everyplace Java Sync Client for IBM Cloudscape Version 10

Cloudscape Past and Present

Cloudscape Version 10: A technical overview