Query The Com-based Statements Of Universal Implementation Of The Component

The statistics function of report is one of the most essential and important requirement of the information system for the most part. But the complexities of report format and query sentence lower the development efficiency of report software. At the same time, the modification of database and the continuous alternative of user's demands restrict the development of MIS. So it's urgent to solve the problem how to develop report software more quickly and make it reusable.Query demand varies with different operation range, thus query function must be general and flexible. Accordingly, one kind of object-oriented design model and an implement method of general query component are introduced in the thesis. The component can be applied not only in Finance and Revenue Interlink, but also in other relational database system. In the realization of the component, data processing module is isolated from data describing module in architecture but combined with it in function, which makes query processing transparent and data processing module general. Data processing module can meet various query demand according to various interface information, thus form an enclosed entity logically combined with corresponding data describing module. Furthermore query optimization makes up the losing speed in data processing module to improve query speed and meet query demand.This component solves the problem arising from different data sources and changed report formats. Moreover it can meet the demand of the extensibility, flexibility and ease of use and maintainability. As a result, it improves the development efficiency of information system.