The Design And Application Of Natural Cold And Hot Resource Data Warehouse Based On GIS

Because of the building regarded as the artificial environment, its energy consumption is extremely high. Substitute traditional artificial cold heat source with natural cold and hot resource, to building of energy saving, arrange carbon dioxide have a great meaning energy-conservation. Natural cold and hot resources include renewable resources such as solar energy, night sky, air, water, rock soil, etc. Rational utilization can improve the internal and external environments of building room, thus achieve the energy saving in architecture goal.Under the software and hardware support of the computer, The geographical information system (GIS) can gather, store, manage, search, analyze and describe space position distribute and related to it attribute datum of object and answer user issue, etc. Through GIS, we can collect, store and deal with various figures related to space and geographical distribution and attribute data with electronic computer, and serve in order to manage and make policy directly through the analysis on data of the computer. Data warehouse is the technology which can structurization combine, store, manage magnanimity datum and offer high-efficient to inquire and analyze. It is theme -oriented, integrates, relatively stable and reflecting the datum set that history changes one. ETL is the key step in the construction of warehouse. ETL is the course of wash, change course of data, purpose scattering, in a mess, standard unified data to together integration of enterprise, dispel the different structural difference of constructing database, then offer the basis analyzed for decision of enterprises. Adopt the data warehouse of natural cold and hot resource to analyze the natural hot and cold resources with place to represent properties in the whole country, through the technology of GIS and data mining, can obtain one utilizing natural hot and cold resource improve building room internal and external mode of environment excellent, thus can realize reducing the energy consumption of building.In this text, at first the basic situations of the energy question and building energy consumption of our country have been introduced, then natural cold and hot resources have been pull-in. Base on the premise that its basic key element and characteristic have been analyzed , the goal of improving the internal and external environments of building room through rational utilization have been proposed. In order to utilize natural cold and hot resources better, raise the efficiency, lower the cost, have proposed using the technology of geographical information system, data warehouse and data mining. After analyzing the area which have representative, we can find a better use mode, then popularize to the whole country.