UnityJDBC 4.0
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. The query can join or match data between sources and return a single ResultSet.
Last update
25 Oct. 2011
Licence
Free to try
OS Support
Windows
Downloads
Total: 711 | Last week: 2
Ranking
#452 in
Databases Tools
Publisher
Unityjdbc
Screenshots of UnityJDBC
UnityJDBC Publisher's Description
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. UnityJDBC will automatically translate SQL functions and dialects and can be used when translating from one database system to another.
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 unique join algorithm that returns results faster than previous algorithms. The built-in optimizer restructures queries to create the most efficient execution plans. It can process queries larger than main memory.
Standards based: UnityJDBC is pure Java and can be used on any Java-enabled platform (Windows, Linux, UNIX). 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: The MERGE operator allows queries that go beyond standard joins and track the provenance of the data.
Function Translation: UnityJDBC supports all standard SQL functions, user-defined functions, and translates functions specific to the dialect and level of support on each database system including date/time functions, string manipulation, and LIMIT/OFFSET paging.
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 unique join algorithm that returns results faster than previous algorithms. The built-in optimizer restructures queries to create the most efficient execution plans. It can process queries larger than main memory.
Standards based: UnityJDBC is pure Java and can be used on any Java-enabled platform (Windows, Linux, UNIX). 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: The MERGE operator allows queries that go beyond standard joins and track the provenance of the data.
Function Translation: UnityJDBC supports all standard SQL functions, user-defined functions, and translates functions specific to the dialect and level of support on each database system including date/time functions, string manipulation, and LIMIT/OFFSET paging.
Look for Similar Items by Category
Developer Tools
> Databases Tools
This product is also listed in: Java Software, Sales & Marketing Software
This product is also listed in: Java Software, Sales & Marketing Software
Feedback
- If you need help or have a question, contact us
- Would you like to update this product info?
- Is there any feedback you would like to provide? Click here
Popular Downloads
- Kundli 4.5
- Macromedia Flash 8 8.0
- Cool Edit Pro 2.1.3097.0
- Cheat Engine 6.8.1
- Hill Climb Racing 1.0
- Grand Theft Auto: Vice City 1.0
- C-Free 5.0
- Windows XP Service Pack 3 Build...
- Iggle Pop 1.0
- Ulead Video Studio Plus 11
- Grand Auto Adventure 1.0
- Netcut 2.1.4
- Zuma Deluxe 1.0
- Horizon 2.9.0.0
- Vector on PC 1.0
- Tom VPN 2.2.8
- Auto-Tune Evo VST 6.0.9.2
- Vidnoz AI 1.0.0
- PhotoImpression 6.5
- FormatFactory 4.3