| These years,with the development of computer networks,an increasing number of government departments start to implement e-government.To the prosecution system, "Power the prosecution by technology" is one of the six major objectives proposed by The Supreme People's Procuratorate.And Internet is an important element of "Power the prosecution by technology".At present,the informationization construction has been started in various parts of the country.Many procuratorates have already built LAN,which means that hardware foundation was ready.But lacking of an efficient management information system is the major problem.Jinan suburb procuratorate is a basic procuratorate which has specially and complex business.The author designed and implemented the "Jinan Suburb Procuratorate Management Information System".The system includes information management subsystem and data mining subsystem.Information management subsystem includes the measures management,case management,room management including all aspects of the job of procuratorate.The system makes staff's work much easier,at the same time,make the information translated much faster.After a long use of the system,a lot of data was stored in the database.How to effectively use these historical data to excavated useful knowledge is a major problem.So,the author designed and implemented the data mining subsystem.Facing different needs,the system use different excavation techniques,including association, clustering,time series and so on.The implementation of data mining relies on Microsoft SQL Server 2005 Data Mining tools.The system used SQL Server Management Studio and DMX. The practice has proved that the results of data mining were very useful for our work.We first analyze background of the informationization construction in prosecution,and then introduce.NET and ETL.At last,we will talk about the information management subsystem and data mining subsystem in detail.About the information management subsystem,we will to find out the needs of every model.In the design stage,we will give out the detailed design of each sub-module and business flow,and at last,we will talk about the implement of this subsystem using some pictures and source code.About the data mining subsystem,we will talk about why data mining,and setup the aims of data mining,and then give out some common technique about data mining,especially the association.We will go into the theory of Apriori algorithm,which is a classic solution for association.At last,we will use SQL Server Management Studio provided by SQL Server 2005 to excavation useful knowledge of the criminal's information in the database,and give a brief introduction about DMX. |