The Design And Implementation Of The Court Data Warehouse System

"The national judicial data aggregation and management platform for People's Courts" was built in 2013. By establishing data dynamically updating pattern of the national judicial data, integrating the national judicial information resources, and then building the national judicial trial information resource warehouse, this platform has achieved the goal of deeply analyzing and utilizing the national judicial information resources and providing information services for user when handling case or managing the court. The topic studies the design of the platform and the construction of aggregation data warehouse systems.The main work of the thesis includes:1, Analyze the system objective, functional and non-functional requirements of the court data warehouse. According to the data warehouse technology and system architecture technology, determine the system architecture, research program.2, Design court unified data view, hierarchical data warehouse concept model, multi-dimensional OLAP analysis model, the main data model and system logic structure by analyzing the data source of the court application system. According to Impala characteristics, design system deployment and software modification program.3, To carry out the work of data collection, data warehouse, the performance test of the column storage database and data service.4, On the basis of research results, inductive effect of court data warehouse system. Test and optimize the performance of autonomous control system, summarize the value of the project.The data warehouse system needs to meet the cost control requirements, as well as operational performance requirements. When designing the system, the open source impala is selected as a analytical database for the platform to design data warehouse model, data mart model and ETL procedures, by studying the properties of the column databases as SybaseIQ, MonetDB, Kingbase and Impala. The data warehouse system performance has been validated when the platform has been put into operation.The platform has a significant demonstration effect for building court intelligence analysis projects. open source software program has effect on reducing reliance on foreign software, accelerating the court construction of information under the background of ruling the Country by law. The output of the topic research is the data analysis product of independent intellectual property rights and the big data solution for court which including BI, data warehousing, ETL technology.