Hello, everybody,<br /><br />I am developing a postgresql-based distributed relational data integration system which is
likethe IBM DB2 Information Integrator. And I have started a pgfoundry project: <a
href="http://pgfoundry.org/projects/ignite">http://pgfoundry.org/projects/ignite</a> .(codes on it have already been
obsolete.)<br/><br />The goal of the system is to provide a collection of virtual views in a pgsql database to
integratedata from various distributed, heterogeneous and autonomous data sources. To achieve this goal, I did my work
intwo aspects: <br />(1) outside pgsql: The system utilizes various wrappers to interact with data sources. A
well-definedwrapper interface is presented, which allows for implementations of concrete wrappers using any language ,
suchas pl/java. In nature, a wrapper is a collection of pgsql functions which consists of the function for obtaining
metadataof a data source, the function for exectuing SQL in data source and etc. <br /><br />(2) inside pgsql: Several
modifictionsto pgsql is used to improve the performance of processing data integration queries including the pipelined
FunctionScanoperator and support of query shipping(selection/projection/sort). <br /><br />The developing work is still
ongoing,although an initial version of the system has already been used in a real application in China. This version
consistsof a wrapper for PostgreSQL using libpq and a wrapper for MS SQL SERVER using pl/java and JDBC. Currently, I
havenot published all sources and not provided good documents in the pgfoundry projects. But I will do it quickly. If
anyoneis interested in the system, pls contact me. <br /><br />I have a question. Does the PostgreSQL project have any
planof adding data integration functionalities in the PostgreSQL system as other DBMS vendors did? <br /><br /><br
/>Thanks.<br/><br />Yours sincerely,<br /><br />Lee Rubao <br /><a
href="mailto:lirubao@software.ict.ac.cn">lirubao@software.ict.ac.cn</a><br/><br />2006-11-1<br /><br /><br /><br />
