Terror Watchlist "Crippled By Technical Flaws"

Slashdot ^ | 8/26/8 | kdawson

[Clint Williams]

I Don't Believe in Imaginary Property writes

"The database used by the government to generate lists like the No-Fly List is 'crippled by technical flaws,' according to the chairman of a House technology oversight subcommittee. And the upgrade may be worse than the original. Rep. Brad Miller (D-NC) says that 'if actually deployed, [the upgrade] will leave our country more vulnerable than the existing yet flawed system in operation today.' It seems that the current database doesn't have any easy way to do plain-text matching, forcing users to enter SQL queries. That might not sound so bad until you learn that the database contains 463 poorly indexed tables. How long until there's a terrorist named Robert'); DROP DATABASE; —?"

[Incorrigible]

Here's a link to the actual article: (Such techie goofballs at /.)

Terror watchlist "upgrade" is "imploding," legislator says
http://arstechnica.com/news.ars/post/20080825-terror-watchlist-upgrade-is-imploding-legislator-charges.html

Obviously I'd like a crack at the schema myself but there are several products that can help with full text indexing.

If they used Microsoft SQL Server, they have full-text indexing built in!

But I'd still want a good schema!