Apache Derby Pure Java relational database engine using standard SQL and JDBC as its APIs
Download

Apache Derby Ranking & Summary

Apache Derby Tags

server database driver database engine jdbc driver network server

Apache Derby Description

Pure Java relational database engine using standard SQL and JDBC as its APIs Apache Derby, an Apache DB subproject, is an open source relational database implemented entirely in Java.Some key advantages include:· Derby has a small footprint -- about 2 megabytes for the base engine and embedded JDBC driver.· Derby is based on the Java, JDBC, and SQL standards.· Derby provides an embedded JDBC driver that lets you embed Derby in any Java-based solution.· Derby also supports the more familiar client/server mode with the Derby Network Server and Derby Network Client JDBC driver.· Derby is easy to install, deploy, and use. Here are some key features of "Apache Derby": · Embedded engine with JDBC drivers · Network Server · Network client JDBC drivers · Command line tools: ij (SQL scripting), dblook (schema dump) and sysinfo (system info) What's New in This Release: · SQL ROW_NUMBER() window function, as described in the SQL 2003 standard section 6.10, for an empty, inlined window specification. The window clause, as described in section 7.11 is not implemented. · Unique constraints on nullable columns. SQL Feature T591. · Asynchronous replication with manual fail-over. · Table Functions. SQL Feature T326. This lets you run queries against any external data source which can be presented as a JDBC ResultSet. Table Functions are useful for data migration and integration. For more information, please consult the "Programming Derby-style table functions" section of the Derby Developer's Guide as well as the functional specification attached to DERBY-716. · Java Management Extensions (JMX) for Derby, allowing local and remote monitoring and management of a running Derby system (this release includes a basic set of MBeans - it is expected that more JMX functionality will be added in later releases). · SQL bracketed comments (/*..*/). SQL Feature T351. · ij continuation marker. Interactive ij shows > prompt until ; is entered. · A JDBC statement object cache in the client driver. Some limitations imposed by the presence of DERBY-3596. · Caching of the isolation level and the current schema in the client driver. · Implement a new multi-threaded buffer manager to get better scalability on machines with multiple CPUs or multiple cores.

Apache Derby Related Software