Arlington National Cemetery's Many IT Flaws 191
imac.usr writes "A story in today's Washington Post calls to light the utter failure of the nation's most sacred final resting place to modernize its pen-and-paper record system. According to the story, the cemetery's administrators have spent $5 million without managing to accomplish the seemingly simple task of creating a database record of the site's graves. As Virginia senator Mark Warner points out, 'We are one fire, or one flood, or one spilled Starbucks coffee away from some of those records being lost or spoiled.'"
That's All? (Score:5, Funny)
Re:That's All? (Score:5, Insightful)
And there are already systems available [google.com] that can manage cemeteries so why not purchase one?
Re: (Score:2)
Thank you for your business.
Re: (Score:2)
I'll better that offer- $6M USD, delivery in 9 to 10 years!
Re:That's All? (Score:5, Informative)
And there are already systems available that can manage cemeteries so why not purchase one?
Arlington has 300,000 gravesites on 624 acres.
"In addition to in-ground burial, Arlington National Cemetery also has one of the larger columbariums for cremated remains in the country. Four courts are currently in use, each with 5,000 niches. When construction is complete, there will be nine courts with a total of 50,000 niches; capacity for 100,000 remains." Arlington National Cemetery [wikipedia.org]
Does your off-the-shelf package scale to to a cemetery of that size?
Arlington has extraordinary historical significance. The data base needs to be more than a bare list of names and dates.
Re: (Score:2)
Does your off-the-shelf package scale to to a cemetery of that size?
If that was absolutely the only option available (which it isn't) I'm sure it could be made to. Say the cap is at 10,000 plots... Just create a new cemetery file every 10,000 plots. Certainly not idea... But if you were at all logical in your naming of the individual files it'd likely be easier to find information than digging through the mountain of paper they must have now.
Arlington has extraordinary historical significance. The data base needs to be more than a bare list of names and dates.
Why?
What more information is contained in their records now?
What more information could you want from a cemetery database?
Joe Smit
Re: (Score:3, Insightful)
As another has pointed out - a few hundred k records is a trivial problem for a database. You could probably do this in MS Access (though I wouldn't recommend it).
It isn't like Arlington has to deal with 10k bodies drifting in and out of the cemetery every hour or something like that. This is just a big table indexed for easy searching by name/location, and it gets a couple of inserts per day.
If this takes more than a day or two to put together, somebody is doing something wrong.
Re: (Score:3, Insightful)
Good gravy man, that's like table creation 101. A few hundred thousand records with mostly read operations, rare updates, occasional inserts? That problem has been solved, thousands of times already.
Just grab some digital collections software (Omeka) or customize some Drupal or code up a quick model in Rails/Django and you're in business. Omeka would probably be the quickest startup and provide the capability for tons of rich metadata.
No want/need for a public web interface? Don't set one up. Done. Lunch ti
Re: (Score:2)
Re: (Score:2)
Five million dollars is good, but I bet there are other agencies that could have blown through way more! Anyone remember the story about the NYC project (i think it was a time clock application)?
Re: (Score:2)
When I was still at Bearingpoint (before they went under), I worked on a project that was at least 400 million in the hole. And the client still wanted to keep changing requirements!
Re: (Score:2)
Re: (Score:2, Insightful)
You see a hobo on the street corner begging for money every day, claiming that he's down on his luck and can't seem to do anything to change it.
You buy him a brand new house, and GIVE it to him, free and clear, to end his days as a transient.
He then sells the house, and blows all the money on drugs, booze, smokes, and hookers.
You then see him back on the same street corner, begging for money, claiming that he's down on his luck and can't seem to do anything to change it.
The "surprise" ending is that the hob
Re: (Score:2)
Re: (Score:2)
Why do you imply that union-mandated dead weight at the bottom (and, I claim, at every level) is mutually exclusive with neoptistic dead weight at the top?
Re: (Score:2)
$5 million? I'll do it for ONLY $4.5 million!
Stories like this where the government throws $millions around for a simple website or database really piss me off. Maybe there's more to this system than TFA leads me to believe, but from the sounds of it this is a pretty straight forward project, a more reasonable figure would be in the low 6 figures I think (if it includes hardware and manual data entry).
This reminds me of the $18 mil us taxpayers spent on recovery.gov . I've built several bigger and better
Accountability (Score:4, Interesting)
Where's accountability when 5 million gets spent and nobody can even make something as simple as a SPREADSHEET?
Re: (Score:2)
It's amazing, $5 million spent and no progress made on something that you could probably do with a few grand in software, and few grand in hardware and setup, and volunteer labor for the data entry. You could make it part of the tour for crying out loud, 'sit down and enter a few names as you go through', double or triple completed to ensure accuracy of course.
Re: (Score:2)
IMHO, this whole issue is philosophically interesting. I think it is a mistake to try and indefinitely preserve the bodies of everyone who ever lived. Rather than be a rotting corpse, I would rather come back sooner as pine needles in an alpine forest and affect the future through writings, or photography, or my descendents.
Of course, none of that real
Re:Accountability (Score:4, Funny)
So at the root of things, you'd be pining for your descendants in the woods instead of your descendants pining for you in a cemetary?
Fair enough. But wouldn't you appreciate the thought of your descendants sprucing up your gravesite in memoriam?
Re: (Score:2)
They could always go hiking and pee on my stump.
Re: (Score:2)
Actually, the specifics that were mentioned in the article indicated
that lots of the money was spent to make computer-readable data
of the old records (Arlington has over two centuries of records). That
might actually be worth what they paid.
We all think of 'making a database' as the center of this kind
of problem, but IT ISN'T. Pretty certainly, the monies
spent weren't spent on building softwares... and the
employees didn't, in their everyday work, feel the need to
get every shovel-pusher a computer termina
Re: (Score:2)
Ancestry.com has something similar for its scanned documents. I've corrected numerous census and draft registration records, with a notification anywhere from a few days to a few weeks later that the changes had been accepted into the database, presumably after confirmation.
Re: (Score:2)
They should use Google Earth or something and tag each plot with GPS coordinates as well as who's in it.
Re:Accountability 5 million is nothing (Score:5, Insightful)
Where's accountability when 5 million gets spent and nobody can even make something as simple as a SPREADSHEET?
Clearly you don't work in or understand IT. First there have to be meetings. Lots and lots of meetings. First at management level to initiate the project. Then detailed meetings to set up staffing and outline goals. Then middle management needs to be appointed (more meetings) so that they can flesh out those goals in more detail (more meetings). Of course this is after HR recruits the middle management. The middle management goes through the same process to recruit actual staff. Then management meets with staff that provide feedback on those tasks "No I'm sorry you can't magically walk around with a laptop and scanner and have it absorb names off the gravestones. No there's no technology to do that on the horizon". Then middle management needs to report back to senior management (did I mention meetings?) and senior management needs to meet separately to decide what it means to the project. At this point all those discussions will get confusing so will need to be summarised and corrected. Only now can we start to see a plan coming into being (drafted by middle management, approved by senior management. You guessed it more meetings). At this point work may commence but if it is it will typically be halted by a new priority/requirement being pulled out of senior management's rectum^H^H^H^H^H^H^H^H^H^H^H ahem I mean coming to light. This will totally screw up every agreement made about the direction and even nature of the work, which will require more meetings at all levels to sort out.
Oh and don't be fooled this happens in industry as well as government. Privitising just adds another layer to all this mess and provides another opportunity for waste each time someone changes their mind or adds an unreasonable or ill thought through requirement.
$5 million is nothing. The fact that an intelligent 6th grader could do better is by the by. it's not how the world works.
Re:Accountability 5 million is nothing (Score:4, Funny)
This seems like a really interesting comment. I'm going to schedule a project kickoff meeting for next week where we can discuss some strategies for reading your comment as efficiently as possible. Reading your comment is a very high strategic priority for me, so I'll try to get a hardware provisioning meeting scheduled ASAP after the kickoff meeting so that I can let everybody know that I'm eventually going to request some hardware to use for reading your comment.
I setting a rough goal of having your comment read before the end of the fiscal year, but there is a good chance that the project will be pushed back a bit somewhere into the next few FY's.
Re: (Score:3, Funny)
Not so fast. People like you always want to just get right into it. Please submit a proposal detailing why the comment is a very high strategic priority and what reading it will mean to the group as a whole.
Next, we would have to determine if you are the one suited to reading the comment. I mean, we have people that are suited to this specific task. I know you are eager but you have a tendency to step on the feet of others.
Since you are obviously not a team player, a meeting will have to be called to de
Re: (Score:2, Insightful)
The jackasses were moving existing remains, and putting new remains into old graves, and putting landscaping on top of existing graves.
When your problem is that the guy with the backhoe hasn't been trained to speak up if there's already an existing grave where he's been told to dig a new grave, the solution isn't "hire some geeks to program some computers".
The solution is to create an environment where everyone who works there respects the dead, and to make sure that procedures enable that respect. It's
Tell me about it! (Score:5, Funny)
Re:Tell me about it! (Score:5, Funny)
They can't even remember who's in the tomb of the unknown soldier!
Corporal Tables, we call him.
Re: (Score:2, Funny)
Corporal Tables, we call him.
With the computers there as old as I think they are, the joke is probably Corporal Deltree
Re: (Score:2)
If only he were. They spent $5 million dollars and they DON'T EVEN HAVE A DATABASE. At all. Of anything.
Re: (Score:2)
They had a database. One careless SQL injection later and they had "DROP'ped TABLES;" and that was that for the database.
link [xkcd.com], if you didn't recognize the joke.
Re: (Score:2)
I hope they don't lose the records of my grandfather "a';DROP TABLE users;"
Good ol' Droppy we called him.
Re:Tell me about it! (Score:5, Funny)
They can't even remember who's in the tomb of the unknown soldier!
Corporal Tables, we call him.
-- Okay time for your morning pushups:
Drop Corporate Tables; -- drop!
Re: (Score:2)
Oh wait. It's a trick question, right? Isn't it Grant?
$5 million is a good deal. (Score:4, Insightful)
Re:$5 million is a good deal. (Score:4, Informative)
Yep, private industry has never wasted a cent. Their track record is spot on.
http://it-project-failures.blogspot.com/ [blogspot.com]
Cut them some slack... (Score:5, Funny)
Re: (Score:2)
Re:Cut them some slack... (Score:5, Funny)
tell me about it. The only thing worse than a zombie is a zombie with stealth and combat training.
Re: (Score:2)
Where do I sign up for that job? (Score:3, Informative)
Re: (Score:2)
This can reasonably be done for $125,000 (two interns and a lead) and be finished in 3 months.
Re:Where do I sign up for that job? (Score:5, Funny)
This is for a government project.
I'll do it for twice that amount!!
Bet I get it before you do.
Re: (Score:2)
I'm pretty sure some veterans would do it for NOTHING if you simply put the word out.
Re: (Score:3, Funny)
Anonymous Coward? You'll never pass the background check!
How Sad... (Score:5, Insightful)
To our Fallen Hero's.... I am sorry.
I do think it is time that companies and even people stop being so damn greedy and do their jobs. Granted we may not have the insight as to what is happening directly but I am left to wonder who is asleep at the controls on this one. We have private sector people doing jobs that are comparable size to this job and I am sure 5 million dollars would have paid for their time and a mojito and Starbucks coffee whenever they wanted it. I think it is time to disband our Government and reform with people that a hell of a lot more honest then some of the guys we have in there now. Sorry to make this political but the fact remains that someone is not doing their job. Any person's loved ones are important to them but a person who defended our rights and country (regardless if the war is right or wrong to which those that feel it is wrong it is time to bitch at the civilian leaders case and point would be the recent Gen. McCrystal deal.) and we can't honor them with keeping accurate records and spending money WISELY when it comes to their final resting place. Sad...
Re: (Score:3, Informative)
I have worked as a DoD contractor and I am a vet. I agree it is sad, but failure on these projects is the routine outcome.
Navigating the federal procurement process is a nightmare you have to experience to believe.
Those infamous $300 hammers are a bargain: at least they got delivered and performed the task.
Re: (Score:2)
Re: (Score:3, Informative)
That might almost be reasonable--that sort of thing gets expensive when they're not making them anymore.
Re: (Score:2)
Currently working on a display for older tanks, price is somewhere in the 100K range for the first 10 units, the price drops on additional ones. We had to redesign everything to meet the old spec.
We could have done it for half the cost if they would have changed the system feeding the information to the display.
The old display was not near a crisp as the new display, and was made with obsolete parts.
But this is better than buying a new tank, so in the end, repair may be cheaper than a whole new system.
Re: (Score:3, Funny)
Re: (Score:3, Insightful)
Transparency.
I'm dead serious. When you're dealing with the private sector, the end result is (usually) far more important than the process. Using your above example, the goal is to get you on a plane that takes you to the destination the company wants you to go to - as long as you get there, the only people that care how it gets paid for are the accountants. In government, however, it's much more important that we avoid fraud
Re:How Sad... (Score:4, Insightful)
The management at Arlington appears to have been too old. Computer literacy should be required of all Federal job holders and they should be shitcanned if they cannot adapt.
Hold them to the standards expected of the military, which is to do your job or suffer appropriate punishment.
Re:How Sad... (Score:5, Insightful)
You know.. Some of those records are over a hundred years old. I dare you to show me any kind of electronic record from more than 30 years ago. Go ahead, I'll wait while you try to find a reel to reel, and a system to use it.
To modernize they need to re-enter everything, then ensure that backups are carefully followed, then they have to replace all the technology every few years, and pay support. Then they have to convert the data when new format/versions come out. That is a ton of Money and Time.
A Vet teacher had a sign on a door that pretty much summed up the Marine Corps feelings on Technology.
A computer with a bullet hole in it is a paperweight. A map with a bullet hole is still a map.
Re:How Sad... (Score:5, Insightful)
A computer with an offsite backup still preserves data when the building is bombed, burned down, flooded, or otherwise destroyed. A map in such a building will be gone forever. Sayonara, data. Your Vet teacher and apparently the entire Marine Corps have it wrong.
Re: (Score:2)
Re: (Score:2)
It is quite possible (and was once quite routine) to maintain offsite backups of paper records.
Re: (Score:3, Insightful)
Re: (Score:2)
Doing BOTH would make sense, as they are not mutually exclusive.
Once plots are inventoried, make sure the STONE INVENTORY MARKERS MATCH WHAT'S UNDER THEM.
Re: (Score:3, Insightful)
The Marine Corps has it right, you have it wrong.
Here's a thought: perhaps there are valid points and drawbacks for both methods? Shocking, I know!
Overkill? (Score:3, Interesting)
Ever hear of technology overkill?
Make 2 maps keep one somewhere else. Have somebody make a copy of the map - or even make a HAND copied map! Whoa! mind blowing concept! wait... what if you don't know how to draw or write because you typed everything from birth?
What is the temp outside? oh, I'll just press F12 and see what it is at the local airport over the internet OR I could just look out the window to a cleverly placed thermometer...
Rube-goldberg machine: web browser powered widget communicating over a
Re: (Score:2)
In my world, it's trivially easy to make backup copies of paper data - photocopying, microfilming, xeroxing, or scanning and storing digital copies. (Or hell, even carbon copies.) In fact, people have been using various such methods of backing up important data (and storing it offsite) for centuries.
In your world people seem
Re:How Sad... (Score:4, Insightful)
C'mon people, this is pretty straightforward. These are two very different things, and both are best for their jobs.
A map is more useful to someone trudging around in the sandbox with 80lbs of gear because it's lighter, the battery isn't going to die, it isn't going to break if you leave it in your pocket and it's invulnerable to software bugs or fried parts. Also, you can hand it to anyone else with basic map reading skills without the added encumbrance of old-timers that don't want your newfangled doohickey.
A large data management task at an office somewhere is obviously is a job for databases and offsite backups. Paper records should still be kept in some vault somewhere to preserve them, but employees, guests, etc. should be working with a database almost exclusively.
Pffff (Score:2)
Haven't you read any of the other posts? This is an easy problem, all they need is a MySQL database!
Re: (Score:3, Funny)
> ...all they need is a MySQL database!
Wrong. PostgreSQL.
Re: (Score:2)
Re: (Score:2)
Re: (Score:2)
Here you go!
http://upload.wikimedia.org/wikipedia/en/2/24/Lenna.png [wikimedia.org]
Re: (Score:2)
I dare you to show me any kind of electronic record from more than 30 years ago.
There's a bunch of them right here [atariage.com].
Re: (Score:2)
From the article: "the Army has reprimanded Superintendent John C. Metzler Jr., who is retiring July 2, and [No. 2 administrator] Higginbotham, who was placed on administrative leave pending a disciplinary review." So, yeah, they're shitcanned. I'm sure some will say that's not enough, though keep in mind they were also juggling many other responsibilities besides IT upgrades.
Re: (Score:2)
One is being allowed to fall back on his full retirement bennies, and the other is being paid to not work. Yep, that's some kind of punishment, there. (Granted, the one on administrative leave might wind up catching it later. Then again, he might not.) Compare this to the worker who tried to blow the whistle on them a few years ago. They FIRED her ass.
Re: (Score:2)
Even worse, when it comes to complex projects(and IT counts), even a supply of honest men isn't good enough to assure success. Malicious actors can definitely poison the best of projects; but good people sail projects on to the rocks all the
Re: (Score:2)
Does it really matter? (Score:2)
They're just bones. Does it matter which bones are where? Change the name from Arlington National Cemetery to Arlington National Memorial and you don't even need the bones at all.
Re: (Score:3, Interesting)
As cynical as it seems, there is something to that.
I'd wager that a lot of the graves belong to people whose living relatives/descendants have no idea they have a grave there and thus the grave is really only symbolic as part of the visual sea of gravestones.
And then there's the idea that, well, barring the dead walking again, none of those guys are walking again.
The other thing I think of is -- as long as the paper records are maintained (eg, copies stored offsite, new copies made periodically, etc), if th
How hard is it really to setup a MySQL database? (Score:5, Informative)
Re: (Score:2)
I'd start by firing anyone that knew this was a problem and did nothing to at least set up a temporary system and start inputting data. And in the mean time, get down to kinkos and photocopy the damn paper records.
Re: (Score:2)
If all else fails, get out the camera (Score:2)
Re: (Score:2)
That sounds reasonable, until you see Arlington and grasp just how very, very big it really is. There are 300,000 graves on the site. That is a huge task, and would require many people. For a place such as Arlington, volunteers would be plentiful. But even organizing a crowd like that is difficult, much less getting them all to perform a specific task correctly.
While it might sound efficient to put an HD video camera in the hands of a rider and have a 4-wheeler zip up and down the rows of the cemetery,
Re: (Score:2)
> take photo of all the graves with their details
How do you know that the markings on the stone are correct?
Should be a fairly simple project. (Score:2)
It might not be within the strictest interpretation of their (NA's) charter, but I think its certainly within the spirit of their mission.
Re:Should be a fairly simple project. (Score:4, Insightful)
It might not be within the strictest interpretation of their (NA's) charter, but I think its certainly within the spirit of their mission.
THIS does not happen enough in the Federal Government. 95% of the time when an agency is in need of a skillset that is outside its purview (or sometimes within its purview, but present in a different department), it contracts it out to some third party vendor with questionable skills and typically high prices. Every federal agency should be ready to consult for other agencies when its primary skills are in need, but it almost never happens that way.
Even the government can do better than this (Score:5, Interesting)
The article notes that the Veterans' Administration *has* computerized graves registration elsewhere, successfully, covering ten times the number of graves at one-third the cost of this utterly failed effort.
Give me half a million (Score:2)
Similar Story (Score:3, Interesting)
Computers aren't necessarily the answer to every problem. I heard this story on NPR and part of the uproar is some people aren't buried where they should be. No computer will fix that. Quite disrespectful, but I'm hardly surprised.
In my younger days I wore many hats at a start-up and one of those hats was logistics. We had parts inventory at a local freight company for free because they did lots of business with our assembler.
I go in to do a cycle count one day and the guy pulls out a notebook and gives it to me before my count, telling me it's all in there. You know what? It was. He had dozens of notebooks. One for each assembler customer. This guys niche was basically to segregate the shipping paperwork from inventory accounting. It wasn't a one-man shop either. He made it work and work well. Most of the LDL shippers use grand-unified logistics applications with double and triple entry labor that would make his kind of service an expensive proposition.
Re: (Score:2)
Irrelevant quotation (Score:5, Insightful)
'We are one fire, or one flood, or one spilled Starbucks coffee away from some of those records being lost or spoiled.'
This is not an IT problem. This is a basic information storage problem dealing with backup procedure. If you're a major organization and you don't have copies of your records, whether paper copies, microfiche copies (which seems to be the case here), or electronic ones, you're vulnerable.
Similarly, IT doesn't necessarily solve this problem. If you digitize all the records to a single server and don't make proper backups, you could still be one fire or flood (or even a coffee) away from losing the records.
(Btw, I do realize that original paper records may have some value as historical artifacts themselves. But those should be in an archive somewhere protected from floods, fires, and errant cups of coffee, while people accessing these records on a daily basis should be using copies, whether digital or microfiche or whatever.)
Re: (Score:2)
It certainly is an IT problem. Taking a big picture view of IT, it includes such things as data integrity, security, disaster recovery. And it touches on all aspects of the systems architecture, from applications down to the sheet metal.
One could even argue that IT is involved with systems based on clipboards and carbon copies.
Re: (Score:2)
It certainly is an IT problem. Taking a big picture view of IT, it includes such things as data integrity, security, disaster recovery. And it touches on all aspects of the systems architecture, from applications down to the sheet metal.
I'm not arguing that backup isn't an IT problem. I'm saying that if whether you are a high-tech organization with electronic records or a medieval church with paper records vulnerable to fire, you need to deal with backup. In other words, backup isn't a problem unique to IT.
One could even argue that IT is involved with systems based on clipboards and carbon copies.
Well, one could, if one doesn't subscribe to the common definition of IT.
Yes, one could understand "information technology" to mean any technology dealing with information transfer, in which case, you're right. But that's not what I
Re: (Score:2)
http://www.youtube.com/watch?v=pQHX-SjgQvQ [youtube.com]
OK, I'll do it. (Score:2)
Re: (Score:2)
> for $5 million...
You'll have just about enough money to hire all the specialized lawyers and accountants you'll need to comply with Federal procurement regulations.
Just let Google take their trike through there (Score:2)
Just let Google take their StreetView trike [blogspot.com], the one for paths too small for a car, down every row in Arlington Cemetery. Then the whole thing would be in StreetView.
Sounds like typical government IT (Score:4, Interesting)
I bet the contractors all bid in good faith, expecting it to be a cake walk like all of us are assuming right now, until they discovered a seething morass of requirements. Things like
one starbucks coffee? (Score:2)
I worked for the National Cemetery Administration (Score:4, Informative)
The interesting thing about the well-functioning VA systems is that they are NOT developed or administered by contractors. They were developed and are maintained by Government employees (civil servants). They are administered daily by civil servants. The programers are all GS employees and the DBAs are all GS employees. Contractors have never touched the systems and hopefully never will. The only thing that contractors did was provide some unskilled labor to do document scanning that was then imported into the system by the Government developers/admins.
VA has had success when they do in-house development with Government employees and dismal failures when they try to contract-out development. Just Google "CoreFLS" to see how a contractor developed system can fail to the tune of $250 Million and then never be deployed. CoreFLS was a $250 Million boondogle worked on by a bunch of H-1Bs that was so bad the Assistant Secretary for IM was fired by the President. If the President of the United States has to be personally notified that you fscked up, its as bad as it gets.
Re: (Score:2)
I'd like to complain about my money being wasted.