Real Estate Information Design And Application Of Data Warehouse

Since the reform and opening up, China’s housing system reform continued to deepen, implemented, Implement the commercialization of housing, including housing. Accompanied by local governments to support the economic development of estate and national income levels have increased, the nation’s housing demand and desire is also increasing investment, so as to promote and stimulate the real estate industry fast development, become one of the pillar industries around about economic development.However, in the real estate economy to promote economic development in the region, but also accompanied by a lot of irrational, blind real estate development and construction projects, and cause serious adverse effects hinder overall economic development of the real estate and economic development impact. Local governments, therefore, an urgent need to analysis and timely grasp the dynamics of the real estate market and trends, with reasonable planning and development for the construction of the real estate industry.Real estate and high-speed economic development in the real estate market is not commensurate with the information construction is lagging behind, the lack of effective data collection, data management, data analysis and forecasting norms and the lack of such technology has become an obstacle on the path of economic development of real estate;In our province, restricted by economic condition, the technique of updating and the lag of related information construction is more obvious. Associated with real estate at present, the most authoritative and comprehensive data is the basis of building management department also gradually improve the building up of "property rights property register management system" acquisition of data, the data itself is business requirements for the property management department management and collection, is not a feature of the real estate market data, cannot be directly used in the analysis.So, how to make full use of existing data environment of existing data resources for timely reporting of government decision making statistical and analytical results; how to get a long-term effective data analysis and automated processes, and can quickly adapt and in response to the future expansion of business data; how to dig in further analysis of the data accumulated, thus the formation of the real estate market monitoring and early warning and forecasting, etc, become analyze and understand the real estate market must be addressed.In this thesis, the above-mentioned case, the real estate registration data for analysis as samples, professional real estate by building a data warehouse, to complete the original registration data extraction, transformation and loading (ETL, Extract-Transform-Load); use of data warehouse tools to achieve data warehouse design and build, and on the basis of data warehouse analysis tool for real estate online analytical processing, data analysis and data simulation investigate instances of mining.