Research And Application Of The Web Database And Data Warehouse

As a communication age has come, Internet is continuously changing people's work and life. We can get a lot of information conveniently and quickly by web. With the fast development of Internet's application, the key of Web node design is that the information of web must be time-effective aad be exchanged between both sides. So with the appearance and development of the technology of Internet/Intranet and web, in order to optimize management more and more enterprises have issued their dynamic information at real time by establishing Internet sites and have established Intranet inside to integrate and share all the information.Data warehouse is a technology that appeared and has got a fast development in recent years. It makes the best of the information that has been stored and helps decision-makers to make a wise decision. So enterprises can take an earlier advance than others in the vehement market competition.Data cleaning is the process that is done by data warehouse created to guarantee the integrality of data. The difference of data sources brings the result that data warehouse is easy to have some "dirty" and " unstable" data. For enterprises it is worse to have a data warehouse that has error information than to have no data warehouse. The procedures of data cleaning are cleaning before integrating, cleaning after integrating and extracting after integrating. Through an example - the design and implementation of data cleaning system(DCS), the great significance of data warehouse technology in Manage and Information System is demonstrated from the application point of view and the actual function in real life is introduced.In this paper the data query and information issuing system based on Web Database, in which the technology of ASP and Oracle database is applied, is introduced. And its design, implementation and examples are showed as well. In this system Browser/Server structure is applied in order that the client can dynamically access database information by browsers and perform the function of information issuing and query by the method of full-browser, in which ASP technology accesses databases by Oracle Objects for OLE of Oracle database to issue enterprise's information dynamically and mutually. It is proved that this system has the advantages of high security and stability and easy-operation.