Research On Database Semantic Discovery Method Of Web Application

In recent years, with the rapid development of the Internet technology and the continually expanding and changing of the business, the database-centric web application has been used in wider area. But owning to the lack of description of the documents, the earlier developed database systems were becoming legacy systems. Without the understanding of the the systems's data semantics, it will take a high costs to maintain and update it. Thus, the discovery of the semantics of the database is very meaningful for the maintenance and integration of the database system. In fact, the information extracted from the Web application usually some semantics of the legacy databases in a specific application field, and the discovery of these semantics is important to the database maintenance and data integration. However, there haven't had any reaserch that trying to to find the field semantics by analysing the database-centric web applications.To solve this problem, a novel and versatile model has been proposed to discover the database fields semantic in the database-centric web application. The method started with analysing the HTML code on the web page to extract control names and its description by using web information extraction technology, and then analyzed the source code in a syntax way to creat an abstract grammar tree by using program understanding technology. With the grammer tree been traversed, we extract and analysis the SQL code and the assignment statement to discover the relations between the database fields and the control names in the database, therefore the semantic information of the fields can be found indirectly.Finally, the proposed method was validated by experiments, achieved the expected effect, verified the method is correct and effective, and the future direction of further research and improvement was also discussed.