[vivegi]

Software written in '98 on Oracle 8i/Sun/Solaris. Mostly SQL, PL/SQL & shell scripts. Still running even after db and os upgrades in 2023. It was mosly a database for online and batch transaction processing that fed a data warehouse and include the Extract-Transform-Load pipeline.

The reason for the longevity is the focus on extreme performance by focusing on I/O by utilizing the database and parallelism offered by the platform. Also, our coding language choices were pragmatic and are still supported. So, even with all the db and platform version upgrades, the code still runs.