NEWSLETTERS
 

CIO.com updates, insights and advice on technology, management and your career.

 CIO BlackBerry News and Tips
 CIO Research and Analysis
 CIO Microsoft
 CIO Insider
 
 
 
SUBSCRIBE TO CIO
 
Are you involved in setting the direction for your company's IT budget or strategy?

Apply today for a FREE subscription to CIO Magazine!

 


Tue, Jun 12, 2007 9:53 EDT

How One CIO Performed Database Magic in 6 Weeks

Topic: Development

Blog: Inside Tech

Current Rating: 5 Comments: 6

Alec Palmer, CIO for the Federal Election Commission had a clear mandate from his business side: Our database presentation tool doesn't serve the public well. Fix it. And he did, in-house, with no extra staff, for $12,000, in 6 weeks, using a map-based tool from Corda. Doesn’t fit your existing perception of government IT? Maybe you can learn a few things from his approach. And thanks to his project, any citizen can now learn who's funding what presidential campaigns -- much easier than was previously possible. The new interactive tool launches publicly today, take a peek here.

The FEC administers U.S. law regarding campaign funding, including limits and rules regarding donations by individuals, political action committees, and campaign groups. It also shares the relevant campaign funding data regarding presidential and congressional campaigns with the public. Prior to this effort, the FEC already had a database of donation data online, but it wasn't pretty, says Palmer. If you wanted to do research, "you could do it but it took many, many steps," he says.

The revamped database tool achieves a goal that many CIOs would like to emulate: Take key data for business side or external customers and present it in an attractive, useful way on the Web. The new database tool lets you click on a map of the United States to drill down on presidential campaign contributions by candidate name, state, or even zip code. You can sort the data in numerous intuitive ways.

So if, for example, you want to research how Rudy Giuliani's contributions are stacking up against Mitt Romney's in your home zip code, this tool is just the ticket. It's also a good choice if, say, you want to see who your town's mayor is supporting financially. All the data cuts and pastes to Excel. (Previously, all you would have had available was a list of contributors for each candidate, in alphabetical order, but not sortable by geography.)

In the late summer or early fall, the FEC will roll out a second tool, using the same technology, with congressional election funding data.

What's interesting about this project? It's not data that's been buried. Several public interest groups, namely the Center for Responsive Politics are tracking 2008 presidential campaign dollars. Also, the New York Times has a similar campaign funding map, (coincidentally, built using

You do not have flash or javascript support.
Average (4 votes)
5
 
 
Thu, Jun 14, 2007 9:19 EDT
Anonymous user
Posted by: Anonymous
Rating:

Very nicely done. What a great example of how a project should be handled.

 
Thu, Jun 14, 2007 11:12 EDT
Anonymous user
Posted by: Anonymous
Rating:

Who fixed it? Palmer, or his staff...

 
Wed, Jun 27, 2007 18:47 EDT
Anonymous user
Posted by: Anonymous
Rating:

Does it really matter? Either way they got it done under either his direction and/or his concept.

 
Fri, Jun 15, 2007 11:32 EDT
Anonymous user
Posted by: Anonymous
Rating:

A great example of teamwork with the leadership of a CIO supported by a technical team, executive sponorship and expert business users. This is how projects should work.

 
Fri, Jun 15, 2007 11:34 EDT
Anonymous user
Posted by: Anonymous
Rating:

I agree, but very hard to do in a government environment

Post new comment

* Subject:
* Username:
* E-mail:
The content of this field is kept private and will not be shown publicly.
Homepage:
* Body:
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <strike> <p> <br>
  • Lines and paragraphs break automatically.
More information about formatting options

* Denotes required field.

About this Blog

Keeping a watchful eye on the technology trends and products that can make your life easier--or oh-so-much more difficult.

Start a Conversation
Click to post

Got something to say? We want to hear it! Click the Post button to get started. GO»

EXPERT ADVICE
See our roster of experts.

Advice & Opinion from more than 113 of IT's most insightful thinkers.

  PARTNERS       WEBCASTS    
 

Windows 7 Webcast Series

There's a lot of buzz about Windows 7 out there. Each month in our webcast series, listen to analysts and customers discuss how Windows 7 and the Windows Optimized Desktop is impacting large companies around the world. Learn how they evaluated Windows 7, including the cost of deployment, deployment strategies, and tangible benefits.

Sponsored by Microsoft  Listen to on-demand Recordings »

 

Service Level Management Best Practices Life Cycle Overview - Improve Service Levels

Best practices for Service Level Management (SLM) is a process for consistently meeting customer requirements and delivering on IT's promises. See the steps required to ensure high-quality SLM.

Sponsored by Compuware  Read this White Paper »

 

Keeping Your Members Safe from Online Scams and Predators

In order to keep fraudsters out, romance sites must deploy effective solutions that look at information independent of what is supplied by users. A device fingerprinting solution such as iovation ReputationManager™ provides unique insight into the computers being used to create multiple accounts and exposes hidden device-account relationships that identity-based fraud solutions often miss.

Sponsored by iovation  Read this White Paper »

Resource Alerts

Get instant email notifications by topic when white papers, webcasts, and case studies are added to our library.

Resource Alerts

Get instant email notification when white papers, webcasts, and case studies are added to our library. Don't just be up-to-date—be up to the minute with our new Resource Alerts.

Defend Against Blended Threats: What You Need to Know

Blended Web and email threats are becoming increasingly complex and represent a huge...  View Now »

 

Prescriptive Actions to Reduce Risk

In this Webcast, learn best practices for effective systems management in a heterogeneous environment and keep client systems cost under control.   View Now »

 

Webcast- Vantage 11: Redefining Application Performance Management

Compuware's latest release, Vantage 11, is a major advance in end-to-end application performance management--bringing together proactive issue identification, quantification of business impact and problem resolution into a single solution. Tune in to learn how Vantage 11's top-down approach helps you make better decisions and dramatically lower operations costs.  View Now »

Resource Alerts

Get instant email notification when white papers, webcasts, and case studies are added to our library. Don't just be up-to-date—be up to the minute with our new Resource Alerts.

 
NEWSLETTER

Sign-up for the Blogs & Discussion Newsletter

 
FEATURED SPONSORS
 
 
 
SPONSORED LINKS
 

Return on Information: Google Enterprise Search pays you back. Get the facts.

VMware. The source for Business Infrastructure Virtualization.

ShoreTel tells businesses to untangle from competitors' complexity and turn to its brilliantly simple UC solution

See how AT&T can help protect your network.

Streamline IT Costs. Boost Performance with WAN Optimization.

Build your 1st app FREE with Force.com

TDWI checklist helps define data readiness for analytics. Download report.

A Clear View Toward Virtualization

Virtualization Technology as a Business Solution

The rules of infrastructure management just changed.

A Clear View Toward Virtualization

Interactive Q&A helps you discover key ways to maximize IT assets.

Ready to virtualize tier one applications? Check your virtualization maturity.

Think you can't afford a Cisco Switch? Cisco Catalyst Switches are now more affordable.

Five minute business analytics assessment. Immediate results.

The Case for Investing in Business Analytics Technology. Read white paper.

Upgrading to VMware vSphere with vWire

Top 10 Lessons Learned for Corporate 3G Mobile Broadband Deployments

CRM Built for IT: The Executive Guide to Selecting CRM that Meets IT Needs

Return on Information: Google Enterprise Search pays you back

ROI of Application Delivery Controllers

Making Consumer Two-Factor Authentication Simple and Cost-Effective

Mining the Cloud to Ease the Enterprise Compliance Burden

Solve Five Key IT Security Challenges with Cloud-Based Authentication

White Paper: Right-Sizing Your Power Infrastructure

AT&T Synaptic Storage as a Service. Expand on demand

Trend Micro ranked #1 against real-world malware. Read more.

Webinar: Jump-start your in-house e-discovery with Ringtail QuickCull from FTI Technology

Top Five CIO Challenges

Read the RSA report: Security for Business Innovation

64-page prescriptive guide to security, compliance, and IT operations.

Increase UPS efficiency without sacrificing protection.

eZine: A Roadmap to Reducing IT Complexity

Reduce risk, gain agility. See how Progress can help your business.

Virtualization Technology as a Business Solution

eZine: A Roadmap to Reducing IT Complexity

World-class trading technology solutions from NYSE Technologies.

If You're Paying for Telecom, You're Paying Too Much. Contact Asentinel Today.

Trade-In your old printer and save up to $1,000 plus free recycling!

infoBOOM! - The Mid-Sized Company CIO's Exclusive Community

Live Webinar: Applying Business Analytics. Click here to learn more

Removing Barriers To Better Server Virtualization Efficiency

4G Revisited. The Continued Evolution of Wireless Mobility.

What's Next for Enterprise Resource Planning?

Maximizing website Return on Information with high-quality search

Gartner Magic Quadrant, Application Delivery Controllers 2009

Authentication as a Service by Forrester Research

Cloud-Based Authentication for Next-Generation Extranets

Cut Costs & Green Your IT Operations with PC Power Management

White Paper: 4 Customer Service Myths