April 23, 2010, University of Virginia, Charlottesville, Virginia, USA

SIEDS'10 Paper Abstract


Paper FPM1Data.1

Reed, Sarah (Univ. of Virginia), Shapiro, Lance (Univ. of Virginia), Mayo, Theodore (Univ. of Virginia), Duty, Joseph (Univ. of Virginia), Na, Daniel (Univ. of Virginia), Conklin, James (Univ. of Virginia), Brown, Donald (Univ. of Virginia)

Implementing and Analyzing a Data Mart for the Arlington County Initiative to Manage Domestic Violence Offenders

Scheduled for presentation during the Regular session "Information Security" (FPM1Data), Friday, April 23, 2010, 13:15−13:45, Zehmer Conference Rm B

2010 IEEE Systems and Information Engineering Design Symposium, April 23, 2010, University of Virginia, Charlottesville, VA, USA

This information is tentative and subject to change. Compiled on March 5, 2015

Keywords data warehousing, information management


The Arlington Domestic Violence Information Collective (ADVIC) is a domestic violence (DV) data mart for the government of Arlington County, VA, combining law enforcement, court and human services databases into a single data repository. The goal of ADVIC in connecting these disparate data sources is to provide the ability to view and analyze DV victim and offender data across agencies, in addition to providing reports on any findings. Utilizing open source Business Intelligence (BI) tools such as the Pentaho BI Suite provides a robust yet cost-effective means for accomplishing this goal. ADVIC uses tools within Pentaho for the Extraction, Transformation, and Loading (ETL) of each data source to remove data inconsistencies, in addition to a reporting tool that presents summary and detailed reports. The design and implementation of ADVIC meets Arlington County’s strict confidentiality and security requirements.

By providing these reports to Arlington County, ADVIC hopes to provide insights that facilitate informed DV policy decisions and answer questions unsolved by the currently disconnected system. Members of Arlington County’s Project PEACE – Partnering to End Abuse in the Community for Everyone – can use ADVIC to create a demographic profile of DV, track victims and offenders throughout the criminal justice system, and critically examine the system to identify any shortcomings in policy or practice.



Technical Content © IEEE SIEDS.

This site is protected by copyright and trademark laws under US and International law.
All rights reserved. © 2002-2015 PaperCept, Inc.
Page generated 2015-03-05  02:19:12 PST  Terms of use