Design and Implementation of ETL in Police Intelligence Data Warehouse System

Liang Zhong Shen; Shi Hua Liu; Sheng Kai Chen

doi:10.4028/www.scientific.net/AMM.121-126.3865

Paper Titles

Comment on Xu et al.'s Key Agreement and Password Authentication Protocol
p.3847

Error Compensation Method of Harmonic Analysis for Time Grating Sensor
p.3850

Controller Design for Petri Net with Uncontrollable and Unobservable Transitions
p.3855

Correlogram-Based Perceptual Similarity in Vehicle Probabilistic Tracking
p.3860

Design and Implementation of ETL in Police Intelligence Data Warehouse System
p.3865

A New Method of Product Configuration for Customization System into Supply Chain
p.3870

Design of MOD-CAN Interface Card Based on OPC Technology
p.3875

Design of Test Software for the CAN/LIN Hybrid Network Automobile Body Control System
p.3880

Design of Rapid Positioning Multi-Axis and Multi-Blade Saw Machine
p.3885

HomeApplied Mechanics and MaterialsApplied Mechanics and Materials Vols. 121-126Design and Implementation of ETL in Police...

Design and Implementation of ETL in Police Intelligence Data Warehouse System

Abstract:

In the light of Information Island phenomenon existing in the current police system and inadequate excavation of data, this paper advances the necessity of establishing police intelligence data warehouse system. Vs.net 2008 and SQL Server 2008 are used to design and implement the police intelligence data warehouse system, and more over probes deeply into the technology of ETL.

You might also be interested in these eBooks

Frontiers of Manufacturing and Design Science II

View Preview

Info:

Periodical:

Applied Mechanics and Materials (Volumes 121-126)

Pages:

3865-3869

DOI:

https://doi.org/10.4028/www.scientific.net/AMM.121-126.3865

Citation:

Cite this paper

Online since:

October 2011

Authors:

Liang Zhong Shen, Shi Hua Liu, Sheng Kai Chen

Keywords:

Data Warehouse (DW), ETL, Police Intelligence System

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] Yuanqi Wei, Xing Wang, Xiaoqin Hu. ETL and its application in Unionpay project [J] Software Guide 2008(11), P: 30-31.

Google Scholar

[2] Xufeng Zhang, Weiwei Sun, WeiWang. Generating incremental ETL processes automatically Proceedings of the first international multi-symposiums on computer and computational Sciences, Washington, 2006: 516-521.

DOI: 10.1109/imsccs.2006.229

Google Scholar

[3] Yun Zhang. ETL Processing in Data Warehouse Project[J]. Computer System Application, 2005(08), P: 77-79.

Google Scholar

[4] Hao Dai, Bo Yang. Researches on mechanics of incremental data extraction in ETL[J]. Computer Engineering and Design. 2009(23) P: 5552-5555.

Google Scholar