Tips & Tricks: Cross Database Resource Guide
More and more, enterprise developers (Java, VB/.NET, C++, etc.) are being asked to create more efficient cross-database access to applications and users. See how many tools there are to help you do much better "database integration" -- before learning anything about web services.
As part of the Integration Developer News
reference libraries series for "developers as integrators," IDN presents the latest techniques and resources from leading developers concerned with cross-database integration.
JDBC Access Methods -- Many Java developers have been working with JDBC for years. But it can be a challenge to know if you getting the most out of your JDBC code solutions, or just slowing your CPU performance. An article in JavaWorld describes three (3) a traits that are required for a well-designed database access method. You can read it here.
Cross Database Integration, Sharing Resources
The article, written by Michael Juntao Yuan, who is a PhD candidate at the University of Texas at Austin, and a frequent JavaWorld contributor also describes how properly written JDBC access methods can greatly reduce the maintenance overhead and improve your Web application's flexibility.
ADOdb -- ADOdb is an object-oriented library written in PHP that abstracts database operations for portability. It is modeled on Microsoft's ADO, but has a handful of modifications for cross-database access, including pivot tables, generating HTML for paging record sets with next and previous links, cached record sets, HTML menu generation, etc). The latest version of ADSOdb (2.31, released 8/20), with tutorials on how to get started is at http://php.Weblogs.com/ADODB. Free copies of the latest ADOdb scripts are also available at Hotscripts.com
Enterprise Data Access (C++) -- For developers with the need to support multiple C++ and/or SQL target databases, Mathtools provides a very easy-to-navigate annotated list of more than several dozen tools (free and fee-based) for these environments. While Mathtools provides a good overview and click-through resources list, users of the site must register to access/download any company-specific resources.
Data Replication -- Some cross-database access is for storage and data replication, rather than simply for user access. Given this requirement for high-availability, the latest issue of Windows & .NET Magazine offers some helpful insights to developers (and their system administrator partners) on how to architect and implement a "clustering" solution using WinNT and/or Win2K Advanced Server.
XML Data Support -- A variety of XML tips, FAQs and forums are available at the XML area of Tek-Tips.com. Some of the latest topics address include: Using XML to Update a Remote Database; Printing an HTML Table with XML; Searching an XML DB; and Selecting Distinct Items from XML using ASP. (As with many forums, not all queries receive a prompt reply, but the XML area is one of the more active areas recently as we've been watching Tek-Tips.)
Migrating OLE-Based Data Sharing -- William Vaughn, a seasoned ActiveX Data Objects (ADO) developer and author presents a simple step-by-step tutorial for converting your existing ADO connection strings to ADO.NET. This straightforward article from Visual Studio Magazine starts the developer from a typical OLE DB connection string (used by ADO to connect to an SQL database), and provides clear instruction and code samples from there. The article is an extract from his latest books "ADO.NET Examples and Best Practices" with editions for VB and C# programmers.