Vector Model-based Report Generation System Design And Realization

Report is a kind of tool to demonstrate data. Reports generating system is the application software system to generate reports; usually the more mature and improved or commercial-oriented reports generating systems are called reporting tools. The understanding of the nature of reports are the following two ways-decision tool and controlling tool. The reporting tools designed under different understanding and purposes are quite different in their functions. The differentials are very obvious between "SQL" reporting tools and "CELL" reporting tools.The differential between the designs of reporting tools is mainly in the different usage of report data models. Data model is a set of rules of data processing, including basic data structure,the process of data relation, the transform of data,data acquisition, the relation of data and report form, the rule of display of data results. We can regard the rule of data processing as an independent data model, if it can be separated from other data models. Report data model is the core to describe and process the report data, and it is the link between the data source and the data demonstrated in the reports. One important contradiction in the reporting tool design is the efficiency of the report template designing and the universalism of complicated report forms, and report data model is a key to reconcile this contradiction.This paper presents a data model which based on the vector, using vector as basic data structures, transforming the data inquired from the database to the form of vector, and processes the relation between the vector, using statistic computing language S which based on vector and matrix and a GPL computing environment R which is an implement of S. Due to the convenient computing Characteristics of vector and matrix, we can expand the one-dimension situation to multi-dimension one, so it's very suitable to describe the complex relation between the data, and nearly all the mathematical and statistical model have matrix form algorithm. Utilizing the report data model based on vector, we can describe the application logic which commonly used in areas such as commercial analyzing (the standard of data analyzing is very high) in matrix language and set it in the reporting system directly. Because matrix languages, such as S, includes many statistical models in their inner system, we can conduct complicated data analyzing and processing without large amount of coding or third-party analysis software, and generate reports with high efficiency, resolving the complicated relation of the core process of generating process in which the data source transforms to the result. In the aspect of describing statistical model, matrix language is very concise and clear, and it can provide all kinds of powerful functions, so the reporting system based on vector has benign characteristics of expansion, and it can expand the complicated relation between data through self-defining functions.This paper provides the clear realization of a reports generating system based on vector model. This realization is based on VBA language environment, combining Excel as its final demonstration, to meets the needs of complicated report forms; and it connects R environment and VBA environment through the way of COM, to unify the complicated relation and complex form of demonstration. This reports generating system will have good results in practical application, and it have obvious advantages especially in those fields which involves complicated relation.