Free Newsletters
InfoWorld Daily

InfoWorld
Log-in | Register

Allegheny County maps data to an array of services

MAYA Designs helps liberate reams of data to create communities around shared information

By Dan Tynan
November 13, 2006
 

It takes more than technology to make some tech projects succeed. It requires diplomacy, dedication, perseverance, a willingness to embrace change, and the vision to come up with new ways to solve old problems.

Free IT resource

Virtualization Insights from Top Experts - Learn how virtualization gets real!

Sponsored by Dell

Free IT resource

TechNet: More ways to know it, share it, and keep it running.

Sponsored by Microsoft

2006 InfoWorld 100 Winners


DOWNLOAD PDF

2006 InfoWorld 100 Awards
(Registration required)


When the Allegheny County Department of Human Services teamed with MAYA Design in June 2004, it hoped to create a data warehouse for the thousands of service providers in the Pittsburgh metro area. But they ended up creating something much bigger: a new model for building communities around information.

HumanServices.net is a gateway to an “Information Commons” -- a distributed database that brings together a wide range of information and data types into a single, easily searchable repository. The site contains detailed profiles of everything from daycare centers and drug counselors to free clinics and food banks, along with photographs, maps, directions, and even the nearest bus routes. The site has changed how case workers do their jobs, says John Pierce, who directs the office of information management at the Allegheny DHS. In the past, a case worker might spend three or four hours calling agencies to find out if they offered certain services needed in a particular neighborhood.

“Now they go online and do it in minutes, and they can look up all the agencies in that neighborhood, not just the few they might already know about,” Pierce says.

Best of all, the department did it without spending a dime of taxpayer money. Pierce says the project has cost $750,000 so far, all provided by more than a dozen Pittsburgh-area foundations.

Building the Commons required breaking down deeply entrenched information silos, both technological and bureaucratic. In fact, the technology was probably the easiest part, says Josh Knauer, MAYA’s director of advanced development.

To extract data stored in Oracle and FoxPro databases, Excel spreadsheets, and the like, MAYA used a universal format it invented called the u-form. Each u-form consists of a small unit of data -- such as one row in a relational database -- along with attributes such as the data’s source, the set it belongs to, and any digital signatures or intellectual property rights associated with it.

MAYA uses XML and SOAP to pull u-forms from each source, then distributes the database on a peer-to-peer network co-hosted by each major stakeholder -- such as the Allegheny DHS, the local chapter of the United Way, and A+ Schools, an educational advocacy group -- all of which offer their own customized gateways to the Commons.

But the biggest hurdles were political and practical, not technical. For example, no agency wanted to cede control over its data or its tools, Pierce notes. In MAYA’s scheme, they don’t have to. Each agency updates information using its existing database tools; the Commons then extracts the data in the background. It turned out to be a cheaper route, Knauer says. “Using a distributed data infrastructure, where everyone in the Commons participates in creating, editing, and updating the information, is a heck of a lot less expensive than having one central server and one organization managing all the data,” he says.

The key to making it all work was having 3 Rivers Connect manage the project, Knauer says. 3rc also hosts DHS’s database and performs day-to-day maintenance.

MAYA is helping communities from Washington state to Vermont develop similar data repositories.

The public is also invited to participate in the Commons. Each profile on Humanservices.net features a comments field where individuals can update or correct information.

“We actually get a smile on our face when see corrections happen,” Knauer says. “The fact is, no one can guarantee data quality. The point of the Commons is that’s it all out in open.”

2006 INFOWORLD 100 WINNERS
Top 10 Finalists
Computing/Tech                                            Distribution/Supply Chain
Education                                                       Financial Services
Government                                                   Health Care
Insurance                                                        Manufacturing
Media/Multimedia                                         Pharmaceuticals
Retail                                                              Services
Sports                                                             Telecommunications
Transportation                                               Unspecified





 


 
Dan Tynan is a technojournalist based in North Carolina and the author of Computer Privacy Annoyances (O'Reilly, 2005).
 

TOP NEWS:


»  Four quick tips for choosing an IM security product
71 percent of businesses will invest in real-time messaging this year. If you're one of them, be sure to protect your enterprise

»  Forrester analysts ID hot IT jobs
Research group finds 16 IT roles with a promising future

»  Nvidia claims 10 hours of HD video on Tegra chip
The Tegra 600 and 650 can be used with hard disk drives and are designed partly for mobile Internet devices

»  Database vendors add Google's MapReduce
Greenplum and Aster Data Systems will support Google's programming technique, developed for parallel processing of large data sets across commodity hardware

»  Network management: Tips for managing costs
New technologies, changing requirements, and ongoing equipment maintenance and upgrades cost money, but there are ways to manage expenses

»  EMC targets SMBs, branch offices with new low-end storage
Celerra NX4 highlights include thin provisioning, snapshot technology for data recovery and backups, and Web-based console for management of storage volumes




REMOTE ACCESS: MAINTAIN SECURITY AND DECREASE THE BURDEN ON IT
Join this interactive webcast to discover how IT Managers can control access rights, end-user security settings and end-point authorization. Sponsor: Citrix(R) GoToMyPC(R) Corporate

»  Click here to view this Webcast
  Planning For A Disaster
This new, comprehensive Solutions Guide is your one stop source for Disaster Recovery. In it you'll learn how to reduce the likelihood of a disaster and to create a rock solid business continuity plan should you face a disaster situation. Sponsored by Equallogic

»  Click here to download now

- Special Advertising Partners -
WHITE PAPERS
 

» Technology White Papers Library

Technology White Papers by Topic

Technology White Papers E-mail Alert

Find out when the latest white paper is available:
 
 
INFOWORLD MARKETPLACE
 
» BUY A LINK NOW
 

FIND PRODUCTS AND COMPANIES
» COMPLETE PRODUCT GUIDE



TECHNOLOGY INDEX
• Applications
• Application Development
• Security
• Networking
• Wireless
• Platforms
• Hardware
• Data Management
• Storage
• Web Services
• Business
• Telecom
• Professional Services
• Standards

TECH WATCH 


What's the 411 on GOOG-411?
Just as Google has become synonymous with "performing a Web search," 411 is understood to mean "information" -- as in "what's the 411?" I was thus surprised to discover, from a billboard, no less, that the king of search is taking on the ...

Apple HTML source reveals 'iPhone Extreme'
"This one's a stretch..." reports AppleInsider. Um, yeah. Reporting on HTML code sightings of product names could be called a stretch, but iPhone Extreme has a ring to it. Now, that sounds like the product Apple should have released first, rather ...

COLUMNISTS

Unified under law
Ephraim Schwartz's Column and Blog (InfoWorld) - In the litigious world we live in, deploying a unified communications platform in your enterprise could...
» MORE COLUMNISTS

MORE INFOWORLD BLOGS


Open Sources 
Product Management
When I joined MySQL four years ago, there was quite a lot of debate about product management. We didn't actually have ...

Zero Day 
Botnet herders tending smaller flocks
New research backs up the theory that botnet operators are keeping their networks smaller in a continued effort to keep ...



• Advice Line
• Database Underground
• The Deep End
• Enterprise Mac
• Geeks in Paradise
• Grid Meter
• The Gripe Line
• InfoWorld Daily
• Inside IT
• IT Troubleshooter
• ITXtreme
• Open Sources
• ProdBlog
• Real World SOA
• Reality Check
• Security Adviser
• SMB IT
• The Storage Network
• Tech Watch
• Virtualization Report
• Zero Day

ADVERTISEMENT


RESOURCE CENTERadvertisement 

GOVERNMENT IT & POLICY
'If you don't go after the network, you're never going to stop these guys. Never.'
From the State Department, All the News for Inquiring Minds
TechPresident, the Internet Citizenry's New Consensus Taker



Sponsored Technology Links

 
 
 HOME  NEWS  BLOGS  PODCASTS  VIDEOS  TECHNOLOGIES  TEST CENTER  EVENTS  CAREERS   About | Advertise | Awards | RSS | Contact Us 

Copyright © 2008, Reprints, Permissions, Licensing, IDG Network, Privacy Policy, Terms of Service.
All Rights reserved. InfoWorld is a leading publisher of technology information and product reviews on topics including viruses,
phishing, worms, firewalls, security, servers, storage, networking, wireless, databases, and web services.

CIO :: ComputerWorld :: CSO :: Demo :: GamePro :: Games.net :: IDG Connect :: IDG World Expo
Industry Standard :: IT World :: JavaWorld :: LinuxWorld :: MacUser :: Macworld :: Network World :: PC World :: Playlist