With the guidance of overseas chinese affairs office of the people ' s government of guangdong province and the overseas exchange association of guangdong province , our school has kept favorable interactive relation with the overseas chinese societies and chinese education administrations , and organizes for friendly visitation to abroad each year for realizing the living situation of overseas chinese and exchanging the information on chinese education , absorbing and introducing the experience of abroad chinese education organizations 我校在广东省人民政府侨务办公室及广东省海外交流协会的指导下，常年与海外华人社团及华教机构保持良好互动关系，每年学校均组团到海外进行友好访问，了解华人生存状况，互通华教信息，汲取和借鉴海外华教机构的办学经验。
First , we research the characters of topic - special searching , and then propose the thinking of design , system structure , searching strategy , searching method and etc . basing on an optimal searching strategy , topic - special search engine can gather more quickly topic - special new information . meanwhile , considering the situation of internet , we accept a searching method of human nature . second , our search engine can parse the content of page , pretreat the page , and recognize a page involved in overseas chinese affairs 并着重针对主题式搜索提出了一种优化的基于历史反馈( bhf )的搜索策略，使主题式搜索引擎能更快更及时的搜索到与主题有关的最新信息；同时就目前的internet上的网站的现状提出适合本课题的人性化搜索方式；其次，在侨务信息处理方面，针对基于内容的分析，进行了有效的预处理，根据侨务信息的特征对网页进行侨务信息的识别。
In this paper , firstly , the technical specialty and design method of data warehouse are expatiated on . the trait of current modeling and etl tools of data warehouse having been analyzed , the qwdw metl tool is brought forward whose realization process is described detailedly 本文阐述了数据仓库系统的技术特点和开发方法，分析了当前的数据仓库建模工具与etl工具的特点，提出结合两种工具为一体的思路，给出侨务数据仓库metl工具的设计思想，并介绍了其详细的设计与实现过程。
So the integration of olap and overseas chinese affair data ware is valuable . the paper adopts the great database system - sql server 2000 of microsoft as the database sever of data ware and olap database . the aim is different structure data sources and dts is the transform tools 本课题是采用了微软公司的大型数据库系统sqlserver2000作为数据仓库和olap数据库的数据库服务器，针对异构数据库来源，采用dts数据转换工具， analysisservices作为olap的主要建立和分析工具，建立了侨务数据olap数据库，创建了有关的多维数据集和其中的事实表和维表的星型结构，实现对数据集的多维操纵和度量的计算。
