Intelligence Agencies’ Databases Set to Be Linked

January 23rd, 2009

Heterogeneous data structures. Spread out all over the place. HAHA. The article makes it sound like it’s actually going to work. I suppose anything is possible with enough billions of dollars.

I’ve seen some hilarious nonsense on IT projects in my day, but nothing like the antics in .gov/.mil circles. And if you’ve spent any time in IT, this will read like comedy gold. I’ll bold the parts that made me laugh.

Via: Wall Street Journal:

U.S. spy agencies’ sensitive data should soon be linked by Google-like search systems, nearly five years after the intelligence community was rebuked by the 9/11 Commission for failing to “connect the dots” and detect the attack.

Director of National Intelligence Mike McConnell has launched a sweeping technology program to knit together the thousands of databases across all 16 spy agencies. After years of bureaucratic snafus, intelligence analysts will be able to search through secret intelligence files the same way they can search public data on the Internet.

Mr. McConnell’s new technology program is also addressing a more basic problem: Spies often have trouble emailing colleagues in other U.S. intelligence agencies, because email addresses aren’t readily accessible, and messages sometimes get eaten by security filters. Mr. McConnell aims to solve that by uniting the agencies’ email systems into a single system with a full directory that links names, expertise and addresses.

Linking up the 16 agencies is the challenge at the heart of the job of director of national intelligence, created after 9/11. Dennis Blair, nominated by President Barack Obama to succeed Mr. McConnell, faces a confirmation hearing Thursday where senators are likely to ask how he will make agencies with different histories and missions work together.

The new information program also is designed to include Facebook-like social-networking programs and classified news feeds. It includes enhanced security measures to ensure that only appropriately cleared people can access the network. The price tag is expected to be in the billions of dollars, but much of that money will be reallocated from existing technology programs.

The impact for analysts, Mr. McConnell says, “will be staggering.” Not only will analysts have vastly more data to examine, potentially inaccurate intelligence will stand out more clearly, he said.

Today, an analyst’s query might scan only 5% of the total intelligence data in the U.S. government, said a senior intelligence official. Even when analysts find documents, they sometimes can’t read them without protracted negotiations to gain access. Under the new system, an analyst would likely search about 95% of the data, the official said.

Several similar efforts have been aborted in the past decade, because cultural divides couldn’t be bridged between rival agencies. Some of those efforts predated 9/11, and many intelligence agencies have botched their own technology programs since 2001.

Mr. McConnell’s team says this effort, called the Information Integration Program, has experienced officials working on it full-time and is designed to deliver tangible products every few months. “There really is a very different spirit about doing all these things than there was, I think, in the past,” said Prescott Winter, a senior National Security Agency official who is directing the program for Mr. McConnell.

The program is likely to get a review from Mr. Blair. The new administration is expected to make sure it is adequately funded, effective and protects privacy.

The initiative grew out of discussions more than a year ago between the Pentagon’s intelligence chief and Mr. McConnell’s top deputy, who were concerned that military and civilian intelligence data couldn’t be easily tapped. They asked the chief information officers at the six largest intelligence agencies to develop a solution.

Over the summer, the officers began to sketch out the technology and policy problems to be solved, including protecting sources and connecting systems at different levels of classification. They also assembled case studies, which showed that the typical analyst is using technology that is about a decade old, a senior intelligence official said.

In September, all 16 agencies agreed to the goal of creating one searchable data and email system, and Mr. McConnell borrowed Mr. Winter from the NSA to get the program under way.

The first stage of the initiative is to merge the email systems of the six largest intelligence agencies, including the Federal Bureau of Investigation, the Central Intelligence Agency and the NSA. Mr. Winter said that is on track to be largely completed by the end of the month. Then, they will expand to the other 10 agencies. By 2010, the intelligence agencies and the Pentagon would have a single email system.

With the Google-like system, intelligence officials would like to connect the bulk of the databases by the end of the year, though no firm date has been set. The system would search all intelligence data, and quickly determine which data an analyst is permitted to see. Someone focused on one corner of the world may be allowed to see everything available on the countries in the region, but not other regions.

Currently, an analyst might run a search but not be able to open a document without negotiating for access. “You don’t want to sort of have to play Twenty Questions to figure out where it is hidden,” Mr. Winter said.

3 Responses to “Intelligence Agencies’ Databases Set to Be Linked”

  1. thucydides says:

    hahahahaha!

    This is great stuff. Like all it takes to link thousands of classified databases together is a handful of “SELECT * FROM NSA_table INNER JOIN FBI_table ON NSA_table.SSN = FBI_table.SSN WHERE …” SQL queries. And the only reason it hasn’t been done yet is because the agencies didn’t have enough money. hah!

    For some history on these sorts of boondoggles in the civilian sector:

    St Petersburg Times: Untangling the VA computer crash How Bay Pines hospital went from guinea pig to paralyzed victim because of pressure to implement a new system – March 2004 ($472m)

    IEEE Spectrum: Who Killed the Virtual Case File? How the FBI blew more than $100 million on case-management software it will never use – September 2005 ($100m)

    The RISKS Digest is a good source for more information on these types of, erm, spectacular uses of taxpayer money.

    Decades of software engineering have illustrated, rather conclusively in my mind, that simply allocating more money doesn’t make these things work.

    But it’s great for whoever the contractors are. 🙂

  2. MW@SA says:

    Oh, this’ll work just fine.

    I’m a DoD civilian employee. I work at a USAF Major Command Headquarters.

    Less than three hours ago, I attended a ‘timesheet class’, where we were shown an ‘electronic’ substitute for a time accounting form where we record our authorized absences. Wow, now we can EMAIL our ‘timesheet’ to the ‘timekeeper’ person. Then it’s PRINTED OUT, to be ‘filed for seven years’.

    This leaves me with only THREE electronic ‘calendars’ (Two Outlook, and one Sharepoint) any one of which could fill out my comings and goings in a properly designed system, plus the paper described above. Oh, and none of the ‘calendars’ talks to any other one.

    I have no faith that any other Government agency is much better off than we are at DoD.

  3. anothernut says:

    But it’ll sure make some contractors a shitload of money. SuuuuuuuuuuuuuEEEEEEE!

Leave a Reply

You must be logged in to post a comment.