Dissertation > Excellent graduate degree dissertation topics show

Research and Application on Judgement and Analysis Platform of Dalian Police Based on Data Warehouse

Author: WangXiong
Tutor: WangXiuKun
School: Dalian University of Technology
Course: Computer Software and Theory
Keywords: Police Analysis Police Judgement Data Warehouse
CLC: TP311.13
Type: Master's thesis
Year: 2008
Downloads: 144
Quote: 1
Read: Download Dissertation

Abstract


Recent years, police have already established their own information systems respectively, but due to the lack of unified planning, these systems applied different platforms, technologies and databases, therefore, "Information islands" formed. These systems are unable to connect with each other, which results in poor flow of information and bad information-sharing, consequently we can not control the situation throughout the Dalian Police as a whole. Such situation has affected the efficiency of Police, as well as the use of historical information. Thereby a judgement and analysis platform is much needed to solve these problems.This article analyses the difficulties and challenges deeply that Dalian Polic faces at first. Then it puts forward the necessity to build the judgement and analysis based on data warehouse for Dalian Police. Secondly, on the basis of in-depth study of data warehouse and police judgement and analysis platform technology, it gives a detailed analysis and design for Dalian police judgement and analysis platform data warehouse model. Conbined with day-to-day police work, it gives the data warehouse model which is divided into five themes (people, cases, things, geography, institutions) on the actual demand by present departments. At the same time it analyses and designs the division of size, data extraction, transformation and loading (ETL) in detail. Finally, it makes use of IBM data warehouse development tool DWE to model the data warehouse. The original data sources of police judgement and analysis platform data warehouse are ORACLE, DB2, SQL SERVER three types.In particular,it does a research on ORACLE data source and put fowards a DELTA extraction algorithm based on ORACLE snapshot log which resolves the problem extracting DELTA from extranet.It points out the algorithm’s advantages and disadvantages by experiment.The platform eliminates the original "information islands". It gives a good solution to the integration and data sharing of distribution heterogeneous databases, and significantly improves the police efficiency. At the same time, the data warehouse layes the foundation for the police using existing information to support decision-making and data mining ,also gets preparations to provide information and services for other political and legal organs, government departments and society organs in technology and data.

Related Dissertations

  1. Data warehouse technology in the banking customer management systems research and implementation,TP315
  2. CCB Sichuan SMS platform to optimize the design and implementation of data warehouse,TP311.13
  3. Applied Research of Data Warehouse, OLAP and Data Mining in Business Intelligence,TP311.13
  4. Research and Application of the Partition Technology in Real-Time Data Warehouse,TP311.13
  5. The Design and Practice of Integrated Data Warehouse Platform for Shanghai Unicom CO.,TP311.13
  6. The Study of Two-way Referral Management Information System Based on Social Insurance Management Information System Platform,D632.1
  7. The Study of Power Customer Classification Based on Data Mining,F426.61
  8. Research and Implementation of Data Cleansing Framework Based on Component,TP311.13
  9. OLAP applications in the northern commercial buildings sales management,TP315
  10. Research and Realization of Decision Support System for Enrollment Management,TP311.52
  11. Flight delays DSS based on data mining technology,TP311.13
  12. The creation of tax data warehouse and OLAP systems research,TP311.13
  13. The Design and Implementation of the Tianjin Port DSS Platform,TP311.52
  14. Research and Design of Data Warehouse System in Secutities Company,TP311.13
  15. Oriented data integration and analysis of defects in the semiconductor manufacturing process,TN305
  16. Telecommunications based on data warehouse design and implementation of management analysis system,TP311.52
  17. Based on Data Warehouse Management System NCMS,TP311.13
  18. Based on statistical process diagram automatic query optimization technology accumulation table,TP311.13
  19. Research and Realization of Auto Sale Decision Support System Based on ASP Industry Chain Collaboration Platform,F426.471
  20. XXX system design and implementation of data warehouse,TP311.13
  21. Research and Realization of Power Financial Forecast System Based on Business Intelligence,TP18

CLC: > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Programming > Database theory and systems
© 2012 www.DissertationTopic.Net  Mobile