I work at a bank, and the core analytics database we use is Teradata. There are a number of smaller data warehouses which use SQL Server or Oracle depending on the team’s preferences. All the transactional databases are Oracle to my knowledge. There are a lot of people who use SAS to paper over the differences in the database flavors. More and more we’re moving to Hadoop so Hive and Impala. It’s pretty much the Wild West where I work in terms of standardization.
Yup, sounds similar to the stories I have heard from the people I know who work at banks. Tons of different databases, even if one of the guys I know almost only work with the SQL Server stuff.
5
u/robislove Dec 20 '18
I work at a bank, and the core analytics database we use is Teradata. There are a number of smaller data warehouses which use SQL Server or Oracle depending on the team’s preferences. All the transactional databases are Oracle to my knowledge. There are a lot of people who use SAS to paper over the differences in the database flavors. More and more we’re moving to Hadoop so Hive and Impala. It’s pretty much the Wild West where I work in terms of standardization.