alt Hacker NewsWhat's about DB2? I have no experience with it but I guess IBM specifically designed it for enterprise-scale transaction processing workloads...
What's about DB2? I have no experience with it but I guess IBM specifically designed it for enterprise-scale transaction processing workloads...
DB2 was crazy good for certain use cases but very weird. For one, the pattern for DB2 efficiency was pretty much the exact opposite of every other database. Every other database would say "Normalize your tables, use BCNF, blah blah, small reference tables, special indices etc".
DB2, the pattern was "denormalize everything into one gigantic wide table". If you did that it was insanely fast for the time and could handle very large datasets.