Font Size: a A A

The Design And Implementation Of Railway Transportation Income Comprehensive Analysis System

Posted on:2019-04-30Degree:MasterType:Thesis
Country:ChinaCandidate:K ZhangFull Text:PDF
GTID:2428330566976288Subject:Computer technology
Abstract/Summary:PDF Full Text Request
As the rapid development of high-speed railway in our country,higher requirements are attached to the informatization of high-speed railway.The correspondence information network of the railway is in the tendency towards a digital and mobile multimedia and broadband access.Conditions of all sides are pushing the application of Internet on the railway transport companies.At the same time,railway transport companies are also under the heavy pressure of operating.With the traffic volume of different goods increasingly shrinking,the revenue budget has deficits continuously.Focusing on the characteristic of railway transport companies,tables and figures are used to put those data in order so that they could be analyzed and studied conveniently.The table,which could count those business data information according to the actual requirement of business users,could also demonstrate them in a comparatively reliable and safer approach to business users.Besides,it could also help companies to understand the present state of operating,so as to be of great importance in guiding the companies ' invests of various aspects.Figures like histograms could help the business users observe business data information more intuitively.At the same time,they could also enable the business users to analyze the companies' operating states more profoundly.Based on the research of different domestic and foreign reporting systems,this paper combines the actual project experience.A set of comprehensive analysis system about the transportation revenue of the railway administration based on the B/S model is developed,through field investigation and interviews and with some domestic and foreign similar revenue information analyzing systems as references.In accordance with the actual needs of business users,the system is divided into three sub-systems via analyzing of current business data information.Three sub-systems are the sub-system of data source,the sub-system of report designs and report shows and the sub-system of back-stage management,respectively.The Extract-Transform-Load(ETL)technology is performed to extract,clean,transform and recombine the present business datainformation within these sub-systems of data source.At last,these business data information is added into the database of this system so that they could be used conveniently when needed.The Oracle BIEE smart platform and SQL statement are employed to reconstitute and integratedly process these information conserved within the database.And a corresponding data cube according to business users' requirements is also built.Using the popular J2 EE framework and the layered architecture applied in Web,the design of this system improves the efficiency of developing.With the help of FineReport template designer,the processed data information is presented more beautifully.After the requirement analyzing and summarizing of the whole system,the whole design,the database design,the safety design and the detailed design of this system are all be analyzed one by one.Besides,careful discussion of each sub-system and the whole test of the system focusing on the business requirements are undergone.This system breaks through the design model of traditional application systems.Combing the actual application system,it not only could satisfy business users' actual needs,but also could fulfill the requirement of system usability and extendibility.Therefore,it could mix and gather the business data information to make data analyzing easy for business personnel so that them can grasp the market trend efficiently and to offer new thoughts and directions for the development of the informatization of railway transportation.
Keywords/Search Tags:transportation revenue, Report, ETL technology, B/S Architecture, Oracle BIEE
PDF Full Text Request
Related items