Tips & Tricks: Cross Database New methods to exploit features and libraries in JDBC, OBDC, ADOdb, SQL and XML are available to developers for such one-off

This week, as part of IDN's reference library series for "developers as integrators," IDN presents the latest in a growing list of cross-db methods for JDBC, OBDC, ADOdb, JDO, SQL and XML.

All you need to do is to paste your code into the top window. Then, depending on how you'd like it changed, choose the appropriate button (OleDb to SQL or SQL to OleDB)...

Basically, the Rules of Normalization are enforced by eliminating redundancy and inconsistent dependency in your table designs...

Steve gives us a great explanation of what a database is, the relational database model, metadata and indexes, the database management system and structured query language.

Julie has written this article to assist a dba to evaluate their database so that it matches the organisation's needs...The database which you think is best matched with your organization is your..

In this article I will introduce you to the JDBC API, showing you how to connect to and work with a database.

The information that has presented in this article is an extremely basic look at databases. If you'd like to learn how to create databases and use manipulate them, then please take a look at the list of related links and books, which are shown below.

MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. In this article Annette takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script.Active Server Pages are a Microsoft technology that allows developers proficient with either Visual Basic or VBScript to easily adapt their skills and knowledge to the web with very little effort at all. ASP uses ActiveX Data Object (ADO) to connect to several popular database management systems including Microsoft Access and SQL Server, Oracle, dBase and Visual Fox Pro.

It is often helpful to be able to query SQL Server to find out the schema for a certain database, including tables, information about columns in a particular table, the text of a stored procedure and so forth. This comes in handy when building applications ...

Want to write a rock-solid, dependable application, but in record time? Code efficiency is the key! This article provides useful tools and ideas to speed up your database interactions in ASP, as well as a best-practice you just might be convinced to adapt for your database-driven applications.

To this end, we have created DataMorph, an intuitive, easy to use data conversion tool that provides powerful conversion functions for the most common data interchange formats.

DataPower supplies enterprises with intelligent XML-aware network infrastructure to address the performance, security and management problems associated with XML.

Databases are one of the most useful of business programs available. They are perfect for all sorts of data storage and retrieval, for example, employee records, inventory control, client marketing, logistics, equipment records and more.

A comparison of relational and object model techniques is shown in the following table

This figure presents a comparison of some basic terms used in relational and object technology...

Inheritance in the object model is a means of defining one class in terms of another. This is common usage for most of us. For example, a conifer is a type of tree. There are certain characteristics that are true for all trees, yet there are specific characteristics for conifers.

Encapsulation is the object model concept of including processing or behavior with the object instances defined by the class. Encapsulation allows code and data to be packaged together. The definition of methods for a class is an integral part of encapsulation. A method is programming code that performs the behavior an object instance can exhibit. Calculating the age of a person would be an example of such behavior.

Data abstraction is the process of distilling data down to its essentials. In an object schema, the abstract data model is implemented as a graph. The following figure shows such a graph structure for a genealogical database. For more information on data abstraction, see the items under "more detail" below.

Instance locking locks a single relational tuple in an RDBMS or a single object in an ODBMS. This type of concurrency control is illustrated below.