The Study Of Crossing SQL In Heterogeneous Database

With the increased communication between commerces and the expansion ofe-commerce, the demand for the interaction between heterogeneous database is beingvery imperative. In order for these interactions to take place across different platformsthere is a need for middleware, XML technology is one type of middleware that canprovide a solution through database and networking technology.This article discusses one of aspects of heterogeneous database interactions,which is the problem of SQL global query in interactions of heterogeneous database.It set forth the status of database application, which lack of system independency. Itanalyzed the differences traditional databases, which is all based on SQL3. Itstudied the technology of auto matching of database source using XML.This article introduced the correlation concept of heterogeneous database, such asODBC, SQL, transform theory of heterogeneous database. Then it analyzed the automatching of database source using XML and discussed the status of databaseinteractions.It is introduced of a application in the last chapter to expound the problem ofinteractive SQL.