I just completed the effort of a database migration to cloud (Snowflake). The project has taken this company over 5 years and we are now finally decommissioning the old systems. This is for a multibillion dollar healthcare company and it has amazed me how much bubblegum, byzantine ancient systems, workarounds, one-off applications, single user inputs and so on that have been keeping the whole mess kind of working. Just my small piece of it has been insane and I am shocked that it works at all.
I've also recognized that the healthcare industry as it exists couldn't function without this shit. Every single company mine interacts with uses peculiar file formats, extremely conditional file generation, weird data types, it just goes on and on and on. All built in the old school database way with thousands of stored procedures, views, data replication systems, and all of them are interdependent and almost none of it is documented.
Absolutely batshit.
Take for example one of our biggest B2B systems to deal with another multibillion dollar healthcare company. The "system" comprises:
- 57 different databases
- At least 100 different individual processes feeding said databases data (I honestly have no idea how many).
- 9 different completely unrelated applications hosted on various servers. Written in C# and others in Java.
- 400+ different stored procedures.
- A shitload of custom data views. No idea the total number. Well into the thousands.
- A massive in house application that actually generates the files to clients. Some of it goes to SFTP, the other part sends it to the in house print shot to put it on paper.