Whether on-premise or in the cloud, DBAs are often asked to create and manage optimal database designs for data warehouses, data lakes, and many other very large databases (VLDBs) using relational database management systems. These databases will be used for business intelligence, data mining, and data analytics. They are radically different than traditional online transaction processing (OLTP) systems. So what special design concerns will be faced? What database editions and features to rely upon? What kind of query execution plans should be sought?
Join IDERA and Bert Scalzo on Wednesday, September 19 at 11 AM CT as he covers all pertinent issues, which some may even consider best practices, for such highly specialized database requirements. While the basic concepts will be universally applicable, examples will be primarily in Oracle, with some also in MySQL, SQL Server, and PostgreSQL.
You can view Bert's presentations slides here. The recording will be available in a few days.