Archived material Access restricted Article
Rantburg

Today's Front Page   View All of Thu 09/09/2004 View Wed 09/08/2004 View Tue 09/07/2004 View Mon 09/06/2004 View Sun 09/05/2004 View Sat 09/04/2004 View Fri 09/03/2004
1
2004-09-09 Terror Networks
Belmont Club: a database is a lethal weapon
Archived material is restricted to Rantburg regulars and members. If you need access email fred.pruitt=at=gmail.com with your nick to be added to the members list. There is no charge to join Rantburg as a member.
Posted by Mike 2004-09-09 12:58:03 PM|| || Front Page|| [11130 views since 2007-05-07]  Top

#1 As they say: A database is a terrible thing to waste.
Posted by Xbalanke  2004-09-09 1:27:10 PM||   2004-09-09 1:27:10 PM|| Front Page Top

#2 Databases work both ways. They can be used for tremendous good as well as horrific evil. Heck, Fred uses a database for his site; I use databases in business, and in wargaming.

In fact I believe that history will eventually regard the computer database as a development/invention on par with the automobile/aircraft as a positive societal changing element.

My main Unix database is postgresql which was originally a DARPA/US Army project way back when.

Some elements of warfare is definately changing, and databases will lead the way in some areas in finding and eliminating Islamists as threats to civilization.

But a database can't fry thos evil f*ckers. Only military ordnance can do that.
Posted by badanov  2004-09-09 1:52:32 PM|| [http://www.rkka.org]  2004-09-09 1:52:32 PM|| Front Page Top

#3 Hand Fallujah to the Kurds? Exxxxxxxcellent Smithers.
/Mr Burns off
Posted by Rex Mundi 2004-09-09 2:08:42 PM||   2004-09-09 2:08:42 PM|| Front Page Top

#4 Can I make a contribution to this database?

Create Procedure WhackATerrorist (int @TerroristId)
Update
    tblTerrorists
Set
    IsBurningInHell = True
Where
    TerroristId = @TerroristId
Posted by Dar  2004-09-09 2:47:43 PM||   2004-09-09 2:47:43 PM|| Front Page Top

#5 That's one entity relationship diagram I'd like to see...
Posted by Howard UK 2004-09-09 3:06:41 PM||   2004-09-09 3:06:41 PM|| Front Page Top

#6 A better procedure would be a trigger that would insert a new record into a targeting database used by intel, automatically uploaded to Global Hawk targeting computers, once a new location of a terrorist is entered into a database.

I am not terribly familiar with SQL commands, but don't you have to first create the function before creating the procedure, and the procedure is executed by creating a trigger. Right?
Posted by badanov  2004-09-09 3:15:58 PM|| [http://www.rkka.org]  2004-09-09 3:15:58 PM|| Front Page Top

#7 I've commented on this subject here previously. I'm very familiar with big, nationally known Insurance Co.s that have highly developed DBs to track and root out insurance fraud.

Not only do the civilian versions of these systems store huge amounts of data but they can also draw analyst's attention to facts that might otherwise excape notice - such as claimants for 7 out of the last 40 claims over X $$ in a particular city all were treated by Dr. Soandso for soft-tissue injuries. 20 of last 40 claimants were represented by two lawyers who share the same business address with the Dr. Coincidence or not?

I have no direct knowledge of the DOD's systems but I'll make the intellectual leap that our guys overseas use MUCH stronger DBs and Data Mining tools to not only track relationships but also to extrapolate connections between seemingly unrelated events, people, locations and time. If you can predict with 95% certainty which vermin is going to land on what pile of sh*t at what time, the shotgun approach is no longer necessary.

Consider this; It's not outside the realm of possibility that these tools can be refined so well that a pilot can release the ordinance that nails the bad guy before the asshat sits down at his regular table at the cafe.
Posted by Doc8404 2004-09-09 3:26:14 PM||   2004-09-09 3:26:14 PM|| Front Page Top

#8 badanov--I can't speak for all DB engines, as I've only worked with SQL Server and Oracle. With SQL Server, you can create a procedure and execute it via triggers, other procedures, or external apps. The only requisite is a database--and tables, of course, if you want to manipulate/return data.

I'd love to see that ERD as well and see how they mine that data--there is SO much cool stuff you can do with a (properly designed and maintained) database!
Posted by Dar  2004-09-09 4:40:24 PM||   2004-09-09 4:40:24 PM|| Front Page Top

#9 I feel we need to take this one step further. However costly, including a biometrics and DNA profile for each suspected militant detained would help to determine, not only when we snuff them, but also who else in their family might be participating in terror activities.

I maintain that terrorism needs to be declared a DNA crime and such tracking should be put in place for all visa applications by individuals originating from countries that are terrorist sponsors and havens. Terrorism does indeed run in the family, and we need to identify exactly which ones they are so those gene pools can be subjected to shock chlorination.

And yes, badanov, the database ranks along side the microprocessor itself, not to mention solid state lasers and GPS, as significant modern inventions.
Posted by Zenster 2004-09-09 9:47:27 PM||   2004-09-09 9:47:27 PM|| Front Page Top

#10 This is precisely the same methodology used to track down Saddam. Establishing linkages between tribalists, data-mining go boom.
Posted by Capt America  2004-09-09 10:24:06 PM||   2004-09-09 10:24:06 PM|| Front Page Top

#11 I bet this is run on Oracle not SQL.
This software really works well.
Posted by Sock Puppet of Doom 2004-09-10 5:25:16 AM||   2004-09-10 5:25:16 AM|| Front Page Top

21:08 UFO
20:55 UFO
16:18 UFO
08:08 UFO
10:24 UFO
01:11 UFO
01:06 UFO
00:57 UFO
00:43 UFO
00:39 UFO
00:26 UFO
00:22 UFO
00:22 UFO
09:17 Sock Puppet of Doom
09:14 Howard UK
09:07 Howard UK
08:58 Critch Griger4522
11:57 Gerry
05:25 Sock Puppet of Doom
05:20 Sock Puppet of Doom
04:33 Super Hose
00:32 Zenster
00:22 Anonymous6378
00:10 Dar









Paypal:
Google
Search WWW Search rantburg.com