Caigen DBF is a DBF JDBC type 4 driver that allows to perform SQL operations on DBF files (dBase III/ IV/ V, Clipper, xBase, FoxPro, Visual FoxPro). * It supports ANSI SQL 92 standard, and more than 230 sql functions. It supports { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] query , INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN, CROSS JOIN, self join, GROUP_CONCAT, GROUPING, WITH ROLLUP, WITH CUBE, multiple-row VALUES table, PIVOT table, UNPIVOT table, and subquery which includes single-row subquery, multirow subquery, multiple-column subquery, inline views, and correlated subquery. * It supports transactions. * It supports data mining on memory database, compressed database(.ZIP, .JAR, .GZ, .TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2), SAMBA database(smb), and url database(http, https, ftp). * It is completely platform-independent and can be deployed on any platform with Java VM, which includes Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, SCO Unix, OS2, OS/400, AIX OS, Tandem OS, MPE OS, FreeBSD, IRIX, OSF/1, OpenVMS, Guardian, UNIX, and LINUX.