Itzam is an embedded database engine that creates and manipulates files containing keyed-access records. Information is referenced by a user-defined key value, and one or more indexes (hash, B-tree, or matrix) may be combined with or separated from data. Itzam is deliberately portable and designed as a foundation for other languages (C++, Python, and Java).
Itzam/C++ wraps the Itzam database engine with C++ templates for both simple and complex database classes. It supports B-tree, hash table, and sparse matrix indexes with unique or duplicate keys, and includes multithreaded resource locking and atomic file transactions. Complete class documentation is embedded in the source code, and available online and in the distribution archive.
Itzam/Java is a pure Java reimplementation of the Itzam embedded database engine, and it is 100% interoperable with files created by Itzam/Core. Since Itzam/Core is the basis of wrappers written in languages such as C++ and Python, Itzam/Java is compatible with those language libraries as well.
This small tool connects to the P6Spy JDBC logger and displays in real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns to enable database index creation. Other information is also gathered and displayed, such as the request time for a single request, for a class of request, and for all the requests. Sorting may be done on these views to detect database problems efficiently.
JPOX provides transparent persistence of Java objects. It fully complies with the JDO1.0/JDO2.0/JDO2.1/JPA1 specifications. It supports persistence to all of the major RDBMSs on the market today, as well as DB4O. It allows querying using JDOQL, SQL, or JPQL. It comes with its own byte-code enhancer. Its 1.1 release is Sun's "Reference Implementation" (RI) for JDO2.0, and its 1.2 release is the RI for JDO2.1. It is highly extensible, using OSGi technology and providing a wide range of value-adding plugins.
JalistoPlus is lightweight, transactional, 100% pure Java database. It is object oriented and is able to directly persist and query for Java object graphs. It has a modular design and may be used either in single or multi-threaded mode. Besides basic operations (create, update, delete, and read), a query module is available. It offers a standard set of operators (i.e. equal, smaller, greater, not, and, or) to build the filter expression. Optionally, indexes may be defined on persistent fields to speed up query execution time.