The FBI could learn a thing or two about using corporate world technology in their quest for data management!
D. NYPD Launches Third Phase Of Data Warehouse Project By: Eric Lai - Monday, September 4th, 2006 'Computerworld' / Framingham, MA http://www.computerworld.com/action/article.do?command=viewArticleBasic <http://www.computerworld.com/action/article.do?command=viewArticleBasic&tax onomyName=data_mining&articleId=9002968&taxonomyId=54> &taxonomyName=data_mining&articleId=9002968&taxonomyId=54 The New York City Police Department is launching a third update of a massive data warehouse that officials hope will one day become a hub for data from dozens of area law enforcement agencies. Officials said that when the latest update is completed, the warehouse will add real-time alerts and links to several new data sources while boosting capacity from 80GB to about 400GB. The next update of the IBM DB2-based data warehouse will also add a link for the first time to the department's 12-year-old Computerized Statistics crime-mapping tool, known as CompStat. City CIO James Onalfo said the city has spent $300 million over the past three years on the technology. "We're in a war, so we need to give our guys in the front lines the best tools possible," he said. Those tools include the Real-Time Crime Center, a centralized help desk tasked with quickly providing data to the NYPD's 8,000 detectives. The tool has used the data warehouse since both were first unveiled in June 2005. The first phase of the data warehouse project, overseen by IBM Global Services, included loading records of complaints, arrests, criminal summons, shootings, homicides and other incidents from 2003 and beyond into the warehouse's IBM DB2 database, according to Christine Tyler, an associate partner in the public-sector practice at IBM Global Services. The second phase of the data warehouse project brought in complaint records dating back to 1995 and arrest data going back to 1990, Tyler said. "Now we can look at things like a silver gun, or a name on a tattoo, or search for a person's name," Onalfo said. The data wasn't easy to import, noted Tyler. Many of the NYPD's 55 department data-bases use older formats such as FoxPro, VSAM or Adabas. The third phase of the project, which is about to commence, calls for linking the data warehouse to additional data sources from within the department and to sources from outside agencies. It also marks the first use of Informatica Corp.'s PowerCenter data integration tools, which replace homegrown Cobol-based tools. "We won't initially save time [using the new integration technology], but our investment is reusable, so it will lower future development costs," Tyler said. The department expects the Informatica tools to help load data from various sources, such as the fingerprint databases run by the state of New York and the FBI, which could reduce the time it takes to match people's fingerprints from as long as three weeks to almost real time, Tyler said. James Kobielus, an analyst at Washington-based Current Analysis Inc., said that the drive for real-time response parallels the efforts of many Fortune 500 firms. To ensure no latency, however, he recommends that the department consider adding management and monitoring tools. Onalfo hopes that the data warehouse will someday serve as a central information hub for as many as 30 local government agencies, such as district attorney offices and neighboring police departments. [Non-text portions of this message have been removed] -------------------------- Want to discuss this topic? Head on over to our discussion list, [EMAIL PROTECTED] -------------------------- Brooks Isoldi, editor [EMAIL PROTECTED] http://www.intellnet.org Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] *** FAIR USE NOTICE. This message contains copyrighted material whose use has not been specifically authorized by the copyright owner. OSINT, as a part of The Intelligence Network, is making it available without profit to OSINT YahooGroups members who have expressed a prior interest in receiving the included information in their efforts to advance the understanding of intelligence and law enforcement organizations, their activities, methods, techniques, human rights, civil liberties, social justice and other intelligence related issues, for non-profit research and educational purposes only. We believe that this constitutes a 'fair use' of the copyrighted material as provided for in section 107 of the U.S. Copyright Law. If you wish to use this copyrighted material for purposes of your own that go beyond 'fair use,' you must obtain permission from the copyright owner. For more information go to: http://www.law.cornell.edu/uscode/17/107.shtml Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/osint/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
