The UnityJDBC driver can integrate and query any number of JDBC-accessible data sources (including Oracle, SQL Server, MySQL, and Postgres) in a single SQL query. UnityJDBC contains a built-in database engine and optimizer that can be used separately from the integration system. It also contains a new, faster join algorithm and syntax for matching/merging data beyond simple joins. It runs on any Java-enabled platform.
Features:
Integrate Everything: UnityJDBC allows you to write a single SQL query to extract data from any number of JDBC-accessible data sources. The query can join or match data between sources and return a single ResultSet.
Supreme Performance: UnityJDBC has minimal overhead and contains a new join algorithm (US patent submitted) that returns results faster than previous algorithms. The built-in optimizer restructures queries to create the most efficient execution plans.
Standards based: UnityJDBC is pure Java and can be used on any Java-enabled platform (Windows, Linux, Solaris). The system supports standard SQL queries and works exactly as other JDBC drivers. This allows for rapid development of applications that access multiple databases without requiring new middleware software or training programmers on a different development environment. It can be deployed within application and web servers as well as stand-alone Java applications.
Database Annotation: The system allows developers to rename fields and tables in the databases being queried. This makes it easier to track and query the databases.
Matching and Merging Data: A unique feature is the ability to match data across sites. The MERGE operator allows queries that go beyond standard joins and track the provenance of the data. This is useful when building comparison shopping sites and any site that needs to relate data from many sources.
Database Convert
(Popularity: ) : 1) The Database Convert software is wizard-like; it's so easy, everyone can use it. You convert one database to the ... Access MySQL Import, Export & Convert
(Popularity: ) : This application will allow you to transfer tables to and from Access and MySQL databases. Importing and exporting can be ... Select to Excel
(Popularity: ) : This small Excel macro allows you to execute SQL commands on any ODBC data source directly in Excel and will ... Exportizer Pro
(Popularity: ) : Database tool for viewing, editing, filtering, copying, exporting tables of different formats (DB, DBF, MDB, XLS, GDB, IB, HTML, UDL, ... DBScribe for MySQL
(Popularity: ) : DBScribe is a free MySQL database documentation tool that creates precise technical documentation of every detail of a database schema ... ESF Database Convert
(Popularity: ) : If you are moving your data across different platforms or applications, then you know that it can’t be done by ... CDB® Comparator
(Popularity: ) : CDB® Comparator is a powerful easy-to-use ODBC based tool for comparison of heterogeneous databases, used by thousands DBAs, developers and ... NEROCODE MySQL Client
(Popularity: ) : GUI Client for MySQL Database Server administartion and development.
Some key features:
- Manage database
- Views
- Triggers
- ... SQL Balance for MySQL
(Popularity: ) : Database Administrators, rejoice! Business owners and IT managers, take a note! Now there is no need to compare and synchronize ... Benchmark Factory for Databases Freeware
(Popularity: ) : Benchmark Factory for Databases is a database performance and scalability testing tool for Oracle, SQL Server, DB2 UDB, Sybase ASE, ...
User reviews
Screenshot
Rate me
supported os's
Linux Mac OSX Windows 2003 Windows XP Windows 2000 Windows NT Windows Me Windows 98 Windows 95
Software Library
) : 1) The Database Convert software is wizard-like; it's so easy, everyone can use it. You convert one database to the ...
