Arlington National Cemetery's Many IT Flaws
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.'"
Only $5 million? At first I thought this story was about the failure to store data electronically, but now I realize that it's about government efficiency.
"Going to war without the French is like going deer hunting without your accordion." ~General Norman Schwarzkopf
Where's accountability when 5 million gets spent and nobody can even make something as simple as a SPREADSHEET?
They can't even remember who's in the tomb of the unknown soldier!
The government gets huge economies of scale. That's why we should have them in charge of the health care system. Clearly we will be able to save substantially more money than the private sector once the profit motive has been removed.
Arlington National Cemetery is not an organization that can afford to take the risk of having their servers turned into zombies lightly...
sacred?
I'll do it for half that amount!
For all of our soldiers who have earned the right to be buried there and we can't even get a decent IT system in place to help people or keep such important records.
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...
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.
Give me Classic Slashdot or give me death!
I mean, really. You can setup a redundant/distributed from bare-metal to running in about 6 hours (including full disk scans). Add a cron job to do a dump every night and even just write that to DVD. Creating a database shouldn't be that big a deal. Even designing a web based front-end to search the records and input new ones wouldn't take more than a couple weeks to hash out and implement. Will it be the flashiest thing, no, but it will work and be better than pen-paper. Now, importing all those paper records, that will be the hard part....
We were all warned a long time ago that MS products sucked, remember the Magic 8 Ball said, "Outlook not so good"
take photo of all the graves with their details on and people can browse through them in context, tag them with details etc. I as a mere amature put together a composite image of the 'tablets of the missing' in the American cemetery in Cambridge,UK which lists the names of a few thousand lost personel. One person has already contacted me to say they found their uncle listed.
It's not like the dead are going to complain about it anytime soon.
Sock Puppets: damn_registrars=pudge_confirmer=jimmy_slimmy=raiigunner=cml4524=a_klavan=red4men=ronpaulisanidiot
All the funny comments aside I think this is kind of appalling. This should be a fairly simple project. If I was in a position to make some unilateral decisions, I would ask the National Archives for some assistance in creating the electronic records system.
It might not be within the strictest interpretation of their (NA's) charter, but I think its certainly within the spirit of their mission.
It is better to be the hammer than the anvil.
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.
I can do it for $125,000 and be finished in 3 months.
Step 1: Get money allocated for government project nobody is going to follow up on (Some nice conservative senator arranged this one, I'm guessing).
Step 2: Channel money to "friends" who are "contractors."
Step 3: Take money back from "friends" (minus their "fee" for "work performed.")
Step 4: Squirrel money away in some nice little Caribbean tax haven.
Step 5: Have passport at the ready.
and I'll get some friends together and have a usable system up in a week. (Hardware extra!)
That's why they put a stone with your name on your grave. No need for it.
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.
These posts express my own personal views, not those of my employer
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.
http://www.maxineudall.com/2010/02/should-economists-be-sued-for-malpractice.html
Haven't you read any of the other posts? This is an easy problem, all they need is a MySQL database!
"We are one fire, or one flood, or one spilled Starbucks coffee away from some of those records being lost or spoiled"
Doesn't this apply to databases also?
Both paper and data needs proper backups. Perhaps in this case a copy machine and some interns would fit the realistic need vs an elaborate electronic system.
'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.)
Regardless of what the end database looks like and how long it takes, the first step should be to hire Google to use their book scanning technology to scan all of those documents for preservation. Hell, I bet Google would do it for free. There goes the possibility that "We are one fire, or one flood, or one spilled Starbucks coffee away from some of those records being lost or spoiled". If you don't like Google, I'm sure there are others who could do it just as well.
for $5 million, I'll rent temporary office space, hire people, pay them above industry standard with benefits. Then use these people to build the database, build the web interface, arrange for hosting (perhaps in the cloud), set up the server, enter all the data, have it independently verified. Within 1 year I can hand the keys of the completed project over to the government. Just let me know when you want me to start...
Exactly.
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.
Nullius in verba
You could crowd-source it to genealogists buffs, or ancestry.com with an expectation of reasonable accuracy.
hahaha, you guys are so wrong. with ELECTRONICS, you are one coffee spill away from losing it. With paper, you wont lose it. fire? come on guys, paper doesn't get lost, period. not even hundreds of years later. by the "fire, flood" argument, we should not have copious data from hundreds of years ago, all on paper. compare with edison's (or whoever's) phonographs. bitches.
Or, even better, have the Gov dept. procard (Government version of an expense account/credit card) Amazon EC2 and S3. Total cost? No more than a couple hundred dollars a month.
Don't forget consultants, lots and lots of consultants. Then you need contract project mangers to "manage" them. Then, of course, you need a PMO to manage the managers - but what process should they use? Thats where the $300/hr process engineer comes in, except he can't begin working until a Business Analyst consultant has created a model of the existing workflows. Of course this has now grown into several projects that now costitute a program - which needs its own manager.
Just let Google take their StreetView trike, the one for paths too small for a car, down every row in Arlington Cemetery. Then the whole thing would be in StreetView.
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
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 TCP stack over the internet routing to dozens of machines to some database server which is updated by another computer running at the airport with all the same complexity plus has electronics to convert temperature to serial and then to USB... and each layer involves protocols and APIs... sure it works pretty well, but that is a lot of points of failure to read the temp which could differ a bit from my location. Who cares if they have slightly different weather than my house?? Well, if that doesn't matter that much then why am I using such a precise complex network of technology to get ball-park information when I could just stick my head out the door??
Democracy Now! - uncensored, anti-establishment news
Have a text file checked into SVN as the database. It's only a few hundred thousand lines. You can just grep or filter for the correct result.
Yes, I think we all remember the two mile island incident, a cup of java could be catastrophic under the right circumstances.
who prays for Satan? Who in 18 centuries has had the humanity to pray for the 1 sinner that needed it most? ~Mark Twain
The government cannot do ANYTHING efficiently, except for the minimalist things it was meant to do, eg, protect our borders (hah!), and other basics defined in the constitution. GET RID OF PROFESSIONAL POLITICIANS! That means ALL of them.
Bite me
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.
1 fire, flood or spilled starbucks? Haven't these idiots heard of a PHOTOCOPIER yet???? Oh, you'll also need some offsite storage for your duplicate but you'd need that for your database anyways. Besides, the paper copy will be "readable" for far longer than a digital one under ideal conditions.
It looks like someone wants to update your cemetary record. Cancel or Allow?
My first Journal Entry ever, in 8 years! http://slashdot.org/journal/365947/aphelion-scifi-fantasy-horror-poetry-webzine
meetings and Donuts ...lots and lots of Donuts
I used to work for the National Cemetery Administration (NCA) at Veterans Affairs (VA). NCA uses two automated systems: Burial Operations Support System (BOSS) and Automated Monunment Application System (AMAS). They even have an on-line grave locator at http://www.cem.va.gov/ . These systems work very well. The systems are fully linked into the the VA administration of burial benefits due to deceased veterans or deceased military. The system contains information on current burials and has also been loaded with historical data all they way back to the civil war. Arlington already uses AMAS to order headstones. I'm sure the VA would be happy to add Arlington as a site for BOSS (they already manage 128 cemeteries and Arlington would just add one more). It would take some work to load the data, but that would be a one-time effort.
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.
As Ancestry ( .com and .ca) are using in the World Archives Project, the volunteer / check / review system is saving many other paper copy records, why can't taht work for the government too? And Ancestry isn't even paying for it! Only servers, I suppose. And an Annual Membership is like $300!!! There are MANY options out there.
Social Security has been maintaining records electronically for many decades, primarily using IBM mainframes (now a very few System z machines). Before that, SSA used IBM electromechanical tabulating equipment. Social Security can tell you today how much you earned, to the penny, decades ago. It has to: that's how certain benefits get calculated.
IT really isn't Arlington National Cemetery's core competency, nor should it be. That's often the problem with both public and private sectors: a relatively small organization struggles to implement a solution that dozens of other, larger departments have more or less solved already. I humbly suggest that Congress ought to consolidate IT projects so that a few good agencies can help other agencies. If 100 or more different agencies have to solve their own IT problems on their own, that really would be a waste of money and would achieve sub-optimal (or no) results. Social Security already carefully records all the death-related details of every American. There's even a searchable "death index." SSA just might be able to help Arlington if Congress could set up the organizational structures to foster better inter-agency cooperation.
Okay time for your morning pushups
Dude, if Corporal Tables is in the Arlington National Cemetery's database, he's not going to be doing many pushups!
(Then again, if he's removed via SQL injection, does he come back to life? Does the US Army have any policies on zombies serving within its ranks? I suspect that a "don't ask, don't tell" policy would fail on the basis that decomposing flesh and a propensity for eating your colleagues would be a dead giveaway).
"Slashdot - News and Chat Sites Deviant". (Click "homepage" link above for details).
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 determine how to handle your handling of this situation. If it is decided that you will get off with a verbal warning it won't take longer than a week. If we have to issue a written warning, there will be a meeting to elect a committee to write up the warning and another meeting to review what has been written.
All this seems like a lot of work. I'm going to call in the consultants.
Look, the press's take on this story is the problem is the lack of having the records in a computer.
The actual reported problems are that the records do not correctly show who is buried where or which plots are in use all of the time. The records are mostly correct, but not 100%.
Another reported issue is the idea that the records are being stored in a single place. I kinda doubt this as the records have been filmed on microfiche and making two copies is a fairly standard practice.
Speaking as a computer analyst with 30 plus years experience, computers are not the automatic answer to every problem. Computers do not fix data issues, nor do they automatically create an offsite backup procedure.