Comment Re:Google? wtf (Score 2) 74
But 20 million cells? That seems ridiculous. Why aren't they using a database for something that huge?
Because I can bet it started out as a way for an engineer to track say, the parts of their little piece of the plane. Maybe it was just all the mechanical bits associated with the inner flap on the right wing. It started as a manual tracking system on pieces of paper and post-it notes.
Then the guy gets handed a spreadsheet, realizes all those little pieces of paper can be consolidated in a nice table that fits in a nice small file. The guy starts using features like colors and such to make tracking easier and boom, he's gone from needing dozens of pieces of paper, risking their loss, to a spreadsheet table that holds all the same data
Slowly it accumulates features and other engineers on other parts of the plane start asking him for a copy of the spreadsheet to simplify their operations. At the same time, people start realizing they could get a better overview if they put all their information into one document instead of it being spread out across dozens of spreadsheets.
And now you have a spreadsheet with 20 million rows which provides remarkable insight into all the parts going into a plane.
Could a database do it better? Of course it can. But it likely wouldn't have happened - it just started as one engineer's way of keeping track of parts, that then grew organically until it became the behemoth it is. I'm sure when it started they decided it was 100 odd parts, the effort to use a database wouldn't be justified, if they learned how to use a database.
But now, it's difficult because now you need to create a database and program it to how the spreadsheet works now, then import all the information over. It's likely something that's going to take some time for a developer to properly develop and deploy it and make it work the way the people using the spreadsheet used it. And then deploy it so it works with dozens or hundreds of users.
And it all took place over 20+ years so it's likely for many users it was always how it worked when they started.