Data organization and validation strategies

Creating standard data architectures is especially difficult for state and local governments that have been collecting information in various forms for decades or in some cases, even centuries, said Vivek Kundra, chief technology officer of the District of Columbia.
“A situation like that can’t be solved with a Big Bang approach,” he said.

Instead, governments need to first develop an electronic information infrastructure by scanning important paper documents and then organizing all digital information within a content management system.

The payoff for well-organized, electronic data comes when governments add a business intelligence layer, which can provide real-time trend summaries to potentially enhance public safety and improve customer service, Kundra said.

“If we have data on crime rates and on where police cruisers are positioned, we can look for correlations and mobilize officers based on real-time information,” he said. “Then government doesn’t have to be reactive anymore when something has gone wrong. We can get ahead of problems.”

One key to making data interoperable is to make certain employees enter data correctly into state records initially. Products are now available to match new address entries to U.S. Postal Service databases. Data-entry employees see whether they are capturing valid street names and numbers or whether an apartment number or other detail should be included for a particular location.

For example, QAS sells a search engine and a copy of the USPS Zip Plus 4 Product File, a database of nationwide delivery. The software doesn’t validate name and address combinations, so if a constituent intentionally provides a false address, the system typically won’t uncover it. But the application does scan address entries for accuracy and forces users to enter information in a consistent format specified by managers.

Data verification products can be one component of a larger architectural strategy, said Joel Curry, QAS’ chief operating officer. “When you have [accurate] data streaming in, it becomes easy to manipulate and mine it for greater benefits among different state departments.”

About the Author

Alan Joch is a freelance writer based in New Hampshire.

The Fed 100

Save the date for 28th annual Federal 100 Awards Gala.

Featured

  • computer network

    How Einstein changes the way government does business

    The Department of Commerce is revising its confidentiality agreement for statistical data survey respondents to reflect the fact that the Department of Homeland Security could see some of that data if it is captured by the Einstein system.

  • Defense Secretary Jim Mattis. Army photo by Monica King. Jan. 26, 2017.

    Mattis mulls consolidation in IT, cyber

    In a Feb. 17 memo, Defense Secretary Jim Mattis told senior leadership to establish teams to look for duplication across the armed services in business operations, including in IT and cybersecurity.

  • Image from Shutterstock.com

    DHS vague on rules for election aid, say states

    State election officials had more questions than answers after a Department of Homeland Security presentation on the designation of election systems as critical U.S. infrastructure.

  • Org Chart Stock Art - Shutterstock

    How the hiring freeze targets millennials

    The government desperately needs younger talent to replace an aging workforce, and experts say that a freeze on hiring doesn't help.

  • Shutterstock image: healthcare digital interface.

    VA moves ahead with homegrown scheduling IT

    The Department of Veterans Affairs will test an internally developed scheduling module at primary care sites nationwide to see if it's ready to service the entire agency.

  • Shutterstock images (honglouwawa & 0beron): Bitcoin image overlay replaced with a dollar sign on a hardware circuit.

    MGT Act poised for a comeback

    After missing in the last Congress, drafters of a bill to encourage cloud adoption are looking for a new plan.

Reader comments

Please post your comments here. Comments are moderated, so they may not appear immediately after submitting. We will not post comments that we consider abusive or off-topic.

Please type the letters/numbers you see above

More from 1105 Public Sector Media Group